Login Page - Create Account

Support Board


Date/Time: Wed, 18 Sep 2019 12:28:26 +0000



How to code a rise in MACD value

[2019-09-11 19:36:23]
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]
tomgilb - Posts: 2267
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 login with your Sierra Chart account:

Login

Login Page - Create Account