Support Board
Date/Time: Sun, 02 Feb 2025 15:49:15 +0000
Post From: 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, |