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

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

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;

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 is converting the data to text , which sorts from the left.

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

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

addlabel is converting the data to text , which sorts from the left.

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.

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

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 "") + .....

### Not the exact question you're looking for?

Start a new thread and receive assistance from our community.

87k+ Posts
294 Online

## The Market Trading Game Changer

Join 2,500+ subscribers inside the useThinkScript VIP Membership Club
• Exclusive indicators
• Proven strategies & setups
• Private Discord community
• Exclusive members-only content
• Add-ons and resources
• 1 full year of unlimited support

### Frequently Asked Questions

What is useThinkScript?

useThinkScript is the #1 community of stock market investors using indicators and other tools to power their trading strategies. Traders of all skill levels use our forums to learn about scripting and indicators, help each other, and discover new ways to gain an edge in the markets.

How do I get started?

We get it. Our forum can be intimidating, if not overwhelming. With thousands of topics, tens of thousands of posts, our community has created an incredibly deep knowledge base for stock traders. No one can ever exhaust every resource provided on our site.

If you are new, or just looking for guidance, here are some helpful links to get you started.

What are the benefits of VIP Membership?