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

column condition Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
tdj
Posted : Monday, June 26, 2017 12:49:25 PM
Registered User
Joined: 1/11/2015
Posts: 7

I have written and saved the following formula. c/avgc126>=1.2

I wish to sort all ETF's by this formula. When i do this, the column only shows a green checkmark showing this condition to be true. I want the column to show a numerical value. (ex. 1.29) How can I do this?

 

 

StockGuy
Posted : Monday, June 26, 2017 12:53:52 PM

Administration

Joined: 9/30/2004
Posts: 9,187

Drop the >= 1.2 if you want to see the value of C/AVGC126

tdj
Posted : Monday, June 26, 2017 2:27:02 PM
Registered User
Joined: 1/11/2015
Posts: 7

Ok thank you. That worked!  Now I want to show beneath a price chart, when the value does indeed reach 1.2 and higher.  How can I show this graphically below my price chart?  Thank you,

StockGuy
Posted : Monday, June 26, 2017 2:40:37 PM

Administration

Joined: 9/30/2004
Posts: 9,187

Add a Custom % True plot and use the following formula:

c/avgc126>=1.2

 

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.