Support Board
Date/Time: Sun, 12 Jan 2025 11:49:57 +0000
Post From: formula for MACD crossover system in spreadsheet
| [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
|