Hi,
I am trying to fetch yesterday price from google sheet with google finance function. But it just returns NA
=INDEX(GOOGLEFINANCE(B2,"price",date(2020,10,28)),2,2)
=INDEX(GOOGLEFINANCE("NSE:INFY","price",date(2020,10,28)),2,2)
Hi,
I am trying to fetch yesterday price from google sheet with google finance function. But it just returns NA
=INDEX(GOOGLEFINANCE(B2,"price",date(2020,10,28)),2,2)
=INDEX(GOOGLEFINANCE("NSE:INFY","price",date(2020,10,28)),2,2)
Last edited by grcshekar; 10-29-2020 at 01:34 AM.
But it works for;
date(2020,10,27)Please Login or Register to view this content.
may be it's a holiday on date(2020,10,28)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks