Displaying 1 result from an estimated 1 matches for "vartd".
Did you mean:
vard
2008 Feb 15
2
How to estimate weekly Variance
Dear All:
Using the Excel formula below I am able to estimate
daily variance(Daily VarPD)for PD,but I can't figure
out how to estimate the Weekly variance for PD. Any
hints?
Daily VarPD = (PD * (1 - TD))/TD + VarTD *
((PD*(1-TD)+ PD^2*TD))/TD^3
WK TD VARTD PD Daily VarPD
28 0.014735 0.0000449 0 0
28 0.012421 0.0000449 0 0
28 0.014396 0.0000449 71 7005
28 0.014898 0.0000449 132 14016
28 0.013512 0.0000449 223 32506
28 0.013886 0.0000449 224 31287
28 0.013778 0.0000449 218 30528
29 0.013274 0...