US Holiday Calendar?

nilesh.patel at bnpparibas.com nilesh.patel at bnpparibas.com
Wed Feb 22 11:38:20 CST 2006


Thanks for the correction.

I was interested in holidays at CME exchange. 
http://www.cme.com/trading/res/cch/holiday_calendar3513.html. 

The President's holiday(3rd Monday of the February) information was picked 
up from http://homepages.rootsweb.com/~maggieoh/Pd/prindex.html site.

The Labor day holiday (First Monday of September) information was picked 
up from http://www.dol.gov/opa/aboutdol/laborday.htm site.

Regards.

Nilesh Patel.




Extranet
Robert_Edis at notes.ntrs.com@lists.sowder.com - 21/02/2006 20:21
 
Sent by: powerh-l-bounces+nilesh.patel=bnpparibas.com at lists.sowder.com
To:     powerh-l
cc: 
Subject:        Re:US Holiday Calendar?



Most companies in the USA do not recognise Easter as a work holiday.

The question about US holidays is a bit vague in the sense that it depends
on the state and the business's rules.  For example in Illinois Pulaski 
Day
is a holiday but Columbus Day is not. Another is that Government and banks
have MLK and Presidents Day as a non-business day but other private
enterprise does not.

The only holidays that are recognised by almost all companies and all
states are:

New Year's Day - Jan 1
Memorial Day - last Monday in May
Independence Day - July 4
Labor Day - last Monday in September
Thanksgiving - 4th Thursday in November
Christmas Day - December 25

Blue

---------------------------------------------------------------------------
Hi,

I was interested in the US holiday Calendar and therefore have collected
the following information.

Holiday Calendar

New Years   - 1st Jan
Martin Luther King Jr.  - 3rd Monday of January
Presidents Day  - 3rd Monday of the February


Memorial Day - Last Monday in May
Independence Day  - 4th July
Labor Day  - Last Monday of May
Columbus Day  - 2nd Monday of October
Veterans Day  - November 11
Good Friday  -

I got the following from http://www.smart.net/~mmontes/nature1876.html
The actual origin of this algorithm appears to be by an anonymous
correspondent from New York to Nature in 1876 (Thanks Denis!). Samuel
Butcher, Bishop of Meath, showed that this algorithm followed from
Delambre's analytical solutions, and produces the date of Easter for all
years. You can see the algorithm, as well as version for Orthodox Easter
at another Easter Date site.
This algorithm appears in Practical Astronomy With Your Calculator, 2nd
Edition by Peter Duffett-Smith, and he obtained this algorithm from
Butcher's Ecclesiastical Calendar, published in 1876. This algorithm has
also been published in the 1922 book General Astronomy by Spencer Jones;
in The Journal of the British Astronomical Association (Vol.88, page 91,
December 1977); and in Astronomical Algorithms (1991) by Jean Meeus.

This algorithm holds for any year in the Gregorian Calendar, which (of
course) means years including and after 1583.

In the text below, / represents an integer division neglecting the
remainder,
while % is division keeping only the remainder. So 30/7=4 , and 30%7=2 .

a=year%19
b=year/100
c=year%100
d=b/4
e=b%4
f=(b+8)/25
g=(b-f+1)/3
h=(19*a+b-d-g+15)%30
i=c/4
k=c%4
l=(32+2*e+2*i-h-k)%7
m=(a+11*h+22*l)/451
Easter Month =(h+l-7*m+114)/31  [3=March, 4=April]
p=(h+l-7*m+114)%31
Easter Date=p+1     (date in Easter Month)

I suppose from here, you can code your holidays for a year etc.

Only thing I will say (Probably you already know) is that within HP
powerhouse, you get a day of the week by doing the   mod(day(sysdate),7),
which would give you numbers from 0 to 6, where zero is a Sunday.

I hope this helps.

Nilesh Patel.

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.


This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060222/9563238d/attachment.html


More information about the powerh-l mailing list