Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

MS PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
xxlake355xx
Posted : Thursday, October 12, 2006 2:37:32 PM
Registered User
Joined: 11/2/2004
Posts: 12
Need help in writing a PCF for MS where yesterday's MS was < today's and today's is > OR yesterday's MS was < its mov avg and today's MS is > its mov avg. MS value is 38 and the mov avg is 19'
Your help is appreciated.
doc355
Craig_S
Posted : Thursday, October 12, 2006 2:49:13 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
I am a tad confused with this last part
QUOTE
MS value is 38 and the mov avg is 19


MoneyStream has no settings... are you sure you don't mean TSV?

- Craig
Here to Help!
doc355
Posted : Thursday, October 12, 2006 2:58:28 PM
Registered User
Joined: 12/3/2004
Posts: 92
Craig...In middle window, I have MS38 with its 19dma plotted and in bottom window I have a TSV & its mov avg plotted. I was attempting to write PCF which would show when MS crossed either "0" line or its 19 dma.
Hope this question is clearly written.
doc355
Craig_S
Posted : Thursday, October 12, 2006 3:00:57 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Do you have a Custom Indicator of MS38 or do you have the MoneyStream indicator plotted?

MS crossing zero is meaningless, it does not have a "zero line" like TSV. Not sure what you mean by "when MS crossed either "0" line"

Is your 19ma simple or exponential?

- Craig
Here to Help!
doc355
Posted : Thursday, October 12, 2006 3:09:00 PM
Registered User
Joined: 12/3/2004
Posts: 92
Craig...Sorry, Custom Indicator of MS38 or MS indicator, I don't know. All I know is that in my mid window, ms38 and itsmov avg19 are plotted and there is a "0" line showing.
Is not this an indicator that PW uses in some of his examples ?
doc355
Craig_S
Posted : Thursday, October 12, 2006 3:43:37 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Not that I know of. Click the EDIT on your chart. What does it say EXACTLY in the middle window?

- Craig
Here to Help!
doc355
Posted : Thursday, October 12, 2006 4:36:56 PM
Registered User
Joined: 12/3/2004
Posts: 92
Craig...Sorry for the confusion. You are absolutely correct. My concern is for the bottom window instead which has a MS with a 22dma. So my correct request should have been for a PCF that today crosses its 22dma.

Again, thanks for your patience and insight to set me on the correct path.
doc355
Bruce_L
Posted : Thursday, October 12, 2006 6:43:36 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
doc355,
Please try the following:

Simple:

SGN(MS - AVG(MS,22)) - SGN(MS1.1 - AVG(MS1.1,22)) <> 0

Exponential:

SGN(MS - XAVG(MS,22)) - SGN(MS1.1 - XAVG(MS1.1,22)) <> 0

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
doc355
Posted : Thursday, October 12, 2006 8:15:52 PM
Registered User
Joined: 12/3/2004
Posts: 92
Bruce...Your help was right on the target. I would never have come with this PCF on my own. Please don't leave us.
doc355
Craig_S
Posted : Friday, October 13, 2006 6:56:18 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
I'm glad we got it figured out.

- Craig
Here to Help!
kmcintyre
Posted : Friday, October 13, 2006 9:07:41 PM
Registered User
Joined: 3/14/2006
Posts: 78
I'm a bit confused.

MS is todays value for moneystream
MS1 is todays value for moneystream averaged over one day
MS1.1 is yesterdays value for MS1

Correct?

Is MS and MS1 equivalent? (An average of 1 is itself, right?)
Is MS.1 a valid syntax for yesterdays MS value?

Now for my big question...

I want to "visually backtest" MS. I would like to create a PCF that helps me find charts that had large moves in MS (say) 6 mongths ago. That way I can space bar through a list of charts exhibiting similar historical indicator traits and get a feel for how consistently the indicator predicted future price movement.

I think I could do this easily if MS was range bound (0..100 or -100..100, etc.) But MS is all over the board, ranging wildly from positive to negative. To date my PCFs haven't worked. (But I'm not giving up...)

Any ideas?

Thanks!
Bruce_L
Posted : Saturday, October 14, 2006 9:46:56 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (kmcintyre)
MS is todays value for moneystream
MS1 is todays value for moneystream averaged over one day
MS1.1 is yesterdays value for MS1

Correct.

QUOTE (kmcintyre)
Is MS and MS1 equivalent? (An average of 1 is itself, right?)

Yes and yes.

QUOTE (kmcintyre)
Is MS.1 a valid syntax for yesterdays MS value?

No.

QUOTE (kmcintyre)
To date my PCFs haven't worked. (But I'm not giving up...) Any ideas?

You may wish to review the following:

Dealing with OBV & MS in PCF's - how to interp their "values"

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
doc355
Posted : Monday, October 16, 2006 10:00:34 PM
Registered User
Joined: 12/3/2004
Posts: 92
Bruce..Having trouble reversing pcf for ms. You kindly provided pcf where ms crossed its ma 22. Would you please write pcf where yesterday ms was > avg.22, but today ms is < avg. 22 ?
doc355
Posted : Monday, October 16, 2006 10:11:43 PM
Registered User
Joined: 12/3/2004
Posts: 92
Bruce..The pcf for ms crossing above the avg 22 gives me mixed results. I have simple throughout. MS for (MI-HD-FIC)crosses avg 22 down today (8/16) instead of up as planned.
Any suggestions ?
doc355
Bruce_L
Posted : Tuesday, October 17, 2006 8:55:40 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
doc355,
Here's the question immediately prior to the formula I presented:

QUOTE (doc355)
So my correct request should have been for a PCF that today crosses its 22dma.

It doesn't specify a direction and neither does my formula. It tests for crosses in either direction.

Replacing <> 0 with > 0 will test for MS crossing up through the Moving Average.

Replacing <> 0 with < 0 will test for MS crossing down through the Moving Average.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
doc355
Posted : Tuesday, October 17, 2006 10:03:44 PM
Registered User
Joined: 12/3/2004
Posts: 92
Bruce...Thanks, as suggested by you; changing the <> to > for "UP" and "<" Down gives me exactly what I wish.
Your efforts are appreciated.
doc355
Bruce_L
Posted : Tuesday, October 17, 2006 10:05:52 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome. Our pleasure.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

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.