The Lemon Fool

I have a Google spreadsheet which looks up prices for my portfolio. Most things work OK, for example

=GOOGLEFINANCE("LON:NTEA","price")

returns the price of my Aviva preference shares.

However

=GOOGLEFINANCE("LON:LLPC","price")

for my Lloyds preference shares returns no data, and puts "#N/A" in the cell.

Does anyone know if there's a way of getting this to work?

Scott.

LLPC isn't covered by Google Finance. Not sure what you can do apart from ask them to add it (long shot) or find another data source.

swill453 wrote:I have a Google spreadsheet which looks up prices for my portfolio.

Does anyone know if there's a way of getting this to work?

Scott.

Use "import table" in another tab (to keep things clean)
=IMPORTHTML(B1, "table", 1)

Where B1 is the URL for your datasource, e.g. for me for NWDB
https://www.londonstockexchange.com/exchange/prices-and-markets/stocks/summary/company-summary/GB0006227051GBGBXSSX3.html

This returns the data from that page (actually the table where the data is presented)
You can then link the actual cell that shows the price into your original tab.

You may need to change the 1 to 2, etc depending on if the data is first table or second or other, but 1 works for LSE page I linked to.

Hope that makes sense.

torata

torata wrote:This returns the data from that page (actually the table where the data is presented)
You can then link the actual cell that shows the price into your original tab.

Enclosing the HTML import in the appropriate INDEX() will pull the wanted price directly as a single cell. That's a way to eliminate any added tab. For your example URL this would be: