Backtesting Heikin-Ashi Candles and EMA in Excel

Weekly HA and EMA. Sorry, should have labeled. I sent the daily data as an fyi. Focus has been on weekly.

1 Like

Below are the trades for TQQQ and 21wEMA marked up on weekly chart for period 2023 to now - did very good during this period (but this was a bullish 2 years for TQQQ - I will do 2022 next to see how it did during a bearish period

1 Like

For 2022 bearish period, 21wEMA was able to stay out for most of the year with minimal loss - It looks like using stochRSI can provide better result than 21wEMA

1 Like

Excellent result for 21wEMA on TQQQ years 2020 and 2021:

2 Likes

Two thoughts. First of all, one perspective is to use “even” increments of time per day for looking at intraday data. There is 6 1/2 hours (390 minutes) in a trading day so 2 hours doesn’t divide it evenly. Stockcharts already uses both 2 hours and 130 minutes. Don’t know if it would change anything, just a thought. I’d run excel backtesting, but I don’t have access (free access that is) to 2 hourly or 130 minute data to run it. Have you ever looked at such?

Similarly, I have previously been exposed to use of 13/30 2 hour SMA as a signal. I only grossly looked at it, but it looks pretty similar to your 50 EMA cross over. Doesn’t really matter, it’s all looking at defining a true trend and reacting to it.

Wish I had intraday data to play with!

Lakedog

Do you mind sharing your specific criteria for StochRSI trades, please. There are three key levels, 0.2, 0.5 and 0.8. The sequence of crosses is important. I have been working on a specific Excel backtest, but it’s tough trying to be sure it’s the right sequence. Meaning it was a cross over 0.2 then a 0.5 cross.

Also, are you marking the actual graph crosses on the EMA when you present the data, or using the Excel dates. Just curious.

Thanks, appreciate the feedback,

Lakedog

For the trades marked on the chart, I used the dates and % gain or loss from your excel.
For stochRSI, my observation was on when it crosses above 0.5 for buy and crosses below for sell

So, evaluating single simple crosses is easy. I took a look at 0.5 crosses for Stochastic RSI (10), which is what you stated in your very initial post and got this:

This is NOT verified, an initial run**

But it didn’t seem to match what you had, and then I realized you were using a StochRSI (9). Which do you prefer? 10 or 9 or standard 14? I’ll have to create the correct columns to do StochRSI(9) and rerun. Just checking, trying to support your graphs.

When I have run such before, it seems that it is important to look at sequences of crosses and mix and match; such as a recovery from less than 0.2, now crossing 0.5 as a “Buy” followed by a drop below 0.8 as a “Sell.” That’s just an example. Have you tried any of those?

Soooo, so much to try and so little time!

Lakedog

For weekly I use stochRSI(9) - did looked at “buy when xover 0.2 from below” and “sell when xover 0.8 from above”, but this causes many whipsaws