Hi All, One of the viewers just reached out to me mentioning that the formula discussed in this video is now resulting in one day earlier price as it should considering we are using "Date-1,"Date" as an input. It looks like Google Finance has patched things now. So in case you are working on your sheets and facing the same issue, Don't worry, Just remove "-1" from the formula and let the input be "DATE","DATE" in the function, that will give you the price for that particular date. I'll be testing this out at my end to ensure its working for all Tickers and then also make a video on this if it is indeed :)
Hi All, One of the viewers just reached out to me mentioning that the formula discussed in this video is now resulting in one day earlier price as it should considering we are using "Date-1,"Date" as an input. It looks like Google Finance has patched things now.
So in case you are working on your sheets and facing the same issue, Don't worry, Just remove "-1" from the formula and let the input be "DATE","DATE" in the function, that will give you the price for that particular date. I'll be testing this out at my end to ensure its working for all Tickers and then also make a video on this if it is indeed :)
Making very useful and educational content, thanks.
Pls keep making such content.
@@kevalkumar9694 Thank you so much for your kind words sir 🙂