August 9, 2012
Aug 9, 2012: Spreadsheet results part 2

Noteworthy: anyone who looks at the spreadsheet now will be able to see the formulas I used

I originally was going to tag this onto the end of yesterday’s post as bonus for reading the whole thing because 1) the post was very long and 2) this post is very very interesting.

Anyone who checked out the spreadsheet would have noticed that there were some additional columns that I didn’t talk about, namely PQRST and some additional statistics. I’ll go over them now:

P/Q ITT buy/sell triggers: I saw an idea on the TT thread over at babypips which was interesting; someone suggested the idea of aninversetriple threat system. That is, use the buy signals as sell signals, and vice versa. Interesting.

RST are then repeats of the same information: R finds profit if you make the call and hold until the end of the day, S finds max profit if you’re a mind reader, T finds the rounded down 25.

—Technical side note: To find these numbers, I did the following. For R: If the Daily low is lower than my buy trigger, (or if the daily low is lower than yesterday’s low -1) then I buy, and hold until the close. Again, this assumes that 1 and only 1 trigger is hit. Along this logic, it assumes that if a buy trigger does not occur, a sell trigger does.To find S, I ran a calculation that states if the Daily Low is is lower than the buy trigger (again, now the lower bound on this new calculation), Then I subtract the buy trigger from the daily high.—

The shocking news? If you move over to column “Z” it will be noted that this actually performs better than the TT system. Wat? The daybreak system performs better this way as well. Wonder why? Think it over.