| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 40
|
I would appreciate if someone would write the formula to use in creating a custom indicator for a 9-day average of the following:
Net Change
(C-C1)
One week percent change
((C-C5)/C5*100)
Close minus Open
(C-O)
Range Today: today's high minus today's low
(H-L)
Range Today: today's high minus today's low
ABS(H-L)
3-DAY AVG HIGH MINUS 3-DAY AVG LOW
AVGH3-AVGL3
Also, is there a difference in meaning between “average over last 9 days” and “9-day average”, or are they one of the same?
Thank you,
John
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (MarketReader) Also, is there a difference in meaning between "average over last 9 days" and "9-day average", or are they one of the same?
I would not normally see a difference as both are referring to a 9-day Moving Average. However, an "average over last 9 days" would seem to only apply to a 9-Period Simple Moving Average while a "9-day average" would seem to apply to other types of 9-Period Moving Averages as well.
QUOTE (MarketReader) I would appreciate if someone would write the formula to use in creating a custom indicator for a 9-day average of the following:
You did not specify if the Moving Average was Simple or Exponential, but if you are using these as Custom Indicators and not as Personal Criteria Formulas, I would suggest either adding a 9-Period Moving Average as a Child Indicator if you want both the original formula line and its Moving Average or creating the Custom Indicator with a Smoothing Period of 9 if you only want the Moving Average line.
You may wish to review the following:
Plotting Custom Indicators with Examples
Adding, removing and saving indicators to a chart template
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 40
|
Thank you Bruce
The video was informative and helpful. Craig touched upon my question when he talked about custom indicator for a range with a smoothing avg of 10.
I am still intersted in what the formula would look like, (without using child indicator or smoothing period) of a 9-day ma, simple of the following:
Net Change
(C-C1)
One week percent change
((C-C5)/C5*100)
Close minus Open
(C-O)
Close minus Open
ABS(C-O)
Range Today: today's high minus today's low
(H-L)
3-DAY AVG HIGH MINUS 3-DAY AVG LOW
AVGH3-AVGL3
I think it would benefit some users if Craig could add some of these examples to his "PCF Example Formulas" list, besides the ones for BOP and TSV.
Thank you again
John
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
Net Change:
AVGC9 - AVGC9.1
Although the following might give a better idea of what's actually happening:
(C - C9) / 9
One week percent change:
100 * (C / C5 + C1 / C6 + C2 / C7 + C3 / C8 + C4 / C9 + C5 / C10 + C6 / C11 + C7 / C12 + C8 / C13) / 9 - 100
Close minus Open:
AVGC9 - AVGO9
Close minus Open (absolute):
(ABS(C - O) + ABS(C1 - O1) + ABS(C2 - O2) + ABS(C3 - O3) + ABS(C4 - O4) + ABS(C5 - O5) + ABS(C6 - O6) + ABS(C7 - O7) + ABS(C8 - O8)) / 9
Range Today: today's high minus today's low:
AVGH9 - AVGL9
3-DAY AVG HIGH MINUS 3-DAY AVG LOW:
AVG(AVGH3,9) - AVG(AVGL3,9)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 40
|
Thank you Bruce
That's what I needed to see. especially how the 3-DAY AVG HIGH MINUS 3-DAY AVG LOW:
AVG(AVGH3,9) - AVG(AVGL3,9) was to be shown.
Please tell me if AVG(H-L, 3) is a valid formula for creating a PCF or in a Custom Indicator, and what it means.
I put it in a custom indicator and compared it to (H - L) 1 period, smoothing avg of 3. The two chart patterns did not coincide with each other and I don’t know what AVG(H-L, 3) is telling me. I appreciate if you have any thoughts.
Thank you
John
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (MarketReader) Please tell me if AVG(H-L, 3) is a valid formula for creating a PCF or in a Custom Indicator, and what it means.
It is not a valid formula. It is meaningless.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 40
|
Thank you again Bruce
I now know not to use it
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
 Gold Customer
Joined: 10/7/2004
Posts: 43
|
i have tried these suggestions and still not able to create a pcf that will 'equal' the MA line that i apply to the window.
i play a lot with momentum, e.g., c-c10, c-c25, etc., and apply MA's to those indicators. i also
like to look at how far away momentum travels from it MA, say 15.
so if i plot the custom indicator c-c20 and add a 15MA to that i get a line that i cannot duplicate by either
1) (c - c20)/15 or
2) AVGC15 - AVGC15.20
if i understand your formulas.
TX.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
mindspring,
If you are on a Daily Chart and have a 15-Period Simple Moving Average applied to a Custom Indicator with an Indicator Formula of C - C20 and a Smoothing Average of 1, AVGC15 - AVGC15.20 should match. If it does not, the most likely reason is that the Moving Average is Exponential. If this is the case, please try the following instead:
XAVGC15 - XAVGC15.20
You may wish to review the following:
Things to check if your moving averages don't "seem right" or "seem to match"
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |