
New Member

July 5, 2021

I have a problem with stock history as one of the stocks did not get completely filled. See the file under the company PLTR. It gives me a N/A error. The formula has not been modified (TRANSPOSE(STOCKHISTORY(B24,TODAY()-365,TODAY(),0,0,1)). The rest of the companies are fine (name, ticker, etc).
Can you help us with this and why is it happening?
Thank you!
Ernst


July 16, 2010

Hi Ernst,
Welcome to our forum and thanks for sharing your file.
This stock doesn't have data until Sep 9, 2020. If you enter this formula in a column:
=STOCKHISTORY(B6,TODAY()-365,TODAY(),0,0,0,1)
You can see #N/A errors start at Sep 14, 2020, which is when the stock became active, but no pricing data yet. Then on Sep 30, 2020 prices start. You'll need to modify the formula to reference the dates in column 2:
=STOCKHISTORY(B6,M2:JD2,TODAY(),0,0,1)
If you want to hide the errors:
=IFERROR(STOCKHISTORY(B6,M2:JD2,TODAY(),0,0,1),"")
Mynda

Answers Post

New Member

July 5, 2021

Good morning, Thank you so much for your help!
I updated it as you mentioned, and it worked as you said!... On a side note, is there a reason why some stocks may show blank data towards the most recent date? Like for instance the same one I had the issue with - I see blank cells towards the most recent date.
Thank you again for your assistance. It's been very well appreciated.
Ernst.
1 Guest(s)
