Decimal places in screener

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #9553 quote
    Sam Macy
    Participant
    Junior

    Hi.

    How do I turn a number such as 34.0097 in my screener criteria into an integer or just rounded by 1 decimal place?

     

    Also, if I want to compare a price to a range, say, over the previous 10 trading days how would I use the RANGE[n] function correctly?

    Thanks.

    #9556 quote
    Nicolas
    Keymaster
    Master

    Hi,
    For your first question you can use ROUND instruction that will round your decimal number to the nearest superior value.

    About finding a range of 10 days in the past, you can find it with the HIGHEST and LOWEST instructions, please have a look into the online documentation.

    Finding the highest high and lowest low of the last n days is like compiling the last n candlesticks into a biggest one, so you get your range.

    #9557 quote
    Sam Macy
    Participant
    Junior

    Thanks.

    So to round up this to 1 decimal place:

    Percent = ((EMA10-EMA60)/close)

    it’d be…

    Percent = ((EMA10-EMA60)/close) ROUND(1)

    #9609 quote
    Nicolas
    Keymaster
    Master

    No the syntax would be:

    Percent = ROUND((EMA10-EMA60)/close)

    But you cannot round up in decimal, only in entire number, sorry.

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

Decimal places in screener


ProScreener: Market Scanners & Detection

New Reply
Author
author-avatar
Sam Macy @iainhmclean Participant
Summary

This topic contains 3 replies,
has 2 voices, and was last updated by Nicolas
9 years, 8 months ago.

Topic Details
Forum: ProScreener: Market Scanners & Detection
Language: English
Started: 06/19/2016
Status: Active
Attachments: No files
Logo Logo
Loading...