Hi Bro's
first of all i want to clarify that most recent one LTP will be on no.1 position and 10th day in past will be on 10 position
please check my image and tally with NSE data.
This excel use log function which picks data from location where we are feeding
Now khushi mam has choice: either she put most recent day on top or at bottom, Now while calculating volatility she put more emphasis on most recent data so she gave preference to recent data to top then a day before yesterday on 2nd and so on.
Hope I have cleared some confusion.
first of all i want to clarify that most recent one LTP will be on no.1 position and 10th day in past will be on 10 position
please check my image and tally with NSE data.
This excel use log function which picks data from location where we are feeding
Now khushi mam has choice: either she put most recent day on top or at bottom, Now while calculating volatility she put more emphasis on most recent data so she gave preference to recent data to top then a day before yesterday on 2nd and so on.
Hope I have cleared some confusion.
u mean to say that at number 1 position it should be last close price and after that i have to consider all prices in decreasing order , and 1st LTP price is not associated with the decreasing order with other prices ...hope u understand wat i'm asking