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

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

  • 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
  • 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?
  • That would be nice, but none that I know of.
Sign In or Register to comment.