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.

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well. Apr 8, 2021 at 17:33

1 Answer 1


You can use the following formula

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

enter image description here

Functions used:

  • thanks for the answer, it helped me a lot, i did a small manipulation against each of my share with below query. =MAX(QUERY(GOOGLEFINANCE("NSE:"&A2&"", "ALL",H2 ,I2),"select Col3",1)) , =MIN(QUERY(GOOGLEFINANCE("NSE:"&A2&"", "ALL",H2 ,I2),"select Col4",1)) I have one more small issue when start date in Today()-1, the formula gives an error, if you can help with that also it would really help. Apr 9, 2021 at 11:12
  • "thanks for the answer, it helped me a lot". Glad I could help. As for the "one more small issue", please read how to and share a test sheet so as you can be easier helped. While preparing the sheet, do take the time and -as mentioned before- accept this answer. Apr 10, 2021 at 0:34
  • please find a link of my demo sheet. docs.google.com/spreadsheets/d/… Apr 12, 2021 at 16:15
  • So sorry for the late reply. Have you solved your issues or still face problems? Apr 17, 2021 at 5:41
  • Thanks for looking, but still i am looking for an answer. Apr 17, 2021 at 13:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.