How to create 20 day average volume column

[Scotty123]

I added a column to display the 20 day average volume with the code "plot avg = round(average(volume, 20), 0);".

I want the values to be integers (no decimal points) and no scientific notation for numbers >= 10,000,000, but that is not currently the case.

Also, Ideally I would like each value to be comma separated, but having them sortable is more important.

Can anyone help?

Thanks!

 

[rad14733]

@Scotty123 Unfortunately, you can't have everything you want... Thinkscript simply doesn't have the right Functions to display a number with comma's, no decimal points, and no dollar sign... The available Functions are AsDollars(), AsPercent(), AsPrice(), and AsText()... Those plus the Round() Function are pretty much all we have to work with, aside from Concat()... If you play around with those you should be able to come up with an acceptable solution... TOS doesn't have String Functions other than a few of the ones that I've mentioned...

 

[Scotty123]

Thanks, @rad14733

If I change the code as below, I get everything I want EXCEPT the sort is a string sort, not a numeric sort.

Not sure why AddLabel adds the commas, but it does.

def avgvol = Round(average(volume, 20), 0);
AddLabel(yes, avgvol);
plot out = avgvol;

 

[rad14733]

Thanks, @rad14733

If I change the code as below, I get everything I want EXCEPT the sort is a string sort, not a numeric sort.

Not sure why AddLabel adds the commas, but it does.

def avgvol = Round(average(volume, 20), 0);
AddLabel(yes, avgvol);
plot out = avgvol;

Hey, give it a whirl and see how that simple solution works for you... Simpler is better... All we can do is experiment to get as close to what we want that also works reliably... I tested it and it seems to be a viable solution...

 

[halcyonguy]

Thanks, @rad14733

If I change the code as below, I get everything I want EXCEPT the sort is a string sort, not a numeric sort.

Not sure why AddLabel adds the commas, but it does.

def avgvol = Round(average(volume, 20), 0);
AddLabel(yes, avgvol);
plot out = avgvol;

you only need 1 output function in a column, plot or addlabel

a link to a couple studies that add characters in front of data, so text sorting works like number sorting
https://usethinkscript.com/threads/combine-plot-and-round.16694/#post-132761

 

[rad14733]

you only need 1 output function in a column, plot or addlabel

a link to a couple studies that add characters in front of data, so text sorting works like number sorting
https://usethinkscript.com/threads/combine-plot-and-round.16694/#post-132761

Good catch...

@Scotty123 Either method can be colored for trend change if desired... I can post examples if needed...