Determine a specific day

• 08/04/2017 at 8:59 AM #42471
  Business Trader Pro

  Hi guys,

  is there a way to retrieve a specific day of the year? For example: My indicator should show me the 01.04.2017 and the 02.07.2017 with backgroundcolor.

  I need this because my trading system should rebalance my positions quarterly.

   

  Thanks in advance

  Business Trader

  

  Business Trader Pro

  Participant

  Topics: 3

  Replies: 7

  Been thanked: 1 time
  08/04/2017 at 2:43 PM #42481
  robertogozzi

  You may try this piece of code (I tested it, but I am not sure that’s what you want):

  IF Month = 1 OR Month = 4 OR Month = 7 OR Month = 10 THEN //only 1st month of each quarter FOR I = 0 TO 6 //scan a whole week to check it's FOREX time IF Day = i AND DayOfWeek = 2 THEN //only color the first Monday backgroundcolor(173,255,47,128) //Green Yellow (255,128,64,32 or 0 in the 4th group of numbers is the FADE gradient, 255=max 0=invisible) break //if found then skip any further check ENDIF NEXT ENDIF RETURN

  1 2 3 4 5 6 7 8 9

  IF Month = 1 OR Month = 4 OR Month = 7 OR Month = 10 THEN  //only 1st month of each quarter    FOR I = 0 TO 6                                          //scan a whole week to check it's FOREX time       IF Day = i AND DayOfWeek = 2 THEN                    //only color the first Monday          backgroundcolor(173,255,47,128)                   //Green Yellow (255,128,64,32 or 0 in the 4th group of numbers is the FADE gradient, 255=max 0=invisible)          break                                             //if found then skip any further check       ENDIF    NEXT ENDIF RETURN

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17148

  Been thanked: 4037 times
  08/10/2017 at 3:24 PM #42938
  Business Trader Pro

  Thx Roberto,

  il will give it a try and let you know about the results.

   

  Greets from Italy to Italy 😉

  

  Business Trader Pro

  Participant

  Topics: 3

  Replies: 7

  Been thanked: 1 time
  08/10/2017 at 4:44 PM #42946
  Business Trader Pro

  I tried your code with following results:

  It shows me (plus/minus) the first monday of each month. The goal should be to fetch every first trading day (not saturday or sunday) of the quarter.

  Any solutions?

   

  Many regards

  Tradewolf

   

  

  Business Trader Pro

  Participant

  Topics: 3

  Replies: 7

  Been thanked: 1 time
  08/10/2017 at 6:42 PM #42952
  robertogozzi

  I tried this one:

  ONCE DayFound = 1 IF Month <> Month[1] THEN DayFound = 0 ENDIF IF Month = 1 OR Month = 4 OR Month = 7 OR Month = 10 THEN IF ((DayOfWeek = 1) OR (DayOfWeek = 2) OR (DayOfWeek = 3) OR (DayOfWeek = 4) OR (DayOfWeek = 0)) AND (DayFound = 0) THEN backgroundcolor(173,255,47,255) DayFound = 1 ENDIF ENDIF RETURN

  1 2 3 4 5 6 7 8 9 10 11

  ONCE DayFound = 1 IF Month <> Month[1] THEN    DayFound = 0 ENDIF IF Month = 1 OR Month = 4 OR Month = 7 OR Month = 10 THEN    IF ((DayOfWeek = 1) OR (DayOfWeek = 2) OR (DayOfWeek = 3) OR (DayOfWeek = 4) OR (DayOfWeek = 0)) AND (DayFound = 0) THEN       backgroundcolor(173,255,47,255)       DayFound = 1    ENDIF ENDIF RETURN

  But it does not work as expected. I still cannot understand, for DAILY bars, what is returned bu DayOfWeek when the indicator is executed, the DAY of the closed BAR or the DAY of the bar which is opening?!

  And If I want to change the background it changes the nackground color of the opening bar, since the bar that is close has already been displayed on video, is it true?

  Only Nicolas can help us out! Thanks a lot!!!

   

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17148

  Been thanked: 4037 times
  08/10/2017 at 7:28 PM #42958
  JC_Bywan

  The following code should work, not just for standard quarters, but also even with a January 1st on a friday the code should/would pick monday Jan.4th instead of friday Jan.1st:

  If (OpenMonth=1 or Openmonth=4 or Openmonth=7 or Openmonth=10) and OpenDay<=4 and OpenDayOfWeek>=1 and OpenDayOfWeek<=5 and opendate-firstdayofquarter>3 then backgroundcolor(0,0,255) firstdayofquarter=OpenDate endif // choose only one of the following 2 return lines: // - the empty return line if wanting only backgroundcolor, // - or the second return line if wanting to read dates data in yyyymmdd format return //return firstdayofquarter as "first day of quarter"

  1 2 3 4 5 6 7 8 9 10 11

  If (OpenMonth=1 or Openmonth=4 or Openmonth=7 or Openmonth=10) and OpenDay<=4 and OpenDayOfWeek>=1 and OpenDayOfWeek<=5 and opendate-firstdayofquarter>3 then   backgroundcolor(0,0,255)   firstdayofquarter=OpenDate endif   // choose only one of the following 2 return lines: // - the empty return line if wanting only backgroundcolor, // - or the second return line if wanting to read dates data in yyyymmdd format   return //return firstdayofquarter as "first day of quarter"

   

  4 users thanked author for this post.

  Bel, robertogozzi, Business Trader Pro, Derek

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2651

  Been thanked: 916 times
  08/11/2017 at 12:56 PM #43026
  Business Trader Pro

  Thanks Noobywan, this did the trick. “OpenDay” was new to me. Never used it.

  Regards

   

  

  Business Trader Pro

  Participant

  Topics: 3

  Replies: 7

  Been thanked: 1 time
• Author
  Posts