Number of days between two dates

• 09/21/2016 at 10:30 AM #13452
  Stef

  Hi All,

  What is the easiest way to calculate the number of days between two dates in ProBuilder?

  If I have:

  startdate=01012008 curbardate=date

  1 2	startdate=01012008 curbardate=date

  How do I calculate the number of days between date and startdate?

  Regards

  

  Stef

  Participant

  Topics: 20

  Replies: 52

  Been thanked: 15 times
  09/21/2016 at 10:33 AM #13454
  Nicolas

  You can retrieve it easily in Daily timeframe while counting the barindex difference between these 2 dates.

  In other timeframes it would be tricky.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20828

  Been thanked: 4742 times
  09/21/2016 at 11:27 AM #13469
  Stef

  Tx. Let me try that.

  

  Stef

  Participant

  Topics: 20

  Replies: 52

  Been thanked: 15 times
  09/22/2016 at 7:04 AM #13521
  Stef

  Should have been:

  startdate=20080101

  1	startdate=20080101

   

  

  Stef

  Participant

  Topics: 20

  Replies: 52

  Been thanked: 15 times
  02/13/2021 at 8:03 PM #161330
  Vincent 3555

  In other than daily time frame, I use the fonction ” DAYS ” which return the number of days from 01/01/1900.

  If you use the DATE fonction it is difficult to extract the difference .

  Please find an example below

  Difference beetween 2 dates

  Indicator1 = Average [20] (close) // SMA of close if Close Crosses Over Indicator1 then // Close Crosses SMA FirstDateSignal = Days // First signal endif If Close Crosses Under Indicator1 then // close Crosses under SecondDateSignal = Days // Second Signal Endif Difference = SecondDateSignal - FirstDateSignal // the difference in REAL days, not traded days Return Difference

  1 2 3 4 5 6 7 8 9 10 11 12 13

  Indicator1 = Average  [20] (close)   // SMA of close   if Close Crosses Over Indicator1 then  // Close Crosses SMA FirstDateSignal =  Days                // First signal endif   If Close  Crosses Under Indicator1  then   // close Crosses under SecondDateSignal = Days                //   Second Signal Endif   Difference =  SecondDateSignal -  FirstDateSignal   // the difference in REAL days, not traded days   Return Difference

   

  

  Vincent 3555

  Participant

  Topics: 0

  Replies: 1

  Been thanked: 0 times
• Author
  Posts