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
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
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
That's it. Thank you.
Missing Stock Quotes
