I subsequently released a LibreOffice version which used the native Yahoo stock symbol so it could be used for any stock, fund, index or currency provided by Yahoo.
Following a recent discussion with
we've updated the Excel and LibreOffice versions to be consistent and allow the use of anything on Yahoo. This is done by added a Parameters sheet, with a parameter Automatically add ".L" suffix to stock symbols? which has the default set to Yes for the Excel version and No for the LibreOffice version. The default can be changed by the user. If the value is set to No, the data also displays the currency. For Yes, the data is in GBp, as previouslyssnw1610 wrote:SSNW1610
This should make both versions more useful and versatile. They can be used as a simple price source for customised spreadsheets, using a VLOOKUP to extract the data.
The new versions are at: http://lemonfoolfinancialsoftware.weebl ... crape.html
--kiloran