Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Wed, 01 May 2024 17:18:06 +0000
[Programming Help] - Spreadsheet Trading w/
View Count: 527
| [2020-07-13 12:11:56] |
| User917140 - Posts: 7 |
|
I'm using Spreadsheet Trading. In cell J28 I've entered the following formula: =AND(J8=0,OR(FRACTIME(J41)<TIMEVALUE("14:00:00"),FRACTIME(J41)>TIMEVALUE("21:00:00"))) However as soon as the allowed timeframe starts (14:00) and my entry conditions are met, the system does not buy/cell and waits for the next signal. Can I change this particular behavior? |
| [2020-07-13 14:55:21] |
| Sawtooth - Posts: 3987 |
|
That formula in J28 disables autotrading outside of the 14:00 to 21:00 window. J28 would show 0 from 14:00 to 21:00. BTW, It won't work for scaling in, or reversals. If your entry signals are ignored, and are from flat, something else is disallowing the entry. Check the Trade Service Log for the reason why. |
| [2020-07-13 16:53:46] |
| User917140 - Posts: 7 |
|
I back tested the spreadsheet trading study. As soon as it is 14:00, J28 show 0 and Buy Entry cell shows 1. In my opinion there is no reason why the system waits for a new signal. |
| [2020-07-14 00:12:57] |
| Sawtooth - Posts: 3987 |
|
If K3 goes TRUE before J28 goes FALSE, you will miss the entry because K3 didn't transition from FALSE to TRUE when J28 was FALSE.
|
| [2020-07-14 06:49:59] |
| User917140 - Posts: 7 |
|
Yes. That's usually the case. Is there a way to bypass this behavior?
|
| [2020-07-14 14:18:08] |
| Sawtooth - Posts: 3987 |
|
Is there a way to bypass this behavior?
You could set 'Reset Condition On New Bar' to Yes.If that doesn't work, or it causes other issues, you might need to find a workaround. |
To post a message in this thread, you need to log in with your Sierra Chart account: