I'm hoping for a little help here...
I would like to link a cell, say A1 to finance.yahoo.com historical prices page... I see on their website there is a button to download the table into excel, but is there an easy way just to retrieve it without going online? Ideally I could do a few stocks, have the table change ect... I'm also going to be need to be able to do calculations off these values. So maybe have the first sheet where I have the stock and the calculations based on the values that were downloaded, then on a separate sheet have the data from yahoo.finance
Do I have to setup a connection in excel? Isn't there way to do this? I feel like it shouldn't be that hard but can't seem to figure it out.
Bookmarks