Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 23 Nov 2024 23:52:09 +0000

How to Post a Message for Support

Post From: Previous VWAP levels on current session chart

[2013-08-06 01:43:52]
[Go To First Post]
Sawtooth - Posts: 4118
You are not using the newer version. The newer version has formulas in column V.

Put this in V3:
=MROUND(A3,1/86400)

Put this in Z3:
=IF(AND($J$1=0,$J$2="D"),IF(INT(V3)>INT(V4),1,0),IF($J$2="D",IF(AND(MROUND($J$1,1/86400)<=MROUND(V3-INT(V3),1/86400),MROUND($J$1,1/86400)>MROUND(V4-INT(V4),1/86400)),1,0),IF($J$2="W",IF(Y3>Y4,1,0),IF($J$2="M",IF(X3>X4,1,0),IF($J$2="Y",IF(W3>W4,1,0),"See cell J2")))))
Date Time Of Last Edit: 2013-08-06 02:22:02