Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 14:19:17 +0000



Post From: VWAP FORMULA FOR SPREADSHEET

[2021-07-03 18:17:33]
Hopeman - Posts: 156
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
imageGap Fail.png / V - Attached On 2021-07-03 18:17:31 UTC - Size: 38.32 KB - 149 views