 Gold Customer
Joined: 10/7/2004
Posts: 54
|
As of Friday’s close (9-21-18) the closing price of the SPY was 291.99. The Forecast Oscillator 17 on Stock Finder 4 was 0.39. I have tried (with your help) to create a Forecast Oscillator 17 in TC 20000. My reading on TC for the Forecast Oscillator 17 was 0.05. Below is the formula that I used to create the F.O 17:
100 * (C - (AVGC17.1 + 7.5 * (6.5 * C1 + 5.5 * C2 + 4.5 * C3 + 3.5 * C4 + 2.5 * C5 + 1.5 * C6 + .5 * C7 - .5 * C8 - 1.5 * C9 - 2.5 * C10 - 3.5 * C11 - 4.5 * C12 - 5.5 * C13 - 6.5 * C17) / 227.5)) / C
Can you tell me what I have done wrong and why the difference between SF 4 and TC2K?
Thank you in advance for your help
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The formula looks like it was for a 14 period forecast oscillator and then modified by just changing one instance of 17 to 13 instead (this will not work). Please try the following indicator formula instead.
100 * (1 - (27 * FAVGC17.1 - 19 * AVGC17.1) / 8 / C)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Gold Customer
Joined: 10/7/2004
Posts: 54
|
As always Bruce I am grateful for your help
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|