Skip to content

A New DV Blog and a Cool New Tool

April 13, 2010

Please note that the DV Indicators Excel Plug-In is currently available in the store.  http://dvindicators.cssanalytics.com/indicators/dv-excel-plug-in/

I would like to introduce our first DV Indicators Blog post which will be an ongoing site dedicated to posting internal DV Indicators research and future ideas/concepts. This blog will be maintained by Enn Kuutan–  who is currently enrolled in the CMT program and is a serious student of the markets.

Cross-posted at DV Indicators by Enn Kuutan

Markets go through different phases, bulls rule one month, bears the next. There are many different strategies to navigating the markets but following the long term trend in terms of the 200dma is a favourite that is helpful in maximizing profitability. Waiting for an oversold condition to enter positions is one way of getting on board. Here we are looking at long trade entries above and below the 200dma using extremes in the DV2 oscillator, initiating on entries below 20. But what should be our exit criteria? Let’s look at the effects of time based exists, holding periods of 1-5,7,10,15 and 20 days. Hat tip to Rob Hanna of Quantifiable Edges (http://quantifiableedges.blogspot.com/) for inspiring the time based analysis and tables! To stick with what Rob typically does in his analysis, I used a fixed $10,000 bet size without reinvestment.


Interestingly enough the long trades below the 200dma outperform those above the 200dma for short holding periods, presumably because of the high volatility and compressed cycle length associated with market conditions under the 200dma/in a bear market (see https://cssanalytics.wordpress.com/2010/04/07/a-simple-adaptive-change-to-daily-follow-through-to-capture-cycle-changes/). However holding on to those entries above the 200dma leads to much higher gains per trade when holding above 7 days. The old Livermore saying “It never was my thinking that made the big money for me. It always was my sitting.” comes to mind, but only when the trend in a higher time frame is your friend.

Looking into the  risk-adjusted analysis details we see a fascinating picture emerge: as the holding period above the 200dma increases, the DVR, a measure of reward to risk which specifically is the linearity-adjusted Sharpe ratio, increases up to an optimal holding period of 10 days while below the 200dma the DVR peaks at 2 days and deteriorates rapidly. This is exactly what you would expect trading counter to the trend.

Looking at another measure of reward to risk, the Win/Loss ratio we see the same effect, although in a less pronounced fashion than with looking at the DVR.

In the next post we’ll look at the same type of time based exit analysis only with short positions, stay tuned….

6 Comments leave one →
  1. Jack permalink
    April 13, 2010 11:23 am

    Are there any plans on splitting out the Excel plugin into different versions with different features, rather than just one version with everything?

    I’m sitting here debating whether I should spend the money on a fully-loaded Lexus, when a base-model Prius was what I was really looking for.

  2. April 13, 2010 6:51 pm

    Hi David,

    Just wanted to say congratulations!

  3. Kevin Smith permalink
    April 13, 2010 8:08 pm

    David:

    The new excel plug-in functionality looks first rate. Very nice work.

    Kevin

  4. Jeff Pietsch permalink
    April 13, 2010 10:03 pm

    Hi, I think I can partially answer Jack’s question in that there will be some lower octane versions of the XL graphic based system featuring basic indicators only. However, I don’t know what DV will be pricing that at or when it will be released. Others have noted some of the systems are correlated… yes, but put combinations of them together for cross-confirmation… magic. Good work DV

  5. kostas permalink
    April 14, 2010 12:37 am

    Question to DV–min requirements are Excel 2007 with “Service pack 2.” I have Excel 2007 but how do I know if I have the Service Pack 2?!

    • Corey permalink*
      April 14, 2010 12:56 am

      Hi Kostas,

      Just go to Excel Start -> Excel Options -> Resources(Version and Service Pack (SP) are listed at the bottom) -> Check for Updates.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: