| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/22/2005
Posts: 88
|
I will appreciate your help with the following two problems.
1. How do I write a PCF to find stocks with "New High for MoneyStream - 30 days"?
2. I am aware of the "MoneyStream Surge - 1 week" built in criteria but how do I write a PCF for a 2-day MS surge?
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (4optrader) How do I write a PCF to find stocks with "New High for MoneyStream - 30 days"?
MS > MAX(MS1.1,29)
QUOTE (4optrader) I am aware of the "MoneyStream Surge - 1 week" built in criteria but how do I write a PCF for a 2-day MS surge?
(MS - MS.2) / (MAX(MS,100) - MIN(MS,100)) * 100
Dealing with OBV & MS in PCF's - how to interp their "values"
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/22/2005
Posts: 88
|
Thanks, Bruce.
|
|
Registered User
Joined: 3/22/2005
Posts: 88
|
Bruce,
After looking over this formula
(MS - MS.2) / (MAX(MS,100) - MIN(MS,100)) * 100
I think it calculates the difference in MS over two days as a percentage of the range in MS over 100 days.
I am not sure how this is a 2-day surge in MS.
Please explain.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes, that is exactly what it does. Why would this not be a 2-Day Surge in MS? Not only is it relatively close to the form given for the MoneyStream Surge - 1 Week when selecting its View Formula icon (the blue circle with a lower case i in it to the right of the Criteria in the Sort list):
100 * (MS - MS1.5) / (MAX(MS1,99) - MIN(MS1,99))
It is the actual formula given for MoneyStream Surge - 2 Day in one of the instructional videos that can be purchased.
It gives the change in Cumulative MoneyStream over the period as a Percentage of its Range over a longer Period. If it has a large magnitude, it is surged relative to its normal variability.
What would you think of as a Surge in MoneyStream?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/22/2005
Posts: 88
|
Thanks, Bruce.
I was thinking of a surge in terms of today's value much higher than the value x days ago.
Something like MS > 5 * MS1.3.
Does this make sense?
One more question. Can I do this in exponential?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
No, it doesn't make sense. MoneyStream is a Cumulative Indicator. It's actual Value is completely meaningless (see the first referenced topic in my first reply for the types of things that do and don't make sense). So you can check for being above or below a Moving Average, but being some multiple of the Moving Average is meaningless.
I suppose you could take the Net Change in MoneyStream to create a non-cumulative version and then Average that (or more likely the Absolute Value of the Net Change for a Surge).
In a very real sense, the current version of the MoneyStream Surge formula already does compare the Averages of the non-cumulative MoneyStream (not the Absolute Value version). I suppose you would actually use the Net Change instead of the Total Range for this to be completely true.
I really don't know what you want to do, but I would read through the previously mentioned topic before making a decision.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
QUOTE (4optrader)
I was thinking of a surge in terms of today's value much higher than the value x days ago.
Something like MS > 5 * MS1.3.
Does this make sense?
Think of it this way 4opttrader.
You have a stock that goes from $20 to $25 a share in two days.
Sounds like a "big" move right?
(even if its moving average was $19 you would have about the same info)
Then you look back over 100 days and see that it was $300 a share.
(now 20 to 25 doesn't seem like that big of a move)
By using its past range it helps normalize movement values to past history.
Add the fact that some stocks trade 100's of thousands of shares and
some trade millions of shares on a "normal" day and you have even more reason to do so.
Thanks
diceman
|
|
Registered User
Joined: 3/22/2005
Posts: 88
|
Thank you Bruce and Diceman.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
4optrader,
You're welcome. Our pleasure.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |