Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 23 Apr 2024 10:48:04 +0000
Spreadsheet System for trading: can it be used for alert only?
View Count: 783
| [2014-12-10 20:53:56] |
| BataviaTrader - Posts: 63 |
|
Can I use the Spreadsheet System for Trading study also for just creating a trading signal to be emailed to me? So without trading execution? If so, could you explain how? Thank you for your support. BT |
| [2014-12-10 21:13:36] |
| Sawtooth - Posts: 3976 |
|
Yes, you can do this, but I would be sure you also do the following: 1) Don't put any formulas in columns K,L,M,N. 2) Put =TRUE in cell J28. 3) Set "Send Orders To Trade Service' to No. This assumes you need to use this study because it has outputs the other spreadsheet studies don't. If your formulas do not require these additional outputs, you could use the Spreadsheet System/Alert study. Date Time Of Last Edit: 2014-12-10 21:19:58
|
| [2014-12-10 21:39:49] |
| BataviaTrader - Posts: 63 |
|
2+3 make sense. How to trigger a signal if K-L-M-N should be left empty? In which cell do I put let's say =AND(AE3>AB3,E3>B3,AT3>AU3,E3>AI3,E3>AJ3) instead ? |
| [2014-12-11 00:05:54] |
| Sawtooth - Posts: 3976 |
|
With 2&3, it's probably not necessary, buy I would leave K,L,M,N empty only as an extra precaution. You can use your formula in any Formula Column O-U, then set the Alert for that column in the Spreadsheet Study settings. If you also want an arrow, use this formula, e.g. a long entry: =IF(AND(AE3>AB3,E3>B3,AT3>AU3,E3>AI3,E3>AJ3),D3,0) then set the Draw Style for that column subgraph to Arrow Up. A non-zero value will also trigger an alert. |
| [2014-12-11 04:41:50] |
| |
|
This can be done but you just need to make sure that Trade >> Trade Simulation Mode is enabled.
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 |
| [2014-12-11 21:42:04] |
| BataviaTrader - Posts: 63 |
|
I now finally understand where all those empty columns are for. Thanks a stack and I will try your suggestion!
|
To post a message in this thread, you need to log in with your Sierra Chart account: