Numbers - UK stock prices have stopped updating on spreadsheet

Question

Level 1

13 points

Numbers - UK stock prices have stopped updating on spreadsheet

Got through to Apple Support, via phone.

They tried it their side and confirmed there is a problem (after they tried to create a stock price, on their side), with it not updating. (US stocks are OK)

They concluded they cannot help me (us), as it's not an Apple issue, but try to contact Yahoo Finance.

Not the result (help) I expected... 😱

Anyone else have this problem and found any solutions?

(Pic below, from 22/4/21, date of stock update, 16/4/21.

Posted on Apr 21, 2021 3:28 PM

Reply

Answer 1

Apr 29, 2021 4:00 AM in response to Atreides67

Found a workaround for closing prices, normally I would use STOCKH but I've tweaked my formula in such that if I start it in the morning during the small window of time that this works it will remember (or cache the result somewhere) that it is usable during the entire day.

The formula is: IFERROR(STOCKH("INGA.AS",0,"2021-04-28"),STOCK("INGA.AS",price))

This means starting the spreadsheet every morning in the correct time window who's exact boundaries are still unknown ;-)

Hope this helps for others as well.

Reply

Answer 2

Apr 22, 2021 2:05 AM in response to Atreides67

I've got the same problem with Euronext listings, no historical prices after the 9th of april 2021. It's a continuing issue on certain events it stops working, like year end, daylight savings, etc. I wish they could do a bit better and monitor the correct workings. The data works and is available at finance.yahoo.com so it must be somewhere in the interfacing between Apple and Yahoo and thus a joint problem.

Reply

Answer 3

SGIII

Level 8

37,532 points

Apr 21, 2021 8:15 PM in response to Atreides67

If that is the help you got from Apple (that it’s Yahoo! Finance’s fault and you should contact them) then that’s not helpful at all. I recommend filing a bug report at Numbers > Provide Numbers Feedback in your menu. This lately has become perhaps the number one recurring issue being reported in this forum.

SG

Reply

Answer 4

Atreides67 Author

Level 1

13 points

Apr 22, 2021 2:14 AM in response to Richard Valk

Hi Richard,

If you have not done it already, do what SGill suggested, on this thread. and go to Numbers and ( Numbers > Provide Numbers Feedback in your menu)

Maybe now we know its not a problem on our side, we can 'bombard' them with feedback... :)

It's painful with the non- updating bug and a pain that Customer Support does not 'appear' to want to tackle the problem, themselves.

Martin

Reply

Answer 5

Atreides67 Author

Level 1

13 points

Apr 27, 2021 5:52 AM in response to Richard Valk

Richard,

Do me a favour and check again? My stock prices have now 'reverted' to Friday's figures (23/4/21)

Cheers

Martin

Reply

Answer 6

Apr 28, 2021 1:01 AM in response to Atreides67

Thats strange, for me STOCK works by returning the close for 27th of april this morning. STOCKH still shows the 23th as the last available date. This is for the Euronext shares.

Reply

Answer 7

Atreides67 Author

Level 1

13 points

Apr 22, 2021 12:55 AM in response to SGIII

Cheers SGill.

Did not consider that option, re Numbers Feedback.

Yes, it was disappointing that they seemed not to want to take the problem further and put the 'work' on us users, to solve the problem.

The actual customer service from Apple, was very good and they were listening to me, explain the problem. They were honest enough to say they could not help.

I did ask them if they were going to monitor my issue and from other people and send it up 'higher'. Thats where I got the answer to try to solve the problem with Yahoo, myself, instead of Apple, as its a 'third party' supplier.

Cheers

Martin

Reply

Answer 8

Atreides67 Author

Level 1

13 points

Apr 22, 2021 2:23 AM in response to Richard Valk

Richard, well, the only positive that its not your side which is having the problem, which I initially thought it was me corrupting the spreadsheet, with my formulas. In someways, it's 'nice' to hear its just not me having this problem and its more universal.

Shame we don't get any feedback from Apple, that they are even looking at the problem. That would helps us a bit.Would be great to get some feedback, just to say, we are working on this problem.

Reply

Answer 9

Atreides67 Author

Level 1

13 points

Apr 28, 2021 12:54 AM in response to Atreides67

Well, the problem regarding incorrect, old stock prices, have come back within 54 minutes of my last post.

Please check screenshot.

Looks like we have. a small window to check, first thing in the morning.

My time was 08.50 CET.

Reply

Answer 10

Atreides67 Author

Level 1

13 points

Apr 29, 2021 4:04 AM in response to Richard Valk

Hi Richard,

Thanks for the possible workaround.

Noticed today (for me), it's all working fine.

First checked it around 07.30 CET and just now, as I reply to you (13.04 CET) and its still working !!! :)

Reply

Answer 11

Apr 29, 2021 4:08 AM in response to Atreides67

Good to hear, for me STOCKH is still not providing any data after the 23th of April for Euronext stocks. American stocks work fine, don't have any UK stocks in my portfolio...

The workaround keeps my current portfolio valuation working...

Reply