Support Board

Date/Time: Thu, 25 Apr 2024 10:31:48 +0000

Post From: How to code a rise in MACD value

[2019-09-11 19:36:23] Link To Thread - Link To Post [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,