Rank: Newbie
Groups: Registered Users, Subscribers Joined: 3/20/2016(UTC) Posts: 6
Thanks: 2 times
|
Hello, Any hardcore Metastock users still out there? Help with a slightly bizarre problem appreciated.
Using MS Explorer, I want to count the number of times that a stock closes less that $1 up or $1 down. This does the trick: Cum(
(C < (Ref(C,-1) + 1) AND C > (Ref(C,-1) - 1))
)
.....except that closes EQUAL to the previous close are not counted. In a separate column, this counts closes equal to the previous close no problem: Cum(C = Ref(C,-1)) Even putting both formulas together doesn't yield the correct result: Cum(
(C < (Ref(C,-1) + 1) AND C > (Ref(C,-1) - 1))
OR
C = Ref(C,-1)
)
The result is the same as the first formula. Any advice appreciated. Best, Kevin
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960
Thanks: 91 times Was thanked: 155 time(s) in 150 post(s)
|
Hi,
I am not sure if this is quite what you are looking for but you may want to see if this might help:
The Rate of Change function looks for a $ (or %) change over X periods, either positive or negative. So we can capture the positive and negative change combined with the Absolute Value function to ensure that the 1-period $ rate of change is less than or equal to 1. Edited by user Wednesday, September 9, 2020 5:45:46 PM(UTC)
| Reason: Not specified
|
|
|
|
Rank: Newbie
Groups: Registered Users, Subscribers Joined: 3/20/2016(UTC) Posts: 6
Thanks: 2 times
|
Hello, Many thanks for your reply, which is much appreciated. The good news is that your suggestion does count the closes equal to the previous close. However, the count is still not correct. The Cum function works fine but the ROC function appears (to me) to be inconsistent. I have attached a chart for Abbott Laboratories, ABT, upon which I have plotted the ROC indicator. The indicator appears to be flagging bars erroneously, for example, 27th Mar, 26th May, 9th June. When I modify the ROC indicator to identify closes < $2 away from the previous close, the error rate goes up substantially. Am I doing something dumb here? Many thanks, Kevin
P.S. I was unable to upload the image with this message. Here is a link: https://www.dropbox.com/s/fu5dwxkkk45enaa/Abbot%20Labs%20ROC.jpg?dl=0
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960
Thanks: 91 times Was thanked: 155 time(s) in 150 post(s)
|
Originally Posted by: OrsonCarte Hello, Many thanks for your reply, which is much appreciated. The good news is that your suggestion does count the closes equal to the previous close. However, the count is still not correct. The Cum function works fine but the ROC function appears (to me) to be inconsistent. I have attached a chart for Abbott Laboratories, ABT, upon which I have plotted the ROC indicator. The indicator appears to be flagging bars erroneously, for example, 27th Mar, 26th May, 9th June. When I modify the ROC indicator to identify closes < $2 away from the previous close, the error rate goes up substantially. Am I doing something dumb here? Many thanks, Kevin
P.S. I was unable to upload the image with this message. Here is a link: https://www.dropbox.com/s/fu5dwxkkk45enaa/Abbot%20Labs%20ROC.jpg?dl=0
Hi again and sorry about that! You are right in that it is not behaving properly thanks to my poor use of parentheses.
The above should function appropriately. Edited by user Thursday, September 10, 2020 9:13:38 PM(UTC)
| Reason: Not specified
|
1 user thanked MS Support for this useful post.
|
|
|
Rank: Newbie
Groups: Registered Users, Subscribers Joined: 3/20/2016(UTC) Posts: 6
Thanks: 2 times
|
Hello, What's the odd parentheses between friends? Your modification works a treat and the exploration performs perfectly. Many thanks, once again, for your help. Best Regards, Kevin
|
|
|
|
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.