Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to Howyoudoin,servodude,tjh290633,csearle,jfgw, for Donating to support the site

LLPC in Google Finance

Discussions regarding financial software
swill453
Lemon Quarter
Posts: 2437
Joined: November 4th, 2016, 6:11 pm
Has thanked: 156 times
Been thanked: 678 times

LLPC in Google Finance

#249557

Postby swill453 » September 5th, 2019, 1:02 pm

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.

mrbrightside
2 Lemon pips
Posts: 123
Joined: March 10th, 2017, 11:44 am
Has thanked: 55 times
Been thanked: 36 times

Re: LLPC in Google Finance

#249954

Postby mrbrightside » September 6th, 2019, 4:53 pm

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.

torata
2 Lemon pips
Posts: 208
Joined: November 5th, 2016, 1:25 am
Has thanked: 68 times
Been thanked: 63 times

Re: LLPC in Google Finance

#250431

Postby torata » September 9th, 2019, 7:48 am

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

TedSwippet
Lemon Slice
Posts: 372
Joined: November 4th, 2016, 12:57 pm
Has thanked: 54 times
Been thanked: 130 times

Re: LLPC in Google Finance

#250434

Postby TedSwippet » September 9th, 2019, 8:23 am

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:

Code: Select all

=INDEX(IMPORTHTML(B1, "table", 1),1,2)


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 3 guests