Stock Function in Numbers

Question

Level 1

4 points

Stock Function in Numbers

I am using two separate non-linked numbers files (numbers version 11.1 (7031.0.102)). In each file I use the stock() function to return the current price of multiple stocks. I am currently experiencing an issue in that the function returns a different result for the same stock symbol in each file. This is random and eventually corrects itself over time but is very annoying. Although the issue does not always occur for the same stock here is an example of one that is currently an issue:

file 1: stock (CEQP-P) = $9.55

file 2: stock (CEQP-P) = $9.397

Has anyone experienced this issue? If so how can it be corrected or is this a known apple bug?

Posted on Jun 11, 2021 1:55 PM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,996 points

Jun 11, 2021 9:04 PM in response to renzo163

I recommend going to Numbers > Provide Numbers Feedback in your menu and filing a bug report (it's one of the choices under feedback type), with a link to this thread.

There have been many reported problems with STOCK and STOCKH. The more information the iWork team has on this the better, though you are unlikely to receive a reply.

Numbers gets its stocks data from Yahoo! Finance and there appear to be recurring problems with the data feed.

SG

Reply

Answer 2

Badunit

Level 7

31,351 points

Jun 11, 2021 7:11 PM in response to Badunit

I tried STOCKH and it is providing prices for that symbol even though STOCK is not.

Reply

Answer 3

Badunit

Level 7

31,351 points

Jun 11, 2021 7:07 PM in response to renzo163

Yahoo Finance. I tried it just now in a new document and there is no data available for that symbol. So, my guess is file 1 was opened on June 5th and that's when it got its last update for that stock. Now it is getting no new data so it is sticking with the data it has. File 2 was able to get an update today (June 11) and has the June 10 closing price.

Reply

Stock Function in Numbers

Similar questions