Monthly close>Monthly Open

• 11/07/2020 at 3:14 PM #149778
  korivijay

  How to find our monthly close > monthly Open for the screener.

  I am trying to add this condition in to my screener as we have max Weekly timeframe available in the screener. Could anyone help me to get code for this condition.

  

  korivijay

  Participant

  Topics: 1

  Replies: 0

  Been thanked: 0 times
  11/07/2020 at 3:31 PM #149782
  robertogozzi

  Try this (not tested):

  IF Month <> Month[2] THEN PrevMonthOpen = MonthOpen PrevMonthClose = close[2] MonthOpen = open[1] ENDIF MonthClose = close

  1 2 3 4 5 6

  IF Month <> Month[2] THEN    PrevMonthOpen  = MonthOpen    PrevMonthClose = close[2]    MonthOpen      = open[1] ENDIF MonthClose        = close

  MonthOpen and MonthClose retain the current month’s values, while PrevMonthOpen and PrevMonthClose retain the previous month’s values.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16469

  Been thanked: 3643 times
  01/20/2021 at 7:58 AM #158620
  Andrea

  Very interesting. Two questions: Is it possible to create a screener with the various sectors of the Italian stock exchange and the end or beginning of the month to evaluate the different performances? Still, is it possible to export the historical data of a service? Thanks

  

  Andrea

  Participant

  Topics: 18

  Replies: 39

  Been thanked: 1 time
  01/20/2021 at 9:36 AM #158629
  robertogozzi

  @Andrea

  • Only post in the language of the forumthat you are posting in. For example English only in the English speaking forums and French only in the French speaking forums.

  As to your question, no it isn’t.

   

  1 user thanked author for this post.

  Andrea

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16469

  Been thanked: 3643 times
• Author
  Posts