Login Page - Create Account

Support Board


Date/Time: Tue, 14 May 2024 09:45:58 +0000



[Programming Help] - Formula fail

View Count: 374

[2021-07-05 16:07:45]
Joperman - Posts: 20
Hello again! I am making a GAP and HALF GAP formula which calculates the gap and a half gap from the closing and opening of the current day, the formula for the gap.

=(ID0.SG4@4)

and for the HALF GAP

=(ID0.SG4@4+ID0.SG1@3)/2

The problem is that the formula only applies when the GAP will be above the price and not below surely I am doing wrong, could you help me to make the calculation correctly! Thank you

https://www.sierrachart.com/Download.php?Folder=TicketingSystem&download=52415
[2021-07-05 20:12:07]
Sawtooth - Posts: 3996
See post #12 here:
VWAP FORMULA FOR SPREADSHEET

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account