Advanced Statistics: ETF OPTION TIMER

Advanced Statistics module contributed by Jules Ellis, C2 Member.

Jules has written a very helpful guide for these statistics.

MonthlyDaily (all)Daily (last 6 mo.)
ANALYSIS BASED ON MONTHLY VALUES, FULL HISTORY (Back)
RATIO STATISTICS
Ratio statistics of excess return rates
Statistics related to Sharpe ratio
 Mean-0.016
 SD0.080
 Sharpe ratio (Glass type estimate) -0.202
 Sharpe ratio (Hedges UMVUE)-0.199
 df40.000
 t-0.374
 p0.645
 Lowerbound of 95% confidence interval for Sharpe Ratio-1.262
 Upperbound of 95% confidence interval for Sharpe Ratio0.860
 Lowerbound of 95% CI (Gibbons, Hedeker & Davis approximation)-1.260
 Upperbound of 95% CI (Gibbons, Hedeker & Davis approximation)0.863
Statistics related to Sortino ratio
 Sortino ratio-0.303
 Upside Potential Ratio1.226
 Upside part of mean0.065
 Downside part of mean-0.081
 Upside SD0.058
 Downside SD0.053
 N nonnegative terms5.000
 N negative terms36.000
Statistics related to linear regression on benchmark
 N of observations41.000
 Mean of predictor0.124
 Mean of criterion-0.016
 SD of predictor0.098
 SD of criterion0.080
 Covariance0.001
 r0.140
 b (slope, estimate of beta)0.115
 a (intercept, estimate of alpha)-0.030
 Mean Square Error0.006
 DF error39.000
 t(b)0.885
 p(b)0.191
 t(a)-0.659
 p(a)0.743
 Lowerbound of 95% confidence interval for beta-0.147
 Upperbound of 95% confidence interval for beta0.377
 Lowerbound of 95% confidence interval for alpha-0.124
 Upperbound of 95% confidence interval for alpha0.063
 Treynor index (mean / b)-0.141
 Jensen alpha (a)-0.030
Ratio statistics of excess log return rates
Statistics related to Sharpe ratio
 Mean-0.019
 SD0.079
 Sharpe ratio (Glass type estimate) -0.241
 Sharpe ratio (Hedges UMVUE)-0.237
 df40.000
 t-0.446
 p0.671
 Lowerbound of 95% confidence interval for Sharpe Ratio-1.302
 Upperbound of 95% confidence interval for Sharpe Ratio0.822
 Lowerbound of 95% CI (Gibbons, Hedeker & Davis approximation)-1.298
 Upperbound of 95% CI (Gibbons, Hedeker & Davis approximation)0.825
Statistics related to Sortino ratio
 Sortino ratio-0.350
 Upside Potential Ratio1.159
 Upside part of mean0.063
 Downside part of mean-0.083
 Upside SD0.056
 Downside SD0.055
 N nonnegative terms5.000
 N negative terms36.000
Statistics related to linear regression on benchmark
 N of observations41.000
 Mean of predictor0.119
 Mean of criterion-0.019
 SD of predictor0.096
 SD of criterion0.079
 Covariance0.001
 r0.147
 b (slope, estimate of beta)0.121
 a (intercept, estimate of alpha)-0.033
 Mean Square Error0.006
 DF error39.000
 t(b)0.927
 p(b)0.180
 t(a)-0.733
 p(a)0.766
 Lowerbound of 95% confidence interval for beta-0.143
 Upperbound of 95% confidence interval for beta0.385
 Lowerbound of 95% confidence interval for alpha-0.126
 Upperbound of 95% confidence interval for alpha0.059
 Treynor index (mean / b)-0.158
 Jensen alpha (a)-0.033
Risk estimates for a one-period unit investment (parametric)
assuming log normal returns and losses (using central moments from Sharpe statistics)
 VaR(95%)0.038
 Expected Shortfall on VaR0.048
assuming Pareto losses only (using partial moments from Sortino statistics)
 VaR(95%)0.022
 Expected Shortfall on VaR0.042
ORDER STATISTICS
Quartiles of return rates
 Number of observations41.000
 Minimum0.930
 Quartile 11.000
 Median1.000
 Quartile 31.000
 Maximum1.074
 Mean of quarter 10.987
 Mean of quarter 21.000
 Mean of quarter 31.000
 Mean of quarter 41.024
 Inter Quartile Range0.000
 Number outliers low3.000
 Percentage of outliers low0.073
 Mean of outliers low0.951
 Number of outliers high6.000
 Percentage of outliers high0.146
 Mean of outliers high1.040
Risk estimates for a one-period unit investment (based on Extreme Value Theory)
 Extreme Value Index (moments method)NA
 VaR(95%) (moments method)NA
 Expected Shortfall (moments method)NA
 Extreme Value Index (regression method)-1.319
 VaR(95%) (regression method)0.051
 Expected Shortfall (regression method)0.073
DRAW DOWN STATISTICS
Quartiles of draw downs
 Number of observations2.000
 Minimum0.027
 Quartile 10.037
 Median0.048
 Quartile 30.059
 Maximum0.070
 Mean of quarter 10.027
 Mean of quarter 2NA
 Mean of quarter 3NA
 Mean of quarter 40.070
 Inter Quartile Range0.021
 Number outliers low0.000
 Percentage of outliers low0.000
 Mean of outliers lowNA
 Number of outliers high0.000
 Percentage of outliers high0.000
 Mean of outliers highNA
Risk estimates based on draw downs (based on Extreme Value Theory)
 Extreme Value Index (moments method)NA
 VaR(95%) (moments method)NA
 Expected Shortfall (moments method)NA
 Extreme Value Index (regression method)NA
 VaR(95%) (regression method)NA
 Expected Shortfall (regression method)NA
COMBINED STATISTICS
 Annualized return (arithmetic extrapolation)0.026
 Compounded annual return (geometric extrapolation)0.025
 Calmar ratio (compounded annual return / max draw down)0.362
 Compounded annual return / average of 25% largest draw downs0.362
 Compounded annual return / Expected Shortfall lognormal0.529
ANALYSIS BASED ON DAILY VALUES, FULL HISTORY (Back)
RATIO STATISTICS
Ratio statistics of excess return rates
Statistics related to Sharpe ratio
 Mean-0.017
 SD0.078
 Sharpe ratio (Glass type estimate) -0.211
 Sharpe ratio (Hedges UMVUE)-0.211
 df1197.000
 t-0.395
 p0.507
 Lowerbound of 95% confidence interval for Sharpe Ratio-1.262
 Upperbound of 95% confidence interval for Sharpe Ratio0.839
 Lowerbound of 95% CI (Gibbons, Hedeker & Davis approximation)-1.262
 Upperbound of 95% CI (Gibbons, Hedeker & Davis approximation)0.839
Statistics related to Sortino ratio
 Sortino ratio-0.295
 Upside Potential Ratio3.501
 Upside part of mean0.196
 Downside part of mean-0.213
 Upside SD0.055
 Downside SD0.056
 N nonnegative terms110.000
 N negative terms1088.000
Statistics related to linear regression on benchmark
 N of observations1198.000
 Mean of predictor0.122
 Mean of criterion-0.017
 SD of predictor0.122
 SD of criterion0.078
 Covariance0.001
 r0.086
 b (slope, estimate of beta)0.055
 a (intercept, estimate of alpha)-0.023
 Mean Square Error0.006
 DF error1196.000
 t(b)2.987
 p(b)0.457
 t(a)-0.555
 p(a)0.508
 Lowerbound of 95% confidence interval for beta0.019
 Upperbound of 95% confidence interval for beta0.091
 Lowerbound of 95% confidence interval for alpha-0.105
 Upperbound of 95% confidence interval for alpha0.059
 Treynor index (mean / b)-0.301
 Jensen alpha (a)-0.023
Ratio statistics of excess log return rates
Statistics related to Sharpe ratio
 Mean-0.020
 SD0.078
 Sharpe ratio (Glass type estimate) -0.250
 Sharpe ratio (Hedges UMVUE)-0.250
 df1197.000
 t-0.467
 p0.509
 Lowerbound of 95% confidence interval for Sharpe Ratio-1.301
 Upperbound of 95% confidence interval for Sharpe Ratio0.800
 Lowerbound of 95% CI (Gibbons, Hedeker & Davis approximation)-1.300
 Upperbound of 95% CI (Gibbons, Hedeker & Davis approximation)0.800
Statistics related to Sortino ratio
 Sortino ratio-0.345
 Upside Potential Ratio3.432
 Upside part of mean0.195
 Downside part of mean-0.214
 Upside SD0.054
 Downside SD0.057
 N nonnegative terms110.000
 N negative terms1088.000
Statistics related to linear regression on benchmark
 N of observations1198.000
 Mean of predictor0.114
 Mean of criterion-0.020
 SD of predictor0.122
 SD of criterion0.078
 Covariance0.001
 r0.086
 b (slope, estimate of beta)0.055
 a (intercept, estimate of alpha)-0.026
 Mean Square Error0.006
 DF error1196.000
 t(b)2.985
 p(b)0.457
 t(a)-0.618
 p(a)0.509
 Lowerbound of 95% confidence interval for beta0.019
 Upperbound of 95% confidence interval for beta0.091
 Lowerbound of 95% confidence interval for alpha-0.108
 Upperbound of 95% confidence interval for alpha0.056
 Treynor index (mean / b)-0.356
 Jensen alpha (a)-0.026
Risk estimates for a one-period unit investment (parametric)
assuming log normal returns and losses (using central moments from Sharpe statistics)
 VaR(95%)0.007
 Expected Shortfall on VaR0.009
assuming Pareto losses only (using partial moments from Sortino statistics)
 VaR(95%)0.002
 Expected Shortfall on VaR0.005
ORDER STATISTICS
Quartiles of return rates
 Number of observations1198.000
 Minimum0.963
 Quartile 11.000
 Median1.000
 Quartile 31.000
 Maximum1.037
 Mean of quarter 10.998
 Mean of quarter 21.000
 Mean of quarter 31.000
 Mean of quarter 41.002
 Inter Quartile Range0.000
 Number outliers low70.000
 Percentage of outliers low0.058
 Mean of outliers low0.991
 Number of outliers high111.000
 Percentage of outliers high0.093
 Mean of outliers high1.006
Risk estimates for a one-period unit investment (based on Extreme Value Theory)
 Extreme Value Index (moments method)0.169
 VaR(95%) (moments method)0.001
 Expected Shortfall (moments method)0.003
 Extreme Value Index (regression method)0.070
 VaR(95%) (regression method)0.001
 Expected Shortfall (regression method)0.006
DRAW DOWN STATISTICS
Quartiles of draw downs
 Number of observations9.000
 Minimum0.000
 Quartile 10.002
 Median0.004
 Quartile 30.083
 Maximum0.132
 Mean of quarter 10.001
 Mean of quarter 20.004
 Mean of quarter 30.046
 Mean of quarter 40.116
 Inter Quartile Range0.081
 Number outliers low0.000
 Percentage of outliers low0.000
 Mean of outliers lowNA
 Number of outliers high0.000
 Percentage of outliers high0.000
 Mean of outliers highNA
Risk estimates based on draw downs (based on Extreme Value Theory)
 Extreme Value Index (moments method)-2.125
 VaR(95%) (moments method)0.121
 Expected Shortfall (moments method)0.122
 Extreme Value Index (regression method)-0.179
 VaR(95%) (regression method)0.141
 Expected Shortfall (regression method)0.165
COMBINED STATISTICS
 Annualized return (arithmetic extrapolation)0.025
 Compounded annual return (geometric extrapolation)0.025
 Calmar ratio (compounded annual return / max draw down)0.187
 Compounded annual return / average of 25% largest draw downs0.213
 Compounded annual return / Expected Shortfall lognormal2.829
ANALYSIS BASED ON DAILY VALUES, LAST 6 MONTHS (Back)
RATIO STATISTICS
Ratio statistics of excess return rates
Statistics related to Sharpe ratio
 Mean-0.044
 SD0.000
 Sharpe ratio (Glass type estimate) NA
 Sharpe ratio (Hedges UMVUE)NA
 dfNA
 tNA
 pNA
 Lowerbound of 95% confidence interval for Sharpe RatioNA
 Upperbound of 95% confidence interval for Sharpe RatioNA
 Lowerbound of 95% CI (Gibbons, Hedeker & Davis approximation)NA
 Upperbound of 95% CI (Gibbons, Hedeker & Davis approximation)NA
Statistics related to Sortino ratio
 Sortino ratio-18.547
 Upside Potential Ratio0.000
 Upside part of mean0.000
 Downside part of mean-0.044
 Upside SD0.000
 Downside SD0.002
 N nonnegative terms0.000
 N negative terms172.000
Statistics related to linear regression on benchmark
 N of observations172.000
 Mean of predictor0.090
 Mean of criterion-0.044
 SD of predictor0.137
 SD of criterion0.000
 Covariance0.000
 rNA
 b (slope, estimate of beta)NA
 a (intercept, estimate of alpha)NA
 Mean Square ErrorNA
 DF errorNA
 t(b)NA
 p(b)NA
 t(a)NA
 p(a)NA
 Lowerbound of 95% confidence interval for betaNA
 Upperbound of 95% confidence interval for betaNA
 Lowerbound of 95% confidence interval for alphaNA
 Upperbound of 95% confidence interval for alphaNA
 Treynor index (mean / b)NA
 Jensen alpha (a)NA
Ratio statistics of excess log return rates
Statistics related to Sharpe ratio
 Mean-0.044
 SD0.000
 Sharpe ratio (Glass type estimate) -7936535306446244.000
 Sharpe ratio (Hedges UMVUE)-7901674975671223.000
 df171.000
 t-5611977934314593.000
 p1.000
 Lowerbound of 95% confidence interval for Sharpe RatioNA
 Upperbound of 95% confidence interval for Sharpe RatioNA
 Lowerbound of 95% CI (Gibbons, Hedeker & Davis approximation)-8739115425704417.000
 Upperbound of 95% CI (Gibbons, Hedeker & Davis approximation)-7064234525638030.000
Statistics related to Sortino ratio
 Sortino ratio-18.547
 Upside Potential Ratio0.000
 Upside part of mean0.000
 Downside part of mean-0.044
 Upside SD0.000
 Downside SD0.002
 N nonnegative terms0.000
 N negative terms172.000
Statistics related to linear regression on benchmark
 N of observations172.000
 Mean of predictor0.081
 Mean of criterion-0.044
 SD of predictor0.136
 SD of criterion0.000
 Covariance0.000
 r0.000
 b (slope, estimate of beta)0.000
 a (intercept, estimate of alpha)-0.044
 Mean Square Error0.000
 DF error170.000
 t(b)0.000
 p(b)0.500
 t(a)-5592648786297106.000
 p(a)1.000
 Lowerbound of 95% confidence interval for beta-0.000
 Upperbound of 95% confidence interval for beta0.000
 Lowerbound of 95% confidence interval for alpha-0.044
 Upperbound of 95% confidence interval for alpha-0.044
 Treynor index (mean / b)-47048140046130557940396755779584.000
 Jensen alpha (a)-0.044
Risk estimates for a one-period unit investment (parametric)
assuming log normal returns and losses (using central moments from Sharpe statistics)
 VaR(95%)0.000
 Expected Shortfall on VaR0.000
assuming Pareto losses only (using partial moments from Sortino statistics)
 VaR(95%)0.000
 Expected Shortfall on VaR0.000
ORDER STATISTICS
Quartiles of return rates
 Number of observations172.000
 Minimum1.000
 Quartile 11.000
 Median1.000
 Quartile 31.000
 Maximum1.000
 Mean of quarter 11.000
 Mean of quarter 21.000
 Mean of quarter 31.000
 Mean of quarter 41.000
 Inter Quartile Range0.000
 Number outliers low0.000
 Percentage of outliers low0.000
 Mean of outliers lowNA
 Number of outliers high0.000
 Percentage of outliers high0.000
 Mean of outliers highNA
Risk estimates for a one-period unit investment (based on Extreme Value Theory)
 Extreme Value Index (moments method)NA
 VaR(95%) (moments method)NA
 Expected Shortfall (moments method)NA
 Extreme Value Index (regression method)NA
 VaR(95%) (regression method)NA
 Expected Shortfall (regression method)NA
DRAW DOWN STATISTICS
Quartiles of draw downs
 Number of observations0.000
 MinimumNA
 Quartile 1NA
 MedianNA
 Quartile 3NA
 MaximumNA
 Mean of quarter 1NA
 Mean of quarter 2NA
 Mean of quarter 3NA
 Mean of quarter 4NA
 Inter Quartile Range0.000
 Number outliers low0.000
 Percentage of outliers lowNA
 Mean of outliers lowNA
 Number of outliers high0.000
 Percentage of outliers highNA
 Mean of outliers highNA
Risk estimates based on draw downs (based on Extreme Value Theory)
 Extreme Value Index (moments method)NA
 VaR(95%) (moments method)NA
 Expected Shortfall (moments method)NA
 Extreme Value Index (regression method)NA
 VaR(95%) (regression method)NA
 Expected Shortfall (regression method)NA
COMBINED STATISTICS
 Annualized return (arithmetic extrapolation)0.000
 Compounded annual return (geometric extrapolation)0.000
 Calmar ratio (compounded annual return / max draw down)NA
 Compounded annual return / average of 25% largest draw downsNA
 Compounded annual return / Expected Shortfall lognormal0.000