Calculate no. of bars from a specific date and time

• 08/24/2024 at 2:10 AM #236666
  Madokin

  Hi,

  I am seeking help with code to calculate the number of bars from a specific date and time. For example, on an hourly chart, I would like to calculate the number of bars since 10am on 23 May 2024.

  Thanks,

  Madokin

  

  Madokin

  Participant

  Topics: 1

  Replies: 1

  Been thanked: 0 times
  08/24/2024 at 6:57 AM #236667
  JS

  Hi,

  Try this one:

   

  myNumberOfBars

  myDate=20240523 myHour=10 If Date=myDate and OpenHour=myHour then myBarIndex=BarIndex EndIf myNumberOfBars=BarIndex-myBarIndex Return myNumberOfBars

  1 2 3 4 5 6 7 8 9 10

  myDate=20240523 myHour=10   If Date=myDate and OpenHour=myHour then myBarIndex=BarIndex EndIf   myNumberOfBars=BarIndex-myBarIndex   Return myNumberOfBars

  2 users thanked author for this post.

  Madokin, druby

  

  JS

  Participant

  Topics: 26

  Replies: 1701

  Been thanked: 768 times
  08/24/2024 at 7:30 AM #236668
  druby

  Hi,

  or this:

   

  myDate = 20240523 myTime = 100000 condition = ((opendate = myDate) and (opentime = myTime)) bars = barssince(condition,0) return bars

  1 2 3 4 5 6 7 8

  myDate = 20240523 myTime = 100000   condition = ((opendate = myDate) and (opentime = myTime))   bars = barssince(condition,0) return bars

  2 users thanked author for this post.

  Madokin, JS

  

  druby

  Participant

  Topics: 1

  Replies: 348

  Been thanked: 261 times
  08/25/2024 at 7:19 AM #236696
  Madokin

  Thank you druby and JS for your help.

  I had success with druby’s solution, although I had to adjust the result by adding 24 (working on an hourly chart)…so I’m wondering if it’s counting barssince the next opentime after the end of the opendate? It’s an easy adjustment for me to make, I was just interested to understand the logic.

  

  Madokin

  Participant

  Topics: 1

  Replies: 1

  Been thanked: 0 times
• Author
  Posts