New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.

Rank by SMA50 Volume increase in Percentage

affolsa1
affolsa1 ✭
in Scanning
I would like to include a column in the scan result, which shows me the SMA50 Volume increase in Percentage. I have tried to use the following:

rank by (((SMA(50,Daily Volume) - Volume) / Volume) * 100)

It gives me always an error like Your scan syntax is incorrect. Could not parse ""

Thanks for your Help.

Sascha

Answers

  • markd
    markd mod
    This seems to do it. Parentheses are used only for functions. To group terms, use brackets as you would parentheses.

    rank by [ [SMA(50,Daily Volume) - Volume] / Volume] * 100
  • affolsa1
    affolsa1 ✭
    Thanks. That works fine, juts had to change the ordering slightly so that the result is correct:
    rank by [ [Volume-SMA(50,Daily Volume)] / SMA(50,Daily Volume)] * 100

    Is there also a clause available to name a column rather than appearing the calculation as a column header?
  • markd
    markd mod
    That would be nice, but none that I know of.

Categories