Support Board

Date/Time: Mon, 06 May 2024 02:13:44 +0000

Post From: Study sub graph difference MA

[2013-11-28 20:18:16] Link To Thread - Link To Post [Go To First Post]
TastyRisk - Posts: 119
So your main 20period average can be your "line in the sand"... If Last is above your "Line in the Sand" then record the difference that exists. If negative then you need to skip onto the next row. Add the recorded value to the next positive result you get. When you have have done this, on cells giving positive results, 5000 times; then you need to divide your running total by 5000 to get your average. So to implement this; you need either a custom study that will loop through until it's found 5000 instances, or, you can devise some logic in a spreadsheet. As SC support won't write the study for you for free; please post your code or spreadsheet formulas and I'm sure that you'll find other people willing to help some more. The maths isn't complicated but the programming / logic might be new to you ? I don't really find it easy myself but I've found it's always best practice to break things down into small chunks so you can more easily plan how to work through them. Date Time Of Last Edit: 2013-11-28 20:33:27