Search code examples
google-sheetsgoogle-finance

How to pull 1 January 2021 stock price data with google finance


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)

Solution

  • 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:

    • wait a day or more
    • grab it from an alternative source (yahoo finance)