Donate to Remove ads

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

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

Another data harvesting problem, Googlefinance

Discussions regarding financial software
Tri2000
Posts: 18
Joined: November 9th, 2016, 8:48 pm
Has thanked: 13 times
Been thanked: 10 times

Another data harvesting problem, Googlefinance

#440163

Postby Tri2000 » September 6th, 2021, 8:56 pm

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?

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: Another data harvesting problem, Googlefinance

#440169

Postby kiloran » September 6th, 2021, 9:20 pm

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

ReformedCharacter
Lemon Quarter
Posts: 3120
Joined: November 4th, 2016, 11:12 am
Has thanked: 3591 times
Been thanked: 1509 times

Re: Another data harvesting problem, Googlefinance

#440235

Postby ReformedCharacter » September 7th, 2021, 10:07 am

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Another data harvesting problem, Googlefinance

#440268

Postby pje16 » September 7th, 2021, 11:44 am

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?

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Another data harvesting problem, Googlefinance

#440576

Postby pje16 » September 8th, 2021, 11:32 am

LON:CCC
works now - just tested it :D

MDW1954
Lemon Quarter
Posts: 2358
Joined: November 4th, 2016, 8:46 pm
Has thanked: 526 times
Been thanked: 1011 times

Re: Another data harvesting problem, Googlefinance

#441714

Postby MDW1954 » September 12th, 2021, 7:52 pm

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

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: Another data harvesting problem, Googlefinance

#441721

Postby pje16 » September 12th, 2021, 9:00 pm

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


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 11 guests