Why is this formula returning N/A ? =INDEX(GOOGLEFINANCE("bsx","price",date(2018,1,1)))
Yet it works fine for =INDEX(GOOGLEFINANCE("bsx","price",date(2018,1,2)))
Asked
Active
Viewed 54 times
0
-
Holiday, maybe? – Paul T. Dec 29 '19 at 18:21
-
@PaulT. ok. so can I get the last price (i.e ignore a holiday). The same issue doesnt happen for a saturday or a sunday – user1438082 Dec 29 '19 at 18:24