Tweet
hi alexis,
i have one Trend Reversal formula in excelsheet. it is like 2 days higher high and 2 days lower low base something link Stop and Reverse, is it possible to make this formula in efs file if yes than can u help me out plss..
A B C D E F G
1 Date Open High Low Close SIGNAL REVERSAL LEVEL
2 Aug 22/11 15.64 15.65 14.82 14.88 SHORT 15.65
3 Aug 23/11 14.98 15.21 14.76 15.21 SHORT 15.65
4 Aug 24/11 15.20 15.77 15.07 15.77 LONG 14.76
5 Aug 25/11 15.92 16.05 15.01 15.05 LONG 15.01
6 Aug 26/11 14.92 15.75 14.66 15.64 LONG 14.66
7 Aug 29/11 15.97 16.49 15.87 16.45 LONG 14.66
8 Aug 30/11 16.36 16.87 16.18 16.71 LONG 15.87
formula for "F column as 'SIGNAL' & 3rd row": =IF(F2="SHORT",IF(E3>G2,"LONG","SHORT"),IF(E3<G2," SHORT","LONG"))
formula for "G column as 'REVERSAL LEVEL' & 3rd row": =IF(F3="SHORT",MAX(C2:C3),MIN(D2
3))
i dont know how to attach file otherwise i wud have attached excel file also...
thank you
Vishu
i have one Trend Reversal formula in excelsheet. it is like 2 days higher high and 2 days lower low base something link Stop and Reverse, is it possible to make this formula in efs file if yes than can u help me out plss..
A B C D E F G
1 Date Open High Low Close SIGNAL REVERSAL LEVEL
2 Aug 22/11 15.64 15.65 14.82 14.88 SHORT 15.65
3 Aug 23/11 14.98 15.21 14.76 15.21 SHORT 15.65
4 Aug 24/11 15.20 15.77 15.07 15.77 LONG 14.76
5 Aug 25/11 15.92 16.05 15.01 15.05 LONG 15.01
6 Aug 26/11 14.92 15.75 14.66 15.64 LONG 14.66
7 Aug 29/11 15.97 16.49 15.87 16.45 LONG 14.66
8 Aug 30/11 16.36 16.87 16.18 16.71 LONG 15.87
formula for "F column as 'SIGNAL' & 3rd row": =IF(F2="SHORT",IF(E3>G2,"LONG","SHORT"),IF(E3<G2," SHORT","LONG"))
formula for "G column as 'REVERSAL LEVEL' & 3rd row": =IF(F3="SHORT",MAX(C2:C3),MIN(D2
3))i dont know how to attach file otherwise i wud have attached excel file also...
thank you
Vishu