How can I sort percentage ascending or descending on the following code? Appreciate your help.

[Qadeer]

Def openPrice = if secondstilltime(930) == 0 then open else openPrice[1];
def pctChangeFromOpen = (close - openPrice) / Openprice;

AddLabel (yes, AsPercent(pctChangeFromOpen),color.black);

 

[Qadeer]

Can somebody help with the following request please? I would like to sort the following code ascending or descending on my watchlist? It is not sorting properly.

Def openPrice = if secondstilltime(930) == 0 then open else openPrice[1];
def pctChangeFromOpen = (close - openPrice) / Openprice;

AddLabel (yes, AsPercent(pctChangeFromOpen),color.black);

 

[halcyonguy]

Can somebody help with the following request please? I would like to sort the following code ascending or descending on my watchlist? It is not sorting properly.

Def openPrice = if secondstilltime(930) == 0 then open else openPrice[1];
def pctChangeFromOpen = (close - openPrice) / Openprice;

AddLabel (yes, AsPercent(pctChangeFromOpen),color.black);

addlabel is converting the data to text , which sorts from the left.
you could add leading zeros...

or replace addlabel with a plot.
plot z = round(100*pctChangeFromOpen,1);

i'm guessing it needs the 100*...

 

[Qadeer]

addlabel is converting the data to text , which sorts from the left.
you could add leading zeros...

or replace addlabel with a plot.
plot z = round(100*pctChangeFromOpen,1);

i'm guessing it needs the 100*...

Thank you so much. It works.

 

[halcyonguy]

Def openPrice = if secondstilltime(930) == 0 then open else openPrice[1];
def pctChangeFromOpen = (close - openPrice) / Openprice;

AddLabel (yes, AsPercent(pctChangeFromOpen),color.black);

if you want to have text in a column, and have a number as the first few characters, you may need to add leading zeros for it to sort correctly.
text sorts left to right. numbers sort right to left.

look at this to see how i used several if statements, each in parenthesis, to decide if a leading character was needed , 0 or a -
that study was dealing with positive and negative numbers, so it needed a leading zero if the number was < 10 and > -10.

addlabel( 1 , (if (ChangefromOpen < 10 and ChangefromOpen > -10) then "0" else "") + .....

https://usethinkscript.com/threads/sorting-custom-watch-list-column.6181/#post-80536