| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/14/2005
Posts: 77
|
I would like to write a scan for FI 13 MA >=0 and 3MA <=0. Anyone can help? I have searched the forum but it does not give me the pcf.
regards,
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
Simple:
100 * ((C - C1) * V + (C1 - C2) * V1 + (C2 - C3) * V2 + (C3 - C4) * V3 + (C4 - C5) * V4 + (C5 - C6) * V5 + (C6 - C7) * V6 + (C7 - C8) * V7 + (C8 - C9) * V8 + (C9 - C10) * V9 + (C10 - C11) * V10 + (C11 - C12) * V11 + (C12 - C13) * V12) / 13 >= 0 AND 100 * ((C - C1) * V + (C1 - C2) * V1 + (C2 - C3) * V2) / 3 <= 0
Exponential:
14.2996048056393 * ((C - C1) * V + 6 / 7 * ((C1 - C2) * V1 + 6 / 7 * ((C2 - C3) * V2 + 6 / 7 * ((C3 - C4) * V3 + 6 / 7 * ((C4 - C5) * V4 + 6 / 7 * ((C5 - C6) * V5 + 6 / 7 * ((C6 - C7) * V6 + 6 / 7 * ((C7 - C8) * V7 + 6 / 7 * ((C8 - C9) * V8 + 6 / 7 * ((C9 - C10) * V9 + 6 / 7 * ((C10 - C11) * V10 + 6 / 7 * ((C11 - C12) * V11 + 6 / 7 * ((C12 - C13) * V12 + 6 / 7 * ((C13 - C14) * V13 + 6 / 7 * ((C14 - C15) * V14 + 6 / 7 * ((C15 - C16) * V15 + 6 / 7 * ((C16 - C17) * V16 + 6 / 7 * ((C17 - C18) * V17 + 6 / 7 * ((C18 - C19) * V18 + 6 / 7 * ((C19 - C20) * V19 + 6 / 7 * ((C20 - C21) * V20 + 6 / 7 * ((C21 - C22) * V21 + 6 / 7 * ((C22 - C23) * V22 + 6 / 7 * ((C23 - C24) * V23 + 6 / 7 * ((C24 - C25) * V24 + 6 / 7 * ((C25 - C26) * V25 + 6 / 7 * ((C26 - C27) * V26 + 6 / 7 * ((C27 - C28) * V27 + 6 / 7 * ((C28 - C29) * V28 + 6 / 7 * ((C29 - C30) * V29 + 6 / 7 * ((C30 - C31) * V30 + 6 / 7 * ((C31 - C32) * V31 + 6 / 7 * ((C32 - C33) * V32 + 6 / 7 * ((C33 - C34) * V33 + 6 / 7 * ((C34 - C35) * V34 + 6 / 7 * ((C35 - C36) * V35 + 6 / 7 * ((C36 - C37) * V36 + 6 / 7 * ((C37 - C38) * V37 + 6 / 7 * ((C38 - C39) * V38 + 6 / 7 * ((C39 - C40) * V39 + 6 / 7 * ((C40 - C41) * V40 + 6 / 7 * ((C41 - C42) * V41 + 6 / 7 * ((C42 - C43) * V42 + 6 / 7 * ((C43 - C44) * V43 + 6 / 7 * ((C44 - C45) * V44))))))))))))))))))))))))))))))))))))))))))))) >= 0 AND 50.0488758553275 * ((C - C1) * V + .5 * ((C1 - C2) * V1 + .5 * ((C2 - C3) * V2 + .5 * ((C3 - C4) * V3 + .5 * ((C4 - C5) * V4 + .5 * ((C5 - C6) * V5 + .5 * ((C6 - C7) * V6 + .5 * ((C7 - C8) * V7 + .5 * ((C8 - C9) * V8 + .5 * ((C9 - C10) * V9)))))))))) <= 0
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Smoothed Force Index
Handy PCF example formulas to help you learn the syntax of PCFs!
Personal Criteria Language Function List
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/6/2005
Posts: 40
|
Bruce,
Would that be difficult for you to write 13 weeks exponential Force Index PCF formula?
Thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Eternum,
I'm really not sure if a Weekly Force Index should use Average Volume or Total Volume for each Week (Total Volume is just five times Average Volume). I'll provide a Total Volume version, but this can be converted to a version using Average Volume by dividing the starting 71.4980240281964 by five (14.2996048056393):
71.4980240281964 * ((C - C5) * AVGV5 + 6 / 7 * ((C5 - C10) * AVGV5.5 + 6 / 7 * ((C10 - C15) * AVGV5.10 + 6 / 7 * ((C15 - C20) * AVGV5.15 + 6 / 7 * ((C20 - C25) * AVGV5.20 + 6 / 7 * ((C25 - C30) * AVGV5.25 + 6 / 7 * ((C30 - C35) * AVGV5.30 + 6 / 7 * ((C35 - C40) * AVGV5.35 + 6 / 7 * ((C40 - C45) * AVGV5.40 + 6 / 7 * ((C45 - C50) * AVGV5.45 + 6 / 7 * ((C50 - C55) * AVGV5.50 + 6 / 7 * ((C55 - C60) * AVGV5.55 + 6 / 7 * ((C60 - C65) * AVGV5.60 + 6 / 7 * ((C65 - C70) * AVGV5.65 + 6 / 7 * ((C70 - C75) * AVGV5.70 + 6 / 7 * ((C75 - C80) * AVGV5.75 + 6 / 7 * ((C80 - C85) * AVGV5.80 + 6 / 7 * ((C85 - C90) * AVGV5.85 + 6 / 7 * ((C90 - C95) * AVGV5.90 + 6 / 7 * ((C95 - C100) * AVGV5.95 + 6 / 7 * ((C100 - C105) * AVGV5.100 + 6 / 7 * ((C105 - C110) * AVGV5.105 + 6 / 7 * ((C110 - C115) * AVGV5.110 + 6 / 7 * ((C115 - C120) * AVGV5.115 + 6 / 7 * ((C120 - C125) * AVGV5.120 + 6 / 7 * ((C125 - C130) * AVGV5.125 + 6 / 7 * ((C130 - C135) * AVGV5.130 + 6 / 7 * ((C135 - C140) * AVGV5.135 + 6 / 7 * ((C140 - C145) * AVGV5.140 + 6 / 7 * ((C145 - C150) * AVGV5.145 + 6 / 7 * ((C150 - C155) * AVGV5.150 + 6 / 7 * ((C155 - C160) * AVGV5.155 + 6 / 7 * ((C160 - C165) * AVGV5.160 + 6 / 7 * ((C165 - C170) * AVGV5.165 + 6 / 7 * ((C170 - C175) * AVGV5.170 + 6 / 7 * ((C175 - C180) * AVGV5.175 + 6 / 7 * ((C180 - C185) * AVGV5.180 + 6 / 7 * ((C185 - C190) * AVGV5.185 + 6 / 7 * ((C190 - C195) * AVGV5.190 + 6 / 7 * ((C195 - C200) * AVGV5.195 + 6 / 7 * ((C200 - C205) * AVGV5.200 + 6 / 7 * ((C205 - C210) * AVGV5.205 + 6 / 7 * ((C210 - C215) * AVGV5.210 + 6 / 7 * ((C215 - C220) * AVGV5.215 + 6 / 7 * ((C220 - C225) * AVGV5.220)))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/6/2005
Posts: 40
|
Bruce,
I tried both versions, but neither one seem to give a value close to what gives the following custom indicator plotted on a weekly chart (top window)
(c-c1)*v, exponential smoothing average = 13
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Bruce,
Whether one uses average volume or total volume in Weekly Force Index does not matter nor does the 71.4... factor.
If one uses Force Index in such a fashion that scale matters, they will have misused the indicator. Right?
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Eternum,
There are three issues. The first issue is that TeleChart's Volume is quoted in blocks of 100 shares. The formulas in this topic take this into account and are designed to match the following Custom Indicator in Daily Mode:
Select Chart Template | Add Indicator | Indicator.
- Center Zero Line: Checked
- Plot using price scale: Unchecked
- Smoothing Average: 13
- Average Type: Exponential
- Indicator Formula: 100 * (C - C1) * V
You can move the decimal place to the left by two places to match your Custom Indicator. The second issue is that if the Time Frame is set to anything greater than Daily, TeleChart reports Average Volume on the charts. This would mean you would want to use the Average Volume version of the formula to match the Custom Indicator even though I'm still not sure which version would be the more standard form:
14.2996048056393 * ((C - C5) * AVGV5 + 6 / 7 * ((C5 - C10) * AVGV5.5 + 6 / 7 * ((C10 - C15) * AVGV5.10 + 6 / 7 * ((C15 - C20) * AVGV5.15 + 6 / 7 * ((C20 - C25) * AVGV5.20 + 6 / 7 * ((C25 - C30) * AVGV5.25 + 6 / 7 * ((C30 - C35) * AVGV5.30 + 6 / 7 * ((C35 - C40) * AVGV5.35 + 6 / 7 * ((C40 - C45) * AVGV5.40 + 6 / 7 * ((C45 - C50) * AVGV5.45 + 6 / 7 * ((C50 - C55) * AVGV5.50 + 6 / 7 * ((C55 - C60) * AVGV5.55 + 6 / 7 * ((C60 - C65) * AVGV5.60 + 6 / 7 * ((C65 - C70) * AVGV5.65 + 6 / 7 * ((C70 - C75) * AVGV5.70 + 6 / 7 * ((C75 - C80) * AVGV5.75 + 6 / 7 * ((C80 - C85) * AVGV5.80 + 6 / 7 * ((C85 - C90) * AVGV5.85 + 6 / 7 * ((C90 - C95) * AVGV5.90 + 6 / 7 * ((C95 - C100) * AVGV5.95 + 6 / 7 * ((C100 - C105) * AVGV5.100 + 6 / 7 * ((C105 - C110) * AVGV5.105 + 6 / 7 * ((C110 - C115) * AVGV5.110 + 6 / 7 * ((C115 - C120) * AVGV5.115 + 6 / 7 * ((C120 - C125) * AVGV5.120 + 6 / 7 * ((C125 - C130) * AVGV5.125 + 6 / 7 * ((C130 - C135) * AVGV5.130 + 6 / 7 * ((C135 - C140) * AVGV5.135 + 6 / 7 * ((C140 - C145) * AVGV5.140 + 6 / 7 * ((C145 - C150) * AVGV5.145 + 6 / 7 * ((C150 - C155) * AVGV5.150 + 6 / 7 * ((C155 - C160) * AVGV5.155 + 6 / 7 * ((C160 - C165) * AVGV5.160 + 6 / 7 * ((C165 - C170) * AVGV5.165 + 6 / 7 * ((C170 - C175) * AVGV5.170 + 6 / 7 * ((C175 - C180) * AVGV5.175 + 6 / 7 * ((C180 - C185) * AVGV5.180 + 6 / 7 * ((C185 - C190) * AVGV5.185 + 6 / 7 * ((C190 - C195) * AVGV5.190 + 6 / 7 * ((C195 - C200) * AVGV5.195 + 6 / 7 * ((C200 - C205) * AVGV5.200 + 6 / 7 * ((C205 - C210) * AVGV5.205 + 6 / 7 * ((C210 - C215) * AVGV5.210 + 6 / 7 * ((C215 - C220) * AVGV5.215 + 6 / 7 * ((C220 - C225) * AVGV5.220)))))))))))))))))))))))))))))))))))))))))))))
The third issue is a result of the dramatic fluctuations that can occur in Volume and how these dramatic fluctuations can affect the result of an Exponential Moving Average calculated using differing amounts of data. You can demonstrate this for yourself by creating the Custom Indicator in the top chart and Zooming all the way in to Zoom 9. When you bring up the Data Box in Pointer Mode and Zoom out, you can watch the Value change at each Zoom all the way out to Zoom 1++. The same thing will happen as you add or remove terms to the provided formula. Even if they used the exact same number of bars of data, the result would vary due to differences in the way the formula is initialized versus the way charted EMAs are initialized. This effect would disappear if both the charts and formula used "enough" data, but there are issues of practicality to consider. This is especially true for Weekly Personal Criteria Formulas because PCFs will not calculate at all if more date is required to calculate the PCF than is actually available for the symbol.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (bustermu) Whether one uses average volume or total volume in Weekly Force Index does not matter nor does the 71.4... factor. If one uses Force Index in such a fashion that scale matters, they will have misused the indicator. Right?
Perhaps (the chart will certainly look the same either way), but trainers cannot give settings, interpretation or investment advice. Maybe they aren't looking at fluctuations in the the Force Index at all, but are using it as a My Universe type condition to filter out stocks with low prices and volume that aren't in a significant trend. Is this a misuse of the Force Index? Are there better ways to do this? As a trainer, I can't answer either question. One thing I do know is that customers frequently wish to compare TeleChart's results to other sources, and in that case, scale matters (as would other issues I have no control over, such as 5 day versus calendar based Weekly charts). To Eternum, the differences in the values returned by my Personal Criteria Formula and his Custom Indicator were certainly problematic.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/6/2005
Posts: 40
|
Got it. Average Volume version gives me 7,140.86 vs 7,135.18 (indicator value on weekly, USG), which is close enough.
Appreciate your help.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |