Hello all
i am working on trends,
A trend is up if its ema of current period is greater then the ema of the last period and vice versa.
Now suppose i have defined Bull:=(MOV(C,3,E);
now what i want is that it calculates the previous period value of the bull and and if the privious period value is less then the current period value then the trend is up and vice versa.
i cannot find any function to calculate the previous bar value
What i want is to work with loop or if there is any other way pls guide me.
thanks in advance
This is how I will implement it..
1) Goto create new explorer - EMA Trend Explorer
2) On Tab-A, Mov(C,10,E) - this will give 10 day exponential moving average on Close in Column A of the report
3) On Tab-B, Mov(ref(C,-1),10,E) - this will create 10 day exponential moving average on Close for PREV Day (ref -1 is used to refer C of -1 day) in Column B of the report
4) Goto Tab-FILTER and write condition ColA>ColB -- this will filter the scrips where ColA i.e. 10dma of today is greater then ColB i.e. 10dma of prev day)
Run this explorer on your selected list of scrips. The output report will have the required outcome.
To extend it further, I will ignore the filter criteria and just get the 2 EMA values in colA and ColB. I will paste the output in Excel and manipulate the data (by write formulas / filter /sorting ) in whatever way I want.
Hope this helps you.
Happy Trading.