Support Board
Date/Time: Mon, 24 Feb 2025 17:58:06 +0000
Post From: Study: MACD & MACD Crossover System with added New Studies
| [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 |