Imported from previous forum
[ original email was from Sergiy Bondar - Sergey_Bondar@epam.com ]
From FIX 4.4 there is a datatype “month-year” that has several formats, and one of them is YYYYMMWW. The valid values for WW are w1,w2,w3,w4 and w5.
What do the values w1,2,… represent? Do they represent the week by the count of the day of the month (for example w1 would be from 1st till 7th) or does it represent a Calendar week (so if we take Year 2001, December, first week [200102w1], would that be 1st December only and second week would start from 2nd December ?).
Also if it is the second case, do the weeks start from Sunday or Monday (In US, week starts from Sunday, in some other countries the week starts from Monday)?
[ original email was from Bivas Mishra - bivas.mishra@wipro.com ]
Hi,
As per ISO 8601 Standards, the Week representation follows the below rules:
a) The 1st week of the year is the week with the first Thursday of the year.
b) Week starts from Monday
Based on the above two rules, the week having the 1st thursday of the month should be the W1 and so on.
In your example, The week of Dec 3rd-Dec 9th would be represented as 200112W1.
November 2001 would have 5 weeks with 200111W5 being from Nov 26th to Dec 2nd.
Would also like to have more inputs from hose who have implemented this month-year format.
Regards,
Bivas
From FIX 4.4 there is a datatype “month-year” that has several
formats, and one of them is YYYYMMWW. The valid values for WW are
w1,w2,w3,w4 and w5.What do the values w1,2,… represent? Do they represent the week by the
count of the day of the month (for example w1 would be from 1st till
7th) or does it represent a Calendar week (so if we take Year 2001,
December, first week [200102w1], would that be 1st December only and
second week would start from 2nd December ?).Also if it is the second case, do the weeks start from Sunday or Monday
(In US, week starts from Sunday, in some other countries the week starts
from Monday)?