Volume Level

kgreenidge · 18 February 2025 10:57

I am using the following formulas in the worklist:

Vol MA(40):

MA(VOL(), BARS=40, CALC=Close)

Vol MA(100):

MA(VOL(), BARS=100, CALC=Close)

Volume():

Volume()

Volume()/Vol MA(100):

Volume()/(MA(VOL(), BARS=100, CALC=Close))

The result of this formula should result ins:

<0.25: Low Volume

1.5-2=High Volume

2 = Very High Volume

I have noticed that with the crypto stocks the Volume () data for the day is not matching what is showing in the chart when you hover over the last bar. Can you please have a look at why this is not working as the data is there but when it is used in the Worklist it is not correct.

I have also attached the worklist.

I am trying to have the Volume Level column show the correct results but I am unsure why it is not working.

Thanks.

DarrenH-Optuma · 19 February 2025 01:33

Everything matches in the example below, but if the watchlist value doesn’t match the chart then make sure the watchlist Date Range property is set to Last Year and not limited to a specific Date Range.

Your formula works, but of these 38 major coins only LTCUSD traded above its 100D MA yesterday (note that like forex, there’s no central exchange to report crypto trades, so volume data will vary between data providers, depending on where they get their data).