First of all, thank you to everyone who has contributed to this thread. I think we really have something of value here, and I hope those who are lurking are also finding some interesting ideas. If you have questions, don't be afraid to speak up.
Well, since Mike let the cat out of the bag lol, let's talk a bit about volatility. There are many ways to measure and define volatility. Maybe the most common in publicly available systems is to look at average true range... you simply take the past 20 days' true range and average them to arrive at the number.
This is an imperfect measure (all measures of volatility are imperfect in some way) because it does not look at the close to close change. Another way to measure volatility would be to average the absolute values of the closing changes, either differenced or percentages. You see right away that volatility measures usually either look at intraday range or close to close, so be aware that this is one limitation of the common practice.
In the academic literature, standard deviation of returns is used as a stand in for volatility. This is probably better than the two measures I listed first, but it raises some interesting questions. Is uncertainty equivalent to risk? Should we account for asymmetrical risk? Lots of questions, no perfect answers.
It might interest you to know that the additional filters I was going to apply to this were volatility based also. You can construct a reasonable proxy by taking one of the measures I listed above and calculating it over a 1-2 week timeframe, and then calculating it again over a 6-12 month timeframe. The ratio of those two measures will tell you if the market is trading at a premium to its long term vola or a discount. While not a standalone trading system can this be a useful addition to our system? let's see.
Going back to the spreadsheet I posted, the average return was 45.14 bp (basis points) with a stdev of 463.6. I collected (but did not post in the original sheet) a volatility measure for each trade at the time of inception. Does this filter have predictive value for the returns? A quick way to answer this is to do a simple linear regression:
Source | SS df MS Number of obs = 1075
-------------+------------------------------ F( 1, 1073) = 12.09
Model | 2571733.96 1 2571733.96 Prob > F = 0.0005
Residual | 228227966 1073 212700.807 R-squared = 0.0111
-------------+------------------------------ Adj R-squared = 0.0102
Total | 230799700 1074 214897.3 Root MSE = 461.19
------------------------------------------------------------------------------
return | Coef. Std. Err. t P>|t| [95% Conf. Interval]
-------------+----------------------------------------------------------------
volaratio | 125.7746 36.17133 3.48 0.001 54.80004 196.7492
_cons | -67.19465 35.2366 -1.91 0.057 -136.3351 1.94581
------------------------------------------------------------------------------
(Quick and dirty here, but an investigation like this is part of our process here so Im showing it.) The key elements here are the sign of the coefficient (+ which means higher vola = higher returns) and the t stat of 3.48, which is probably significant. (Don't get too caught up on R-squared, etc... this is not a complete model just a first foray into looking at the relationship.)
What happens if we only take trades when the volatility is greater than the long term for that market? Adding this filter drops the number of trades to 357 from 1075, increases the average trade to 102.27 bp(!) with a standard dev of 525.3. The median trade also raises to 143 from 106. Biggest and smallest trades are no affected.
Question: does this look like a worthwhile addition to the system? Thoughts??
And yes, I know BoWo will steal... but we're using some big words so I think we're safe (like spelling words in front of the kids so they don't understand lol.)
Quote from Mike805:
Hi Talon,
I'm not going to give away my filters, but, they basically filter for vola.
So, to reproduce something comparable to the below result, do the following:
1. Devise a method to trade when volatility is above a certain threshold for the specific product.
Where is Bowo BTW? Be careful, don't give away too much - he'll take this system and then try to sell it on C2 for 5mil, or $200/month...
LOL...
Mike