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. – marikamitsos Apr 8 at 17:33

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. – Himanshu Shekhar Apr 9 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. – marikamitsos Apr 10 at 0:34
  • please find a link of my demo sheet. docs.google.com/spreadsheets/d/… – Himanshu Shekhar Apr 12 at 16:15
  • So sorry for the late reply. Have you solved your issues or still face problems? – marikamitsos 2 days ago
  • Thanks for looking, but still i am looking for an answer. – Himanshu Shekhar 2 days ago

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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