I use a Google Sheet to record end of data prices for my portfolio and since last week two of my long held shares refuse to update and show the latest prices. All other lines seem unaffected. I have deleted and recreated the lines but it does not work. I have started a new Sheet and cannot get the prices. The two are BP. and CCC (Computercentre).
I can get prices from Google directly so I know there has been no ticker change etc, https://www.google.com/finance/quote/CCC:LON but in my sheet all I see is #N/A
The 2 stocks are in consecutive rows, but I don't believe that is relevant. They are also the 5th and 6th shares, so the table reads:
Any ideas what is wrong and how to make it work again?
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Wasron,jfgw,Rhyd6,eyeball08,Wondergirly, for Donating to support the site
Another data harvesting problem, Googlefinance
-
- Lemon Quarter
- Posts: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3254 times
- Been thanked: 2855 times
Re: Another data harvesting problem, Googlefinance
I believe the Google ticker symbol for BP is BP
Not BP. (no trailing period),
BP works for me in a Google Finance sheet I set up a few years ago,
No idea why CCC isn't working. I can only guess it's a temporary glitch
--kiloran
Not BP. (no trailing period),
BP works for me in a Google Finance sheet I set up a few years ago,
No idea why CCC isn't working. I can only guess it's a temporary glitch
--kiloran
-
- Lemon Quarter
- Posts: 3141
- Joined: November 4th, 2016, 11:12 am
- Has thanked: 3648 times
- Been thanked: 1522 times
Re: Another data harvesting problem, Googlefinance
Tri2000 wrote:I use a Google Sheet to record end of data prices for my portfolio and since last week two of my long held shares refuse to update and show the latest prices. All other lines seem unaffected. I have deleted and recreated the lines but it does not work. I have started a new Sheet and cannot get the prices. The two are BP. and CCC (Computercentre).
I can get prices from Google directly so I know there has been no ticker change etc, https://www.google.com/finance/quote/CCC:LON but in my sheet all I see is #N/A
The 2 stocks are in consecutive rows, but I don't believe that is relevant. They are also the 5th and 6th shares, so the table reads:
Any ideas what is wrong and how to make it work again?
BP works fine for me without the trailing period. Computercentre doesn't.
RC
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Another data harvesting problem, Googlefinance
BP shows today's price as 24p
LON:BP shows the correct price
CCC is returning Carlyle Commodities Corp in Google finace
but HL show it correctly
https://www.hl.co.uk/shares/shares-sear ... -ord-7-59p
Odd?
LON:BP shows the correct price
CCC is returning Carlyle Commodities Corp in Google finace
but HL show it correctly
https://www.hl.co.uk/shares/shares-sear ... -ord-7-59p
Odd?
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
-
- Lemon Quarter
- Posts: 2365
- Joined: November 4th, 2016, 8:46 pm
- Has thanked: 527 times
- Been thanked: 1013 times
Re: Another data harvesting problem, Googlefinance
pje16 wrote:BP shows today's price as 24p
LON:BP shows the correct price
CCC is returning Carlyle Commodities Corp in Google Finance
but HL show it correctly
https://www.hl.co.uk/shares/shares-sear ... -ord-7-59p
Odd?
Just spotted this -- sorry, this is a wonderful board, but one that I come to far too infrequently.
BP wasn't showing as 24p. It was showing as $24. If you don't specify a precise stock market, it's all too easy for Google Finance to get confused, and default to American prices.
What you were actually looking up was NYSE:BP, whereas what you wanted was LON:BP -- try it.
MDW1954
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Another data harvesting problem, Googlefinance
OK thanks
I didn't realise without a prefix it was showing NYSE
cheers
Paul
PS I have quite a few UK ones on my Google finance sheet without the Lon Prefix but I guess UK is the only place they are quoted
I didn't realise without a prefix it was showing NYSE
cheers
Paul
PS I have quite a few UK ones on my Google finance sheet without the Lon Prefix but I guess UK is the only place they are quoted
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 28 guests