UnThreaded | Threaded | Whole Thread (34) | Ignore Thread Prev Thread | Next Thread
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 250240  
Subject: The Best Measure for the Best Blend Date: 11/16/2007 12:01 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 75
What is the absolute best measure for finding the best blend?

If it isn't already, this should be the key question in everyone's mind -- at least, everyone who employs a blend for their MI investing. I've done hours and hours of testing over the past year or so to answer this question, compiling tests that include hundreds of millions of data points. At the very core, each test is trying to determine which measure is the most predictive of future return.

How did you set up the tests?

Well, I've run hundreds and hundreds of tests, but for this post, I'll be sharing based on using ranks 1-10 of each screen with a backtest history from 1969 to present. From these backtests I find five screens to invest in at the beginning of each year from 1989 using a descending sort of each of the measures. The # of lookback years to consider is varied from 1 to 29 in steps of two for a total of 15 lookbacks for each measure. I then take the results from this test and find the Minimum, Maximum, Median and Average value for each measure. I would consider the median and maximum to be key, but I also pay attention to the degree of deviation from max to min. The measure you actually use will also be used with a fixed number of years lookback so the maximum value is probably the one you will end up with, but we want to consider all to determine how robust the measure is. A vast span between min and max reflects a measure that probably just landed on such a high value by luck.

In summary, the period tested is 1989 to 11/9/2007 and the # of screens held is five holding ranks 1-10 for a total hold of 50 stocks. The idea here is not to necessarily hold 50 stocks, but to use this as a basis for finding the best measure. I've actually tested the exact same thing as this using ranks 1-4 and the results are not that much different, although the values are all higher.

All of the tables that follow are sorted by the Median column with the best values at the top.

What is the best measure for finding the highest future CAGR? In other words, which measure is most predictive of future CAGR?

A measure that is not talked about on this board comes out on top -- Jensen. The next one down is Alpha, also not often discussed as far as using it to predict future CAGR. The one that comes out on the absolute bottom is Sharpe/GSD recently suggested by StevnFool.

When looking at these returns, keep in mind that using the Solver to optimize and select a blend at the end of each year produced these results:
A Sharpe Optimized Strategy
CAGR around 26
Sharpe around 1.20
This then is the benchmark that we are comparing to.
RANKS 1-10                                 
CAGR Minimum Maximum Median Average
Jensen 29.33% 39.17% 37.50% 35.77%
Alpha 28.33% 38.34% 37.48% 35.85%
UP 27.96% 37.54% 36.95% 34.57%
Treynor 31.75% 37.08% 35.48% 35.13%
GSD 27.47% 35.18% 34.95% 33.58%
DD 27.86% 35.72% 34.93% 33.22%
Trough # 26.33% 34.49% 33.06% 31.83%
UI 27.08% 34.28% 31.78% 31.07%
CAGR/UPI 26.04% 36.02% 29.75% 29.85%
UPI 22.69% 28.36% 27.62% 26.67%
Sharpe 26.51% 30.91% 27.26% 27.70%
CAGR/UI 22.54% 27.56% 26.90% 26.07%
Sortino 24.29% 30.38% 26.37% 26.34%
UPR 4.88% 27.72% 26.25% 24.34%
Beta 20.83% 27.16% 24.81% 24.44%
GSD Ratio 20.67% 30.58% 23.57% 24.32%
CAGR/GSD 21.68% 24.03% 22.18% 22.42%
Correlation 20.35% 23.53% 21.80% 21.88%
Sharpe/GSD 20.14% 23.83% 21.78% 21.61%

But our goal is risk-adjusted return, not raw return, so what is the best measure for finding the highest Sharpe Ratio?

Well, you'll be surprised to learn that what is at the absolute bottom of the list above, comes out at the absolute top of the list for risk-adjusted return -- StevnFool's Sharpe/GSD. BTW -- I just added this measure to my backtester after he suggested it yesterday. As a result I had to run a special test just for that indicator and add it to all my other tests.
  Sharpe     Minimum  Maximum  Median  Average
Sharpe/GSD 1.25 1.67 1.62 1.58
Treynor 1.38 1.62 1.54 1.52
UPR 0.16 1.62 1.47 1.33
Sortino 1.02 1.45 1.37 1.36
CAGR/GSD 0.98 1.58 1.34 1.33
Sharpe 1.03 1.45 1.33 1.34
UPI 0.86 1.26 1.24 1.16
CAGR/UI 0.86 1.26 1.18 1.16
Alpha 0.91 1.22 1.18 1.15
Jensen 0.94 1.22 1.17 1.13
UI 1.03 1.21 1.17 1.13
CAGR/UPI 0.90 1.25 1.14 1.12
UP 0.81 1.13 1.11 1.03
GSD 0.84 1.09 1.09 1.04
DD 0.87 1.08 1.07 1.01
GSD Ratio 0.89 1.37 1.05 1.05
Trough # 0.76 1.06 1.01 0.97
Correlation 0.79 1.02 0.93 0.93
Beta 0.63 0.78 0.73 0.72

What measure comes out on top for Ulcer Index?

Once again we find that Sharpe/GSD comes out on top. We also see that although Jensen is great at finding the best screens to invest in at certain times, it does so at the expensive of a much higher Ulcer Index. If your goal is to find screens with just amazing forward returns then Jensen may be for you, but be forewarned, it will not be a smooth ride to the top.
    UI       Minimum  Maximum  Median  Average
Sharpe/GSD 3.40% 3.64% 3.62% 3.57%
CAGR/GSD 3.43% 10.89% 4.10% 4.54%
Sortino 4.68% 9.16% 4.93% 5.46%
UPR 0.00% 9.37% 5.19% 5.06%
Sharpe 5.33% 9.82% 5.64% 6.19%
CAGR/UI 6.38% 12.26% 6.49% 7.51%
UPI 6.48% 12.40% 6.52% 7.55%
Treynor 6.16% 7.60% 6.61% 6.64%
GSD Ratio 5.71% 11.42% 8.10% 8.63%
Correlation 6.92% 21.86% 8.42% 9.03%
UI 8.97% 12.63% 9.23% 9.77%
CAGR/UPI 8.37% 12.92% 9.27% 9.48%
Jensen 15.27% 19.46% 15.55% 16.29%
Alpha 15.32% 21.41% 15.62% 16.54%
Trough # 17.55% 29.73% 17.81% 21.16%
GSD 19.02% 31.45% 19.18% 20.80%
UP 21.62% 31.55% 21.67% 23.70%
DD 21.91% 31.81% 21.92% 23.95%
Beta 29.10% 35.59% 30.96% 31.99%

Which measure chooses screens with a high win ratio?

In other words, which of the measures tends to choose screens that consistently produce a positive return each year? Note again which measure comes out on top! Indeed, this simple little idea that StevnFool has come up with has produced some amazing results.
 Win Ratio   Minimum  Maximum  Median  Average
Sharpe/GSD 89% 92% 91% 91%
UPR 0% 89% 88% 82%
CAGR/GSD 86% 91% 88% 88%
Sortino 83% 88% 86% 87%
Sharpe 83% 87% 85% 85%
CAGR/UPI 77% 85% 85% 83%
Treynor 81% 89% 84% 85%
UI 77% 87% 84% 83%
GSD Ratio 77% 86% 83% 82%
Jensen 79% 83% 82% 81%
UPI 78% 85% 82% 82%
CAGR/UI 80% 85% 82% 83%
Alpha 79% 83% 81% 81%
Trough # 72% 80% 78% 77%
GSD 75% 81% 77% 77%
Correlation 72% 78% 77% 77%
DD 74% 80% 77% 77%
UP 69% 81% 76% 75%
Beta 71% 77% 74% 73%

When it comes to the maximum daily drawdown, which of the measures is able to avoid drawdowns the best?

Of course, here we are not suggesting that max drawdown is predictive of anything, but rather, evaluating how well a measure does at avoiding drawdowns. Once again we find that the winner is Sharpe/GSD.
  Drawdown   Minimum  Maximum  Median  Average
Sharpe/GSD -22% -16% -17% -17%
CAGR/GSD -43% -21% -21% -23%
Sortino -40% -22% -23% -25%
UPR -41% 0% -25% -23%
Sharpe -40% -23% -25% -28%
Treynor -33% -26% -28% -28%
UPI -45% -29% -29% -31%
CAGR/UI -47% -29% -29% -31%
CAGR/UPI -45% -31% -31% -33%
UI -41% -32% -32% -34%
Correlation -62% -31% -34% -35%
GSD Ratio -52% -25% -39% -41%
Jensen -60% -44% -44% -47%
Alpha -62% -44% -44% -48%
Trough # -72% -48% -48% -56%
GSD -75% -52% -52% -56%
DD -76% -58% -58% -62%
UP -74% -60% -60% -63%
Beta -75% -69% -71% -71%

Which of the measures you used actually produced a backtest with the lowest GSD?

You guessed it -- Sharpe/GSD comes out on top once again! In fact, this new measure comes out on top for every evaluation except CAGR. I sure do like the looks of those GSD values for the Sharpe/GSD strategy. A GSD around 10 is pretty much unheard of.
    GSD      Minimum  Maximum  Median  Average
Sharpe/GSD 9.71 13.16 10.06 10.25
CAGR/GSD 11.60 18.26 12.68 13.36
UPR 0.21 17.97 14.39 13.73
Sortino 14.41 22.09 14.92 15.82
Sharpe 16.05 22.14 16.49 17.23
CAGR/UI 18.15 23.73 18.28 19.01
Treynor 18.02 20.11 18.43 18.55
GSD Ratio 17.62 21.42 18.74 19.30
UPI 18.59 24.24 18.79 19.43
Correlation 18.60 26.04 19.53 19.98
CAGR/UPI 22.50 27.28 23.25 23.58
UI 23.13 29.35 23.50 24.39
Alpha 25.17 29.87 28.75 28.27
Jensen 27.60 29.52 29.07 28.92
GSD 29.38 34.52 29.92 30.39
DD 30.40 35.87 30.98 31.48
UP 31.12 35.82 31.19 31.99
Trough # 30.39 36.45 31.22 32.08
Beta 34.03 36.77 35.60 35.65

It seems that Sharpe does not seem to be the best measure based on your tests -- why is that?

I have no idea, but it definitely does not come out on top. In fact, here is its position for each of the evaluation tables above.
  Sharpe   Position
CAGR 11
GSD 5
Sharpe 6
UI 5
Win Ratio 5
Drawdown 5

So out of the nineteen measures that I used to sort on, Sharpe takes 11th place when it comes to CAGR, and sixth when it comes to Sharpe itself. In other words, there are much better measures to use than Sharpe itself for determining the best blend to invest in.

Remember that using the Solver to find a new blend each year resulted in a CAGR around 26 and a Sharpe around 1.20. Using the Sharpe/GSD above produces a CAGR around 1.65 and a CAGR around 24. Which would you say is better?

NOTE: I actually had no intention of sharing even this much research on this theme, but decided to open the flood gates and let the generosity flow -- being that the holidays are just around the corner and all. I hope you've found it useful, and I also hope it promotes some discussion that will be a benefit to us all.

Further Research

A very interesting bit of information that comes out of this research is the fact that some of these measures do exceedingly well at finding the best screens for when the market is bullish, and others find the best when the market is bearish. If you have even a very simple way to determine the bullish and bearish periods you'll do very well switching between the measures used. For example, when the market is bullish use the Jensen -- it found five screens for a total hold of 50 stocks that produced a return of 131% in 1991 and 180% in 1999 and close to 90% in both 2003 and 2006. Pretty amazing! Now if you use a SMA on the market and switch to Sharpe/GSD during the bearish periods you'd get 45% in 2000, 27% in 2001 and 15% in 2002. The problem with Sharpe/GSD is that it really tends to under-perform when the market is super-bullish like 1991 and 1999, but does great the rest of the time. It seems to me that a very simple method can be found that would enable anyone here to switch their sorting method to fit the market. But of course, this would be timing, and there are so many strongly opposed to that no matter how sound the evidence is supporting its benefit. Right? Even when the Hindenburg Omen gives a perfect signal there will still be naysayers that will claim it is all luck and voodoo. Right? That's fine, I'm simply trying to help, and I'm sure that there are many out there that appreciate it, even if a few insist on rejecting it.
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: Knighted Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203943 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 12:24 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 2
But of course, this would be timing, and there are so many strongly opposed to that no matter how sound the evidence is supporting its benefit.

Not so much a matter of being opposed as a matter of so little supporting evidence being present. Given the massive scope of what timing is trying to accomplish as well as the lack of any supportive data to suggest that it truly does work, many are naturally skeptical about it. It also goes without saying that many have tried it in the past only to have it end in disaster.

Back on the topic of the very informative research you presented, though, (and thanks for sharing it), i'm curious what screens the Sharpe/GSD measure has chosen during the last 12 months in particular considering the volatility the market has given us. As you said, a GSD that low sounds almost too good to be true, especially with the wild ride that virtually all of the screens have taken everyone on lately.

Print the post Back To Top
Author: elann Big gold star, 5000 posts Top Favorite Fools Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203946 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 1:58 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 4
What is the absolute best measure for finding the best blend?

If it isn't already, this should be the key question in everyone's mind -- at least, everyone who employs a blend for their MI investing. I've done hours and hours of testing over the past year or so to answer this question, compiling tests that include hundreds of millions of data points. At the very core, each test is trying to determine which measure is the most predictive of future return.


You're right about the question, and thank you for offering an answer.

You mentioned two measures that I've never heard of - Jensen and Treynor. Could you define them or point to their definition?

Elan

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203947 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 2:10 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 14
Treynor Index
Treynor Index -- Treynor developed the first composite measure. This measure postulates two components of risk:
*Risk resulting from unique fluctuations in markets
*Risk resulting from unique fluctuations in portfolios

In order to identify risk due to market fluctuations, Treynor introduced the Characteristic Line. This line defines the relationship between rates of return for a portfolio over time and the rates of return for an appropriate market portfolio.
Treynor noted that the Characteristic Line's slope measures the relative volatility of the portfolio's returns in relation to returns for the aggregate market -- the Portfolio's Beta.
Deviations from the Characteristic Line indicate unique returns for the portfolio relative to the market.
Treynor suggested that risk averse investors would always prefer portfolio possibility lines with larger slopes, because such high-slope lines would place investors on higher indifference curves.

What is measured by the Treynor Index?
It measures the portfolio's Risk Premium Return per Unit of Risk
All investors would prefer to maximize this value
Beta measures systematic risk, but says nothing about diversification. It implicitly assumes a completely diversified portfolio.
The Treynor Index (T) is a measure of the stock's excess return per unit of risk. The excess return is defined as the difference between the stock’s return and the 1-Year Treasury Bill rate over the same period of time. The risk measure here is the market risk evaluated by the stock's beta.

How should the Treynor's values be Interpreted?

Positive T Values: The larger the T value, the more preferable the stock is for all investors, regardless of their risk preference. Normally, a stock with a negative beta should experience a rate of return below the Treasury Bill rate, so both the excess return and beta would be negative, and the T values would be positive.

Negative T Values: Stock has a return below the 1-Year Treasury Bill rate and a positive beta; indicates extremely poor stock performance and selection.

Stock beta is negative with a positive excess return; indicates very good stock performance.

Treynor Index Calculation

Treynor Index = (Average ROI of Investment - Average ROI of Risk Free Investment) / Slope of Fund's Characteristic Line (Volatility) i.e., Beta

Jensen Performance Measure
What is measured by the Jensen Performance Measure? Superior portfolio managers who accurately predict market turns or who identify undervalued investments earn higher returns. Each of them have consistently positive random error terms. Jensen's alpha represents the ability of the fund manager to achieve a return that is above what could be expected, given the risk in the fund. It is a statistical measure of performance similar to the Sharpe Ratio.
This indicator was developed to determine the success of a fund manager in stock selection by providing a basis of comparison for portfolios that have different risk exposures. It is generally used for portfolio performance measurement and to identify the part of the performance that can be attributed solely to the portfolio (in other words, the result of superior performance and not luck).

How should Jensen index's values be Interpreted?
Positive alphas represent good performance by the fund manager. Negative alphas reflect poorly on the performance of the fund manager. The alpha should be calculated based on an extended period of time - usually three years.

Jensen Index Calculation
Jensen Index = ((Average ROI of Investment - Average ROI of Risk Free Investment) - (Beta * (Average ROI of Index i.e. S&P 500 - Average ROI of Risk Free Investment))) * 0.10

Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: JeffLandon One star, 50 posts Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203950 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 2:32 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Have you tried CAGR/(GSD*GSD)?

Print the post Back To Top
Author: Syvash Two stars, 250 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203951 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 3:01 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Zee,

Thank you for very the valuable post.

Is GSD in SHARPE/GSD for past 12 months of returns with daily data?

Best

Syvash

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203952 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 4:11 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Jeff asked:
Have you tried CAGR/(GSD*GSD)?

Nope, it has about a .88 correlation with CAGR/GSD and .82 with the Sortino -- based on January 2007. It is interesting which screens pop to the top with that method.

Syvash asked:
Is GSD in SHARPE/GSD for past 12 months of returns with daily data?

No, the Sharpe and the GSD are both based on the same # of years. I do not have the ability to set them as different, at least, not as of right now.

Print the post Back To Top
Author: bust100 Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203958 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 9:44 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
Great job Zee,

If it's not to much trouble - each year you found an optimal blend for the year
and then calculated the returns for the blend if used for the year.
Could you also indicate the expected return for the year as indicated by
the blend. This would give some idea of the gap between expectations and reality.

Thanks,
Dave

Print the post Back To Top
Author: StevnFool Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203963 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 12:51 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
No, the Sharpe and the GSD are both based on the same # of years. I 
do not have the ability to set them as different, at least, not as of 
right now. 

Zee,

In this respect, what you have done and what I suggested / tested are 
different, but the basic idea is the same.

From your original post, you showed the table below.

Sharpe     
             Minimum  Maximum  Median  Average
Sharpe/GSD     1.25     1.67    1.62     1.58

If I have interpreted your testing correctly, I understand that the 
variations in the resulting Sharpe is due to varying the lookback 
period.  Would you be able to post a table showing the resulting Sharpe 
ratio for all of the different lookbacks used for calculating 
Sharpe/GSD.  Given that the Maximum, Median and Average are grouped 
relatively closely it would seem that there is a fairly wide range of 
lookbacks that work quite well.

StevnFool


Print the post Back To Top
Author: StevnFool Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203972 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 6:13 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 7
Zee,

I want to lay out an idea for further research if it interests you.

You have done a great job in demonstrating through testing the possible use of Sharpe/GSD as a useful prediction metric.

I have commented many times before that (CAGR-rfr)/GSD is a reasonable substitute for Sharpe when looking at our typical screens and where rfr = the average risk free rate over the backtest period. RRR4 as suggested by me a long time ago and as used by some is the version of this that uses 4% as the risk free rate.

My main point here though is that Sharpe essentially has a CAGR component in its numerator and a GSD component in its demoninator. When I originally suggested the idea of looking for low GSD screens which ultimately led to using Sharpe/GSD, the logic was that the GSD component of the Sharpe ratio is a better predictor than the CAGR component and thus the GSD component needs to get extra weight. We started doing this by selecting low GSD screens first before selecting the high Sharpe, but using Sharpe/GSD is just another way of overweighting the GSD as we essentially have GSD^2 in the denominator now.

This raises the question. "What is the optimimum amount by which we should overweight GSD?"

For example, which of the following is a better predictor of future Sharpe?

Sharpe/GSD
Sharpe/(GSD^X) where X could be any value > 0

A suggestion might be to try X = 0.5 and X = 2 and see how they compare with what you have already done (X=1).

If you would be interested in testing this idea, I would love if you posted the results. If not, let me know and I might try it if I get time.

StevnFool

Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: JeffLandon One star, 50 posts Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203974 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 6:20 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
>>A suggestion might be to try X = 0.5 and X = 2 and see how they compare with what you have already done (X=1).

That's a great idea and charting the curve would be illuminating.

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203978 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/16/2007 10:23 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 2
StevnFool asked:
A suggestion might be to try X = 0.5 and X = 2 and see how they compare with what you have already done (X=1).

If you would be interested in testing this idea, I would love if you posted the results. If not, let me know and I might try it if I get time.


Excellent idea! We are working on it as I type. I'll let you know the results once they are completed.

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203982 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/17/2007 6:46 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
StevnFool requested:
Would you be able to post a table showing the resulting Sharpe
ratio for all of the different lookbacks used for calculating
Sharpe/GSD.


Here you are -- the year lookbacks are along the left side:
Sharpe  Jensen  Sharpe  Sharpe/GSD  Treynor
1 0.94 1.26 1.67 1.39
3 0.96 1.03 1.25 1.38
5 0.99 1.39 1.65 1.39
7 1.00 1.32 1.61 1.45
9 1.18 1.34 1.51 1.62
11 1.17 1.42 1.57 1.60
13 1.21 1.45 1.53 1.57
15 1.21 1.42 1.51 1.57
17 1.22 1.38 1.62 1.50
19 1.16 1.37 1.62 1.54
21 1.19 1.33 1.63 1.60
23 1.19 1.33 1.63 1.54
25 1.19 1.33 1.63 1.58
27 1.16 1.33 1.63 1.52
29 1.16 1.33 1.63 1.59
CAGR Jensen Sharpe Sharpe/GSD Treynor
1 29% 31% 24% 35%
3 29% 28% 22% 33%
5 31% 27% 22% 32%
7 30% 27% 21% 34%
9 38% 29% 20% 36%
11 37% 29% 21% 37%
13 39% 30% 21% 36%
15 39% 29% 20% 36%
17 39% 28% 22% 35%
19 38% 27% 22% 35%
21 38% 27% 22% 36%
23 38% 27% 22% 35%
25 38% 27% 22% 36%
27 37% 27% 22% 35%
29 37% 27% 22% 36%


Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: StevnFool Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203989 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/17/2007 3:09 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Here you are -- the year lookbacks are along the left side:

Sharpe  Jensen  Sharpe  Sharpe/GSD  Treynor  
1      0.94    1.26      1.67       1.39  
3      0.96    1.03      1.25       1.38  
5      0.99    1.39      1.65       1.39  
7      1.00    1.32      1.61       1.45  
9      1.18    1.34      1.51       1.62  
11     1.17    1.42      1.57       1.60  
13     1.21    1.45      1.53       1.57  
15     1.21    1.42      1.51       1.57  
17     1.22    1.38      1.62       1.50  
19     1.16    1.37      1.62       1.54  
21     1.19    1.33      1.63       1.60  
23     1.19    1.33      1.63       1.54  
25     1.19    1.33      1.63       1.58  
27     1.16    1.33      1.63       1.52  
29     1.16    1.33      1.63       1.59

Thanks.  The results look more stable at the longer lookback.  I think I 
would use all available data if using a common lookback for both Sharpe 
and GSD.

StevnFool


Print the post Back To Top
Author: sencoman One star, 50 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203992 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/17/2007 5:27 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Since Sharpe/GSD results are still slightly better with one year lookback, it might be worthwhile to see if there is any improvement using a measure like Sharpe(13)/GSD(1) - long lookaback for Sharpe and short lookback for GSD, as StevenFool initially did (post #203911).
The measure is roughly reciprocal to a multiple of long term and short term GSD, giving some extra weight to recent volatility of a screen.

Just a thought, I do not have the tools and capability to test this myself :-(

senco

Print the post Back To Top
Author: sailrmac Big red star, 1000 posts Old School Fool CAPS All Star Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 203999 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/17/2007 7:48 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Since Sharpe is essentially CAGR - C / GSD, where C is a constant, and you are using this as a ranking indicator, the constant C isn't really changing anything. For ranking purposes Sharpe / GSD / GSD should give the same ranking as CAGR / GSD squared. Other methods that could be explored would be CAGR / GSD *x (x being a variable to solve for), rank by GSD top x, then by CAGR, etc.

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204006 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/17/2007 8:50 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
Choosing a Blend Based on Momentum Alone

This test finally completed. It is set up the same way as I did in the Sharpe/GSD^x post -- three screens are selected from VL and three from SIPRO and then blended to form a total of six screens with ranks 1-4 for a total hold of 24 stocks. The period examined is 1999 to present.

I used lookbacks from 20 to 240 market days allowing them to be different for VL and SIPRO -- the lookback days are on the left side of the table. The following very long table is sorted by the resulting Sharpe Ratio.

It appears that VL requires a short lookback, while SIPRO requires a longer lookback. But 40/50 comes in at position #5 in the sort so one cannot arrive at a very fixed statement regarding this. I was expecting the lookback to favor something around 200 or so meaning these results are not what I thought.
VL   SIPRO   CAGR    GSD   Sharpe  Ulcer Index
40 140 40.00% 32.66 1.21 11.88%
60 140 39.71% 32.61 1.2 12.27%
60 180 39.32% 32.38 1.2 12.23%
40 180 39.64% 32.43 1.2 11.86%
40 50 38.64% 32.11 1.19 12.32%
60 50 38.15% 32 1.18 12.99%
40 90 38.42% 32.22 1.18 12.38%
40 40 38.68% 32.51 1.18 11.95%
40 100 38.75% 32.5 1.18 12.32%
60 90 38.04% 32.12 1.17 12.93%
40 60 38.29% 32.55 1.17 11.56%
60 40 38.36% 32.46 1.17 12.33%
60 100 38.39% 32.45 1.17 12.87%
70 140 38.84% 33.5 1.16 13.89%
60 130 37.80% 32.49 1.16 12.39%
40 130 38.18% 32.56 1.16 11.97%
40 110 37.47% 32.49 1.15 11.97%
60 80 37.46% 32.48 1.15 12.12%
40 120 37.47% 32.49 1.15 11.97%
40 80 37.64% 32.52 1.15 11.80%
70 180 38.45% 33.27 1.15 13.78%
60 60 37.81% 32.54 1.15 11.92%
60 120 37.08% 32.42 1.14 12.39%
40 20 36.96% 32.26 1.14 11.97%
60 110 37.08% 32.42 1.14 12.39%
40 30 37.13% 32.42 1.14 12.62%
210 220 36.85% 32.12 1.14 13.95%
240 220 37.68% 33.02 1.14 15.02%
70 40 37.47% 33.34 1.13 13.82%
60 30 36.74% 32.31 1.13 13.20%
70 90 37.14% 33.05 1.13 14.74%
60 20 36.55% 32.21 1.13 12.38%
70 100 37.50% 33.38 1.13 14.59%
40 150 36.96% 32.6 1.13 12.30%
60 150 36.86% 32.55 1.13 12.62%
80 140 38.25% 34.25 1.13 14.62%
70 50 37.25% 32.95 1.13 14.55%
210 200 36.65% 32.4 1.13 14.04%
240 200 37.49% 33.21 1.13 15.21%
30 180 36.33% 32.23 1.12 12.84%
80 180 37.92% 34.04 1.12 14.49%
30 140 36.62% 32.53 1.12 12.87%
200 220 37.04% 33.17 1.12 15.17%
210 210 36.11% 32.2 1.12 14.85%
240 210 36.80% 32.92 1.12 17.06%
70 130 36.94% 33.39 1.11 14.02%
40 160 36.22% 32.65 1.11 12.50%
40 70 36.10% 32.53 1.11 11.86%
30 50 35.51% 31.94 1.11 13.35%
70 60 36.95% 33.4 1.11 13.51%
200 200 36.80% 33.42 1.11 15.29%
70 110 36.22% 33.32 1.1 14.03%
60 70 35.80% 32.53 1.1 12.19%
30 40 35.38% 32.32 1.1 12.95%
80 50 36.83% 33.68 1.1 15.30%
30 100 35.39% 32.36 1.1 13.49%
80 100 36.94% 34.09 1.1 15.35%
70 120 36.22% 33.32 1.1 14.03%
80 40 36.99% 34.09 1.1 14.55%
70 80 36.58% 33.38 1.1 13.78%
80 90 36.57% 33.76 1.1 15.58%
60 160 35.92% 32.59 1.1 12.87%
200 210 36.13% 33.16 1.1 16.27%
210 230 35.38% 32.25 1.1 14.35%
240 230 36.17% 33.13 1.1 15.40%
70 20 35.67% 33.1 1.09 13.93%
50 140 35.69% 33.04 1.09 15.38%
70 30 35.82% 33.28 1.09 14.92%
40 170 35.18% 32.5 1.09 12.45%
30 60 35.16% 32.35 1.09 12.53%
30 90 35.08% 32.11 1.09 13.60%
140 140 34.96% 32.16 1.09 14.76%
80 60 36.59% 34.14 1.09 14.16%
70 150 35.97% 33.46 1.09 14.27%
220 220 36.01% 33.18 1.09 15.19%
90 140 36.08% 33.78 1.08 14.64%
50 180 35.26% 32.8 1.08 15.34%
140 180 34.59% 31.97 1.08 14.63%
60 170 34.99% 32.44 1.08 12.79%
90 180 35.74% 33.56 1.08 14.53%
80 130 36.40% 34.11 1.08 14.72%
30 130 34.86% 32.41 1.08 13.00%
200 230 35.58% 33.3 1.08 15.55%
220 200 35.81% 33.42 1.08 15.31%
240 240 36.37% 34.47 1.08 17.75%
80 110 35.71% 34.04 1.07 14.72%
80 120 35.71% 34.04 1.07 14.72%
30 80 34.41% 32.35 1.07 12.78%
80 80 36.02% 34.11 1.07 14.50%
210 240 35.62% 33.66 1.07 15.69%
220 210 35.15% 33.16 1.07 16.95%
70 70 34.94% 33.4 1.06 13.78%
160 140 34.31% 32.51 1.06 15.87%
50 50 34.02% 32.43 1.06 16.23%
30 20 33.73% 32.05 1.06 12.99%
30 110 34.17% 32.34 1.06 13.01%
160 180 33.98% 32.28 1.06 15.34%
110 180 33.25% 31.53 1.06 14.50%
30 120 34.17% 32.34 1.06 13.01%
140 40 33.65% 32.03 1.06 14.67%
80 20 35.24% 33.84 1.06 14.60%
70 160 35.04% 33.49 1.06 14.51%
110 140 33.57% 31.76 1.06 14.62%
80 30 35.31% 33.94 1.06 15.67%
90 50 34.65% 33.21 1.06 15.30%
50 100 34.31% 32.89 1.06 16.17%
200 240 35.79% 34.67 1.06 16.96%
230 220 34.77% 33.35 1.06 15.42%
90 90 34.42% 33.26 1.05 15.62%
140 50 33.29% 31.65 1.05 15.91%
140 90 33.17% 31.69 1.05 16.66%
50 90 33.95% 32.58 1.05 16.39%
90 40 34.81% 33.62 1.05 14.60%
150 180 35.13% 34.45 1.05 17.64%
90 100 34.78% 33.6 1.05 15.38%
140 100 33.56% 32 1.05 16.09%
150 140 35.49% 34.66 1.05 18.14%
170 180 34.67% 33.72 1.05 15.53%
50 40 34.25% 32.88 1.05 15.37%
80 150 35.28% 34.17 1.05 14.97%
30 30 33.81% 32.31 1.05 13.79%
170 140 35.04% 33.92 1.05 15.67%
220 230 34.55% 33.3 1.05 15.55%
230 200 34.60% 33.6 1.05 15.49%
140 60 33.13% 32.15 1.04 14.47%
90 60 34.37% 33.7 1.04 14.23%
90 130 34.21% 33.65 1.04 14.76%
50 130 33.85% 32.93 1.04 15.47%
50 60 33.74% 32.86 1.04 15.13%
30 150 33.54% 32.43 1.04 13.44%
70 170 34.11% 33.34 1.04 14.44%
140 130 33.11% 32.03 1.04 14.86%
230 210 33.91% 33.3 1.04 17.32%
160 90 32.54% 32.03 1.03 18.05%
110 100 32.28% 31.61 1.03 15.39%
160 50 32.78% 31.91 1.03 17.03%
160 40 33.04% 32.37 1.03 15.34%
20 140 33.73% 33.48 1.03 16.68%
160 100 32.93% 32.35 1.03 17.47%
80 160 34.45% 34.17 1.03 15.19%
140 80 32.73% 32.03 1.03 14.69%
110 50 32.18% 31.2 1.03 15.33%
80 70 34.44% 34.11 1.03 14.45%
110 40 32.34% 31.59 1.03 14.58%
50 80 33.22% 32.91 1.03 15.32%
30 70 32.95% 32.28 1.03 12.92%
90 80 33.86% 33.64 1.03 14.53%
220 240 34.77% 34.67 1.03 17.69%
110 60 31.89% 31.66 1.02 14.27%
180 140 33.66% 33.64 1.02 16.12%
170 100 33.65% 33.76 1.02 16.89%
140 150 32.15% 32.02 1.02 15.04%
170 50 33.36% 33.32 1.02 16.67%
160 60 32.58% 32.42 1.02 15.01%
170 40 33.73% 33.79 1.02 15.57%
150 40 34.20% 34.51 1.02 17.51%
140 110 32.42% 31.94 1.02 14.86%
90 110 33.53% 33.57 1.02 14.77%
180 180 33.33% 33.46 1.02 15.67%
170 90 33.26% 33.42 1.02 17.36%
140 120 32.42% 31.94 1.02 14.86%
30 160 32.74% 32.49 1.02 13.72%
150 100 34.06% 34.5 1.02 19.79%
90 120 33.53% 33.57 1.02 14.77%
160 130 32.42% 32.39 1.02 15.99%
20 180 33.38% 33.24 1.02 16.60%
50 120 33.10% 32.86 1.02 15.48%
100 140 32.25% 32.03 1.02 13.88%
150 50 33.75% 34.13 1.02 19.48%
50 110 33.10% 32.86 1.02 15.48%
110 90 31.94% 31.33 1.02 15.79%
230 230 33.30% 33.45 1.02 15.78%
140 30 31.91% 31.85 1.01 16.58%
90 20 33.05% 33.38 1.01 14.66%
160 80 32.13% 32.39 1.01 15.78%
100 180 31.92% 31.78 1.01 13.79%
90 30 33.15% 33.47 1.01 15.70%
50 30 32.63% 32.79 1.01 16.44%
90 150 33.14% 33.68 1.01 15.05%
150 130 33.61% 34.54 1.01 18.28%
80 170 33.47% 34.03 1.01 15.13%
50 20 32.51% 32.63 1.01 15.45%
140 20 31.90% 31.79 1.01 14.76%
50 150 32.70% 33.01 1.01 15.63%
150 90 33.63% 34.15 1.01 20.35%
130 140 31.48% 31.47 1.01 14.99%
170 130 33.16% 33.79 1.01 15.78%
170 60 33.17% 33.83 1.01 15.27%
150 60 33.68% 34.62 1.01 17.21%
110 130 31.74% 31.63 1.01 14.75%
110 110 31.07% 31.54 1 14.75%
170 80 32.85% 33.8 1 15.58%
20 100 32.36% 33.3 1 18.07%
110 120 31.07% 31.54 1 14.75%
130 180 31.12% 31.25 1 14.86%
20 50 32.11% 32.85 1 17.84%
110 80 31.40% 31.6 1 14.50%
30 170 31.82% 32.31 1 13.62%
160 110 31.73% 32.32 1 15.99%
160 120 31.73% 32.32 1 15.99%
20 40 32.46% 33.31 1 16.60%
150 80 33.34% 34.56 1 18.02%
230 240 33.51% 34.81 1 18.03%
20 60 32.00% 33.38 0.99 16.39%
180 50 32.13% 33.11 0.99 17.26%
160 30 31.27% 32.21 0.99 17.98%
110 30 30.71% 31.47 0.99 15.73%
90 70 32.26% 33.66 0.99 14.57%
140 160 31.28% 32.04 0.99 15.24%
100 100 31.03% 31.87 0.99 14.46%
100 50 30.96% 31.43 0.99 14.37%
20 90 31.97% 33.09 0.99 18.52%
160 150 31.42% 32.43 0.99 16.26%
120 140 30.42% 31.01 0.99 14.85%
100 40 30.99% 31.86 0.99 13.90%
180 90 31.90% 33.13 0.99 18.20%
50 160 31.95% 33.06 0.99 15.83%
170 110 32.46% 33.71 0.99 15.79%
140 70 31.13% 32.08 0.99 14.68%
150 110 32.92% 34.47 0.99 18.28%
160 20 31.25% 32.11 0.99 15.47%
50 70 31.64% 32.86 0.99 15.33%
180 100 32.29% 33.48 0.99 17.68%
170 120 32.46% 33.71 0.99 15.79%
110 20 30.61% 31.34 0.99 14.64%
180 40 32.40% 33.56 0.99 15.72%
90 160 32.29% 33.7 0.99 15.30%
150 120 32.92% 34.47 0.99 18.28%
170 30 31.99% 33.62 0.98 17.38%
150 150 32.70% 34.54 0.98 18.46%
20 130 31.96% 33.37 0.98 16.74%
150 30 32.36% 34.34 0.98 20.36%
180 60 31.90% 33.6 0.98 15.37%
180 130 31.74% 33.51 0.98 16.25%
150 20 32.41% 34.29 0.98 17.78%
170 150 32.26% 33.87 0.98 15.94%
130 40 30.21% 31.31 0.98 14.89%
100 90 30.73% 31.59 0.98 14.62%
120 180 30.05% 30.8 0.98 14.73%
110 150 30.70% 31.66 0.98 15.03%
170 20 31.94% 33.54 0.98 15.66%
130 90 29.76% 31.08 0.97 16.74%
140 170 30.34% 31.89 0.97 15.18%
100 60 30.58% 31.92 0.97 13.49%
180 80 31.53% 33.53 0.97 16.01%
20 120 31.28% 33.3 0.97 16.74%
50 170 30.91% 32.89 0.97 15.77%
130 100 30.12% 31.33 0.97 16.27%
20 110 31.28% 33.3 0.97 16.74%
130 50 29.86% 30.93 0.97 16.10%
20 80 31.52% 33.39 0.97 16.65%
150 70 31.71% 34.55 0.96 17.41%
150 160 31.77% 34.56 0.96 18.72%
160 160 30.48% 32.48 0.96 16.50%
130 60 29.70% 31.45 0.96 14.55%
170 70 31.21% 33.81 0.96 15.49%
100 80 30.05% 31.9 0.96 13.74%
110 70 29.83% 31.62 0.96 14.60%
180 110 31.06% 33.44 0.96 16.25%
130 130 29.68% 31.34 0.96 15.09%
180 120 31.06% 33.44 0.96 16.25%
170 160 31.33% 33.9 0.96 16.16%
90 170 31.32% 33.56 0.96 15.23%
20 20 30.78% 33.07 0.96 16.68%
20 150 30.92% 33.48 0.96 16.88%
110 160 29.85% 31.68 0.96 15.28%
20 30 30.74% 33.21 0.96 18.48%
160 70 30.52% 32.39 0.96 15.30%
120 40 29.13% 30.85 0.95 14.74%
180 30 30.65% 33.37 0.95 18.20%
180 20 30.59% 33.29 0.95 15.80%
120 100 29.11% 30.83 0.95 15.85%
120 50 28.85% 30.45 0.95 15.68%
100 120 29.76% 31.82 0.95 14.01%
100 110 29.76% 31.82 0.95 14.01%
120 90 28.77% 30.59 0.95 16.27%
130 80 29.42% 31.37 0.95 14.92%
180 150 30.83% 33.57 0.95 16.50%
100 30 29.46% 31.76 0.95 14.81%
100 150 29.34% 31.97 0.94 14.36%
160 170 29.57% 32.31 0.94 16.45%
130 150 28.83% 31.35 0.94 15.29%
100 20 29.28% 31.59 0.94 13.94%
120 130 28.64% 30.87 0.94 14.95%
150 170 30.86% 34.41 0.94 18.65%
170 170 30.42% 33.73 0.94 16.10%
130 120 29.00% 31.26 0.94 15.10%
120 60 28.63% 30.96 0.94 14.44%
130 110 29.00% 31.26 0.94 15.10%
120 80 28.31% 30.89 0.93 14.80%
110 170 28.91% 31.53 0.93 15.22%
20 160 30.15% 33.5 0.93 17.00%
20 70 29.99% 33.41 0.93 16.54%
130 30 28.51% 31.16 0.93 16.78%
130 20 28.50% 31.08 0.93 15.00%
180 70 29.89% 33.57 0.93 15.63%
120 110 27.95% 30.8 0.92 14.95%
100 70 28.50% 31.9 0.92 13.90%
180 160 29.83% 33.6 0.92 16.75%
100 160 28.51% 31.99 0.92 14.62%
120 120 27.95% 30.8 0.92 14.95%
130 70 27.85% 31.38 0.91 14.78%
20 170 29.19% 33.37 0.91 16.98%
130 160 27.89% 31.36 0.91 15.49%
120 30 27.51% 30.68 0.91 16.25%
120 150 27.74% 30.89 0.91 15.15%
120 20 27.44% 30.61 0.91 14.85%
180 170 28.95% 33.44 0.9 16.70%
100 170 27.57% 31.84 0.89 14.56%
120 160 26.85% 30.9 0.89 15.36%
130 170 27.07% 31.22 0.89 15.44%
120 70 26.75% 30.9 0.88 14.68%
120 170 25.99% 30.76 0.86 15.30%
100 130 17.32% 43.65 0.52 27.49%


Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: TMT33 Two stars, 250 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204011 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/17/2007 9:49 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 3
At the beginning of this thread, Zee concluded by pointing out that using Sharpe/GSD could provide an even greater advantage combined with timing. Timing is not an easy thing to accomplish as evidenced by the poor performance over the last couple of years by commercial times like Equitrend, Intellitimer, Timing Cube, etc. Zee on the other hand seems to be far more succesful than most.

One timing method that does seem to generally add value is trend following. Something as simple as using a 100 day SMA on the Nasdaq composite over a 45 year period produced some pretty good results.

Timed 17% vs Buy and hold 10%

http://www.investmentwarrior.com/Performance.htm

I suspect using these same signals would work reasobably well on an MI blend.

Print the post Back To Top
Author: musselmant Three stars, 500 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204014 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/17/2007 11:08 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
You can get 17% v. 11% for the S&P since 1969 with identical GSD to the S&P and a better Sharpe by monthly trading by putting 60% of money into T-Bills and 40% into the 20 stocks of the RS 13 screen, without timing at all.

Screen S&P
CAGR 17 11
GSD 17 17
Sharpe 0.7 0.36
CAGR-3σ -27 -31
Blend 40% RS13WK 1-20, 60% T-Bill 1-1
code: 6906BLrq120p40tb11p60

It seems like timers have to generate better results than that to justify the risk of missing the key days of each year in which market gains occur.

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204016 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/17/2007 11:24 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 23
TMT33 stated:
One timing method that does seem to generally add value is trend following. Something as simple as using a 100 day SMA on the Nasdaq composite over a 45 year period produced some pretty good results.

I wondered if anyone would ask more on this question. I took some time the other day to find a simple way to do this for the typical investor on this board.

I found that it was optimal to use the Nasdaq 100 as a proxy for the market to determine when to be invested in bullish screens and when to be in defensive screens. The primary reason for this is that there are very few signals doing it the way I found as optimal. Only nine signals to be long over the period from 1989 to present. Here are the dates:
01/03/1989  BEAR
07/24/1989 BULL
01/26/1990 BEAR
05/17/1990 BULL
08/16/1990 BEAR
01/23/1991 BULL
05/19/1992 BEAR
09/23/1992 BULL
04/19/1994 BEAR
08/31/1994 BULL
12/26/1997 BEAR
02/03/1998 BULL
10/09/2000 BEAR
04/15/2003 BULL
07/28/2004 BEAR
10/13/2004 BULL
03/31/2005 BEAR
06/03/2005 BULL
05/26/2006 BEAR
09/29/2006 BULL

This is based on a cross of two EMAs on the Nasdaq 100 -- 40 and 140. For the test of the index itself this produces an ROI of 2067, compared to what you suggested as a 100 EMA crossing the close of the index which produces an ROI of 1000.

Now I also found a way for anyone on this board to easily track this. You just go to this site and sign up for a free subscription.
http://secure.timetotrade.eu/

Once you are signed up you can log in and set up an email alert on the NDX for a 40/140 EMA crossover. Whenever there is a cross you'll receive an email alert that you can act on the next day.

The idea here would be to move between screen sorts -- using very low risk, low GSD, high Sharpe screens when the market is in bearish mode, and use higher risk, high CAGR screens when the market is in bullish mode.

BULLISH MODE: Jensen 10 year lookback
BEARISH MODE: Sharpe/GSD 5 year lookback

Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: sencoman One star, 50 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204019 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/18/2007 2:23 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
Zee,

Thank you for sharing all this great work.

The other simple timing system that could be easily used by investors like myself is Seasonality - whether using fixed dates (bearish May through end-September or October), or switch dates modified with MACD per Sy Harding's STS .

Have you tested how Seasonality compares with the NDX 40/140 EMA crossover for bullish/bearish screen selection?

I wonder not only about CAGR and Sharpe, but also whether going bearish in summer will improve drawdowns and UI.

senco

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204020 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/18/2007 3:58 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 2
Senco asked:
Have you tested how Seasonality compares with the NDX 40/140 EMA crossover for bullish/bearish screen selection?

Well, to test that fully would take quite a bit of time, but the following tables I can produce in less than a minute. This shows the average returns for all the various tests with ranks 1-10 -- 5 screens. As you can easily see, Jensen pops out on top. The top row in each table shows the average of all the results. So about 96% of the years are positive for all results. The % POS column shows the # of years with a positive return. The High is the highest year return, while Low is the lowest return. The StdDev tells us the standard deviation of all the year returns. The tables are sorted by the average return of all the years for each test. The most difficult period for the bullish season was Oct 2000 to May 2001. The absolute best measure for this period was UPI with a three or five year lookback.
Bullish Period
      Nov 1 to April 30                                                         
Title AVG StdDev % POS P N High Low
18.66% 13.79 95.60% 17 1 53.80% -1.34%
Jensen, 9.00 27.17% 24.95 88.89% 16 2 88.95% -3.83%
Jensen, 21.00 26.58% 23.39 83.33% 15 3 72.49% -4.37%
Jensen, 23.00 26.50% 23.12 88.89% 16 2 72.49% -4.37%
Jensen, 15.00 26.47% 23.04 83.33% 15 3 72.49% -4.37%
Jensen, 25.00 26.47% 22.99 83.33% 15 3 72.49% -4.37%
Jensen, 13.00 26.42% 23.45 83.33% 15 3 72.49% -4.37%
Jensen, 29.00 26.37% 23.37 83.33% 15 3 72.49% -4.37%
Jensen, 27.00 26.37% 23.37 83.33% 15 3 72.49% -4.37%
Jensen, 17.00 26.29% 22.93 83.33% 15 3 72.49% -4.37%
UPI, 3.00 26.23% 24.15 83.33% 15 3 65.81% -2.83%
Jensen, 19.00 26.22% 22.81 83.33% 15 3 72.49% -4.37%
Jensen, 5.00 25.14% 25.03 94.44% 17 1 85.79% -4.90%
Jensen, 11.00 24.75% 20.43 88.89% 16 2 62.35% -4.37%
Jensen, 3.00 24.37% 20.59 94.44% 17 1 66.86% -11.23%
UPI, 5.00 23.86% 21.95 94.44% 17 1 75.78% -4.41%
Jensen, 1.00 23.20% 29.35 88.89% 16 2 112.55% -24.27%
Jensen, 7.00 22.35% 19.11 94.44% 17 1 66.54% -5.20%
Sharpe, 1.00 21.22% 22.47 88.89% 16 2 90.08% -7.05%
Sharpe, 3.00 20.64% 17.72 94.44% 17 1 65.81% -6.23%
Sharpe, 9.00 20.24% 13 100.00% 18 0 58.66% 0.70%
Sharpe, 13.00 20.19% 12.89 100.00% 18 0 60.59% 0.70%
Sortino, 3.00 20.16% 16.44 94.44% 17 1 66.12% -6.23%
Sortino, 1.00 20.14% 22.24 88.89% 16 2 90.08% -6.93%
Sharpe, 15.00 19.79% 12.39 100.00% 18 0 57.30% 0.70%
Sharpe, 11.00 19.55% 11.4 100.00% 18 0 51.63% 0.70%
Ulcer Performance Index, 1.00 19.40% 21.25 83.33% 15 3 81.68% -9.87%
Ulcer Performance Index, 3.00 19.35% 15.89 94.44% 17 1 64.55% -8.22%
Sharpe, 17.00 19.35% 11.62 100.00% 18 0 53.54% 0.70%
UI, 3.00 19.22% 15.97 94.44% 17 1 64.55% -8.22%
Ulcer Performance Index, 17.00 19.18% 11.85 100.00% 18 0 49.19% 3.42%
Sortino, 5.00 19.17% 10.8 100.00% 18 0 42.41% 1.24%
UPI, 7.00 19.16% 23.33 83.33% 15 3 78.34% -4.79%
Ulcer Performance Index, 13.00 19.09% 11.83 100.00% 18 0 49.19% 3.42%
UI, 1.00 19.07% 21.25 83.33% 15 3 80.98% -17.69%
Ulcer Performance Index, 15.00 19.03% 11.79 100.00% 18 0 49.19% 3.42%
UPI, 13.00 18.91% 18.92 94.44% 17 1 62.14% -3.87%
UPI, 27.00 18.90% 19.67 88.89% 16 2 60.70% -5.61%
UPI, 19.00 18.88% 19.04 94.44% 17 1 61.78% -4.82%
UI, 15.00 18.87% 11.93 100.00% 18 0 49.19% 1.48%
Ulcer Performance Index, 19.00 18.86% 11.41 100.00% 18 0 49.19% 3.42%
Sharpe, 19.00 18.76% 9.86 100.00% 18 0 42.38% 0.70%
UI, 19.00 18.68% 11.89 100.00% 18 0 49.19% 1.48%
UI, 17.00 18.68% 11.89 100.00% 18 0 49.19% 1.48%
UPI, 21.00 18.68% 17.98 94.44% 17 1 58.16% -5.61%
UPI, 29.00 18.67% 19.21 88.89% 16 2 58.26% -5.61%
Sharpe, 27.00 18.65% 10.05 100.00% 18 0 43.68% 0.70%
Sharpe, 23.00 18.65% 10.05 100.00% 18 0 43.68% 0.70%
Sharpe, 29.00 18.65% 10.05 100.00% 18 0 43.68% 0.70%
Sharpe, 25.00 18.65% 10.05 100.00% 18 0 43.68% 0.70%
Sharpe, 21.00 18.65% 10.05 100.00% 18 0 43.68% 0.70%
Ulcer Performance Index, 25.00 18.61% 11.36 100.00% 18 0 49.19% 3.42%
Ulcer Performance Index, 29.00 18.61% 11.36 100.00% 18 0 49.19% 3.42%
Ulcer Performance Index, 23.00 18.61% 11.36 100.00% 18 0 49.19% 3.42%
Ulcer Performance Index, 27.00 18.61% 11.36 100.00% 18 0 49.19% 3.42%
Ulcer Performance Index, 21.00 18.61% 11.36 100.00% 18 0 49.19% 3.42%
UI, 13.00 18.60% 11.86 100.00% 18 0 49.19% 1.48%
UPI, 17.00 18.57% 18.08 94.44% 17 1 58.16% -4.82%
Ulcer Performance Index, 11.00 18.49% 11.41 100.00% 18 0 49.19% 3.42%
UI, 21.00 18.44% 11.83 100.00% 18 0 49.19% 1.48%
Sharpe, 5.00 18.44% 9.14 100.00% 18 0 43.73% 3.51%
UPI, 11.00 18.43% 18.12 88.89% 16 2 62.14% -3.87%
Sortino, 9.00 18.41% 12.93 100.00% 18 0 58.66% 1.22%
UI, 11.00 18.31% 11.87 100.00% 18 0 49.19% 1.48%
Sortino, 15.00 18.28% 13 100.00% 18 0 60.59% 1.84%
UPI, 25.00 18.28% 18.6 88.89% 16 2 58.59% -5.61%
UPI, 15.00 18.18% 18.1 94.44% 17 1 62.14% -3.87%
UPI, 23.00 18.16% 17.86 94.44% 17 1 58.16% -5.61%
UI, 29.00 18.11% 11.49 100.00% 18 0 49.19% 1.48%
UI, 27.00 18.11% 11.49 100.00% 18 0 49.19% 1.48%
UI, 23.00 18.11% 11.49 100.00% 18 0 49.19% 1.48%
UI, 25.00 18.11% 11.49 100.00% 18 0 49.19% 1.48%
UPI, 9.00 18.04% 20.01 88.89% 16 2 63.11% -6.51%
Sortino, 11.00 17.99% 11.22 100.00% 18 0 50.29% 2.16%
UI, 9.00 17.78% 11.47 100.00% 18 0 49.23% 1.48%
Ulcer Performance Index, 9.00 17.78% 11.23 100.00% 18 0 45.27% 3.42%
Sortino, 13.00 17.73% 11.23 100.00% 18 0 52.22% 2.29%
Sortino, 17.00 17.69% 11.47 100.00% 18 0 52.20% 1.45%
UPI, 1.00 17.67% 18.93 88.89% 16 2 62.33% -4.57%
Sharpe, 7.00 17.53% 9.52 100.00% 18 0 42.38% 0.70%
Upside Potential Ratio, 17.00 17.25% 11.26 94.44% 17 1 52.57% -0.59%
Upside Potential Ratio, 23.00 17.25% 11.33 94.44% 17 1 53.00% -0.59%
Upside Potential Ratio, 29.00 17.25% 11.33 94.44% 17 1 53.00% -0.59%
Upside Potential Ratio, 25.00 17.25% 11.33 94.44% 17 1 53.00% -0.59%
Upside Potential Ratio, 27.00 17.25% 11.33 94.44% 17 1 53.00% -0.59%
Upside Potential Ratio, 5.00 17.24% 12.01 94.44% 17 1 50.21% -2.65%
Upside Potential Ratio, 21.00 17.23% 11.25 94.44% 17 1 52.57% -0.59%
Upside Potential Ratio, 15.00 17.20% 11.33 94.44% 17 1 53.71% -0.80%
Sortino, 19.00 17.17% 9.81 100.00% 18 0 42.38% 1.45%
Upside Potential Ratio, 13.00 17.13% 11.31 94.44% 17 1 53.71% -0.80%
UI, 5.00 17.07% 9.99 94.44% 17 1 38.62% -1.07%
Ulcer Performance Index, 5.00 16.97% 10.16 94.44% 17 1 41.68% 0.00%
Sortino, 23.00 16.89% 9.88 100.00% 18 0 43.68% 1.45%
Sortino, 29.00 16.89% 9.88 100.00% 18 0 43.68% 1.45%
Sortino, 27.00 16.89% 9.88 100.00% 18 0 43.68% 1.45%
Sortino, 25.00 16.89% 9.88 100.00% 18 0 43.68% 1.45%
Upside Potential Ratio, 11.00 16.89% 11.02 94.44% 17 1 51.83% -1.26%
Sortino, 21.00 16.84% 9.94 100.00% 18 0 44.31% 1.45%
Upside Potential Ratio, 9.00 16.71% 12.09 100.00% 18 0 55.03% 0.22%
Sortino, 7.00 16.71% 9.82 100.00% 18 0 42.38% 1.22%
Upside Potential Ratio, 7.00 16.65% 11.37 94.44% 17 1 50.21% -0.22%
GSD, 1.00 16.47% 19.29 83.33% 15 3 73.16% -12.80%
UI, 7.00 16.43% 10.24 94.44% 17 1 38.62% -1.74%
Ulcer Performance Index, 7.00 16.15% 10.92 94.44% 17 1 41.68% -6.27%
GSD, 3.00 16.14% 13.8 100.00% 18 0 61.66% 2.38%
Upside Potential Ratio, 3.00 16.10% 14.46 94.44% 17 1 64.96% -2.65%
GSD, 15.00 15.07% 9.3 100.00% 18 0 46.25% 2.68%
GSD, 5.00 15.05% 7.28 100.00% 18 0 29.24% 3.14%
Upside Potential Ratio, 1.00 14.76% 13.54 88.89% 16 2 39.97% -14.94%
GSD, 13.00 14.45% 7.53 100.00% 18 0 37.27% 2.68%
GSD, 17.00 14.21% 5.91 100.00% 18 0 29.24% 2.68%
GSD, 19.00 14.21% 5.91 100.00% 18 0 29.24% 2.68%
GSD, 9.00 14.12% 6.68 100.00% 18 0 30.59% 2.68%
GSD, 11.00 14.09% 6.08 100.00% 18 0 30.59% 2.68%
GSD, 25.00 14.04% 5.94 100.00% 18 0 29.24% 2.68%
GSD, 21.00 14.04% 5.94 100.00% 18 0 29.24% 2.68%
GSD, 29.00 14.04% 5.94 100.00% 18 0 29.24% 2.68%
GSD, 27.00 14.04% 5.94 100.00% 18 0 29.24% 2.68%
GSD, 23.00 14.04% 5.94 100.00% 18 0 29.24% 2.68%
GSD, 7.00 13.96% 6.28 100.00% 18 0 29.24% 2.68%
Upside Potential Ratio, 19.00 2.32% 0.93 100.00% 18 0 4.11% 0.64%

Bearish Period
      May 1 to October 31                                                      
Title AVG StdDev % POS P N High Low
8.32% 13.22 74.39% 14 5 33.06% -16.01%
Jensen, 17.00 12.38% 17.51 73.68% 14 5 45.34% -16.36%
Jensen, 13.00 11.91% 16.8 73.68% 14 5 45.34% -16.36%
Jensen, 15.00 11.75% 16.63 73.68% 14 5 45.34% -14.72%
Jensen, 21.00 11.62% 16.98 73.68% 14 5 45.34% -16.36%
UPI, 27.00 11.53% 14.51 78.95% 15 4 37.11% -16.28%
Jensen, 25.00 11.50% 16.86 73.68% 14 5 45.34% -16.36%
UPI, 19.00 11.47% 14.52 78.95% 15 4 37.11% -16.28%
Jensen, 23.00 11.47% 16.82 73.68% 14 5 45.34% -16.36%
Jensen, 11.00 11.46% 16.12 73.68% 14 5 42.69% -14.72%
Jensen, 19.00 11.37% 17.49 68.42% 13 6 45.34% -16.36%
UPI, 21.00 11.31% 14.46 78.95% 15 4 37.11% -16.28%
UPI, 29.00 11.18% 14.36 78.95% 15 4 37.11% -16.28%
UPI, 25.00 11.05% 14.34 78.95% 15 4 37.11% -16.28%
Jensen, 29.00 11.04% 16.77 68.42% 13 6 45.34% -16.36%
Jensen, 27.00 11.04% 16.77 68.42% 13 6 45.34% -16.36%
Jensen, 9.00 10.91% 17.48 73.68% 14 5 45.34% -19.15%
UPI, 17.00 10.85% 14.52 78.95% 15 4 37.40% -16.28%
UPI, 23.00 10.78% 14.68 78.95% 15 4 37.40% -16.28%
Sortino, 1.00 10.69% 13.63 78.95% 15 4 34.76% -12.49%
UPI, 7.00 10.42% 15.86 73.68% 14 5 38.68% -16.28%
UPI, 15.00 10.42% 14.86 73.68% 14 5 37.40% -16.28%
Sharpe, 1.00 10.11% 13.14 84.21% 16 3 34.13% -16.11%
UPI, 3.00 10.10% 14.33 68.42% 13 6 28.40% -13.23%
UPI, 11.00 9.93% 14.79 73.68% 14 5 36.33% -16.28%
UPI, 1.00 9.84% 17.84 73.68% 14 5 42.63% -23.79%
Upside Potential Ratio, 1.00 9.46% 11.37 84.21% 16 3 33.22% -10.52%
UPI, 5.00 9.43% 14.87 68.42% 13 6 32.97% -15.77%
UPI, 13.00 9.31% 15.74 68.42% 13 6 41.01% -16.28%
Ulcer Performance Index, 1.00 9.18% 12.3 78.95% 15 4 28.76% -15.64%
Upside Potential Ratio, 15.00 8.93% 11.42 84.21% 16 3 27.38% -12.72%
Sharpe, 13.00 8.66% 12.84 78.95% 15 4 33.12% -16.58%
UPI, 9.00 8.59% 15.55 73.68% 14 5 36.33% -16.28%
Ulcer Performance Index, 15.00 8.55% 12.31 73.68% 14 5 31.63% -14.97%
Sortino, 13.00 8.54% 12.83 73.68% 14 5 34.55% -16.58%
UI, 1.00 8.48% 12.18 78.95% 15 4 28.76% -14.72%
Sortino, 11.00 8.39% 12.65 73.68% 14 5 34.55% -16.58%
Ulcer Performance Index, 17.00 8.38% 12.25 73.68% 14 5 31.63% -14.97%
Upside Potential Ratio, 9.00 8.36% 10.87 84.21% 16 3 26.59% -12.72%
Sortino, 9.00 8.36% 12.89 73.68% 14 5 34.55% -16.58%
Jensen, 1.00 8.36% 17.17 68.42% 13 6 40.05% -18.46%
Jensen, 7.00 8.36% 19.44 57.89% 11 8 54.58% -19.15%
Ulcer Performance Index, 19.00 8.32% 12.23 73.68% 14 5 31.63% -14.97%
UI, 17.00 8.27% 11.92 78.95% 15 4 31.63% -14.97%
UI, 19.00 8.27% 11.92 78.95% 15 4 31.63% -14.97%
Sharpe, 5.00 8.24% 13.92 68.42% 13 6 33.42% -16.58%
Sharpe, 9.00 8.23% 13.43 73.68% 14 5 33.12% -16.58%
Sharpe, 11.00 8.22% 12.5 78.95% 15 4 33.12% -16.58%
Sharpe, 7.00 8.22% 13.88 68.42% 13 6 36.86% -16.58%
Sharpe, 15.00 8.20% 12.71 78.95% 15 4 33.12% -16.58%
Sortino, 15.00 8.18% 12.61 73.68% 14 5 34.55% -16.58%
Ulcer Performance Index, 27.00 8.17% 12.31 73.68% 14 5 31.63% -14.97%
Ulcer Performance Index, 25.00 8.17% 12.31 73.68% 14 5 31.63% -14.97%
Ulcer Performance Index, 23.00 8.17% 12.31 73.68% 14 5 31.63% -14.97%
Ulcer Performance Index, 29.00 8.17% 12.31 73.68% 14 5 31.63% -14.97%
Ulcer Performance Index, 21.00 8.17% 12.31 73.68% 14 5 31.63% -14.97%
Upside Potential Ratio, 17.00 8.15% 12.91 78.95% 15 4 28.42% -14.91%
UI, 21.00 8.12% 12 78.95% 15 4 31.63% -14.97%
Sortino, 17.00 8.10% 12.8 73.68% 14 5 34.55% -16.58%
UI, 25.00 8.05% 11.98 78.95% 15 4 31.63% -14.97%
UI, 29.00 8.05% 11.98 78.95% 15 4 31.63% -14.97%
UI, 23.00 8.05% 11.98 78.95% 15 4 31.63% -14.97%
UI, 27.00 8.05% 11.98 78.95% 15 4 31.63% -14.97%
Sortino, 19.00 8.03% 12.5 73.68% 14 5 34.55% -16.58%
Upside Potential Ratio, 11.00 8.00% 12.53 78.95% 15 4 27.14% -13.53%
Upside Potential Ratio, 13.00 7.92% 12.65 78.95% 15 4 27.38% -14.98%
Upside Potential Ratio, 21.00 7.87% 13.48 78.95% 15 4 28.42% -20.23%
GSD, 1.00 7.84% 10.45 78.95% 15 4 25.53% -15.07%
GSD, 5.00 7.81% 11.62 73.68% 14 5 28.47% -14.99%
Upside Potential Ratio, 29.00 7.78% 13.39 78.95% 15 4 28.42% -20.23%
Upside Potential Ratio, 23.00 7.78% 13.39 78.95% 15 4 28.42% -20.23%
Upside Potential Ratio, 27.00 7.78% 13.39 78.95% 15 4 28.42% -20.23%
Upside Potential Ratio, 25.00 7.78% 13.39 78.95% 15 4 28.42% -20.23%
Sharpe, 17.00 7.70% 12.76 78.95% 15 4 33.12% -16.58%
Sharpe, 19.00 7.66% 12.73 78.95% 15 4 33.12% -16.58%
GSD, 9.00 7.65% 11.12 73.68% 14 5 28.47% -13.53%
Sortino, 21.00 7.61% 12.86 73.68% 14 5 34.55% -18.04%
Sortino, 23.00 7.56% 12.85 73.68% 14 5 34.55% -18.04%
Sortino, 27.00 7.56% 12.85 73.68% 14 5 34.55% -18.04%
Sortino, 25.00 7.56% 12.85 73.68% 14 5 34.55% -18.04%
Sortino, 29.00 7.56% 12.85 73.68% 14 5 34.55% -18.04%
UI, 15.00 7.53% 12.93 73.68% 14 5 31.63% -14.97%
GSD, 15.00 7.46% 11.25 68.42% 13 6 28.47% -13.53%
Ulcer Performance Index, 13.00 7.43% 13.28 68.42% 13 6 31.63% -14.97%
Ulcer Performance Index, 11.00 7.41% 13.14 68.42% 13 6 31.63% -14.97%
UI, 11.00 7.36% 12.85 73.68% 14 5 31.63% -14.97%
Sortino, 5.00 7.33% 12.95 73.68% 14 5 34.55% -16.58%
Jensen, 5.00 7.33% 16.88 68.42% 13 6 33.51% -19.15%
UI, 13.00 7.32% 12.97 73.68% 14 5 31.63% -14.97%
Sharpe, 23.00 7.28% 12.92 78.95% 15 4 33.12% -19.33%
Sharpe, 29.00 7.28% 12.92 78.95% 15 4 33.12% -19.33%
Sharpe, 21.00 7.28% 12.92 78.95% 15 4 33.12% -19.33%
Sharpe, 25.00 7.28% 12.92 78.95% 15 4 33.12% -19.33%
Sharpe, 27.00 7.28% 12.92 78.95% 15 4 33.12% -19.33%
Ulcer Performance Index, 9.00 7.27% 13.97 68.42% 13 6 32.30% -14.97%
GSD, 11.00 7.27% 11.19 68.42% 13 6 28.47% -13.53%
Sortino, 3.00 7.24% 13.7 68.42% 13 6 35.20% -16.58%
GSD, 13.00 7.20% 11.3 68.42% 13 6 28.47% -13.53%
GSD, 19.00 7.18% 11.09 68.42% 13 6 28.73% -13.53%
GSD, 17.00 7.18% 11.09 68.42% 13 6 28.73% -13.53%
Sharpe, 3.00 7.15% 14.07 68.42% 13 6 33.83% -16.58%
GSD, 25.00 7.07% 11.25 68.42% 13 6 28.73% -15.18%
GSD, 21.00 7.07% 11.25 68.42% 13 6 28.73% -15.18%
GSD, 27.00 7.07% 11.25 68.42% 13 6 28.73% -15.18%
GSD, 29.00 7.07% 11.25 68.42% 13 6 28.73% -15.18%
GSD, 23.00 7.07% 11.25 68.42% 13 6 28.73% -15.18%
Upside Potential Ratio, 7.00 7.04% 11.62 78.95% 15 4 26.59% -16.02%
Sortino, 7.00 6.98% 12.14 73.68% 14 5 31.81% -16.58%
UI, 9.00 6.92% 13.29 73.68% 14 5 30.04% -14.97%
GSD, 7.00 6.78% 10.91 68.42% 13 6 27.18% -13.53%
GSD, 3.00 6.64% 11.45 73.68% 14 5 23.05% -17.53%
Upside Potential Ratio, 5.00 6.39% 11.73 78.95% 15 4 28.22% -19.68%
Ulcer Performance Index, 7.00 6.37% 13.62 68.42% 13 6 29.95% -14.97%
UI, 5.00 6.10% 12.63 68.42% 13 6 29.95% -14.97%
Ulcer Performance Index, 5.00 6.09% 12.09 68.42% 13 6 29.95% -14.97%
Upside Potential Ratio, 3.00 6.00% 11.27 78.95% 15 4 32.22% -16.45%
UI, 7.00 5.91% 12.9 73.68% 14 5 29.95% -14.97%
Jensen, 3.00 5.86% 14.73 73.68% 14 5 26.25% -23.32%
Ulcer Performance Index, 3.00 5.30% 12.48 63.16% 12 7 23.61% -14.97%
UI, 3.00 5.12% 12.97 63.16% 12 7 24.63% -14.97%
Upside Potential Ratio, 19.00 2.41% 0.97 100.00% 19 0 4.26% 0.60%

One very important thing to remember is that when the market is really tanking big time, nothing wins, no matter what measure you use. Here are the percent of the results that were positive for each year during the summer months. Note that in 2002, 1998 and 1990, nothing worked. The only thing that would have saved you during those three periods was being 100% in cash. It is also interesting to note that this year has been extremely difficult as well. One would be better served using a super-defensive position during these times, rather than just move into another blend. The problem is, how do you know whether it will be one of those years or not.
2007   42.50%
2006 86.67%
2005 100.00%
2004 100.00%
2003 100.00%
2002 0.83%
2001 72.50%
2000 31.67%
1999 82.50%
1998 9.17%
1997 100.00%
1996 100.00%
1995 100.00%
1994 85.83%
1993 100.00%
1992 99.17%
1991 100.00%
1990 0.83%
1989 100.00%


Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204021 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/18/2007 4:50 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 14
In order to enhance everyone's analysis of which measure is the best predictor of future risk-adjusted return, let me take a few minutes to post the exact same data as what you find in the top post of this thread but based on ranks 1-4 instead of ranks 1-10. Keep in mind that this is holding five screens for a total blend of twenty stock positions.

It used to be that we believed Sharpe was the best measure to use for determining a blend. How has that measured faired under all the testing you've done?

As I posted a day or two ago, the Sharpe does not tend to come out on top with any of the means we have to evaluate a blend. Let me share the same table again, but this time with ranks 1-4 included.
             1-10      1-4
Sharpe Position Position
CAGR 11 9
GSD 5 6
Sharpe 6 6
UI 5 8
Win Ratio 5 3
Drawdown 5 10

What this shows more than anything else, is simply that there are better tools available for blend selection.
What is the best measure for finding the highest future CAGR? In other words, which measure is most predictive of future CAGR?

Jensen and Alpha came out on top with ranks 1-10, but this time GSD is the top CAGR finder. This is most definitely counter-intuitive, since what this is saying is that we find the best screens by sorting on GSD in descending order. In other words, the highest GSD screens produce the highest CAGR. GSD was in position #5 for ranks 1-10, but it shoots to first position when only twenty stocks are held.
 RANKS 1-4                                 
CAGR Minimum Maximum Median Average
GSD 28.65% 47.69% 46.31% 43.34%
Treynor 40.61% 46.82% 43.99% 44.02%
UP 30.20% 43.71% 43.54% 40.35%
Alpha 34.27% 41.73% 39.99% 39.47%
DD 28.96% 42.81% 39.76% 37.73%
Jensen 30.47% 40.68% 39.30% 38.34%
UPI 28.49% 36.15% 35.05% 34.02%
CAGR/GSD 27.92% 35.35% 32.16% 31.35%
Sharpe 27.64% 34.09% 31.94% 31.40%
Sortino 25.77% 35.28% 31.53% 30.92%
UPR 24.02% 35.05% 31.18% 30.92%
Beta 24.85% 32.21% 30.50% 30.13%
CAGR/UPI 23.10% 33.74% 29.36% 28.95%
CAGR/UI 26.17% 32.33% 29.10% 28.82%
Correlation 21.47% 31.14% 29.09% 28.02%
UI 21.52% 30.28% 27.54% 27.17%
Sharpe/GSD 24.41% 30.67% 27.32% 26.89%
GSD Ratio 19.18% 39.10% 26.41% 26.88%
Trough # 19.09% 32.80% 24.30% 23.79%

But our goal is risk-adjusted return, not raw return, so what is the best measure for finding the highest Sharpe Ratio?

Treynor pushes Sharpe/GSD out of first place when ranks 1-4 are employed. What is interesting is that there is a pretty big difference between the median Treynor and either Sharpe/GSD or CAGR/GSD.
  Sharpe     Minimum  Maximum  Median  Average
Treynor 1.32 1.73 1.66 1.64
CAGR/GSD 0.87 1.55 1.47 1.37
Sharpe/GSD 1.07 1.53 1.44 1.39
UPR 0.93 1.49 1.39 1.34
UPI 1.00 1.43 1.38 1.33
Sharpe 0.91 1.44 1.35 1.28
GSD 0.83 1.38 1.34 1.25
Sortino 1.00 1.42 1.33 1.26
CAGR/UI 0.91 1.25 1.24 1.19
UP 0.84 1.20 1.20 1.11
Alpha 1.02 1.25 1.19 1.17
Jensen 0.92 1.20 1.14 1.13
Correlation 0.82 1.21 1.14 1.08
DD 0.83 1.21 1.13 1.07
GSD Ratio 0.72 1.36 0.98 0.99
CAGR/UPI 0.76 1.11 0.93 0.92
UI 0.70 0.97 0.91 0.89
Beta 0.67 0.84 0.80 0.79
Trough # 0.58 0.86 0.75 0.71

What measure comes out on top for Ulcer Index?

I consider the UI one of the most important tools for evaluating a blend. A low value with this measure will make a huge difference in real-time use of the blend chosen, at least that has been my experience since Mungo first suggested the measure. Based on this I'd say Treynor is a very reasonable option rather than Sharpe/GSD.
    UI       Minimum  Maximum  Median  Average
Sharpe/GSD 4.67% 5.55% 4.96% 5.02%
CAGR/GSD 6.25% 17.98% 6.76% 7.58%
Treynor 6.61% 8.05% 6.87% 7.00%
UPR 6.64% 12.33% 7.01% 7.32%
CAGR/UI 6.81% 18.41% 7.77% 8.35%
UPI 6.95% 13.10% 7.83% 8.02%
Sortino 7.47% 16.99% 8.07% 9.15%
Sharpe 7.81% 18.10% 8.13% 8.95%
Correlation 7.27% 18.94% 8.22% 9.29%
UI 11.20% 17.90% 11.46% 12.40%
CAGR/UPI 11.10% 14.62% 12.13% 12.39%
GSD 11.89% 22.07% 12.81% 14.05%
Jensen 12.43% 22.71% 13.14% 14.01%
Alpha 11.85% 21.20% 13.15% 13.90%
GSD Ratio 7.03% 21.10% 16.07% 15.67%
DD 15.97% 24.30% 16.12% 17.81%
UP 16.26% 25.37% 16.29% 18.03%
Trough # 18.83% 39.42% 19.98% 23.60%
Beta 29.57% 37.30% 34.55% 34.53%

Which measure chooses screens with a high win ratio?

This tells us what percent of the screens employed each year produced a winning return. It is pretty impressive to find a win ratio about 85%. I doubt there are too many here who have had this level of success in picking screens to use for their investing.
 Win Ratio   Minimum  Maximum  Median  Average
CAGR/GSD 80% 92% 91% 90%
Sortino 82% 92% 91% 90%
Sharpe 79% 91% 88% 88%
Treynor 86% 92% 88% 89%
Sharpe/GSD 83% 87% 86% 86%
UPR 78% 88% 84% 84%
GSD 74% 86% 83% 83%
UP 75% 83% 83% 81%
Alpha 81% 85% 82% 83%
CAGR/UI 80% 85% 82% 82%
Correlation 71% 84% 82% 80%
UPI 81% 86% 82% 82%
DD 75% 84% 81% 80%
GSD Ratio 77% 89% 81% 81%
Jensen 80% 83% 80% 81%
UI 69% 83% 77% 76%
CAGR/UPI 67% 79% 76% 76%
Beta 68% 77% 73% 73%
Trough # 64% 75% 71% 71%

When it comes to the maximum daily drawdown, which of the measures is able to avoid drawdowns the best?

  Drawdown   Minimum  Maximum  Median  Average
Sharpe/GSD -26% -24% -24% -24%
CAGR/UI -57% -26% -28% -30%
UPR -50% -27% -28% -29%
UPI -47% -24% -29% -29%
Treynor -38% -28% -31% -31%
Correlation -55% -33% -33% -35%
CAGR/GSD -59% -35% -35% -36%
CAGR/UPI -44% -37% -38% -39%
Sortino -56% -38% -38% -40%
Sharpe -59% -38% -38% -40%
UI -47% -39% -39% -40%
GSD -66% -40% -41% -45%
Jensen -66% -40% -43% -45%
Alpha -63% -40% -43% -45%
DD -68% -44% -44% -48%
UP -70% -46% -48% -51%
Trough # -80% -52% -54% -60%
GSD Ratio -64% -30% -63% -57%
Beta -78% -71% -75% -76%

Which of the measures you used actually produced a backtest with the lowest GSD?

I only wish that Treynor came out a bit better on this one. But if it did, the Sharpe on the Treynor would really be out in the stratosphere.
    GSD      Minimum  Maximum  Median  Average
Sharpe/GSD 14.54 20.73 15.34 15.66
CAGR/GSD 17.63 30.87 17.85 19.58
UPR 17.79 24.69 18.87 19.44
CAGR/UI 19.75 28.23 19.98 20.98
Sortino 19.63 28.43 20.20 21.10
Sharpe 19.66 29.78 20.29 21.38
UPI 20.87 26.07 21.79 22.16
Treynor 20.96 27.02 21.86 22.18
Correlation 22.01 28.74 22.22 22.90
GSD Ratio 19.54 26.30 24.06 23.85
UI 27.72 32.54 28.12 28.77
CAGR/UPI 27.96 31.51 29.58 29.75
GSD 31.08 38.64 31.39 32.16
Alpha 28.69 32.42 31.87 31.25
Jensen 30.84 32.53 32.11 31.90
Trough # 31.81 41.23 33.04 34.72
DD 33.02 38.53 33.14 33.82
UP 34.28 39.24 34.36 35.31
Beta 41.06 43.30 41.74 41.93

What about the Treynor as an option instead of Sharpe/GSD?

Here I've prepared a table with Sharpe, Treynor and Sharpe/GSD laid out side by side, and their position rank among all the measures for each of the factors we use to evalute the results. I'm confident that there is a huge difference in opinion regarding how to best use all of this data, but I for one, based on this data alone, would lean toward the Treynor as the best measure. One other factor why I think so is that when you look at the annual returns it wins every year and has an average win of over 50% CAGR. Pretty impressive! The only year where it really did not do great is 1990. In fact, when I take all the yearly returns and sort by the percent of years that were positive so that those with 100% winning are at the top, and then sort by average yearly return, Treynor takes the top twelve positions. Pretty amazing!
             1-10      1-4                        1-10      1-4                         1-10      1-4
Sharpe Position Position Treynor Position Position Sharpe/GSD Position Position
CAGR 11 9 CAGR 4 2 CAGR 19 17
GSD 5 6 GSD 7 8 GSD 1 1
Sharpe 6 6 Sharpe 2 1 Sharpe 1 3
UI 5 8 UI 8 3 UI 1 1
Win Ratio 5 3 Win Ratio 7 4 Win Ratio 1 5
Drawdown 5 10 Drawdown 6 5 Drawdown 1 1


Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: emintz Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204024 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/18/2007 7:09 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Z,

What index are you using to calculate Alpha?

Eric

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204026 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/18/2007 8:52 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Eric asked:
What index are you using to calculate Alpha?

My default -- the S&P 500 -- but I can test it off of any index. Do you have some thought of one being better than another?

Print the post Back To Top
Author: emintz Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204027 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/18/2007 9:22 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 2
My default -- the S&P 500 -- but I can test it off of any index. Do you have some thought of one being better than another?

I would guess it doesn't make too much difference.

The problem I've run into with Alpha, is that backtested performance is so far above the S&P 500 that when I try to optimize for alpha I get blends that have unacceptably (to me) high GSD's (I'm talking in the 30's). But that's using only monthly data.

Another approach to your optimization is to use the Sharpe ratio, but modify the risk-free rate as a constant rather than using the treasury yield. For example, something I might call Sharpe(8) using a figure of 8% as the risk-free rate. You could vary that number and see how it affects future returns.

I've found that's actually a decent way to optimize a blend based on differential risk levels. I use a different value in optimizing, which yields blends that vary in their level of volatility.

Eric

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204048 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/19/2007 12:29 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 6
Eric wrote:
I would guess it doesn't make too much difference.

For alpha I would definitely think it would not, but for other measures, it can make a huge difference.

The problem I've run into with Alpha, is that backtested performance is so far above the S&P 500 that when I try to optimize for alpha I get blends that have unacceptably (to me) high GSD's (I'm talking in the 30's). But that's using only monthly data.

The median GSD is 31.87 for ranks 1-4 and 28.75 for ranks 1-10. I personally would think there are other measures that work better so there is no use in using this one.

Another approach to your optimization is to use the Sharpe ratio, but modify the risk-free rate as a constant rather than using the treasury yield. For example, something I might call Sharpe(8) using a figure of 8% as the risk-free rate. You could vary that number and see how it affects future returns.

Here is a backtest of the Sharpe using various MAR values from 2-15%. I also have the ability to easily test the granularity of the data used so I included that in the backtest. This is using daily, weekly, monthly and yearly data. As you can see with the Sharpe-based sort below, the highest Sharpe Ratio is attained using yearly granularity, but the highest CAGR is obtained by using a larger MAR and daily data. The default in the list that follows is using the Sharpe with the 1 year t-bill.
MAR Fixed  Look-back Period   CAGR    GSD   Sharpe  Ulcer Index
2.00% Years 30.52% 18.6 1.37 7.40%
4.00% Years 30.51% 18.85 1.36 7.58%
5.00% Years 30.77% 19.26 1.35 7.71%
6.00% Years 30.81% 19.33 1.35 7.75%
3.00% Years 29.99% 18.75 1.34 7.54%
9.00% Years 31.57% 21.11 1.29 9.58%
8.00% Years 31.12% 21.11 1.27 9.65%
13.00% Years 31.24% 21.6 1.25 9.66%
14.00% Years 31.16% 21.61 1.25 9.66%
15.00% Years 31.58% 22.06 1.24 9.69%
7.00% Years 29.92% 20.65 1.24 9.48%
Default Days 29.04% 19.91 1.24 8.15%
11.00% Years 30.16% 21.22 1.23 9.77%
10.00% Years 30.10% 21.09 1.23 9.76%
12.00% Years 30.25% 21.5 1.22 9.77%
3.00% Months 32.76% 23.95 1.21 9.34%
4.00% Months 33.18% 24.25 1.21 9.36%
2.00% Months 32.43% 23.85 1.2 9.25%
7.00% Months 33.04% 24.77 1.19 9.75%
5.00% Months 32.73% 24.46 1.19 9.40%
6.00% Months 32.65% 24.53 1.19 9.74%
3.00% Weeks 34.10% 26.38 1.17 10.15%
4.00% Weeks 33.71% 26.37 1.16 10.32%
2.00% Weeks 33.69% 26.31 1.16 10.14%
5.00% Weeks 33.71% 26.33 1.16 10.32%
8.00% Months 31.42% 24.99 1.13 10.20%
10.00% Months 31.50% 25.01 1.13 10.24%
9.00% Months 31.42% 24.99 1.13 10.20%
15.00% Months 31.89% 25.62 1.12 11.32%
12.00% Months 31.34% 25.56 1.11 11.24%
14.00% Months 31.46% 25.57 1.11 11.31%
13.00% Months 31.49% 25.56 1.11 11.24%
11.00% Months 31.34% 25.56 1.11 11.24%
6.00% Weeks 32.96% 28.36 1.08 12.98%
7.00% Weeks 32.43% 28.43 1.06 13.06%
8.00% Weeks 31.95% 28.52 1.04 13.09%
11.00% Weeks 31.75% 28.77 1.03 13.23%
9.00% Weeks 31.75% 28.77 1.03 13.23%
10.00% Weeks 31.75% 28.77 1.03 13.23%
12.00% Weeks 31.68% 28.86 1.03 13.28%
14.00% Weeks 31.45% 29.06 1.02 13.54%
15.00% Weeks 31.45% 29.06 1.02 13.54%
14.00% Days 42.73% 33.57 1.01 7.75%
13.00% Days 42.73% 33.57 1.01 7.75%
11.00% Days 42.73% 33.57 1.01 7.75%
15.00% Days 42.73% 33.57 1.01 7.75%
12.00% Days 42.73% 33.57 1.01 7.75%
10.00% Days 42.73% 33.57 1.01 7.75%
7.00% Days 42.11% 33.38 1 7.69%
13.00% Weeks 30.92% 28.9 1 13.52%
8.00% Days 42.11% 33.38 1 7.69%
5.00% Days 42.11% 33.38 1 7.69%
9.00% Days 42.11% 33.38 1 7.69%
6.00% Days 42.11% 33.38 1 7.69%
2.00% Days 41.74% 33.18 0.99 7.68%
4.00% Days 41.77% 33.37 0.99 7.93%
3.00% Days 41.74% 33.18 0.99 7.68%


Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204090 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/20/2007 6:23 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
Emintz wrote:
Another approach to your optimization is to use the Sharpe ratio, but modify the risk-free rate as a constant rather than using the treasury yield. For example, something I might call Sharpe(8) using a figure of 8% as the risk-free rate. You could vary that number and see how it affects future returns.

No comment on the results I posted? I'd like to hear what you think about how this test turned out. Is it what you expected? What conclusions would you draw from it, if any?

Print the post Back To Top
Author: emintz Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204117 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/20/2007 2:45 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 1
No comment on the results I posted? I'd like to hear what you think about how this test turned out. Is it what you expected? What conclusions would you draw from it, if any?

I'm on the road and haven't commented because of that.

My initial comment is to ask what is meant by the comment that is labeled "Look-back period". In the paragraph above the table you refer to the granularity of the data by that's not what I normally think "look-back period" means. Does this mean that you are using only single-start dates per period, or that you are only looking back a limited time for some calculation?

My own results, using a much more limited data set, find that as the MAR was increased, you get higher CAGR, higher GSD, and lower Sharpe, but the changes were much more dramatic than what you saw... probably because of my inclusion of simulated bond returns - with low MAR, a high percentage of the port is in bonds.

I guess I need a better understanding of what that look-back period column really means. If I had to guess, I'd think it just meant granularity of the data used and that the results (other than daily) are averages of the rolling periodic returns?

Eric

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204129 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/20/2007 6:06 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Eric asked:
I guess I need a better understanding of what that look-back period column really means. If I had to guess, I'd think it just meant granularity of the data used and that the results (other than daily) are averages of the rolling periodic returns?

Yes, that is right. There are nine years of data in all cases, but the granularity is changed from Annual to Daily. It illustrates well the difference that can make.

Print the post Back To Top
Author: emintz Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204237 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/23/2007 12:31 PM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Z,

What about the calculation of the Sharpe of the resulting optimization? Is this the Sharpe using the monthly granularity? Do you think it makes a difference if you use daily or annual? For example, does optimization using the daily values still produce worse results if you calculate the Sharpe using daily data? Or is annual granularity better at predicting annual sharpe?

Eric

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204264 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/24/2007 1:03 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 7
Eric asked:
What about the calculation of the Sharpe of the resulting optimization? Is this the Sharpe using the monthly granularity?

No, all that I have posted to date uses daily granularity.

Do you think it makes a difference if you use daily or annual? For example, does optimization using the daily values still produce worse results if you calculate the Sharpe using daily data? Or is annual granularity better at predicting annual sharpe?

Let me share the results of some tests I did earlier this year. Unfortunately, this means that some of the methods I'm using now are not included, and some of the measures as well are not in this test, most importantly, it does not include Sharpe/GSD.

The period tested is from 1/1/1986 to 2/14/2007, so it is three years farther back in time, which does make a big difference. These results are based on holding five screens of ranks 1-4. I show the measures in both ascending and descending sort, whereas in previous tests I was only using a descending sort. As you can see, sometimes the measure works a whole lot better in ascending sort.
        Based On         Sort  Daily   Weekly  Monthly  Yearly
CAGR/GSD DESC 37.65% 37.43% 33.98% 40.37%
Sharpe DESC 37.23% 37.02% 36.90% 41.00%
Downside Deviation ASC 25.21% 27.55% 26.75% 38.57%
Treynor DESC 31.00% 37.51% 39.26% 45.81%
Beta ASC 29.09% 34.83% 35.06% 38.68%
Sortino DESC 35.47% 35.41% 32.49% 37.51%
CAGR/UPI ASC 29.44% 28.70% 28.81% 35.44%
GSD ASC 23.28% 24.31% 21.21% 29.79%
Upside Potential Ratio DESC 35.73% 33.26% 30.55% 37.51%
CAGR/SF DESC 32.36% 31.13% 32.69% 39.76%
Ulcer Index ASC 25.40% 26.22% 27.95% 36.18%
Sleep Ratio ASC 25.67% 26.03% 28.28% 36.18%
CAGR/UI DESC 31.69% 32.03% 33.45% 39.76%
Upside Potential ASC 21.00% 21.69% 21.91% 30.68%
Ulcer Performance Index DESC 30.62% 32.48% 31.75% 38.76%
Jensen ASC 31.66% 29.81% 29.95% 29.52%
Correlation DESC 27.82% 28.20% 29.84% 26.23%
Alpha DESC 34.26% 35.17% 35.39% 38.44%
Alpha ASC 28.91% 32.01% 34.16% 32.88%
Upside Potential Ratio ASC 29.61% 30.08% 30.09% 32.70%
Correlation ASC 33.69% 33.69% 34.19% 38.77%
GSD Ratio ASC 33.87% 32.55% 38.13% 27.60%
Ulcer Performance Index ASC 30.22% 30.97% 30.01% 29.03%
Jensen DESC 32.30% 32.18% 33.46% 38.44%
Sortino ASC 31.32% 29.64% 28.45% 31.22%
GSD Ratio DESC 23.30% 21.78% 22.04% 41.57%
CAGR/SF ASC 29.53% 30.60% 28.70% 27.50%
CAGR/UI ASC 30.04% 30.04% 28.39% 27.71%
CAGR/GSD ASC 27.01% 26.59% 28.22% 24.85%
Sharpe ASC 25.67% 26.56% 25.56% 26.40%
Treynor ASC 31.10% 32.27% 31.24% 32.23%
Upside Potential DESC 35.83% 33.73% 33.23% 28.81%
Beta DESC 31.70% 34.02% 33.71% 34.84%
Sleep Ratio DESC 32.51% 31.17% 32.46% 26.15%
CAGR/UPI DESC 32.52% 31.14% 28.61% 28.33%
GSD DESC 26.60% 27.22% 27.63% 26.18%
Downside Deviation DESC 30.41% 31.17% 33.02% 28.80%
Ulcer Index DESC 30.39% 28.84% 30.60% 24.74%


Based On Sort Daily Weekly Monthly Yearly
CAGR/GSD DESC 1.54 1.56 1.41 1.34
Sharpe DESC 1.48 1.47 1.39 1.45
Downside Deviation ASC 1.38 1.53 1.45 1.14
Treynor DESC 1.10 1.48 1.48 1.37
Beta ASC 1.14 1.39 1.53 1.20
Sortino DESC 1.43 1.45 1.22 1.12
CAGR/UPI ASC 1.37 1.32 1.32 1.16
GSD ASC 1.28 1.41 1.20 1.27
Upside Potential Ratio DESC 1.45 1.38 1.14 1.12
CAGR/SF DESC 1.30 1.23 1.31 1.18
Ulcer Index ASC 1.30 1.31 1.34 1.06
Sleep Ratio ASC 1.27 1.29 1.39 1.06
CAGR/UI DESC 1.26 1.22 1.30 1.18
Upside Potential ASC 1.20 1.23 1.17 1.28
Ulcer Performance Index DESC 1.21 1.23 1.24 1.11
Jensen ASC 1.16 1.09 1.10 1.08
Correlation DESC 1.07 1.07 1.13 1.04
Alpha DESC 0.99 1.01 1.03 1.10
Alpha ASC 1.02 1.04 1.08 0.98
Upside Potential Ratio ASC 1.06 1.01 1.03 0.98
Correlation ASC 0.96 0.96 0.98 1.11
GSD Ratio ASC 1.02 1.02 1.23 0.70
Ulcer Performance Index ASC 1.00 1.02 1.00 0.89
Jensen DESC 0.93 0.92 0.97 1.08
Sortino ASC 1.00 0.98 0.95 0.95
GSD Ratio DESC 0.86 0.85 0.79 1.29
CAGR/SF ASC 0.98 1.00 0.96 0.85
CAGR/UI ASC 0.99 0.99 0.94 0.86
CAGR/GSD ASC 0.95 0.93 0.98 0.89
Sharpe ASC 0.91 0.93 0.90 0.94
Treynor ASC 0.86 0.89 0.89 1.02
Upside Potential DESC 0.90 0.88 0.87 0.84
Beta DESC 0.82 0.86 0.85 0.89
Sleep Ratio DESC 0.90 0.87 0.95 0.64
CAGR/UPI DESC 0.88 0.84 0.85 0.70
GSD DESC 0.79 0.78 0.84 0.81
Downside Deviation DESC 0.81 0.83 0.85 0.71
Ulcer Index DESC 0.85 0.81 0.89 0.61


Based On Sort Daily Weekly Monthly Yearly
CAGR/GSD DESC 20.50 20.06 20.37 26.77
Sharpe DESC 21.34 21.32 22.82 24.60
Downside Deviation ASC 14.28 14.21 14.58 31.88
Treynor DESC 24.87 21.65 22.66 30.42
Beta ASC 21.86 20.62 18.95 29.65
Sortino DESC 21.06 20.63 23.11 31.56
CAGR/UPI ASC 17.71 17.92 18.01 27.72
GSD ASC 14.08 13.38 13.43 19.79
Upside Potential Ratio DESC 20.79 20.25 23.49 31.56
CAGR/SF DESC 21.23 21.64 21.14 31.21
Ulcer Index ASC 15.68 16.08 16.99 32.60
Sleep Ratio ASC 16.17 16.18 16.46 32.60
CAGR/UI DESC 21.56 22.45 21.97 31.21
Upside Potential ASC 13.31 13.52 14.49 20.15
Ulcer Performance Index DESC 21.63 22.70 21.89 33.13
Jensen ASC 23.40 23.47 23.64 23.58
Correlation DESC 22.60 22.97 23.01 21.46
Alpha DESC 33.63 33.66 33.24 33.50
Alpha ASC 25.28 27.64 28.82 31.77
Upside Potential Ratio ASC 24.13 26.78 26.02 28.91
Correlation ASC 34.19 34.10 33.71 33.05
GSD Ratio ASC 31.80 29.78 28.07 31.94
Ulcer Performance Index ASC 27.50 27.75 27.16 28.08
Jensen DESC 34.09 34.38 33.69 34.70
Sortino ASC 28.83 27.52 27.15 28.33
GSD Ratio DESC 23.81 21.77 24.61 29.31
CAGR/SF ASC 27.42 27.89 27.31 27.19
CAGR/UI ASC 27.92 27.92 27.45 27.14
CAGR/GSD ASC 25.62 25.81 26.06 24.21
Sharpe ASC 24.93 25.31 25.19 24.39
Treynor ASC 37.44 36.88 35.22 29.61
Upside Potential DESC 42.52 40.31 40.04 34.42
Beta DESC 42.29 43.34 43.64 42.18
Sleep Ratio DESC 36.06 36.29 33.08 32.90
CAGR/UPI DESC 37.97 38.42 33.07 31.71
GSD DESC 33.31 35.56 32.31 31.45
Downside Deviation DESC 40.01 39.55 42.01 32.94
Ulcer Index DESC 36.50 36.27 33.47 31.83

This is the same as above, but in this case the date range tested is 1/1/1999 to 2/14/2007. The reason for this is that both SIPRO and VL screens are used. There are times, therefore, that SI screens alone are chosen for a particular year.
        Based On         Sort  Daily   Weekly  Monthly  Yearly
CAGR/GSD DESC 48.89% 47.19% 48.37% 42.84%
Sharpe DESC 45.96% 47.02% 44.36% 48.50%
Downside Deviation ASC 28.57% 29.12% 29.49% 51.85%
Treynor DESC 50.27% 52.37% 44.38% 49.21%
Beta ASC 47.29% 46.21% 63.43% 54.08%
Sortino DESC 47.78% 55.25% 54.46% 50.82%
CAGR/UPI ASC 41.97% 39.40% 33.26% 53.59%
GSD ASC 25.92% 29.68% 27.82% 31.32%
Upside Potential Ratio DESC 57.66% 54.61% 52.62% 50.82%
CAGR/SF DESC 40.35% 45.65% 48.81% 57.49%
Ulcer Index ASC 37.67% 34.54% 36.66% 37.87%
Sleep Ratio ASC 33.84% 34.15% 39.46% 37.87%
CAGR/UI DESC 41.62% 48.46% 48.66% 57.49%
Upside Potential ASC 27.27% 29.81% 26.92% 30.66%
Ulcer Performance Index DESC 46.78% 46.40% 48.66% 58.33%
Jensen ASC 35.11% 34.20% 32.07% 36.97%
Correlation DESC 33.76% 34.21% 30.33% 30.10%
Alpha DESC 49.08% 49.54% 49.39% 50.75%
Alpha ASC 34.53% 34.12% 32.97% 39.44%
Upside Potential Ratio ASC 26.60% 32.81% 33.89% 33.07%
Correlation ASC 37.17% 37.17% 37.16% 36.05%
GSD Ratio ASC 37.28% 32.28% 35.94% 40.89%
Ulcer Performance Index ASC 34.69% 33.01% 38.39% 29.50%
Jensen DESC 47.39% 49.67% 47.53% 47.75%
Sortino ASC 29.13% 30.85% 32.65% 29.25%
GSD Ratio DESC 39.54% 44.78% 38.13% 63.06%
CAGR/SF ASC 33.58% 35.74% 36.60% 26.48%
CAGR/UI ASC 38.54% 35.16% 34.43% 26.69%
CAGR/GSD ASC 27.16% 27.25% 34.74% 24.33%
Sharpe ASC 28.02% 28.72% 26.04% 23.71%
Treynor ASC 35.31% 40.89% 47.24% 30.65%
Upside Potential DESC 47.59% 41.72% 40.06% 45.15%
Beta DESC 22.40% 33.79% 40.93% 39.33%
Sleep Ratio DESC 33.49% 34.81% 36.36% 31.44%
CAGR/UPI DESC 32.87% 31.80% 34.33% 35.07%
GSD DESC 49.96% 44.64% 34.60% 32.20%
Downside Deviation DESC 54.45% 34.49% 46.78% 38.47%
Ulcer Index DESC 25.78% 25.80% 27.15% 30.62%


Based On Sort Daily Weekly Monthly Yearly
CAGR/GSD DESC 2.18 2.07 2.01 1.51
Sharpe DESC 2.05 1.97 1.83 1.79
Downside Deviation ASC 1.69 1.77 1.54 1.63
Treynor DESC 1.71 2.13 1.87 1.71
Beta ASC 1.70 2.01 2.13 1.68
Sortino DESC 2.13 2.27 2.13 1.60
CAGR/UPI ASC 1.94 1.83 1.62 1.98
GSD ASC 1.56 1.74 1.63 1.57
Upside Potential Ratio DESC 2.41 2.37 1.96 1.60
CAGR/SF DESC 1.71 1.83 1.96 1.96
Ulcer Index ASC 1.96 1.82 1.71 1.31
Sleep Ratio ASC 1.86 1.81 1.79 1.31
CAGR/UI DESC 1.81 1.98 1.98 1.96
Upside Potential ASC 1.71 1.77 1.68 1.65
Ulcer Performance Index DESC 1.94 1.90 1.98 1.87
Jensen ASC 1.69 1.57 1.47 1.61
Correlation DESC 1.44 1.49 1.30 1.28
Alpha DESC 1.39 1.43 1.44 1.56
Alpha ASC 1.46 1.41 1.36 1.26
Upside Potential Ratio ASC 1.16 1.30 1.34 1.41
Correlation ASC 1.26 1.26 1.28 1.24
GSD Ratio ASC 1.20 1.08 1.07 1.45
Ulcer Performance Index ASC 1.40 1.35 1.45 1.27
Jensen DESC 1.36 1.43 1.39 1.48
Sortino ASC 1.16 1.23 1.30 1.24
GSD Ratio DESC 1.56 1.87 1.57 2.10
CAGR/SF ASC 1.32 1.37 1.38 1.15
CAGR/UI ASC 1.45 1.35 1.33 1.17
CAGR/GSD ASC 1.11 1.09 1.33 1.08
Sharpe ASC 1.23 1.28 1.22 1.06
Treynor ASC 1.15 1.28 1.42 1.14
Upside Potential DESC 1.27 1.15 1.09 1.40
Beta DESC 0.75 0.95 1.16 1.10
Sleep Ratio DESC 1.01 1.04 1.13 1.20
CAGR/UPI DESC 1.00 0.96 1.13 1.36
GSD DESC 1.48 1.26 1.09 1.01
Downside Deviation DESC 1.40 0.95 1.20 1.27
Ulcer Index DESC 0.82 0.82 0.92 1.17


Based On Sort Daily Weekly Monthly Yearly
CAGR/GSD DESC 19.02 19.42 20.76 26.08
Sharpe DESC 19.14 20.57 21.21 23.84
Downside Deviation ASC 14.28 13.81 16.26 29.11
Treynor DESC 26.14 20.97 20.62 25.85
Beta ASC 24.68 19.74 25.40 29.19
Sortino DESC 19.03 20.46 21.75 29.27
CAGR/UPI ASC 18.65 18.68 17.80 23.49
GSD ASC 13.98 14.40 14.43 17.23
Upside Potential Ratio DESC 19.93 19.22 23.25 29.27
CAGR/SF DESC 20.73 21.92 21.55 25.47
Ulcer Index ASC 16.32 16.17 18.65 27.24
Sleep Ratio ASC 15.47 16.08 19.07 27.24
CAGR/UI DESC 20.01 21.12 21.15 25.47
Upside Potential ASC 13.34 14.16 13.44 15.97
Ulcer Performance Index DESC 20.89 21.23 21.15 27.61
Jensen ASC 18.02 19.18 19.32 20.35
Correlation DESC 20.97 20.39 21.12 21.26
Alpha DESC 34.06 33.22 32.64 30.10
Alpha ASC 21.13 21.88 21.93 30.42
Upside Potential Ratio ASC 20.85 23.20 23.19 21.02
Correlation ASC 28.18 28.18 27.64 27.87
GSD Ratio ASC 30.22 29.31 34.31 25.75
Ulcer Performance Index ASC 22.56 22.22 24.20 21.05
Jensen DESC 33.84 33.37 33.11 30.32
Sortino ASC 23.28 23.14 23.05 21.56
GSD Ratio DESC 22.84 20.70 21.61 25.75
CAGR/SF ASC 23.47 23.93 24.47 20.81
CAGR/UI ASC 24.45 23.92 24.01 20.71
CAGR/GSD ASC 22.70 23.40 24.25 20.45
Sharpe ASC 20.65 20.17 18.96 20.23
Treynor ASC 29.95 30.92 31.61 25.67
Upside Potential DESC 37.37 37.19 38.40 30.79
Beta DESC 31.55 38.46 35.64 37.00
Sleep Ratio DESC 34.34 34.40 32.10 24.27
CAGR/UPI DESC 34.08 34.90 30.07 23.33
GSD DESC 31.68 34.92 31.47 32.61
Downside Deviation DESC 38.21 39.62 40.19 29.05
Ulcer Index DESC 33.52 33.21 29.64 24.20

So in answer to your questions regarding the Sharpe as the basis for screen selection, based on these tests alone, it is optimal to use yearly granularity for the highest CAGR, daily granularity for the highest Sharpe, and daily/weekly for the lowest GSD. This is for the VL only test. When it comes to the test of VL-SI, the highest CAGR is obtained with yearly again, and daily data gets the best Sharpe and lowest GSD. When it comes to Sharpe it is optimal to use daily granularity, but keep in mind, that is not true for other measures.

Take note of the highest CAGR measures:
Sharpe DESC Yearly at 41.00%
Treynor DESC Yearly at 45.81%
GSD Ratio DESC Yearly at 41.57%

The highest Sharpe measures:
CAGR/GSD DESC Daily and Weekly at 1.54 / 1.56
Downside Deviation ASC Weekly at 1.53
Beta ASC Monthly at 1.53

The lowest GSD measures:
Upside Potential ASC Daily at 13.31
GSD ASC Weekly and Monthly at 13.38 / 13.43

When it comes to the VL-SIPRO universes combined from 1999:

Take note of the highest CAGR measures:
Beta ASC Monthly at 63.43%
GSD Ratio DESC Yearly at 63.06%
UPI DESC Yearly at 58.33%

The highest Sharpe measures:
Sortino DESC Weekly at 2.27
UPR DESC Daily at 2.41
UPR DESC Weekly at 2.37

The lowest GSD measures:
Upside Potential ASC Daily and Monthly at 13.34 / 13.44
Downside Deviation ASC Weekly at 13.81

So it appears that GSD has been replaced by other measures as the best predictors of future low GSD.

Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
Author: emintz Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204270 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/24/2007 7:26 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
What about the calculation of the Sharpe of the resulting optimization? Is this the Sharpe using the monthly granularity?

No, all that I have posted to date uses daily granularity.


Maybe it is just my own denseness, but I'm not clear what the columns represent in your data. Your daily/weekly etc. columns: is this the granularity of all the calculations, or the one on which you are optimizing, or the resulting measure after optimization?

My question really is this: if there are significant differences in the result of the optimization, using daily Sharpe as the measure, regardless of whether you are optimizing on Sharpe, GSD, or anything else: then might not there also be differences depending on whether you rank the optimization by final Sharpe based on annual instead of daily data?

You may have already explained this with your data, but I'm not getting it.

Eric

Print the post Back To Top
Author: Zeelotes Big red star, 1000 posts Top Favorite Fools Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 204271 of 250240
Subject: Re: The Best Measure for the Best Blend Date: 11/24/2007 7:39 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 0
Eric asked:
Maybe it is just my own denseness, but I'm not clear what the columns represent in your data. Your daily/weekly etc. columns: is this the granularity of all the calculations, or the one on which you are optimizing, or the resulting measure after optimization?

Right now almost everyone on this board has one option for optimizing blends and that is using Jamie's backtester which outputs monthly granularity. Of course, I have daily data, so I can calculate off of daily, weekly, monthly and yearly, or anything else for that matter. In the table you are seeing above, I've shown the differences in the results from using these various granularity levels.

My question really is this: if there are significant differences in the result of the optimization, using daily Sharpe as the measure, regardless of whether you are optimizing on Sharpe, GSD, or anything else: then might not there also be differences depending on whether you rank the optimization by final Sharpe based on annual instead of daily data?

Yes, there most certainly are differences as the tables above show. It can make a huge difference. Of course, the problem is that the vast majority do not have any other option besides monthly or yearly data. They can't get ahold of weekly or daily, so in some measure, although I find daily to be optimal, that doesn't help too many. Of course, if you can get the daily data from Robbie's backtester, than I'd guess that would resolve this problem.

Are you clear now, or only as clear as mud?

Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post Back To Top
UnThreaded | Threaded | Whole Thread (34) | Ignore Thread Prev Thread | Next Thread
Advertisement