Tuesday, May 9, 2017

Iron Condor Results Summary

Over the last several months I have shared the results from an extensive set of backtests of SPX iron condors (IC). In all, I backtested 600,912 individual SPX IC trades entered at varying days to expiration (DTE) between January 2007 and September 2016. The prior articles can be found at the links below:

In this article, I'll review two key metrics collected from all of the backtests:
  1. Win Rate
  2. Normalized P&L Per Day

Win rate is a common metric to analyze, but P&L per day is less obvious.  P&L per day gives us a very clear view of the expected return by day for a given strategy variation. We've already seen in the prior posts how the number of days in trade (DIT) increases as we enter trades at higher days to expiration (DTE). As a very rough rule of thumb, it takes about half the DTE to collect 50% of the credit (although this changes with short strike delta!). From this normalized P&L per day value we can derive the average return per trade, as well as the average return per year.

Before we get into the results, I need to describe the format of the heat-map tables below. First, each IC wing width is presented in a separate table, starting with the 25 point wing ICs.

Next, the first column lists the strategy variation, including the exit used. This column uses the strategy description nomenclature that I used in the last several months worth of articles in the links above.

Next, there are four groups of seven columns. Each group corresponds to a different short strike delta, and each of the seven columns in the group corresponds to a different DTE starting point.


Win Rate

(click to enlarge)

It's clear that the 8 delta short strike has the highest win rates from a delta perspective.  Also, 80 DTE has the highest win rate of all of the DTE tested.  The 50% profit taking level is the winner for profit taking exits. We also see that the larger wing widths have slightly higher win rates. Let's think about each of these points:
  • Both the smaller delta and higher DTE end up making a wider "tent" for the IC, which gives the market more room to run before a loss exit is triggered.
  • Taking profits at 50% versus 75% or expiration has you out of the trade sooner...reducing the chance that the market can move against your position.
  • The larger wing width, creates a larger credit, and at 75 points approximates a naked strangle. With 75 point wings, you get the margin relief (defined risk) from the long options that you don't get with a strangle. Since the longs are so far away from the short strikes, this structure has greater theta decay than ICs with 25 and 50 point wings.

It's interesting to note that the win rate for the same short strike delta increases with increasing DTE. Recall, as DTE increases the implied volatility (IV) for the same delta option increases.  For example, an 8 delta put at 38 DTE might have an IV of 14.15% while an 8 delta put at 80 DTE might have an IV of 17.44%. Using these two examples of IV we calculate the expected one standard deviation move of the underlying in percent:
  • 0.1415  x  sqrt(38/365)  =  0.045656   (+/- 4.57%)
  • 0.1744  x  sqrt(80/365)  =  0.081648   (+/- 8.16%) 
Note: IV from TOS for each of these option chains is lower at approximately 11.5% and 12.6% respectively

Based on these expected moves, it's worth considering a couple of questions.  How does actual market movement over 40 days (half of 80 DTE) compare with the expected move?  How do the actual market moves over 19 days (half of 38 DTE) compare with those over 40 days?

Finally, I have two tables showing the top 30 and bottom 30 IC variations in terms of win rate. The top variations are dominated by higher DTE, 75 point wings, 8 delta short strikes, profit taking at 50%, and no loss exit. The bottom 30 are dominated by mid-range DTEs, 25 point wings, 20 delta short strikes, extra long put (EL) structures, with loss taking at 100% and no profit taking exit (take the trade to expiration).

(click to enlarge)


P&L Per Day
Recall from the prior articles that all of the P&L per day numbers are normalized. The P&L per day values shown in the charts below are expressed as a percentage of the max risk for that test run. Each of the different wing width ICs (25 point, 50 point, 75 point) will have a different max risk, and it is important to normalize daily returns by the associated max risk number. For example, a 25 point IC will have slightly less than $25K max risk (margin), while a 75 point IC will have slightly less than $75K max risk (margin). Since the 25 point IC will have approximately 1/3 the risk/margin, the $ returns need to be normalized by these varying max risk / margin numbers for proper strategy variation comparison.

(click to enlarge)

There are a few high level trends from these tables of normalized P&L % per day values:
  • The lowest returns occur with the EL structure.  The extra long put negatively impacts the theta decay of the structure, but this negative impact decreases (as we'd expect) as wing width increases
  • The next lowest returns occur with the DN structure. Since there are fewer call credit spreads than put credit spreads in this structure, there is lower theta decay than with the ST structure
  • The ST structure has the highest normalized P&L % per day numbers
  • From a short strike delta perspective, the lowest returns per day occur at 8 delta, and the highest returns occur in the 16 to 20 delta range
  • The 75 point wing structures have the lowest returns, and the 25 point wing structures have the highest returns
  • From a DTE perspective:
    • The DN structures' returns are highest in the 38 to 45 DTE range
    • The EL structures' returns are highest in the 73 to 80 DTE range
    • The ST structures' returns are highest in the 73 to 80 DTE range, but there is also a second high return clustering in the 38 to 45 DTE range

The return distributions related to structure and DTE, suggest that in the 38 to 45 DTE range, the market has tended to trend up or stay flat.  Hence the clustering of higher daily return numbers for the DN structure in the 38 to 45 DTE range. Additionally, the data suggest that in the 73 to 80 DTE range the market has tended to stay flat or drop. The EL structure shows higher returns in longer duration trades, indicating that the extra long put has some benefit in the 73 to 80 DTE range. 

Similar to the win rate section, I have two tables showing the top 30 and bottom 30 IC variations in terms of normalized P&L per day. The top variations are dominated by the standard (ST) structure with 25 point wings, 20 delta short strikes, profit taking at 50%, and a range of loss exits. The bottom 30 are dominated by the extra long put (EL) structure with 25 point wings, 20 delta short strikes, with no profit taking exit (take the trade to expiration).

(click to enlarge)

In the next article, we'll narrow down the list of 3024 strategy variations, to a list of strategies that look trade-able.  I'll remove the variations without profit and loss exits, and look at win rate, normalized P&L per day, largest loss, and profit factors.

Also, over the next several days I'll use Twitter to share other versions of the tables above, organized around DTE groupings instead of grouping by short strike delta..


Follow my blog by email, RSS feed or Twitter (@DTRTrading).  All options are available on the top of the right hand navigation column under the headings "Subscribe To RSS Feed", "Follow By Email", and "Twitter"

9 comments:

Unknown said...

Thank you for all your remarkable work.
Paul C.

Dave R. said...

You're welcome...I appreciate the feedback!

Dave

Scott said...

Thank you for your fantastic contributions and rigorous sharing of your work.

In your earlier work (year+ ago), you shared the results using risk adjusted return metrics, like UPI, Sortino & Sharpe. While the industry "default" standard is Sharpe, I find UPI & Sortino a better measure of a trading systems' relative drawdown experience. Most traders/investors have difficulty staying with systems with prolonged drawdowns.

While I like the formats of the information in your latest versions, it seems that the normalized % per day is a variation of a normalized CAR or CAGR, and does not capture downside risk.

Thoughts?

Dave R. said...

Thanks for your comments Scott.

This summary article is the first in a series. I expect at least two more. I have calculated Sortino ratios for each of the variations and I'll share those metrics in one of the upcoming summary articles or via Twitter.

Thanks,
Dave

Scott said...

Awesome, thanks Dave.

Unknown said...

Why is the IV of the strike used to calculate the one standard deviation move instead of the underlying IV? Thanks.

Joonas said...

Hi,

Thank you very much for sharing your interesting research Dave!

In one of your previous posts you mentioned that the (80 DTE SPX Iron Condor) Call Credit Spreads lost more often than the Put Credit Spreads.
So, between January 2007 and September 2016, would it have been better (Avg. P&L per Day, Profit Factor, Win %) to just do Put Credit Spreads instead of an Iron Condor (80 DTE, 8 Delta, ST, 300:50, Wing Width 25)?

Dave R. said...

Jason -

The proper way to calculate the expected move is to use the IV of the underlying. Out of habit, I used the IV of the strikes. I do this to get a sense of the size of a worst case move...although the market could certainly move even more. On the day I wrote this part of the article, the IVs were as follows:

SPX Close: 2389.38
SPX Underlying IV: 11.4
SPX 38 DTE Chain IV: 11.5
SPX 80 DTE Chain IV: 12.6

Now let's take a look at the expected moves for the different IV values:

38 DTE
Underlying: 0.114 x sqrt(38/365)=0.03678 (~ 88 points)
Chain: 0.115 x sqrt(38/365)=0.03710 (~ 89 points)
Strike: 0.1415 x sqrt(38/365)=0.04566 (~ 109 points)

80 DTE
Underlying: 0.114 x sqrt(80/365)=0.05337 (~ 128 points)
Chain: 0.126 x sqrt(80/365)=0.05899 (~ 141 points)
Strike: 0.1744 x sqrt(80/365)=0.08165 (~ 195 points)

As I mentioned earlier, the correct approach to calculate the expected move is to use the IV of the underlying. Out of habit, I used the strike IV in the article above, since this is how I typically gauge market movement risk in my actual IC trades.

Thanks for the question!

Dave

Dave R. said...

Joonas -

In this series, I didn't look into the performance of each side of the IC separately. This is a good point though, and I may look at this in one of the later summary articles.

Thanks,
Dave

Post a Comment