Decimal places in screener

• 06/19/2016 at 9:16 AM #9553
  Sam Macy

  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.

  

  Sam Macy

  Participant

  Topics: 9

  Replies: 7

  Been thanked: 0 times
  06/19/2016 at 9:59 AM #9556
  Nicolas

  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.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  06/19/2016 at 10:17 AM #9557
  Sam Macy

  Thanks.

  So to round up this to 1 decimal place:

  Percent = ((EMA10-EMA60)/close)

  it’d be…

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

  

  Sam Macy

  Participant

  Topics: 9

  Replies: 7

  Been thanked: 0 times
  06/20/2016 at 4:51 PM #9609
  Nicolas

  No the syntax would be:

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

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

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

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
• Author
  Posts