Support Board

Date/Time: Sun, 28 Apr 2024 22:08:36 +0000

Post From: Orientation ??

[2015-08-27 06:40:53] Link To Thread - Link To Post [Go To First Post]
User713273 - Posts: 409
I think you may have answered this in #3 but just to clarify. I am trying to do the following I am trying to do a custom formula. For example even though you already have this study. I would like to do SMA for 4 time periods. in my custom formula in row 3 how would I write that since I need 4 time period before the calculation actually can happen. Assuming ID0.SG4 is LastPrice Row Formula 3 =(ID0.SG4@3+???)/4.0 4 =(ID0.SG4@3+ID0.SG4@4 + ???)/4.0 5 =(ID0.SG4@3+ID0.SG4@4 + ID0.SG4@5 + ???)/4.0 5 =(ID0.SG4@3+ID0.SG4@4 + ID0.SG4@5 + + ID0.SG4@6)/4.0 <-- This can actually calculate now. How do I represent this in row 3? since I can't go ID0.SG4@2, ID0.SG4@1, ID0.SG4@0? Even simpler example is difference between current and last price. How do I do that in custom formula in row 3? Thanks again