@kuldeep_agarwal I don’t know if you use the same formula as I have done, but please consider the following.
- This is the formula I use. =index(GOOGLEFINANCE(“NSE:”&$B$4,“price”,$A400-1),2,2). You will notice that if you need the price for 11/04/2024, you should write, (11/04/2024-1). This is the way google Finance picks the correct date.
- If you have got the above correct, please check after 9am. I have seen that google finance seems to be picking up the updated information after 9 only.
| Subscribe To Our Free Newsletter |
