Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 22:59:14 +0000



Post From: Orientation ??

[2015-08-27 06:40:53]
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