Hi, I've come upon a macro (attached, with extension changed to .txt) which fetches data from a yahoo finance site.
In its current state, the macro retrieves historical data from one stock at a time upon click of a button.
Would it be possible to tweak this so that the macro fetches data on mulitple stocks and populates tables much like the mockup I've attached?
And rather than choosing start and end dates, could the macro show a start date of today()-50 and a fixed row length of 50?
Thanks for any help with this.
(and if you'd like I can upload the xlsm workbook I'm borrowing from)
Bookmarks