I’d like to have an Excel spread sheet that can keep track of a specific stock price, for simplicity let’s say Apple, ticker symbol AAPL
Is there a way to do that? It doesn’t need to be up to the minute, I’d be happy with the previous day’s close.
I realize there are at least two issues involved: 1) getting the stock price, 2) calling that data in Excel. I figured someone that knows html (xtml?) would be able to get the price data from Yahoo, then it’s just a matter of calling it in Excel.
Thanks
Oops, turns out this is insanely easy. Click on the “data” tab, then click “From Web”
A little screen will pop up where you can view the page with the data on it
The next feature is kind of neat, the page will have little yellow arrows indicating data you can pull. If you scroll down a bit it will have an arrow next to the current stock data. Click that arrow then “insert.”
It will ask you where to insert the data, so you should know that before hand.
I think the next step once it’s in is to click the “refresh” button under “data” to update it.