IsUp – What, How, How Many, etc.?

Optuma Forums Optuma General Discussion IsUp – What, How, How Many, etc.?

Tagged: ,

  • This topic has 2 replies, 2 voices, and was last updated 1 month ago by Raaj.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #69179
    Raaj
    • Topics: 3
    • Replies: 4
    • Posts: 7

    Hi Folks,

    Where can I find the details around how the IsUp (and IsDown) operators function?  How do they work, what are the rules, how does it calculate the “slope” and what are the ranges that define True, False, etc.?

    Grateful for any pointers to the details.

    Warm Regards,
    -raaj

    • This topic was modified 1 month ago by Raaj.
    #69185
    Darren
    • Topics: 71
    • Replies: 880
    • Posts: 951

    Hi Raaj,

    It simply looks at the preceding value and if it’s higher then IsUp will return a true value. Likewise,  MA(Bars=34) IsDown will be true if today’s 34 period MA is lower than yesterday’s. There’s no range so if the difference is -0.00001 then IsDown would be true. However, you can use the ROUND() function set to 2 decimals to prevent this type or scenario:

    If you want to use a range then you would use a different calculation, eg for the EMA34 being 0.1% higher than the previous period for your definition of slope to be up:

    #69191
    Raaj
    • Topics: 3
    • Replies: 4
    • Posts: 7

    Terrific!  Thank you, Darren!  As always, your help is much appreciated.

    Warm Regards,
    -raaj

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest