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.
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Wasron,jfgw,Rhyd6,eyeball08,Wondergirly, for Donating to support the site
LLPC in Google Finance
-
- Lemon Half
- Posts: 7988
- Joined: November 4th, 2016, 6:11 pm
- Has thanked: 989 times
- Been thanked: 3658 times
-
- 2 Lemon pips
- Posts: 139
- Joined: March 10th, 2017, 11:44 am
- Has thanked: 83 times
- Been thanked: 45 times
Re: LLPC in Google Finance
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.
-
- Lemon Slice
- Posts: 524
- Joined: November 5th, 2016, 1:25 am
- Has thanked: 207 times
- Been thanked: 212 times
Re: LLPC in Google Finance
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
-
- Lemon Slice
- Posts: 578
- Joined: November 4th, 2016, 12:57 pm
- Has thanked: 135 times
- Been thanked: 299 times
Re: LLPC in Google Finance
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 42 guests