Function STOCKHISTORY and its Troubling NA errors

[DRSteele]

DRSteele submitted a new Excel article:

Function STOCKHISTORY and its Troubling NA erros - get STOCKHISTORY to report ALL the data between two dates

The relatively new function STOCKHISTORY is terrific in most respects. Of course, it’s not without deficiencies. Principally, it delivers data only for dates that the source possesses, that source being Refinitiv. When a security did not trade for whatever reason or Refinitiv does not have the data, the function reports NA. This NA error is most troublesome when making calculations across dates and securities.

Take for example a portfolio of stocks going across columns and dates and another...

Read more about this Excel article...

 

[DRSteele]

Jerry has written another viewpoint on the topic, here.

 

[manen2312]

DRSteele,
such a great solution. THANK YOU.

How would you set up the sheet for the dates to be in reverse order? So most recent dates at the top.

A2 = today ()
A3 = today -1
A4 = today -2 etc

Think the SORT function is helpful
SORT(STOCKHISTORY(I2, $B$2, TODAY(), 0, 0, 0,2,3,4,1,5),1,-1)

Cheers