Divide by Zero issues

• 12/14/2020 at 10:50 AM #153652
  Monobrow

  Hi

  My system is stopping every Sunday night at 2305 without fail. It works the rest of the week. The reason if gives me is more or less a divide by zero error. I believe the reason is because there is not sufficent data (previous bars) in order for me to make the required calculation.

  The code I am using is along the lines of

  Gap = Close-CustomClose[1]

  IF <indicator> and GAP <= 21 THEN

  Etc etc

   

  I believe at certain times Gap is not able to return a value so the system fails. Is there a way to code around this? something along the lines of:

   

  If Gap = Null/Error then do nothing Else carry on etc?

  Hope this makes sense as I kind of new to ccoding.

   

  thanks!

  

  Monobrow

  Participant

  Topics: 15

  Replies: 157

  Been thanked: 23 times
  12/14/2020 at 11:09 AM #153657
  GraHal

  Try …

  Gap = max(1, Close-CustomClose[1])

  1	Gap = max(1, Close-CustomClose[1])

   

  1 user thanked author for this post.

  Monobrow

  

  GraHal

  Participant

  Topics: 222

  Replies: 9290

  Been thanked: 2460 times
  12/14/2020 at 11:11 AM #153658
  robertogozzi

  You can try this to make sure it’s never 0:

  Gap = Close-CustomClose[1]) + 0.000001

  1	Gap = Close-CustomClose[1]) + 0.000001

  this small amount shouldn’t affect your performance (but you can increase or decrease it).

  You can also write it as:

  Gap = Close-CustomClose[1] IF Gap = 0 THEN Gap = 0.000001 ENDIF

  1 2 3 4

  Gap = Close-CustomClose[1] IF Gap = 0 THEN    Gap = 0.000001 ENDIF

   

  1 user thanked author for this post.

  Monobrow

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 18046

  Been thanked: 4612 times
  12/14/2020 at 11:13 AM #153659
  robertogozzi

  @GraHal

  that works with positive numbers, but in this case the gap can be negative and your code could change it quite a bit!

   

  2 users thanked author for this post.

  Monobrow, GraHal

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 18046

  Been thanked: 4612 times
  12/14/2020 at 11:19 AM #153663
  Monobrow

  Doh!, yes, that seems so intuitive and obvious (now I see it!).

  Thank you so very much, I will try these out.

  

  Monobrow

  Participant

  Topics: 15

  Replies: 157

  Been thanked: 23 times
  12/14/2020 at 11:21 AM #153664
  GraHal

  Monobrow wrote:

  now I see it!).

  Must have been that monobrow obstructing your vision! 🙂  (sorry couldn’t resist! 🙂 )

  1 user thanked author for this post.

  JC_Bywan

  

  GraHal

  Participant

  Topics: 222

  Replies: 9290

  Been thanked: 2460 times
  12/14/2020 at 12:58 PM #153677
  Monobrow

  GraHal wrote:

  Monobrow wrote:

  now I see it!).

  Must have been that monobrow obstructing your vision! 🙂 (sorry couldn’t resist! 🙂 )

  Haha, I guess i deserved that! 😬

  1 user thanked author for this post.

  GraHal

  

  Monobrow

  Participant

  Topics: 15

  Replies: 157

  Been thanked: 23 times
• Author
  Posts