Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 7/1/2007(UTC)
Posts: 33
|
Hi
My exploration aim for the
following
1) Monthly periodicity
2) candlestick hover very near to MA low
3) candlestick body cannot cut lower MA.
4) candlestick body also cannot cut upper MA.
5) max load data of 32767
5) within a specify date range
Using the code below, my result vary wth the
the following issues.
1) last 1-3 candles didn't cut the lower MA which is fine
but some of the candle body cut the upper MA which is not what I wanted.
It should be within the upper and lower MA.
2) Some candles will not fulfill the condition, meaning
the candle body cut into upper or lower MA even within the date range given.
Is my usage of the DateRange function correct ?
Thank you.
MaL:=Mov(L,10,S);
MaH:=Mov(H,10,S);
(O < MaH) AND (C < MaH)
AND
(O > MaL) AND (C > MaL)
AND
ExtFml("forum.DateRange", 20100901,20110401);
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Might be time for you to head back into the MS User Manual and the free Equis Formula Primer to do a little more homework yourself. Do some work on dealing with comparison scenarios which result in true or false returns (1 or 0).
You are making definitions in your criteria which you are not including in your code, which is why you aren't getting the results you expect. Also, you cannot say words like "hover very near" without defining (specifically) your definition of "very near" and the time periods associated with the "hovering".
wabbit [:D]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 7/1/2007(UTC)
Posts: 33
|
Hi Wabbit
Thank for the advise, will go back to do my homework
on comparsion and come back.
Thank you
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
