Support Board
Date/Time: Mon, 24 Feb 2025 18:05:47 +0000
[User Discussion] - Study: MACD & MACD Crossover System with added New Studies
View Count: 1120
| [2021-03-15 20:36:12] |
| PeaceFrog - Posts: 105 |
|
Hello. Thank you for taking the time to answer my question. I very much appreciate it. Into one Study, I am looking to combine the Sierra Chart "MACD" and "MACD Crossover System" studies found in "Analysis->Studies" and add five “New Studies” that reference data from those studies as follows (I've attached a pic and an excel file that hopefully helps clarify): A B C D E F G H 1 MACD New Study #1 MACD MACD New Study #2 MACD Crossover System MACD Crossover System 2 MACD MACD[-1] MA DIFF DIFF[-1] BUY SELL 3 =IF(B3<>B4,B4,IF(B3=B4,C4,0)) =IF(E3<>E4,E4,IF(E3=E4,F4,0)) 4 Con’t A I 1 New Study #3 2 =Buy or Sell 3 =IF(AND(G3=0,G4>0,H3>0,H4=0),1,IF(AND(G3>0,G4=0,H3=0,H4>0),-1,IF(AND(G3=0,G4>0,H3=0,H4=0),1,IF(AND(G3=0,G4=0,H3=0,H4>0),-1, IF(I4>0,I4+1,IF(I4<0,I4-1,0)))))) 4 Con’t A J 1 New Study #4 2 Max of DIFF for Buy or Sell 3 =IF(I3=1,E4,IF(I3=-1,E4,IF(AND(I3>1,E3<>E4,E4>J4),E4,IF(AND(I3>1,E3<>E4,E4<J4),J4,IF(AND(I3>1,E3=E4),J4, IF(AND(I3<-1,E3<>E4,E4<J4),E4,IF(AND(I3<-1,E3<>E4,E4>J4),J4,IF(AND(I3<-1,E3=E4),J4,0)))))))) 4 Con't A K 1 New Study #5 2 =DIFF[-1]/ Max of DIFF 3 =F3/J3 4 Your help is most appreciated. Thank you very much for your willingness to help, time and effort. |
 MACD&Crossover.PNG / V - Attached On 2021-03-15 20:23:12 UTC - Size: 22.63 KB - 226 views Private File |
| [2021-03-15 22:52:22] |
| Flipper_2 - Posts: 57 |
|
That all a bit too hard to translate. Happy to help but maybe you show what code you have managed to produce so far and/or a chart screenshot with the conditions you want to mark/set as trade triggers. By the way that excel file is marked private we cannot see it! You may also want to have a look at these examples. Post number 8 shows how to translate spreadsheet columns into Bar array indexes. https://futures.io/sierra-chart/55327-sierra-chart-acsil-beginners.html |
To post a message in this thread, you need to log in with your Sierra Chart account: