Hi,
I have been sent two MS formulae which I'd like to emulate in Excel. I just need a little clarification on what the codes are. Any help would be much appreciated.
***********************************
The first one is:
RSI(C ,2) - Ref(RSI(C ,3),-1)
Is this 2 day RSI less (3 day RSI minus 1)?
***********************************
***********************************
The second one is:
(Fml( "a_Mid") + (ATR(1) - (H-L))/2) - (C- Mov(C ,3 ,E )) - (Fml( "a_Mid"))
where
a_Mid = (H+L)/2
ATR = Average True Value
I think this formula is incorrect as the a_Mids would cancel. Any thoughts?
************************************
Thanks a lot
I have been sent two MS formulae which I'd like to emulate in Excel. I just need a little clarification on what the codes are. Any help would be much appreciated.
***********************************
The first one is:
RSI(C ,2) - Ref(RSI(C ,3),-1)
Is this 2 day RSI less (3 day RSI minus 1)?
***********************************
***********************************
The second one is:
(Fml( "a_Mid") + (ATR(1) - (H-L))/2) - (C- Mov(C ,3 ,E )) - (Fml( "a_Mid"))
where
a_Mid = (H+L)/2
ATR = Average True Value
I think this formula is incorrect as the a_Mids would cancel. Any thoughts?
************************************
Thanks a lot