How do I display the last known price of a security?

 

For some thinly traded securities, there is no current price and no historical price for a number of days. To display the last known historical price, use this formula:

 

=Q("MSFT","p",,"-1y",FALSE)

 

where MSFT is the ticker of interest

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017