Translating from Excel to PRC

• 07/30/2018 at 9:24 AM #77061
  DavHam

  Hi!

  Another trader shared an ATR (1) code to use as an intraday indicator that I really want to try out.

  However since I am a beginner at coding and PRC is the first “language” I am learning, I need help translating this from Excel to PRC. I appreciate any help!

  A1 = yesterdays close

  A2 = day high

  A3 = day low

  =IF(A1<A3;A2-A1;IF(A1>A2;A1-A3;A2-A3))

  

  DavHam

  Participant

  Topics: 4

  Replies: 4

  Been thanked: 2 times
  07/30/2018 at 12:55 PM #77072
  Vonasi

  I’m not big on Excel calculations but I think this is what it says. Apologies if I am wrong. If I am then I look forward to being corrected and to learn something!

  A1 = close[1]//yesterdays close A2 = high//day high A3 = low//day low IF A1 < A3 then a = A2 - A1 else if A1 > A2 then a = A1 - A3 else a = A2 - A3 endif endif return a

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

  A1 = close[1]//yesterdays close A2 = high//day high A3 = low//day low   IF A1 < A3 then a = A2 - A1 else if A1 > A2 then a = A1 - A3 else a = A2 - A3 endif endif   return a

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  08/06/2018 at 10:04 PM #77667
  CharlieByrd

  Did you get this to work? When i upload the code i get this result, if you have any tips please let me know!

  Thanks in advance 🙂

   

  

  CharlieByrd

  Participant

  Topics: 1

  Replies: 4

  Been thanked: 0 times
  08/06/2018 at 10:37 PM #77669
  Vonasi

  Don’t add it to your ‘price’ chart – add it as a separate indicator and you get something like this:

  

  What the values or the time frame are supposed to be or how you are supposed to analyse the results I don’t know. Maybe Davham can enlighten us?

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  08/07/2018 at 7:54 AM #77683
  JC_Bywan

  That’s the formula of the true range,  you could just use TR (keyword I discovered thanks to your question until then I thought the “average true range” over only 1 period was the only way to get it fast) and have the same result:

  x=TR(close) return x

  1 2 3

  x=TR(close)   return x

  If your next question was going to be how to program the average of this over say 14 periods for example, then you can use the averagetruerange keyword:

  x=AverageTrueRange[14](close) return x

  1 2 3

  x=AverageTrueRange[14](close)   return x

   

   

  1 user thanked author for this post.

  GraHal

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2652

  Been thanked: 919 times
  08/07/2018 at 8:31 AM #77684
  Vonasi

  Yes – I guess I should read the question where it clearly says it is the ATR[1] calculation – but as usual I was more interested in the coding problem to solve than the actual question…. and I already knew about the TR instruction! Oh well it is all good practice.

  This code confirms that all three return identical values – so the OP has three ways to choose from:

  c = averagetruerange[1] b = TR A1 = close[1]//yesterdays close A2 = high//day high A3 = low//day low IF A1 < A3 then a = A2 - A1 else if A1 > A2 then a = A1 - A3 else a = A2 - A3 endif endif return a as "Calculation",b as "TR",c as "ATR"

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

  c = averagetruerange[1] b = TR   A1 = close[1]//yesterdays close A2 = high//day high A3 = low//day low IF A1 < A3 then a = A2 - A1 else if A1 > A2 then a = A1 - A3 else a = A2 - A3 endif endif return a as "Calculation",b as "TR",c as "ATR"

   

  1 user thanked author for this post.

  DavHam

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  08/07/2018 at 9:53 AM #77694
  DavHam

  The trader who shared it with me uses it on an intraday futures chart to take trades. Not sure about the accuracy of it, that is really why I wanted to try it out.

  The code shows the correct value when you add it as an indicator, but is there any way to place it on top of the price like in the example below?

  A = Dhigh (0) B = Dlow (0) C = (A+B)/2 RETURN A, B, C

  1 2 3 4 5

  A = Dhigh (0) B = Dlow (0) C = (A+B)/2   RETURN A, B, C

   

  1 user thanked author for this post.

  CharlieByrd

  

  DavHam

  Participant

  Topics: 4

  Replies: 4

  Been thanked: 2 times
  08/07/2018 at 10:01 AM #77698
  CharlieByrd

  Hello Guys,

  So i have talked to the author of the original code, he is a known swedish daytrader.

  So this code is meant to be built in the chart(see the attachment).

  Blue line = OMX30 Intraday

  Grey line = ATR1 Daily (resolution) high & low

  Yellow = (ATR1 daily high-low)/2+ATR1 daily low.

  So when we spoke he mentioned that you must combine the daily chart ATR1 with intraday chart to make this possible.

  I hope i have all the information needed for you guys to look further if it is possible to code this in PRT.

  If you have questions i can contact the author because i would really love to see this work in PRT too!

  

  CharlieByrd

  Participant

  Topics: 1

  Replies: 4

  Been thanked: 0 times
• Author
  Posts