Hi @visuarchie Sir,
I have checked every date value with Google Finance and Yahoo Finance for each day.
I can confirm all the data is correct from my side and there is 1 issue I found that is causing this changing data from Google Finance.
googleFinance function returns 2 rows but sometimes it returns 3 rows and our index function is picking 2,2, causing the same data to be picked for different dates.
Please find an updated formula which I tried in my sheet.
=INDEX(GOOGLEFINANCE(“NSE:”&C$4,“price”,$B7-1), ROWS(GOOGLEFINANCE(“NSE:”&C$4,“price”,$B7-1)), 2)
I got the same list as yours, but the order is different for some stocks.
Doubt: You have not made price changes for last week, which can cause the order to be different as we are considering 1-year and 6-month data in the standard deviation formula.
I downloaded the data from Bhav copies and verified them for the 3rd and 14th of June.
No difference I found in the price for these 2 dates.
Please check and verify the same.
| Subscribe To Our Free Newsletter |
