WebCab XL Community Edition

Volatility.HistVolError Method 

Returns the estimate of the standard error of the standard historical estimation given by the functions historicalEstimate and historicalEstimateWithDividends.

public double HistVolError(
   double numberOfDays,
   double VolEstimate
);

Parameters

numberOfDays
VolEstimate
Estimate of the volatility per annum.

Remarks

Recall that the standard error is the standard deviation of the sampling distribution of that statistic. Standard errors are important because they reflect how much sampling fluctuations effect the reliability of the statistic, in this case the estimate of the volatility. The standard error of a statistic will depend on the sample size where generally the larger the sample size the smaller the standard error will be.

Excel Remarks

The full name of this function inside Excel is Port_Volatility_HistVolError.

See Also

Volatility Class | Portfolio Namespace