Sub CreateNewQuery() p355 VBA and Macros for Microsoft Excel

[ExcelQuant]

I've been using the sub for over a year with no problem to download security prices to Excel.

The routine no longer works.
The symbols are updated ok, but price data is not downloaded to the "portfolio" and "workspace" sheets.

Has Yahoo changed their table structure?
What changes need to be made to the sub?

Thanks

 

[starl]

Yes, Yahoo has changed their layout - which they do often.

For now - find the line:

 .WebTables = "20"

and change it to

        .WebTables = "14"

in the future, what you can do is go the the Workspace sheet, manually edit the query (Data, Import External Query, Edit Query) and see what table is checked. if it's the proper table - then the problem is elsewhere. If it's not, then you need to find the proper table and modify the code accordingly.

 

[ExcelQuant]

Thank you so much. I should have contacted you three days ago.
It would have saved me the work of creating symbol strings for manual
links to the data which I then exported to Excel. That worked OK for stocks with uniques symbols, although it was obviously brute force.

On the other hand, I created options valuations model in which the option symbol is dynamically constructed based on code tables for option type ("put" or "call"), expiration month and exercise price. There wa no way I could do the downloads manually.

Again, thanks for your help. This site is a goldmine.

ExcelQuant