Question about dates of daily data
Author: snout_hound
Creation Date: 2/8/2009 1:10 PM
profile picture

snout_hound

#1
In the script that I am working on, I am printing out the following information.

weekly macd = 1.47691584432711 Date = 2/3/2009 12:00:00 AM
weekly macd = 1.47691584432711 Date = 2/4/2009 12:00:00 AM
weekly macd = 1.47691584432711 Date = 2/5/2009 12:00:00 AM
weekly macd = 1.37345083996251 Date = 2/6/2009 12:00:00 AM

I'm using the following PrintDebug command.

PrintDebug( "weekly macd = " + weekly_macd_hist[bar] + " Date = " + weekly_macd_hist.Date[bar] );

I thought I was understanding the dates until I thought about them more. What puzzles me is that the time during the day is noon. I was thinking that a weekly indicator like weekly macd would change after the market closed at the end of the week, in this case on Friday. So I was thinking that the daily time should be 4pm rather than noon. Am I missing something? Are the timestamps of data discussed somewhere in the documentation? I'm assuming this is not a local time issue because I am in Mountain Standard Time and so noon my time would be 2pm Eastern time which is again before the market closes at the end of the day/week.

Thanks,

Dave
profile picture

Eugene

#2
I used to think that:
QUOTE:
In the United States, noon is often called "12:00 p.m." and midnight "12:00 a.m.". With this convention, thinking of "12" as "0" makes the system completely logical.

And Wikipedia seconds this opinion:
12-hour clock

Anyway, you're not looking in the right direction. The "12:00:00 AM", or midnight, is the "absense" of time. With weekly data it is not applicable, thereby the time "field" is 0, aka 0:00 or 12:00:00 AM.
profile picture

snout_hound

#3
Thanks. I had been looking at my computer time. Anyway, I suppose the bottom line is that a week ends after the market closes on Friday, assuming Friday is not a holiday, and that is what my output above is telling me. So after the market closes on Friday, WL is able to add another week to the weekly macd calculation.

Thanks,

Dave
profile picture

Eugene

#4
QUOTE:
Anyway, I suppose the bottom line is that a week ends after the market closes on Friday, assuming Friday is not a holiday, and that is what my output above is telling me. So after the market closes on Friday, WL is able to add another week to the weekly macd calculation.

You are right.

P.S. By the way, you still have the control over compressed series synchronization:
Intraday / Multi-Time Frame | Compressed price series alignment
Hope that helps.