Fix faulty response to web query in Excel
When I access historical prices for ASX stocks the results are missing dates for all of September. The fault first occurred for 2 Sept and some attempts to rectify it have only introduced other faults. I access the table using Data/From Web and, for example, URL https://au.finance.yahoo.com/quote/ANZ.AX/history?p=ANZ.AX in Microsoft Excel for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20256) 64-bit . There is no way I can tell if the bug is in the feed from the ASX or in Yahoo's software.
3rd
ranked
John Sharp
shared this idea
