Time Template Problem

[AssetHound]

I have a daily SPY chart with a defined time template -- user defined, daily interval, 300days, auto start and end. I also have an intraday default defined for that same template -- 300 bars, 0600 start and 1800 end. I added the daily template after reading some of the posts about time templates.

A 200-day moving average on daily charts does not calculate correctly until I scroll back several months. It then seems to recalculate and the current average is correct.

I can't seem to determine why the average doesn't initially calculate correctly. Any help would be appreciated. Thanks.

[ACM]

Re: Time Template Problem

AssetHound
From what I am seeing the Time Template in the image you posted does not show an Intraday Default of 0600/1800 as you instead describe in your post.
You may want to try setting the chart interval to daily and then right click the Cursor Window and enable Show Bar Count so as to verify how many daily bars you are actually loading
Alex

Originally posted by AssetHound
I have a daily SPY chart with a defined time template -- user defined, daily interval, 300days, auto start and end. I also have an intraday default defined for that same template -- 300 bars, 0600 start and 1800 end. I added the daily template after reading some of the posts about time templates.

A 200-day moving average on daily charts does not calculate correctly until I scroll back several months. It then seems to recalculate and the current average is correct.

I can't seem to determine why the average doesn't initially calculate correctly. Any help would be appreciated. Thanks.

[AssetHound]

Alex,

When I right click the chart I don't see any option to view the bar count.

Sorry for the confusion on the intraday. The time template image is the correct image. When I wrote the post, I was looking at something else. Here's an example of what I get. The maroon line is the 200-day moving average. It is not correct.

Thanks.

[eSignal_AveryH]

Assethound,

To add the bar counts you'll need to right click on the chart go to Cursor-->Properties and add the check mark next to bar count.


I've added the 300 bars to my chart as well and its displays much like your charts. I've also exported the data did the calculation in excel to confirm the numbers are correct based on 300 bars. I can send it to you if you'd like.

What source are you using to compare the averages?

[AssetHound]

Avery,

On 2/5/2010, SPY bounced off the 200-day moving average exactly. On the chart I posted, you can see that the average is plotted well below the low for SPY that day (bar index -5) and, in fact, the calculated average was lower than the low for SPY. I confirmed that 300 bars were in fact loaded for the daily chart.

I changed the time template to the below settings and the average is now working as I expected it would and producing correct results (correct being what all other technical analysts calculated). I think I was under the assumption that the time template controlled what was shown on the chart but scripts actually used more data. They only use the data that is contained in the chart so, if I need a 200 day moving average and show 300 bars, I need to load a minimum of 500 bars. Correct?

Does that also mean that "dynamic" settings load and use as much data as needed by the chart AND the scripts?

I understand your point that the script was mathematically correct, but I was expecting something else. Thanks very much for your help. All things make sense in retrospect.