Registered User
Joined: 4/9/2010
Posts: 1
|
Would you Please help with a program for the following:
This is what I want it to do and look like:
I want to take to the change in price from one day to the next and divide it by the current price to eliminate price bias. The result should be expressed as an absolute - whether the change is up or down is immaterial. Then I want to run a 10 day moving average of the data. I would like to Invert the data and use a Log scale so that it would equate easier to price. The highs in the APC tend to align with highs in a security, and vice versa.
Below is a formula that is used for this in another charting program - Metastock
Mov(Abs((C-Ref(C,-1))/C,10,Simple)
Thanks,
Greg
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:
If you are new to TeleChart READ THIS FIRST!
One way to write a formula for the 10-Period Moving Average of the Absolute Percent Change would be:
10 * (ABS(C / C1 - 1) + ABS(C1 / C2 - 1) + ABS(C2 / C3 - 1) + ABS(C3 / C4 - 1) + ABS(C4 / C5 - 1) + ABS(C5 / C6 - 1) + ABS(C6 / C7 - 1) + ABS(C7 / C8 - 1) + ABS(C8 / C9 - 1) + ABS(C9 / C10 - 1))
I'm really not quite sure what you mean by "Invert the data and use a Log scale". Two guesses follow:
LOG(1 / (ABS(C / C1 - 1) + ABS(C1 / C2 - 1) + ABS(C2 / C3 - 1) + ABS(C3 / C4 - 1) + ABS(C4 / C5 - 1) + ABS(C5 / C6 - 1) + ABS(C6 / C7 - 1) + ABS(C7 / C8 - 1) + ABS(C8 / C9 - 1) + ABS(C9 / C10 - 1)))
Or:
0 - LOG((ABS(C / C1 - 1) + ABS(C1 / C2 - 1) + ABS(C2 / C3 - 1) + ABS(C3 / C4 - 1) + ABS(C4 / C5 - 1) + ABS(C5 / C6 - 1) + ABS(C6 / C7 - 1) + ABS(C7 / C8 - 1) + ABS(C8 / C9 - 1) + ABS(C9 / C10 - 1)))
Plotting Custom Indicators with Examples
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|