Registered User
Joined: 12/10/2005
Posts: 32
|
Hi,
I have "price % change today", how do I input "price change today".
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You could use the following Personal Criteria Formula for Price Net Change:
C - C1
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
Thanks Bruce for a fast reply!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
Hi,
Please help me write a pcf that would identify a OBV that is increasing in value in the last 30 days or in top range while stochastic is oversold to find divergence.
I am using 14,3,3 for stochastic vales. CYH stock retraced from its high in the beginning of December 05 to the end of December and Stochastic went from overbought to oversold while OBV is still in high territory and retracing just a little bit.
Thanks
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I am not sure what you mean by "in top range"...
Here are a few PCFs to try:
OBV Direction 30-day
100*(AVG(OBV1,15)-MIN(OBV1,30))/(AVG(OBV1.15,15)-MIN(OBV1,30))
Stoc 14.3 Today
STOC14.3
Once you create these two PCFs, go to EasyScan and add them as conditions.
Limit as follows using the range selector:
OBV Direction 30-day
VALUE over 100
Stoc 14.3 Today
VALUE less than 20
Here are some videos to review:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Understanding Stochastics
- Craig
Here to Help!
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
Hi Craig,
Thank you so much for trying to help so fast.
I input the PCF for OBV Direction 30-day and some of the results are not clear. For example:
1. WLT has OBV value of -318.5 and OBV chart has been increasing to the top of its range.
2. BLI has OBV value of -282.56 and OBV chart has been increasing to the top of its range.
3. CMCSA has a large positive value of 1001.47 and the chart is on the bottom of its 90 days.
I am trying to find divergence by having Stochastic and OBV in one template. Using 3 months range I would like to see the OBV line improving and staying aroung 80% Stochastic line while Stochastic itself (8,3,3) is oversold.
Again, thank you so much for your excellent service.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Try this:
OBV 3-month range:
100*(OBV1-MIN(OBV1,63))/(MAX(OBV1,63)-MIN(OBV1,63))
You will want to focus on values greater than 80.
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
BTW, I also made a change to the OBV direction PCF...
Values over 100 mean OBV is trending up over the last 30 trading days
Values less than 100 mean the opposite.
- Craig
Here to Help!
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
Hi Craig,
Another example would be AMZN with Stochastic value of 10.09 (8,3,3) and OBV -44.64. On the chart template, AMZN stochastic has clear divergence vs OBV.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Here is a formula for your other Stochastic:
STOC8.3
Same limit as as I gave above (less than 20).
Keep in mind, the OBV value is meaningless. My PCF normalizes OBV by giving you where the OBV is in its range.
Stochastics is a measure of where price is within a trading range.
My PCF above shows where OBV is with its set range.
You are really looking for OBV to be plotting near the top of its range while price is trading closer to the bottom of its range (the period you set your stochastics determines the number of days for the trading range.)
The PCFs I gave you should work fine. You may want to check out this video on stochastics:
Understanding Stochastics
- Craig
Here to Help!
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
Hi Craig,
The PCF works great! It is exactly what I am looking for.
Thanks again for your help.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Glad to hear it!
- Craig
Here to Help!
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
QUOTE (Craig_S) Try this:
OBV 3-month range:
100*(OBV1-MIN(OBV1,63))/(MAX(OBV1,63)/MIN(OBV1,63))
You will want to focus on values greater than 80.
I doubt this PCF is what you intended. It is not invariant under a scale factor change nor a translation and therefor is meaningless.
My guess is that you probably intended:
100*(OBV1-MIN(OBV1,63))/(MAX(OBV1,63)-MIN(OBV1,63))
If so, please correct your PCF and delete this without mention.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Yep, made a typo. Meant it to be a "-" not a "/".
Good catch, thanks.
Corrected the original formula above.
- Craig
Here to Help!
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
Hi,
Can you help me with a PCF to search for stocks with 10EMA just crossing 50EMA in the last 3 days. I input "XAVGC10 > XAVGC50" and obtained too many returns with the 10EMA way above the 50EMA.
Thanks so much.
|
|
Registered User
Joined: 10/7/2004
Posts: 286
|
I believe this should work to return all stocks that where the 10d exp. ave. has crossover the 50d exp. ave. in any one of the past three days.
(XAVGC10 > XAVGC50 AND XAVGC10.1 < XAVGC50.1) OR (XAVGC10.1 > XAVGC50.1 AND XAVGC10.2 < XAVGC50.2) OR (XAVGC10.2 > XAVGC50.2 AND XAVGC10.3 < XAVGC50.3)
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Try This,
EMA10 Up through EMA50 3 Days Ago
(XAVGC10 > XAVGC50) AND (XAVGC10 > XAVGC50.1) AND (XAVGC10.3 < XAVGC50.3)
Thanks
Winnie
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
jynkin & Winnie,
Thanks so much!
|
|
Registered User
Joined: 10/7/2004
Posts: 286
|
your welcome htp1
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
Hi,
I search and found the formula for Chaikin Money Flow. The indicator shows as a line. Could someone change it so that it shows as histogram. Thanks
Chaikin Money Flow:
((2*C-L-H)/(H-L)*V +(2*C1-L1-H1)/(H1-L1)*V1 +(2*C2-L2-H2)/(H2-L2)*V2 +
(2*C3-L3-H3)/(H3-L3)*V3 +(2*C4-L4-H4)/(H4-L4)*V4 +(2*C5-L5-H5)/(H5-L5)*V5 +(2*C6-L6-H6)/(H6-L6)*V6 +(2*C7-L7-H7)/(H7-L7)*V7 +(2*C8-L8-H8)/(H8-L8)*V8 +
(2*C9-L9-H9)/(H9-L9)*V9 +(2*C10-L10-H10)/(H10-L10)*V10 +(2*C11-L11-H11)/(H11-L11)*V11 +
(2*C12-L12-H12)/(H12-L12)*V12 +(2*C13-L13-H13)/(H13-L13)*V13 +(2*C14-L14-H14)/(H14-L14)*V14 +
(2*C15-L15-H15)/(H15-L15)*V15 +(2*C16-L16-H16)/(H16-L16)*V16 +(2*C17-L17-H17)/(H17-L17)*V17 +
(2*C18-L18-H18)/(H18-L18)*V18 +(2*C19-L19-H19)/(H19-L19)*V19 +(2*C20-L20-H20)/(H20-L20)*V20) / (AvgV21 * 21)
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
There is no way to have a custom indicator plot as a histogram. The line shows the same information the histogram would show.
- Craig
Here to Help!
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
Craig,
Many thanks for your quick reply!
|
|
Registered User
Joined: 12/10/2005
Posts: 32
|
Hi,
Could you help me with a PCF that will show positive MACD (12/26/9) Weekly and Daily. I would like to use this PCF to search for stocks that are trending.
Thanks
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
When you say "positive MACD" do you mean above zero or just moving up? Are you looking for the MACD or the MACD Histogram?
Have you watched this video and looked at the PCF templates under it?
Understanding MACD
- Craig
Here to Help!
|
|
|
Guest-1 |