| 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 |