I’ve been drawn back to this thread since I now reckon this issue only concerns the pricing of funds while quotes for stocks and ETFs are unaffected - indeed, Yahoo continues to provide both the latest and historical quotes in GBX for these types of investments.
For those that have been affected by this issue, building on the earlier post by @ProgFriese, I set out below what seems to be a good solution, which can be easily implemented (without any need to modify the XML, or entailing any manual edits via an export/import sequence):-
- Use this JSON URL, which will provide access to both current and historical quotes - https://query2.finance.yahoo.com/v8/finance/chart/0P0000XAFE.L?period1=1546300800&period2=1924905600&interval=1d&events=history&includeAdjustedClose=true
- Note, this retrieves data for a certain timeframe, set between ‘period1’ and ‘period2’ and is expressed as Unix timestamps. Modify these timestamps with a converter as you see fit. As things stand ‘period1’ is set to 1/1/2019, while ‘period2’ is set @ 31/12/2030 – meaning all future quotes will continue to be retrieved until the end of that year.
- Path to date = chart.result[0].timestamp[*]
- Path to Close = chart.result[0].indicators.quote[0].close[*]
- Finally, if needs be, set the factor (for quotes) to 100.