I want to get last 40 days close price of stocks.
I used below formula for the same but the result not showing the last day close price.
=QUERY( GOOGLEFINANCE("nse:"&B2,"all",$A$2-80,81), "SELECT Col5 WHERE Col1 <= date '"&TEXT($A$2+1, "YYYY-MM-DD")&"' order by Col1 desc limit 40",False )
It updates next day evening. I mean for example today is
Friday 27 Sep 1:15 PM (India) but result is showing up to 25 Sep. Data for 26 will be shown today evening.
Can someone please help me out?