Support Board
Date/Time: Wed, 27 Nov 2024 08:41:30 +0000
Post From: Exploring the Reverse Function In Spreadsheet Trading
| [2014-07-30 18:30:44] |
| infpz - Posts: 826 |
|
I have tried to take a different approach. Go Short if: =AND(J8>-1,E3<AA3) (position is not short, and last price is < moving average) Go Long if: =AND(J8<1,E3>AA3) (position is not long, and last price is > moving average) Allow reversals: Yes The problem is, this immediately fires a trade, since we don't wait for a crossover. After some inquiry I found out my main issue is that my "definition" of a crossover is not the same as the chart's definition, and that is what is causing the signal to not fire off twice in one bar. I would like to turn the auto trader on, wait for the last price (E3) to cross the MA (AA3) and then abide by the critera above. With the above code, the result is true immediately, so I get a trade without the first crossover. I think I am almost there but just missing a piece. Thank you |