Support Board
Date/Time: Wed, 14 May 2025 09:48:31 +0000
I made my first Spreadsheet System for Trading
View Count: 1739
| [2016-03-26 12:04:39] |
| User938955 - Posts: 10 |
|
I made my first Spreadsheet System for Trading I used the same formula that I also for Color Backgroudd Based On Alert Condition Use, But the system does not work No buying and selling. What else should I change in the formula so that it works? |
| [2016-03-26 18:36:51] |
| |
|
Refer to the documentation about this here: https://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#IgnoredSignals Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-03-26 19:34:32] |
| Sawtooth - Posts: 4214 |
|
Simple Alert formulas differ slightly from those used on a spreadsheets study: Simple Alert formulas refer to the bar with a [], e.g the previous bar is ID1.SG1[-1] That formula on a spreadsheet needs to reference a row, e.g. ID1.SG1@4 http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy |
| [2016-03-28 12:25:28] |
| User938955 - Posts: 10 |
|
I still have the line reference added In column K =AND(ID16.SG1@3>ID17.SG1@3,ID16.SG1@3>ID15.SG1@3,ID16.SG1@3<ID4.SG1@3,ID3.SG4@3<ID2.SG4@3,CROSSFROMBELOW(ID5.SG1@3:ID5.SG1@3[-1],ID5.SG2@3:ID5.SG2@3[-1])) In column L = AND (ID16.SG1@3 <ID17.SG1 @ 3, CROSS FROM ABOVE (ID5.SG1@3: ID5.SG1@3 [-1], ID5.SG2 @ 3: ID5.SG2@3 [-1 ])) I have turned on the Trade simulation. I have turned on the Trading Mode and Auto Trading enabled. I tried several times to back test but it does not work. |
| [2016-03-28 14:48:13] |
| Sawtooth - Posts: 4214 |
|
The L3 formula needs to use row references without Simple Alert bar references: =AND(ID16.SG1@3<ID17.SG1@3,CROSSFROMABOVE(ID5.SG1@3:ID5.SG1@4,ID5.SG2@3:ID5.SG2@4)) |
| [2016-04-21 07:36:49] |
| User938955 - Posts: 10 |
|
I try backtesting from a spreadsheet system in simulation mode. But it shows me no results. Who can help me. I have Chart Trading Mode on. And automatic trading enable. |
| [2016-04-21 14:54:27] |
| Sawtooth - Posts: 4214 |
|
Are you using these formulas ?: K3: =AND(ID16.SG1@3>ID17.SG1@3,ID16.SG1@3>ID15.SG1@3,ID16.SG1@3<ID4.SG1@3,ID3.SG4@3<ID2.SG4@3,CROSSFROMBELOW(ID5.SG1@3:ID5.SG1@4,ID5.SG2@3:ID5.SG2@4)) L3: =AND(ID16.SG1@3<ID17.SG1@3,CROSSFROMABOVE(ID5.SG1@3:ID5.SG1@4,ID5.SG2@3:ID5.SG2@4)) |
To post a message in this thread, you need to log in with your Sierra Chart account: