@aakash11agarwal The index is updated manually only. I had extended the value more for copying the formula for 50 and 200DMA.
Index values are obtained from https://www.niftyindices.com/reports/historical-data
On the left you have a drop down menu where you can choose Equity, whatever index you want and the date range. The values will come up on the right. I then download the csv file and copy / paste them onto the sheet.
I hope the lookback date you have put is a typo as it should be 24/11/2023 and not 01/12/2023.
Virtually the entire list is matching; small differences in the ranking and with respect to KESORAMIND and IIFLSEC. I will post my list and you can see the differences.