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"))
GOOGLEFINANCE in Google Sheets to get high & low and timestamp of high/low from the day I took trade
-
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.– marikamitsosApr 8, 2021 at 17:33
Add a comment
|
1 Answer
You can use the following formula
=QUERY(GOOGLEFINANCE("NSE:"&C1&"", "ALL",C2 ,C3),"select Col1, Col3, Col4",1)
Functions used:
answered Apr 8, 2021 at 17:31
-
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
-
-
So sorry for the late reply. Have you solved your issues or still face problems? Apr 17, 2021 at 5:41
-