Build excel spreadsheet accessing most current stock price

已取消 已发布的 6 年前 货到付款
已取消 货到付款

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