DYO: 3 day average on intra-day chart


Q:  Hello, I am trying to get a daily 3 bar simple moving average (offset by one day) onto an intraday chart (say 10 min) but am having difficulty. I tried making a 120 bar MA offset by 40 on a chart of the "day session only" but it doesn't work (there are 40 bars per day on a 10 min bond chart).

A:  This DYO will plot a 3 bar average of the daily close values on your intra-day chart.   It reads Yesterday's close on the 1st bar of today, and puts that in an array of 3 values that are averaged.   On the action of a new day, the array shifts rightward, and yesterday's close is added to the array which remembers the last 3 close values.

Template:  1298-3DayAve

In the picture Yesterday's Close is plotted by the thin red line on Line D.  Uncheck this box to remove the red line.

Line E is the average of 3 closes, and is the plot in the thicker blue line.  This is the value you wanted plotted.

Template:  1298-3DayAve


Last modified 1/17/08 5:56 PM