From the above screen we can see that the average price is Rs. 102, the closing price is Rs. 112 and the change in open interest is 78,675 shares. Then we will go to the historical data and download the last one month’s data in excel. After downloading the data, we need to arrange it from the lowest to the highest dates. We can delete the settlement price, the number of contracts, turnover, and also the opening prices columns. Make a column of average pri