New version 17 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

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

Performance Price formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Trittrot
Posted : Thursday, April 20, 2017 10:49:21 AM
Registered User
Joined: 10/28/2012
Posts: 6

can anyone assist me with a formula to express the value in percentage terms of  current price above or below a moving average e.g. 50 day sma.  For illustration purposes at time of sending this message GLD is trading +3.04% above its 50 day & XME is trading -5.84% below its 50day.  I would then like to use the formula in a watchlist.  Any help appreciated

Bruce_L
Posted : Thursday, April 20, 2017 10:51:42 AM


Worden Trainer

Joined: 10/7/2004
Posts: 59,682

Please try the following Indicator Formula.

100 * (C / AVGC50 - 1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Trittrot
Posted : Thursday, April 20, 2017 11:13:08 AM
Registered User
Joined: 10/28/2012
Posts: 6

Bruce wow, just over 2 mins for the response thank you. Sorry it was such a dumb question on my part. At the risk of testing your patience, the result would look optically better to my eyes if the % sign was included in the dispayed result, and with no more that two decimal places.   Are you able to help with these also?

Bruce_L
Posted : Thursday, April 20, 2017 11:22:33 AM


Worden Trainer

Joined: 10/7/2004
Posts: 59,682

You should be able to click on the name of the WatchList Column and select Edit to adjust the WatchList Column. The Properties tab will have an option to adjust Decimal Places in v17. That said, there isn't a way to add the % sign.



-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.