Build excel spreadsheet accessing most current stock price

I need a spreadsheet that will retrieve the latest stock price in the US. Stock data retrieval should be from a free source like Google Finance. Once the price is retrieved, I need to build a performance comparison chart of the stock portfolio vs the S&P 500.

Here is the data I will provide: Stock ticker/symbol, Entry Date, Entry Price, Exit Date, Exit Price, $P/L for Position, %Return for Position.

Note: I do not have the number of shares bought as these are just buy signals. I need a way to compare the signal's performance to the S&P 500 index/SPY.

Project requirement: must know how to retrieve most current stock price to excel and use it to calculate unrealized P/L. Must know Excel to compare my signals to S&P 500 on a chart. The chart should look something like the attached image.


Skills: Excel

See more: excel clout stock quotes, import stock prices into excel 2013, get stock quotes in excel from google finance, msn moneycentral investor stock quotes excel, real time stock prices excel, msn moneycentral investor stock quotes excel 2016, get stock quotes in excel from yahoo finance, excel 2016 stock quotes, build a price query website using an excel spreadsheet, extract stock price google finance excel, calculate abnormal return excel, calculate rolling return excel, stock price history vba excel, excel spreadsheet creation calulate stock trade, stock price excel vba

About the Employer:
( 3 reviews ) Rowland Heights, Taiwan

Project ID: #14295173

20 freelancers are bidding on average $184 for this job


#1 Excel VBA programming expert on and have been featured by the freelancer community ( Relevant Skills and Experience I More

$200 USD in 3 days
(463 Reviews)

Hi, my name is Sevinc. I read "Build excel SS accessing most current SP" project descriptions before bidding. I checked the attached sshot as well... I got what you need, and ready to go ahead. Relevant Skills and Ex More

$300 USD in 5 days
(210 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$200 USD in 2 days
(156 Reviews)

Dear Sir/Madam, I have 12 years of experience in data processing and analysis using Excel and VBA while working in finance, audit and accounting industries (including 4 years at a Big 4 audit firm). Projects I delivere More

$120 USD in 3 days
(65 Reviews)
$155 USD in 3 days
(38 Reviews)

I am an ACCA (UK) professional , APA and Mcom finance. Relevant Skills and Experience After carefully reading your project description, I think that I am the perfect candidate! With over 8 years of experience in advan More

$147 USD in 3 days
(61 Reviews)

Hi, We’ve read your proposal regarding building a spreadsheet with stock prices. We build monitoring apps for traders by algorithms, formulas and other methods like Bivariate Binomial Option Pricing Method and Hilliar More

$555 USD in 10 days
(25 Reviews)
$73 USD in 3 days
(32 Reviews)

we have expertise in this domain(web scraping , Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience web scraping , Excel VBA , More

$100 USD in 3 days
(25 Reviews)

Sir, I reviewed your job description and am very interested to work with you. I can complete with fast and accurately. Please consider my bid. Thanks........Shariful Relevant Skills and Experience Excel Proposed Mi More

$166 USD in 2 days
(44 Reviews)

Greetings Hope you are doing well. I am a CPA (CA/ACCA) Finalist and I provide a range of services majorly focusing on excel, accounting, financial management, cost accounting and other allied subjects. I have been wo More

$77 USD in 2 days
(18 Reviews)

Hi!!! I can help you with the task! I am very analytical, have lots of experience in analysing data (excel), structuring and presenting it to make decisiones. Relevant Skills and Experience I am very responsable and s More

$155 USD in 3 days
(1 Review)

Hi Relevant Skills and Experience Hi I can complete your project in a day. I am forex trader my self I can build excel file that exports stock data to excel and create chart from that. Proposed Milestones $100 USD - More

$100 USD in 2 days
(4 Reviews)

Hi, I am already doing same task in my company for financial benchmarking. I am working as financial analyst in a NASDAQ listed company. I also have experience of more than 5 years in field of accounts, book keepin More

$150 USD in 2 days
(5 Reviews)

A proposal has not yet been provided

$250 USD in 5 days
(8 Reviews)

Hi, I'm a Business intelligence and statistical engineer, check my profile and don't hesitate to contact me, I have a set of skills that can provide value to your work . Relevant Skills and Experience I'm not an inter More

$222 USD in 3 days
(1 Review)

I can create automatics web script for you that will retreview latest live currency stock data from google finance and other live apis and save them & analyze them in google spread sheet or excel. and also can creat More

$155 USD in 3 days
(1 Review)

I have created spreadsheets exactly like this in the past and can definitely help you achieve your desired outcome quickly and on budget! Relevant Skills and Experience I do equity research fora living and am very More

$200 USD in 3 days
(0 Reviews)

I am able to do the job Relevant Skills and Experience Data entry , Excel Proposed Milestones $45 USD - Create one milestone

$45 USD in 3 days
(1 Review)
$277 USD in 7 days
(0 Reviews)