New version 18 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 |

error in sorting column Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Monday, November 27, 2017 5:06:37 PM
Registered User
Joined: 3/10/2012
Posts: 322

Hi Bruce 

this below formula i m not getting values in watchlist to sort but i can see the value when i plot it as custom indicator is there something wrong with formula ?? or any other bug ?

((((C - C63) / C63) * .4) + (((C - C126) / C126) * .2) + (((C - C189) / C189) * .2) + (((C - C252) / C252) * .2)) * 100

 

thanks 

 

Dhiren

diceman
Posted : Monday, November 27, 2017 5:22:23 PM
Registered User
Joined: 1/28/2005
Posts: 6,048

On every symbol?

 

The PCF uses C252, so you need at least that much data.

 

 

 

Thanks

 

dhirenshah
Posted : Monday, November 27, 2017 6:45:39 PM
Registered User
Joined: 3/10/2012
Posts: 322

Thanks Diceman i get that but the stocks that have atleast C252 those should pop up in the sorting watchlist correct  ?? thats what i m not gettting in the watchlist so what is the error there

 

 

diceman
Posted : Monday, November 27, 2017 6:59:39 PM
Registered User
Joined: 1/28/2005
Posts: 6,048

I tried the PCF and it worked for me.

 

Thanks

 

dhirenshah
Posted : Monday, November 27, 2017 7:26:34 PM
Registered User
Joined: 3/10/2012
Posts: 322

You mean are u able to get the value as column in the watchlist or u plotting as pcf in custom indicator and thats where u see the value  ?? 

because i can see values when i plot on chart as custom indicator but values are not showing when adding to watchlist to sort that as a column 

thanks 

diceman
Posted : Monday, November 27, 2017 7:46:06 PM
Registered User
Joined: 1/28/2005
Posts: 6,048

Both the column and the plot.

(the plot is how I get it into the column,

click on it and move it to the watchlist)

 

Only symbols that dont have enough data wont display.

 

 

Thanks

 

Bruce_L
Posted : Tuesday, November 28, 2017 8:51:35 AM


Worden Trainer

Joined: 10/7/2004
Posts: 62,704

Please contact technical support.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Tuesday, November 28, 2017 10:50:28 AM
Registered User
Joined: 3/10/2012
Posts: 322

Thanks Bruce 

it seems there is a bug ... tech support not sure what's causing it but they helped me fix it .... 

Regards

 

Dhiren

Bruce_L
Posted : Tuesday, November 28, 2017 10:54:44 AM


Worden Trainer

Joined: 10/7/2004
Posts: 62,704

I don't know why it would be happening either. We don't seem to be able to reproduce it except in your profile.

The only major diffirence I see in the formula which you were using and the formula which works is the lack of decimal markers in the versions which works.

40 * C / C63 + 20 * C / C126 + 20 * C / C189 + 20 * C / C252 - 100

But if it is the decimal markers, it should have tested OK on our side even in your profile because the computer doing the testing would be using the . as the decimal marker (even if you aren't).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Tuesday, November 28, 2017 11:04:46 AM
Registered User
Joined: 3/10/2012
Posts: 322

haha haha I know I m Unique but i didn;t know i m that unique :)

thanks Anyways 

And Thanks Diceman 

Bruce_L
Posted : Tuesday, November 28, 2017 11:17:56 AM


Worden Trainer

Joined: 10/7/2004
Posts: 62,704

You're welcome.



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