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"

Answer 1

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))