Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Missing Stock Quotes

I have a speadsheet that looks up stock prices by date.

In each cell is the formula: IFERROR(STOCKH(stock,close,date),"")

It has worked great until a couple weeks ago when cells for PRWCX began returning Blank from 10/16/17 — 11/3/17. After that date it returns fine again. I make a chart from the stock sums on each date and this is messing it up.


Any ideas about what's blocking this stock on those days?


Thanks

iMac, macOS High Sierra (10.13), Safari 11

Posted on

Reply
Question marked as Solved
Answer:
Answer:

Numbers gets its data from Yahoo! Finance. If you look for PRWCX on Yahoo! Finance here you'll see for some reason PRWCX was not priced for some dates. It appears to be a data problem at Yahoo! Finance.


(Yahoo! was acquired by Verizon this year. Alas, Verizon appears to be neglecting Yahoo! Finance.)


SG

Posted on

Page content loaded

Question marked as Solved

Nov 17, 2017 7:00 AM in response to Les Vogt1 In response to Les Vogt1

Numbers gets its data from Yahoo! Finance. If you look for PRWCX on Yahoo! Finance here you'll see for some reason PRWCX was not priced for some dates. It appears to be a data problem at Yahoo! Finance.


(Yahoo! was acquired by Verizon this year. Alas, Verizon appears to be neglecting Yahoo! Finance.)


SG

Nov 17, 2017 7:00 AM

Reply Helpful
User profile for user: Les Vogt1

Question: Missing Stock Quotes