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:




where MSFT is the ticker of interest




Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017