Home >> Support Board

Support Board

Date/Time: Fri, 19 Apr 2024 08:23:58 +0000

How to Post a Message for Support

[Programming Help] - How to code a rise in MACD value

View Count: 504

[2019-09-11 19:36:23] #1 [Go To First Post]
User116135 - Posts: 9
In my spreadsheet,column AF, I need to code when the current value ID4.SG1@3 is greater than the value prior to a change in value. I can't put ID4.SG1@3 > ID4.SG1@4, because when MACD changes value it may print 2 or 10 of identical values. So i need to have the statement compare the current value ID$.SG1@3 with the value prior to the change in value. In this case ID4.SG1@10,but it's in a different location each time. I hope that is clear... [ID4.SG1] MACD 4.080810546875 == @3 4.080810546875 4.080810546875 4.080810546875 4.080810546875 4.080810546875 4.080810546875 4.0302734375 == @10 4.0302734375 4.0302734375 4.0302734375 4.0302734375 4.0302734375 4.0302734375 Thanks in advance,

[2019-09-11 20:29:51] #2 [Go To First Post]
Sawtooth - Posts: 3973
Create a persistent variable in P3 of the last time it changed value: =IF(ID4.SG1@3<>ID4.SG1@4,ID4.SG1@4,P4) Date Time Of Last Edit: 2019-09-11 20:30:52

To post a message in this thread, you need to log in with your Sierra Chart account: