Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/16/2013(UTC)
Posts: 2
|
Hello, I'm trying to write a formula for an Explorer. The first part is to determine the price is below the moving average, which seems to be: c<mov(c,4,s), which would look at the close below the 4 day simple Mov Ave. But I'd like to expand this to work out a % value below the moving average, but I'm a bit stumped on how to do that.
My second question is a further expansion of the above. I want to test for stocks which have fallen 3 out of the four past days. I've read through the MS primer, but I'm not the wiser.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/16/2013(UTC)
Posts: 2
|
Ok, I think I've got it. Does this look sensible:
ROC(C,1,%)<=-4
Which would look at today's price versus yesterdays price and confirm it is 4% lower or more.
Any suggestions for the second question is welcome.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi Aerostar
Here's one solution to your second question, and it's certainly not the only solution.
Sum(Ref(C,-1)>C,4)=3;
If you want to test for at least three falls in the past four days the = symbol should be replaced by >=.
Roy
|
|
|
|
|
|
| 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.
