Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 19 May 2024 15:52:16 +0000
[Programming Help] - formula for MACD crossover system in spreadsheet
View Count: 2566
| [2017-02-08 12:40:48] |
| thr33pedals - Posts: 2 |
|
hi, i have been trying to use the MACD CROSSOVER SYSTEM in the Sierra Chart studies in automated spreadsheet trading. have tried K=ID5.SG1@3>0 and L=ID5.SG2@4>0 and M=ID5.SG2@4>0 for buy trades (entry+exit) + reversal(sell) entry (ID5 being the MACD CROSSOVER SYSTEM study, and having problem with the formula with N input to make the system work correctly). so for sell trades (entry+exit) + reversal(buy) entry i would use M=ID5.SG2@3>0 and N=ID5.SG1@4>0 and K=ID5.SG1@4>0 so have problem with L input. any idea how to combine these into one spreadsheet? i tried K=(ID5.SG1@3:ID5.SG1@4,">0") and M=(ID5.SG2@3:ID5.SG2@4,">0") but then the cells would return with #VALUE! many thanks. Date Time Of Last Edit: 2017-02-08 12:46:03
|
| [2017-02-09 17:34:35] |
| |
|
The formula does not make sense: =(ID5.SG1@3:ID5.SG1@4,">0") What are you trying to do here? 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 Date Time Of Last Edit: 2017-02-09 17:38:45
|
| [2017-02-09 17:38:28] |
| |
|
We made a mistake in the prior posting. It has been corrected. 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 |
| [2017-02-09 17:59:26] |
| thr33pedals - Posts: 2 |
|
sorry i am new at this.. basically i was combining what i have read and trying to make it work.. sorry the formula did not make sense. basically i was trying to automate the study MACD CROSSOVER SYSTEM to make it an automated strategy, whereby it buys at the blue arrow and sells at the yellow arrow.. see image attached http://www.sierrachart.com/image.php?Image=1486663003767.png |
| [2017-02-09 18:41:01] |
| |
|
Assuming the MACD Crossover System study has a study ID of 1 these are the formulas to use: Cell K: =ID1.SG1@3>0 Cell M: =ID1.SG2@3>0 For exiting the position you can use the Support Reversals study Input: http://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#SupportReversals Or use Attached Orders to exit which is preferred: http://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#UsingManualOrAttachedOrdersExits 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: