Yahoo deleted their Finance API a few weeks ago, so the "Simple Yahoo Price Scrape" no longer works.
I've updated the Excel and LibreOffice spreadsheets to get them functional again, and renamed them "Simple Price Scrape". They are available at: https://lemonfoolfinancialsoftware.weeb ... crape.html
A few notes:
- The original Yahoo version allowed the downloading of global prices, market indices, and exchange rates. The new version is restricted to share prices on the London Stock Exchange (but does include bonds and ETFs)
- The process initially loads prices for shares in the FTSE All-Share index, then fills in any gaps on a share-by-share basis
- Shares must now be referenced using the EPIC symbol (so, for example, BT.A and not the Yahoo symbol BT-A,L)
- The price source for the data is https://shareprices.com/ which was chosen for the relatively simple process to extract data and speed of response