help defining a trade rule with excel
|June 13th, 2011, 08:37 PM||#11 (permalink)|
Phoenix AZ USA
Futures Experience: Advanced
Favorite Futures: NQ YM ES
Posts: 262 since Nov 2009
Thanks: 121 given, 283 received
Since SC worksheets are in descending order, try using a match_type of -1, not FALSE.
This should give you the first crossover and not the last crossover.
Your idea of using another chart of a shorter timeframe, 1 min as you suggested, is the only way I know to get the time inside the 15 min bar. J41 updates with every price tick but I don't know any way to capture it at the moment another cell goes TRUE.
I don't think locking the state can lock a value. I've tried to do this without success. If you figure it out, I'd be interested to see your solution.
|The following user says Thank You to tomgilb for this post:|