How can I plot different moving averages on Monthly/Daily/Weekly

• 06/12/2017 at 1:25 AM #38089
  prcolf

  Hi

  Could someone please tell me how to make an indicator that will recognise what timeframe  I am viewing and plot different moving averages. I have tried the following formula but after a lot of googling I’m not sure if this is possible in ProBuilder.

   

  Timeframe(month) RETURN ExponentialAverage[10](close) Timeframe(weekly) RETURN ExponentialAverage[40](close) Timeframe(daily) RETURN ExponentialAverage[10](close) RETURN ExponentialAverage[50](close) RETURN ExponentialAverage[200](close)

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

  Timeframe(month)   RETURN ExponentialAverage[10](close)   Timeframe(weekly)   RETURN ExponentialAverage[40](close)   Timeframe(daily)   RETURN ExponentialAverage[10](close) RETURN ExponentialAverage[50](close) RETURN ExponentialAverage[200](close)

   

  

  prcolf

  Participant

  Topics: 4

  Replies: 13

  Been thanked: 0 times
  06/12/2017 at 8:30 AM #38117
  Nicolas

  Not possible to use “timeframe” in ProBuilder.

  To automatically find on which timeframe you are on, you can try to use this code snippet, it will return the minutes quantity (120 for a 2 hours timeframe for instance).

  find timeframe of the current chart

  once NbBar = 1 if BarIndex < NbBar+2 then MyDay=openday dayminutes = 1440*(MyDay-MyDay[1]) MyHour=openhour hourminutes = 60*(MyHour-MyHour[1]) MyMin=openminute barminutes = MyMin - MyMin[1] + hourminutes + dayminutes barminutes=abs(barminutes) Mybarminutes = lowest[NbBar](barminutes)[1] endif return Mybarminutes as "Timeframe"

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

  once NbBar = 1   if BarIndex < NbBar+2 then MyDay=openday dayminutes = 1440*(MyDay-MyDay[1]) MyHour=openhour hourminutes = 60*(MyHour-MyHour[1]) MyMin=openminute barminutes = MyMin - MyMin[1] + hourminutes + dayminutes barminutes=abs(barminutes) Mybarminutes = lowest[NbBar](barminutes)[1] endif   return Mybarminutes as "Timeframe"

   

  1 user thanked author for this post.

  prcolf

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  06/12/2017 at 8:50 AM #38120
  prcolf

  Hi Nic

  Thanks for the help mate. I’ve only been using ProRealTime for a few days so I’m a bit green. I’m used to Amibroker and Metastock.

  How can I start writing the conditions based on that formula? Do I place that at the beginning of the formula and then start referencing to Timeframe?

  Alan

  

  prcolf

  Participant

  Topics: 4

  Replies: 13

  Been thanked: 0 times
  06/12/2017 at 11:00 AM #38129
  Pinny

  I use the following code to determine timeframe (daily/weekly/monthly)/ It is based on PRT’s time format: yyyymmdd (i.e. 20170612 for today) and bar-to-bar simple subtraction to detect the number of days between adjacent bars. The OR in each IF deal with weekends etc. This, of course, only work for swing trading

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif

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

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif

   

  2 users thanked author for this post.

  prcolf, Nicolas

  

  Pinny

  Participant

  Topics: 2

  Replies: 16

  Been thanked: 11 times
  06/13/2017 at 7:48 AM #38171
  prcolf

  Thanks Pinny

  I’m still having a bit of trouble. How many times can you add “Return” to an indicator. I’m getting an error and I’m not sure what to do.

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif If (a==100) Then RETURN ExponentialAverage[10](close) Elsif (a==30) Then RETURN ExponentialAverage[40](close) Else (a==1) Then RETURN ExponentialAverage[10](close) RETURN ExponentialAverage[50](close) RETURN ExponentialAverage[200](close) EndIf

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif       If (a==100) Then RETURN ExponentialAverage[10](close)   Elsif (a==30) Then RETURN ExponentialAverage[40](close)   Else (a==1) Then   RETURN ExponentialAverage[10](close) RETURN ExponentialAverage[50](close) RETURN ExponentialAverage[200](close)   EndIf

   

  

  prcolf

  Participant

  Topics: 4

  Replies: 13

  Been thanked: 0 times
  06/13/2017 at 8:19 AM #38177
  Nicolas

  You can only RETURN the variables once.

  You should have coded it like this:

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif If (a=100) Then ema1= ExponentialAverage[10](close) Elsif (a=30) Then ema1= ExponentialAverage[40](close) Else (a=1) Then ema1= ExponentialAverage[10](close) ema2= ExponentialAverage[50](close) ema3= ExponentialAverage[200](close) EndIf return ema1, ema2, ema3

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif     If (a=100) Then ema1= ExponentialAverage[10](close)   Elsif (a=30) Then ema1= ExponentialAverage[40](close)   Else (a=1) Then   ema1= ExponentialAverage[10](close) ema2= ExponentialAverage[50](close) ema3= ExponentialAverage[200](close)   EndIf   return ema1, ema2, ema3

  Please test it and tell us if it works! 🙂

  (there is not need to make double equal for testing like in other programming languages).

  1 user thanked author for this post.

  prcolf

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  06/13/2017 at 8:27 AM #38179
  prcolf

  Thanks Nic. I entered that code but I’m getting an error in line 26. Not sure why sorry.

   

  

  prcolf

  Participant

  Topics: 4

  Replies: 13

  Been thanked: 0 times
  06/13/2017 at 8:40 AM #38182
  Pinny

  I think its a EndIf issue, the following works:

   

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif If (a=100) Then ema1= ExponentialAverage[10](close) Else If (a=30) Then ema1= ExponentialAverage[40](close) Else If (a=1) Then ema1= ExponentialAverage[10](close) ema2= ExponentialAverage[50](close) ema3= ExponentialAverage[200](close) EndIf endIf endif return ema1, ema2, ema3

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif   If (a=100) Then   ema1= ExponentialAverage[10](close) Else If (a=30) Then   ema1= ExponentialAverage[40](close) Else If (a=1) Then   ema1= ExponentialAverage[10](close) ema2= ExponentialAverage[50](close) ema3= ExponentialAverage[200](close)   EndIf endIf endif   return ema1, ema2, ema3

   

  1 user thanked author for this post.

  prcolf

  

  Pinny

  Participant

  Topics: 2

  Replies: 16

  Been thanked: 11 times
  06/13/2017 at 8:43 AM #38183
  prcolf

  Thanks Pinny. I checked the manual and it seemed to use an Else for the last condition. Thanks heaps for the help. It works. After years of learning Amibroker and Metastock it seems I’m starting all over again!

  

  prcolf

  Participant

  Topics: 4

  Replies: 13

  Been thanked: 0 times
  06/13/2017 at 9:25 AM #38189
  prcolf

  Looks like there is still a small problem. It wasn’t plotting on the weekly when using “a=30″ so I changed it to ” a=7″ and it plots fine. The monthly was plotting fine but now that the weekly is set to “a=7” the monthly no longer plots

  

  prcolf

  Participant

  Topics: 4

  Replies: 13

  Been thanked: 0 times
  06/13/2017 at 9:43 AM #38193
  Nicolas

  >> For clarity of messages on ProRealCode’s forums, please use the “insert code PRT” button to separate the text of the code part! Thank you! <<

   

  1 user thanked author for this post.

  prcolf

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  06/13/2017 at 9:57 AM #38195
  prcolf

  Here is the whole formula. The monthly will not plot

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif If (a=100) Then ema1= ExponentialAverage[10](close) Elsif (a=7) Then ema1= ExponentialAverage[40](close) Elsif (a=1) Then ema1= ExponentialAverage[10](close) ema2= ExponentialAverage[50](close) ema3= ExponentialAverage[200](close) EndIf return ema1, ema2, ema3

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Weekly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Monthly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif If (a=100) Then ema1= ExponentialAverage[10](close) Elsif (a=7) Then ema1= ExponentialAverage[40](close) Elsif (a=1) Then ema1= ExponentialAverage[10](close) ema2= ExponentialAverage[50](close) ema3= ExponentialAverage[200](close) EndIf   return ema1, ema2, ema3

  There is also a vertical line at the beginning of the ema. I use valuewhen in metastock to hide that but that doesn’t seem to be available in Probuilder. Is there a way to hide it?

  HideEMA1 = 0.9*valuewhen(1,ema1<>0,ema1) ShowEMA1=If(ema1=0, HideEMA1, ema1)

  1 2	HideEMA1 = 0.9*valuewhen(1,ema1<>0,ema1) ShowEMA1=If(ema1=0, HideEMA1, ema1)

   

  

  prcolf

  Participant

  Topics: 4

  Replies: 13

  Been thanked: 0 times
  06/13/2017 at 10:17 AM #38199
  Pinny

  Sorry, this is my documentation mistake – 1/daily, 7/Weekly, 30/Monthly, 100/Quarterly, 200/Annual

  Just use a=30 and this will plot on the Monthly (tried it:-)

  If (date–date[1])=1 OR (date[1]–date[2])=1 Then

  a=1 // 1 signals Daily timeframe

  Endif

  If (date–date[1])=7 OR (date[1]–date[2])=7 Then

  a=7 // 7 signals Weekly timeframe

  Endif

  If (date–date[1])=99 OR (date[1]–date[2])=99 Then

  a=30 // 30 signals Weekly timeframe

  Endif

  If (date–date[1])=299 OR (date[1]–date[2])=299 Then

  a=100 // 100 signals Monthly timeframe

  Endif

  If (date–date[1])>9500 Then

  a=200 // 200 signals Annual timeframe

  Endif

  If (a=100) Then

  ema1= ExponentialAverage[10](close)

  Elsif (a=7) Then

  ema1= ExponentialAverage[40](close)

  Elsif (a=1) Then

  ema1= ExponentialAverage[10](close)

  ema2= ExponentialAverage[50](close)

  ema3= ExponentialAverage[200](close)

  EndIf

  return ema1, ema2, ema3

  1 user thanked author for this post.

  prcolf

  

  Pinny

  Participant

  Topics: 2

  Replies: 16

  Been thanked: 11 times
  06/13/2017 at 10:20 AM #38200
  Pinny

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Monthly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Quarterly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif If (a=100) Then ema1= ExponentialAverage[10](close) Elsif (a=7) Then ema1= ExponentialAverage[40](close) Elsif (a=1) Then ema1= ExponentialAverage[10](close) ema2= ExponentialAverage[50](close) ema3= ExponentialAverage[200](close) EndIf return ema1, ema2, ema3

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

  If (date-date[1])=1 OR (date[1]-date[2])=1 Then a=1 // 1 signals Daily timeframe Endif If (date-date[1])=7 OR (date[1]-date[2])=7 Then a=7 // 7 signals Weekly timeframe Endif If (date-date[1])=99 OR (date[1]-date[2])=99 Then a=30 // 30 signals Monthly timeframe Endif If (date-date[1])=299 OR (date[1]-date[2])=299 Then a=100 // 100 signals Quarterly timeframe Endif If (date-date[1])>9500 Then a=200 // 200 signals Annual timeframe Endif If (a=100) Then ema1= ExponentialAverage[10](close) Elsif (a=7) Then ema1= ExponentialAverage[40](close) Elsif (a=1) Then ema1= ExponentialAverage[10](close) ema2= ExponentialAverage[50](close) ema3= ExponentialAverage[200](close) EndIf return ema1, ema2, ema3

   

  1 user thanked author for this post.

  prcolf

  

  Pinny

  Participant

  Topics: 2

  Replies: 16

  Been thanked: 11 times
  06/13/2017 at 10:46 AM #38201
  prcolf

  Thanks for all of the help. Its all plotting correctly now. This isn’t a problem but I would just like to know if there is a way to hide the vertical lines at the start of the EMA.

  Is there a function that I can use?

   

  

  prcolf

  Participant

  Topics: 4

  Replies: 13

  Been thanked: 0 times
• Author
  Posts