Support Board
Date/Time: Tue, 22 Apr 2025 05:16:50 +0000
Spreadsheet System for Trading
View Count: 267
| [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: 39395 |
|
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: 39395 |
|
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: 4209 |
|
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: 3 |
|
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 |
| [2025-02-03 17:23:27] |
| John - SC Support - Posts: 39395 |
|
You would have to overlay information from one chart to the other using the "Study/Price Overlay" study. Refer to the following: Study/Price Overlay Study We do not know what exactly you are doing, so we can not say what the best option is for overlaying, but offhand we would say that you would overlay the 2 minute chart's spreadsheet study to the 15 minute chart, so you can then just reference the subgraph that has the condition you have set. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-02-05 21:34:05] |
| User173435 - Posts: 3 |
|
Sorry my French is better Great study but there is no Delta in the subgraph Exemple I I want the 1minutes chart to execute with +1000 Delta and if the swing high of the 15 minutes chart is breaking Combine 2 chart studies for execution |
| [2025-02-06 15:07:12] |
| John - SC Support - Posts: 39395 |
|
How are you getting the Delta on the 1 minute chart?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-02-06 21:01:40] |
| User173435 - Posts: 3 |
|
Using the study numbers of bar calculated values
|
| [2025-02-06 21:25:37] |
| John - SC Support - Posts: 39395 |
|
In this case, since you can not overlay the "Numbers Bars Calculated Values" study, you would need to create the condition you want in the 1 minute chart first and then overlay that to the 15 minute chart. The simplest way to do this is to use the "Spreadsheet Formula" study, which, despite its name, uses the Alert syntax. Therefore, on the 1 minute chart, you would add the "Spreadsheet Formula" study and enter a formula like the following: =ID1.SG1 > 1000 Where ID1 is the "Numbers Bars Calculated Values" study ID and SG1 is the first subgraph of the Numbers Bars Calculated Values. This will then give you a value of 1 if the condition is true or a value of 0 if the condition is false. Then use the "Study/Price Overlay" to overlay the "Spreadsheet Formula" to the 15 minute chart and reference the "Study/Price Overlay" in your spreadsheet. Refer to the following: Spreadsheet Formula Study/Price Overlay Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: