Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Dollar Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
couto7
Posted : Tuesday, January 17, 2017 7:56:06 PM
Gold Customer Gold Customer

Joined: 10/14/2004
Posts: 202

Isolate the Dollar's movement only, DXY0, and write a PCF when the dollar crosses below its 7-week EMA and PCF when it crosses above its 7-week EMA. -Thanks

Bruce_L
Posted : Wednesday, January 18, 2017 11:36:40 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There really isn't a way to specify DXY0 in a formula. You would just need to use the condition on a weekly chart as a Custom Indicator. The following would be crossing up.

C > XAVGC7 AND C1 <= XAVGC7.1

And the following would be crossing down.

C < XAVGC7 AND C1 >= XAVGC7.1

If you want to create a Personal Criteria Formula to use in an EasyScan or as a WatchList Column, you would need to create a daily PCF to approximate the weekly results for TC2000 v7. The crossing up formula could be written as follows.

C > .25018828 * (C5 + .75 * (C10 + .75 * (C15 + .75 * (C20 + .75 * (C25 + .75 * (C30 + .75 * (C35 + .75 * (C40 + .75 * (C45 + .75 * (C50 + .75 * (C55 + .75 * (C60 + .75 * (C65 + .75 * (C70 + .75 * (C75 + .75 * (C80 + .75 * (C85 + .75 * (C90 + .75 * (C95 + .75 * (C100 + .75 * (C105 + .75 * (C110 + .75 * (C115 + .75 * (C120 + .75 * (C125))))))))))))))))))))))))) AND C5 <= .25018828 * (C10 + .75 * (C15 + .75 * (C20 + .75 * (C25 + .75 * (C30 + .75 * (C35 + .75 * (C40 + .75 * (C45 + .75 * (C50 + .75 * (C55 + .75 * (C60 + .75 * (C65 + .75 * (C70 + .75 * (C75 + .75 * (C80 + .75 * (C85 + .75 * (C90 + .75 * (C95 + .75 * (C100 + .75 * (C105 + .75 * (C110 + .75 * (C115 + .75 * (C120 + .75 * (C125 + .75 * (C130)))))))))))))))))))))))))

With the crossing down fomula being the following.

C < .25018828 * (C5 + .75 * (C10 + .75 * (C15 + .75 * (C20 + .75 * (C25 + .75 * (C30 + .75 * (C35 + .75 * (C40 + .75 * (C45 + .75 * (C50 + .75 * (C55 + .75 * (C60 + .75 * (C65 + .75 * (C70 + .75 * (C75 + .75 * (C80 + .75 * (C85 + .75 * (C90 + .75 * (C95 + .75 * (C100 + .75 * (C105 + .75 * (C110 + .75 * (C115 + .75 * (C120 + .75 * (C125))))))))))))))))))))))))) AND C5 >= .25018828 * (C10 + .75 * (C15 + .75 * (C20 + .75 * (C25 + .75 * (C30 + .75 * (C35 + .75 * (C40 + .75 * (C45 + .75 * (C50 + .75 * (C55 + .75 * (C60 + .75 * (C65 + .75 * (C70 + .75 * (C75 + .75 * (C80 + .75 * (C85 + .75 * (C90 + .75 * (C95 + .75 * (C100 + .75 * (C105 + .75 * (C110 + .75 * (C115 + .75 * (C120 + .75 * (C125 + .75 * (C130)))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.