Build excel spreadsheet accessing most current stock price

Анульовано Опубліковано %project.relative_time Оплачується при отриманні
Анульовано Оплачується при отриманні

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.

DO NOT APPLY IF YOU DO NOT MEET THESE REQUIREMENTS.

Excel

ID Проекту: #14295173

Про проект

20 заявок(-ки) Дистанційний проект Остання активність 6 роки(ів) тому

20 фрілансерів(-и) готові виконати цю роботу у середньому за $184

jaylancer43

#1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I Більше

$200 USD за 3 дні(-в)
(463 відгуків(и))
7.9
seaanddream

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 Більше

$300 USD за 5 дні(-в)
(210 відгуків(и))
7.2
schoudhary1553

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 Більше

$200 USD за 2 дні(-в)
(156 відгуків(и))
6.7
javed1705

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 Більше

$147 USD за 3 дні(-в)
(61 відгуків(и))
5.8
dgled

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 Більше

$555 USD за 10 дні(-в)
(25 відгуків(и))
5.5
dviruki

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 Більше

$120 USD за 3 дні(-в)
(65 відгуків(и))
5.4
axiomswb

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 , Більше

$100 USD за 3 дні(-в)
(25 відгуків(и))
5.1
sharifulhap

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 Більше

$166 USD за 2 дні(-в)
(44 відгуків(и))
5.2
awaisjahangir25

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 Більше

$150 USD за 2 дні(-в)
(5 відгуків(и))
3.4
JITINGOYAL1992

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 Більше

$77 USD за 2 дні(-в)
(18 відгуків(и))
3.8
marudelavallaz

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 Більше

$155 USD за 3 дні(-в)
(1 відгук)
3.7
aimefx

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 - Більше

$100 USD за 2 дні(-в)
(4 відгуків(и))
3.5
saintmh

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 Більше

$222 USD за 3 дні(-в)
(1 відгук)
2.4
ketas

A proposal has not yet been provided

$250 USD за 5 дні(-в)
(8 відгуків(и))
2.4
techsoftpk

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 Більше

$155 USD за 3 дні(-в)
(1 відгук)
1.1
AmiParvez

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

$45 USD за 3 дні(-в)
(1 відгук)
0.0
adeelab

I can finish this project in time. I know Microsoft Excel. I can assure you 100% satisfaction Relevant Skills and Experience Microsoft Exce Proposed Milestones $77 USD - dsaffd

$77 USD за 3 дні(-в)
(0 відгуків(и))
0.0
danpressl

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 Більше

$200 USD за 3 дні(-в)
(0 відгуків(и))
0.0