I'm trying to pull 1/1/2021 stock price data with google finance but it gives an error. I can do it for 2020 or any other time but not 2021. Please write if you know how to solve.
=index(GOOGLEFINANCE("AAPL","close",DATE(YEAR(TODAY()),1,1)),2,2)
you can run:
=GOOGLEFINANCE("AAPL", "close", DATE(2020, 12, 1), TODAY())
and see that there is no value for your date as of right now
solution: