How to format the watchlist

To format the values displayed in a watchlist is possible to a limited extent. All formatting must be done by writing custom thinkscript. So you cannot apply custom formatting to any of the built in columns. You must create a custom column to display your data, then apply the formatting within the code. There is only one tool provided in Thinkscript for formatting values and that is called AsText(). You can read about that here: http://tlc.thinkorswim.com/center/reference/thinkScript/Functions/Others/AsText.html

There is not a lot there. You can select 2 or 3 decimals places or you can display values as currency.

In order to display 1,000,000 as 1m. You need to take the actual value, multiply it by 0.000001, then concatenate the result with the letter “m”.  The problem is you have a value like 1,000,001 turn out like “1.000001M”. So you would also need to do some rounding. You also have to apply some mathematical gymnastics to address issues created by binary precision.

Have I talked you out of it yet?

Changing 15.05 to 15 is doable with simple rounding. Not a big deal there.

Replacing N/A with a blank should be possible. You simply check the return value using a function named IsNaN(your value here). If true, set to empty quotes “”.

Bottom line is, depending on what you want to do, it’s can be a lot of work. Be sure to check out the solution I provided in this post to get some ideas what is possible: https://www.hahn-tech.com/ans/changing-background-color-to-show-new-day-high-2-day-high/

Thanks Pete! But I can’t figure them out :-). I tried the following tests but all not work. Also, NumberFormat.TWO_DECIMAL_PLACES can’t change TWO into ONE or ZERO. Please help~

def a=reference VolumeAvg(length = 5);
plot a=if(IsNaN(a) then “” else a);
AddLabel(1, AsText(If(a>1000000) then a/1000000 + “M” else a)); (I changed + to ‘and’ or ‘.’ still not work);
how to do a round?

Took me a few hours, but here you go buddy


#Thinkorswim Watchlist Column Volume By Millions
#by DaveDoggyDogg 2019
plot x = (volume);
AddLabel (yes, + Round(x *.000001 , 1) + "M",color.white);


http://tos.mx/zokdvR