Support Board
Date/Time: Wed, 05 Mar 2025 19:19:15 +0000
[Programming Help] - Spreadsheet Trading
View Count: 510
| [2022-01-21 20:43:59] |
| User956550 - Posts: 12 |
|
Hello, I want to automate my trading. For this I try it with spreadsheet trading. Now my question: I put all my conditions in field K3 for a buy entry; I connect all my conditions with AND; when everything is true a buy is started. That works. When one condition gets false and at the next candle it gets again true a new buy ist started. Is it possible that, for example, 4 conditions have to be true but only one is the tigger? I mean 3conditions are true and the trigger gets true a trade is started. But only the trigger starts a trade? How will I have to manage this? |
| [2022-01-21 20:51:49] |
| Sawtooth - Posts: 4179 |
|
Try this: Put each buy condition in O3, P3, Q3, R3 Then use something like this in K3: =AND(O3,P3,Q3,R4=0,R3) where R3 is the trigger condition. |
| [2022-01-21 21:02:51] |
| User956550 - Posts: 12 |
|
Ok thank you for your answer! When I do it like the way you say and O3 changes from false to true ( the other conditions have been the whole time true) no new trade will be started? |
| [2022-01-21 21:37:47] |
| Sawtooth - Posts: 4179 |
|
When I do it like the way you say and O3 changes from false to true ( the other conditions have been the whole time true) no new trade will be started?
The trigger is with the R4/R3 transition so you won't get a new signal if the others transition, unless R4/R3 also does.This example assumes your entries are at close of bar, because the comparison is with the previous bar/row. If your entries are intrabar, the comparison is still with the previous bar. This can create unexpected results, and signal arrows might disappear if the conditions didn't exist at close of bar. There is no way to compare intrabar transitions. |
| [2022-01-21 22:08:28] |
| User956550 - Posts: 12 |
|
Perfect! Thanks for your explanations! I will try it this weekend
|
To post a message in this thread, you need to log in with your Sierra Chart account: