GOOGLEFINANCE – Get High & Low and Timestamp in Google Sheets

formulasgoogle sheetsgoogle-financegoogle-sheets-query

I wanted to keep a track of high/low of a trade from the day I took the trade.
For a day I am able to get high/low but how to get from the date I took my trade which is stored in one of cell.

=IFERROR(GOOGLEFINANCE("NSE:"&A2&"","HIGH"))

Best Answer

You can use the following formula

=QUERY(GOOGLEFINANCE("NSE:"&C1&"", "ALL",C2 ,C3),"select Col1, Col3, Col4",1)

enter image description here

Functions used: