Build excel spreadsheet accessing most current stock price
$30-250 USD
货到付款
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.
项目ID: #14295173
关于项目
有20名威客正在参与此工作的竞标,均价$184/小时
#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 更多
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 更多
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 更多
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 更多
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 更多
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 更多
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 更多
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 更多
I am able to do the job Relevant Skills and Experience Data entry , Excel Proposed Milestones $45 USD - Create one milestone
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