@kuldeep_agarwal Was the sequence ok last week? If yes, please check if there are some values that are not ok this week.
You will remember that we had an issue of Google Finance fetching the prices about a month ago. At that time, we changed our function also. Please see if you are using the latest function so that there are no errors coming from this. This is the function we are using now.
=INDEX(GOOGLEFINANCE(“NSE:”&$B$4,“price”,$A465-1),ROWS(GOOGLEFINANCE(“NSE:”&$B$4,“price”,$A465-1)),2) where B4 is the scrip symbol and A465 is the date.
I have not included any special sessions in my sheet. Please check if you have. No harm if you have done; you just need to keep using it.
Last option is to use the function we are currently using to fetch prices from one month back until last weekend.