ExponentialAverage – Map to Bloomberg

• 06/18/2019 at 10:25 AM #100947
  Paget76

  Hi all,

  I am trying to get my exponential moving average to return figures that map to those given by Bloomberg (with price tolerance, of course). I have the units set to 5 minutes (testing against DAX), and am running (for example) ExponentialAverage[100](Close). However, the results I am getting are different enough to be causing issues.

  One thought I had was that the PRT averages run for the last n units regardless of time, whereas I believe Bbg only run for values when the markets are open. I don’t know if there is a way around this.

  Another thought is simply that the underlying calculation is different, although that would surprise me.

  Has anyone had experience with this, or is able to give me some guidance?

  Many thanks,

  Richard

  

  Paget76

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  06/18/2019 at 12:07 PM #100951
  swapping

  This is it ?

  

  swapping

  Participant

  Topics: 10

  Replies: 97

  Been thanked: 38 times
  06/18/2019 at 12:47 PM #100953
  Vonasi

  Paget76 wrote:

  PRT averages run for the last n units regardless of time, whereas I believe Bbg only run for values when the markets are open.

  This is most likely your issue. Due to the lack of arrays in PRT coding the only way to get the same result would be to store the last 100 values in 100 different variables while the market is open and then store the latest value and shift all the previous variable values and forgetting the first one.

  Something like (except that this is just for an average with a lookback of 4 and just a simple average:

  if opentime >= 130000 and opentime < 220000 then a1 = a2 a2 = a3 a3 = a4 a4 = close endif average4 = (a1 + a2 + a3 + a4) / 4 return average4

  1 2 3 4 5 6 7 8 9 10

  if opentime >= 130000 and opentime < 220000 then a1 = a2 a2 = a3 a3 = a4 a4 = close endif   average4 = (a1 + a2 + a3 + a4) / 4   return average4

  Your question is more of an indicator question than a platform question so I have moved it to the ProBuilder forum.

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  06/19/2019 at 1:05 PM #101049
  Paget76

  Thanks – as someone from a programming background I do find the PRT language exasperatingly limited at times. It took me quite a while to realise that it didn’t allow text variables, which is just downright odd!

  Do you know what the code would be for an exponential moving average, as calculated by Bloomberg or by PRT?

  Also, would it work to limit the market times in the general template settings, as that seems to limit the values shown in the charts, which is presumably what the indicators are based on? I have tried to check, but I am having (unrelated) issues getting the detailed results window up for my probacktest…

  

  Paget76

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  06/19/2019 at 1:15 PM #101050
  robertogozzi

  Many features are missing, arrays, text, integer & date data types,

  Unfortunately they are not easy to support and it’s not likely we are gonna have them before long!

  You may try using these averages, setting their time range https://www.prorealcode.com/prorealtime-indicators/time-range-moving-averages-simple-exponential-weighted-trsma-trema-trwma/

  It could be a workaround.

  1 user thanked author for this post.

  Paget76

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17298

  Been thanked: 4135 times
  06/19/2019 at 1:36 PM #101052
  Paget76

  robertogozzi wrote:
  You may try using these averages, setting their time range https://www.prorealcode.com/prorealtime-indicators/time-range-moving-averages-simple-exponential-weighted-trsma-trema-trwma/

  Thanks – looks like it could be an answer. Not terribly efficient, but hopefully not enough to impact.

  

  Paget76

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
• Author
  Posts