Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
I am a tad confused with this last part
QUOTEMS 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!
|
|
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
|
|
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!
|
|
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
|
|
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!
|
|
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
|
|
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
|
|
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
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
I'm glad we got it figured out.
- Craig Here to Help!
|
|
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!
|
|
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
|
|
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 ?
|
|
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
|
|
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
|
|
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
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome. Our pleasure.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |