HI
I have this formula for Demarks Pivot points
=IF(B5>B2,((B3*2)+B4+B5),IF(B5<B3,((B3+(B4*2+B5))))) i also want to add IF IF(B5=B4,(B3+B4+(2*B5))) (which works independently) so when i do =IF(B5>B2,((B3*2)+B4+B5),IF(B5<B3,((B3+(B4*2+B5),IF(B5=B4,((B3+B4+(2*B5)))))) it comes up with an error which i cant fix...
I am trying to use the for demarks pivot for trading to determine X
If Close < Open: X = H + 2 x L + C
If Close > Open: X = 2 x H + L + C
If Close = Open: X = H + L + 2 x C
New High = X / 2 - L
New Low = X / 2 - H
H =High L=Low C= Close
with input points being
Open 7,556.44
High 7,689.44
Low 7,556.20
Close 7,682.27
Hope you can help ! Ia m not the greatest at this ... Regards
Bookmarks