Daily MA7 on smaller timeframe

• 04/08/2019 at 3:45 PM #95729
  stefou102

  Hello I’m looking to code a daily  moving average(7)  on my intraday chart. I know there has been already topics on that in the past, but the particularity here is that I would like to take the closing price of a particular time, ie 17h35 for the Dax for example, corresponding to the cash close.  Any idea how to navigate with the past dates, and avoid the problem with the weekend, the new month etc??

   

  

  stefou102

  Participant

  Topics: 22

  Replies: 171

  Been thanked: 71 times
  04/08/2019 at 4:09 PM #95734
  Vonasi

  So you want a seven period average of the closing price at 1735?

  You could just store the last seven values at close of 1735 candle. Each time there is a new one drop one of the old ones and record the new one.

  Another alternative is to code a dummy MTF strategy and then use GRAPHONPRICE to draw it on your intraday chart.

  I’m not sure what weekend or change of month issues you see happening?

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  04/08/2019 at 4:19 PM #95735
  Vonasi

  Here is the first idea:

  if time = 173500 then a = b b = c c = d d = e e = f f = g g = close endif if a <> 0 then ave = (a + b + c + d + e + f + g) / 7 else ave = undefined endif return ave

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

  if time = 173500 then a = b b = c c = d d = e e = f f = g g = close endif   if a <> 0 then ave = (a + b + c + d + e + f + g) / 7 else ave = undefined endif   return ave

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  04/08/2019 at 4:21 PM #95736
  stefou102

  “So you want a seven period average of the closing price at 1735?”

  Yes

  seems simple but I have some difficulties in my head to work with dates.

  If you compare Date in YYYYMMDD, then rolling month complicates a bit the calculation

  

  stefou102

  Participant

  Topics: 22

  Replies: 171

  Been thanked: 71 times
  04/08/2019 at 4:29 PM #95741
  Vonasi

  stefou102 wrote:

  seems simple but I have some difficulties in my head to work with dates. If you compare Date in YYYYMMDD, then rolling month complicates a bit the calculation

  I don’t understand. What do dates and months have to do with it? There is only one 1735 everyday unless you have a time machine!?

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  04/08/2019 at 4:43 PM #95747
  stefou102

  Sorry I made my comment before seeing your code idea. I didn’t know that it was that easy and dates weren’t needed.

  Idea is good, even though what is missing is to make it more dynamic by taking the value of today into consideration. So the 6 last closes at 17h35, and the seventh value is the most current one

  

  stefou102

  Participant

  Topics: 22

  Replies: 171

  Been thanked: 71 times
  04/08/2019 at 4:49 PM #95748
  stefou102

  So now I have a bit modified your code, I need to check if this is correct

   

  if time = 173500 and (currenttime<090000 or currenttime>173500) then a = b b = c c = d d = e e = f f = g g= close endif if time = 173500 and (currenttime>=090000 and currenttime< 173500) then a = b b = c c = d d = e e = f f = close endif if (currenttime>=090000 and currenttime< 173500) then g= close endif if a <> 0 then ave = (a + b + c + d + e + f + g) / 7 else ave = undefined endif return ave

  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

  if time = 173500 and (currenttime<090000 or currenttime>173500) then a = b b = c c = d d = e e = f f = g g= close endif if time = 173500 and (currenttime>=090000 and currenttime< 173500) then a = b b = c c = d d = e e = f f = close endif   if (currenttime>=090000 and currenttime< 173500) then g= close endif   if a <> 0 then ave = (a + b + c + d + e + f + g) / 7 else ave = undefined endif return ave

   

  

  stefou102

  Participant

  Topics: 22

  Replies: 171

  Been thanked: 71 times
  04/08/2019 at 5:02 PM #95749
  Vonasi

  Your conditions in lines 1 and 7 can never be met.

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  04/08/2019 at 5:03 PM #95750
  Vonasi

  Maybe you mean something like this?

  if time = 173500 then a = b b = c c = d d = e e = f f = close endif if a <> 0 then ave = (a + b + c + d + e + f + close) / 7 else ave = undefined endif return ave

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

  if time = 173500 then a = b b = c c = d d = e e = f f = close endif   if a <> 0 then ave = (a + b + c + d + e + f + close) / 7 else ave = undefined endif   return ave

   

  1 user thanked author for this post.

  stefou102

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  04/08/2019 at 5:26 PM #95752
  stefou102

  Indeed;)

  the price at 17h35 is the close price of the 17h30 candle on a 5min chart actually, so 17300 it should be for those who wish to use this little code snippet for scalping.

  

  stefou102

  Participant

  Topics: 22

  Replies: 171

  Been thanked: 71 times
  04/08/2019 at 5:41 PM #95753
  Vonasi

  Yes OPENTIME is the time a candle opens and TIME is the time it closes. So if you want the exact price at 1735 then you can use OPEN and OPENTIME or use CLOSE and TIME. Both should return the same value unless there is a gap in price between CLOSE and OPEN.

  In a strategy TIME is used more often as decisions are made at the candle close and trades opened at the next candle open. In indicators generally OPENTIME is of more use as on the fly analysis of a candle is carried out from the moment it opens.

  I still find that sometimes I have to just put the following indicator on a chart to clarify things in my head when coding stuff:

  return time as "time", opentime as "opentime"

  1	return time as "time", opentime as "opentime"

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
• Author
  Posts