Support Board
Date/Time: Mon, 03 Feb 2025 11:57:35 +0000
Spreadsheet System for Trading
View Count: 76
| [2025-01-29 17:47:40] |
| User956550 - Posts: 12 |
|
Hello, One short question. If I use this spreadsheet and my system would be, for example, buy if the price is over the moving average. I put in K3 B3> MA. Ok that works. But I have an entry at every new candle. But I only want an entry only at the first candle of this trading system. I have yes at signal only once per bar and no at alow multiple entries in same direction. But there are arrows on every candle. What do I wronge? |
| [2025-01-29 18:26:40] |
| John - SC Support - Posts: 37656 |
|
You will get a signal for each bar that is true, so the marker will show. But as long as you have the Input for "Allow Multiple Entries in Same Direction" set to "No", then you will not get any additional orders sent. This is the right way to handle this.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-01-29 20:11:14] |
| User956550 - Posts: 12 |
|
Ok. And is it possible to get only one signal?
|
| [2025-01-29 22:24:09] |
| John - SC Support - Posts: 37656 |
|
In order to get just one signal you need to add some kind of additional logic that would not create an additional signal. For instance, if you are opening a position on the first instance of the signal, then you could use cell J5 to see if there is a position open. Therefore, your entry formula would look like the following: =AND(B3 > MA, $J$5 = 0) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-01-30 02:38:01] |
| Sawtooth - Posts: 4164 |
|
Or try this: =CROSSFROMBELOW(B3:B4,ID1.SG1@3:ID1.SG1@4) where ID1.SG1 is the MA. |
| [2025-02-03 01:59:55] |
| User173435 - Posts: 1 |
|
I wanna combine 2 condition together to automatically execute a trade using spreadsheet system The first one is in a 15 minute chart the second a 2 minute chart is it possible? How can I refer to the other spreadsheet after I link them up The 15 mm I have =AND(E>AA,E>BD,BB>25) The 2minhtes I have =AND(AG>1000,F>5000 |
To post a message in this thread, you need to log in with your Sierra Chart account: