Leveraged-3X-ETF-simulated-historical-data-possible

I don't know of a source, but I'd also be interested in getting my hands on one! Perhaps we can reverse engineer TQQQ and simulate it going back in history?

Thats my goal glitch, I read some articles and tried it out when I was using realtest, but I couldn't get it to work well.

I've seen some people do it for Portfolio Visualizer over on the bogleheads forum, but they only calculated Daily change % and not open/close prices.

It would be awesome to see how these funds would have performed at least through the 2008 crash if not earlier.

I’ve also wondered if the very existence of these funds has changed the market behavior dynamic. In 2008 it wasn’t quite as easy to go short for the average joe trader. Now anyone can buy SQQQ just like it was an ordinary stock.

Not anyone -
If you live in Europe, you cannot buy U.S. ETFs.
(Not even I can - and I'm an American with U.S. accounts living in Europe.)

I was looking at trying to do this with the One Percent strategy since it trades on daily data (I can't find any source with less than daily timeframe before 2009ish). My thought is to use QQQ as a proxy with trade 3x margin, and change the entry/exit percentages to reflect the smaller fluctuations, but when I set the Margin Factor to 3 doesn't change the results of the run vs. a margin of 1.

Any ideas?

Changing the margin factor just allows the backtest to use more margin.

If you don't increase the position size then you won't see any impact.

Maybe triple the position size as well?

Changing the position size increases the $$ return but doesn't change the % return.

What I'm hoping to see is that the backtest will incorporate the 3x margin (i.e. add $2 for each $1 in the position size) for each trade. I'm not seeing that, but I could be missing a setting or I'm mis-interpreting how the margin factor works.

I can't tell what you're looking at but the % return of each trade is not affected by sizing.
For long trades, it's always just 100 x (SellPrice / BuyPrice - 1);

But if the $$ return increases, then Profit % and APR increases, necessarily.

It does change the % return.

Here's proof, a simple Strategy that places and exits one trade.

CODE:

        //execute the strategy rules here, this is executed once for each bar in the backtest history
        public override void Execute(BarHistory bars, int idx)
        {
         if (idx == bars.Count - 20)
            PlaceTrade(bars, TransactionType.Buy, OrderType.Market);
         if (idx == bars.Count - 2)
            PlaceTrade(bars, TransactionType.Sell, OrderType.Market);
      }

If I run it on SPY with 100% of equity position sizing, Margin 1, I get profit of 2163.10 and profit % of 2.16%.

If I change the position size to 300% of equity and Margin 3, I get a profit of 5358.49 and profit % of 5.36%.

Ah I see, I need to change both the margin factor and the percent of equity. That works!

Thanks.

You didn’t change your position size. It’s 100% of equity in each backtest. You need to change the second backtest to 300% of equity.

Thanks, Glitch, I just realized that and edited my previous entry.

Have a great weekend, thanks again for the help!