When using the
GOOGLEFINANCE formula to get historical prices and performance for different periods, if the date used in the formula is one where the market was closed the formula returns
#N/A. This occurs for every weekend as well as market holidays.
Since I'm looking at performance, the correct price for a stock on a date the market was closed is the close price of the last date the market was open prior to that date.
I have seen workarounds using
WORKDAY, but that would involve having a separate table with all the market holidays. This seems like a common enough problem for there to be an easier solution.
Is there another way to obtain the price for the last open market date for any given date?