How to get Google Sheets (Google Finance) to show today's close value

Question

I am able to get todays high / low / open with below formula correctly.

=INDEX(GOOGLEFINANCE("NSE:CIPLA", "HIGH"))  // considering changing second param

but I cant get the today's close with below formula.

=INDEX(GOOGLEFINANCE("NSE:CIPLA", "CLOSE"))

it gives below error -> "Function GOOGLEFINANCE parameter 2 value is invalid for the symbol specified"

I checked the [stock](https://finance-preprod.sandbox.google.com/quote/CIPLA:NSE?window=5D) manually in Google Finance site, If you will see the 5D data, the latest date May 25 onward is not yet available. I tried getting the close date from a range of date and the last valid data was from May 24. `=GOOGLEFINANCE("NSE:CIPLA", "CLOSE", today()-7,today())` — Ron M, May 25 '21 at 16:24

score 0 · Answer 1 · answered May 25 '21 at 21:20

0

Apparently you need to specify the date and I was only able to get the close from the previous day

=INDEX(GOOGLEFINANCE("NSE:CIPLA", "CLOSE",TODAY()-1))

answered May 25 '21 at 21:20

JohnA

1

yes @JohnA it never give todays close it seems. It always give yesterdays close. – codingHack May 26 '21 at 05:21

1 Answers1