Support Board
Date/Time: Sun, 02 Feb 2025 16:01:19 +0000
[Programming Help] - How to code a rise in MACD value
View Count: 564
| [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] |
| Sawtooth - Posts: 4164 |
|
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: