No. of Recommendations: 5
Sure. Mine is Excel 2003, seemed to upload to google sheets just fine.
Google: QQQ-daily-for-TQQQ-tracking - timingAh, I did make one mistake in my post. Since TQQQ inception there have been 15 trades, not 20. 2/11/2010 - 11/6/2025
4/2/09 Buy
8/31/10 Sell
9/20/10 Buy
12/1/11 Sell
1/18/12 Buy
8/9/12 Sell
8/16/12 Buy
1/31/13 Sell
3/5/13 Buy
4/12/16 Sell
7/12/16 Buy
1/9/19 Sell
3/12/19 Buy
3/31/22 Sell
1/27/23 Buy
TQQQ-qqq-timing tab computes the timing. Rows 91-122 have the signals, which are computed in columns E, F, and G. Col H has the
trades.
Col E shows if the QQQ close is the highest in the last 90 days.
Col F is the number of those that occurred in the last 90 days.
If that is zero, it's the "OUT" signal.
TQQQ tab has the B&H and Timed daily returns.
Tab QQQ-daily-3xO-O is a trial to simulate TQQQ before its inception. The best fit is actual 2.76X instead of 3X.
