Tuesday, August 20, 2019

Backtest platform - eDeltaPro

--Disclaimer-- I do not receive any compensation from eDeltaPro. This article is based on my personal opinion.

Want to share a very powerful option backtest platform - eDeltaPro. It can backtest almost every mechanical strategy. You can set many parameters such as profit target, stoploss, DTE, rolling, etc. Backtest is supposed to help you to understand your strategy better. In the end of the day, it is still up to your execution ability and trading psychology. If you decide to trade using a mechanical strategy, you have to keep trading it no matter what. You get what the market gives you.

https://www.edeltapro.com/

Before using a backtest platform to evaluate your strategy, you need to consider the following points:

1. Know your product. For example, SPX does not have weekly options until Oct 2005, Monday-expiring options started in Aug 15, 2016, and Wednesday-expiring options started in Feb 23, 2016. So you have much less data points in the past than it is now. The backtest result means differently in the past 3 years vs. 5 years vs. 10 years, etc.

2. I believe every backtest platform only uses EOD data so the result will be much different if you were to enter/exit your position intraday, basically strategies that involve profit target and stoploss .

3. Past result does not guarantee the future performance. Don't be obsessed or over-thinking/explaining the backtest result too much. No one knows what the market will be like in the future. It could be a completely different environment that has never happened before. Sometimes you just get lucky having a good backtest result. For example, you can choose to enter a position everyday and set up the maximum number of simultaneous open position. If you choose to trade daily with long DTE with small maximum open positions, you will skip a lot of trading days. If it is a short put strategy you might just skip the really bad down days of the year and you happen to get great result. But that does not tell you how resilient your strategy is during big selloffs.

Here is an example of Tastytrade's favorite strategy, SPY short naked put 16 delta 45 DTE manage @ 50% and 21 DTE, 12 yr, including commission (Tastyworks rate). It shows that this is a profitable strategy. But if you look at the green trace (unrealized P/L), there is a $10,000 drawdown in the end of 2018. That is where most people give up and decide to take the loss (or get margin call). This is a good example showing why it doesn't matter if you find a profitable strategy from backtest because the problem is execution. Most people will bail out during big loss days. However, this result does not guarantee that you won't see a bigger drawdown in the future. It just tells you the biggest drawdown is 13.7% with this strategy in the past 12 years.


For an ideal strategy, you should be looking for a smooth P/L curve. For example, 60 delta short strangle managed @10% looks very promising. But you do need a lot of capital to do that. The capital req. showed in the picture is the lowest starting capital. The program will fully utilize BP including the profit. One thing to note is that this strategy only gives you 300% ROC (return on capital) over 12 years and this is the maximum ROC you can get since it fully utilizes the capital. 300% ROC over 12 years I would rather just buy and hold SPY. ROC is a big thing to consider. I would argue if your strategy does not give you a better ROC than holding SPY, it is not worth the effort to execute it.


To summarize, backtest can quickly tell you if one strategy has potential or not as well as help you to understand what to expect with the strategy (like potential consecutive losses, etc). It does have limitations if you want to incorporate more complex defense strategies. I personally use it to educate myself.

7 DTE Strategy

Let's talk about 7 DTE strategy.

I shared this briefly in commenting someone's post. I'd like to share more details about what I found from backtesting 7 DTE strategy. I would like to address two points beforehand so you can understand backtest better.

Backtesting an early exit strategy (profit target and stoploss) is problematic because of intraday fluctuation and overnight gap up/down. If you only use EOD data your backtest result will be far off (which is basically the main problem for every backtest platform). The backtest platform I am using offers these two options: check execute vs open price (to include gap up/down) and check execution vs high & low (to be able to exit intraday). With these two options, the backtest result will be more reliable. One issue that is hard to verify is the daily high&low price. Since the daily high&low prices are based on actual transaction. So if a certain strike has a very low volume, the price would not be that reliable. That means the prices for low volume strikes don't move much with the stock price. I hope they can include theoretical price for high&low prices.

OK, let's see the result. The test condition is 7 DTE (+-1) SPY short 30 delta put vertical with $40 wide long leg, stopped at 100, 200, and 300% loss. The trade was entered everyday for the past 3 years. You might wonder why I only test for 3 year. It is because SPY has much less expiration to select from 2-3 years ago. You can't enter a trade everyday in older times. This is a profitable strategy for the past 3 years. However, there is a very strong psychological hurdle for this strategy as indicated. The drawdown in 2018 is too much. I would not want to see my one year worth profit go away in just several months. Imagine you trade this strategy for one year and your return is negative. How bad is that?


Interestingly, when I do 50% stoploss, the drawdown becomes much smaller. In exchange you get only 62% win rate but better ROC and total P/L. It is noted that in the worse period of time there is 15 consecutive losses (so are other stoplosses). Are you willing to stay engaged when you get more than 10 consecutive losses?

So, which is more important? Winning rate? P/L curve? or return on capital (ROC)? In my opinion, I would like to have high ROC, otherwise I can just buy SPY and leave it alone. SPY gives 34% ROC for the past 3 years and this strategy offers 81%. But you won't put just enough money to do short strategy, if you use 50% required capital the ROC becomes 41%, kind of similar to buy and hold SPY stock but you get a much smoother P/L curve using this strategy. I would like to see how this strategy performs in a recession but unfortunately there is not enough data in 2008 to test that out. Since I still have concern about high&low price data, I will trade it to figure out how reliable this backtest is.

100% win rate strategy?

100% win rate strategy? Is it possible?

According to backtest (2010-2019), if you keep selling 120 DTE (+-5) 20 delta naked strangle on SPY (5 max active positions), managed at 5% credit received, and no stoploss, you win 605 times out of 605 trades. It is no doubt a winning strategy but it is a difficult strategy to execute. For example, the drawdown circled in red (unrealized P/L) in late 2011 is a psychological stop for most traders. This is one of the "one big loss wipes out all profit" scenarios. If it happens, you might keep thinking premium selling is too risky and stop doing it. So you need to know what your risk tolerance is.

The good part of this strategy is the long DTE. It gives you more time to be right. It is noted that all losing positions happen to recover within 120 days in the test period. Will it be a trade that never recovers? Yes, might be sometimes in the future. It is just the odd of that to happen is small but not zero. One thing that is worth mentioning is that this strategy can live through volatile 2018 which is pretty impressive to me. Since naked strategy is high risk, I would make sure I have 5-10x of the required capital in my account before trading strategies like it. Again, 215% since 2010 is not so promising. You get similar ROC if you buy and hold SPY.

P.S. 1: I really want to see how this strategy does in 2008 but there is lack of data for either selected DTE or delta before 2010.

P.S. 2: If you don't limit the max active position, it still has 100% win rate (881/881) but the required capital becomes $32,438.