LivePrice
LivePrice is a spreadsheet developed by anc1. The original announcement from anc1 is available at this link.
It extracts data from Yahoo for the FTSE-100 and FTSE-250 and lists bid/offer/last price among other bits of data. It also lists some indices and currency exchange rates.
The Excel version uses the getdata() function developed by anc1, and which is referenced on various other discussion on The Motley Fool
The original Excel version has not been maintained since its announcement. An Openffice/LibreOffice version (similar in principle but not identical) is also available
17Jan20
It has been noted that both versions now fail due to changes in Yahoo. Fix is pending
It extracts data from Yahoo for the FTSE-100 and FTSE-250 and lists bid/offer/last price among other bits of data. It also lists some indices and currency exchange rates.
The Excel version uses the getdata() function developed by anc1, and which is referenced on various other discussion on The Motley Fool
The original Excel version has not been maintained since its announcement. An Openffice/LibreOffice version (similar in principle but not identical) is also available
17Jan20
It has been noted that both versions now fail due to changes in Yahoo. Fix is pending
Excel version
-------> |
|
OpenOffice version
-------> |
|