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.