Value at Risk (VaR ... Repeat this process for each historical day. 3. Calculate the mean of the historical returns from Step 2. In Excel, this can be achieved by using the average function.