Finding VaR in Excel Below is the process of calculating VaR using a different method called the variance-covariance approach. Import relevant historical financial data into Excel.

If you are entering an investment amount, type it as a negative number, because it represents money you are currently spending. If this is the variable you wish to calculate, omit this step.