Create bank holidays table

Question

Create bank holidays table

Sector7G

Ten Centuries

Points: 1040
More actions
December 14, 2011 at 2:54 pm

#249782

Comments posted to this topic are about the item Create bank holidays table

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Robert.Sterbal SSCrazy Points: 2855 More actions · Answer 1

This line needs an edit:

If a holiday falls on a Saturday, the Federal Reserve will be open for business as usual on the Friday before. But if a holiday falls on Sunday, they will be closed on the following Monday.

Sector7G Ten Centuries Points: 1040 More actions · Answer 2

Robert.Sterbal (1/17/2012)
This line needs an edit:
If a holiday falls on a Saturday, the Federal Reserve will be open for business as usual on the Friday before. But if a holiday falls on Sunday, they will be closed on the following Monday.

Thank you for your feedback. Even though I proof read several times, I still may miss something.

I am looking at the line now, and I must not see the problem you're seeing. How do you suggest I edit this line?

Robert.Sterbal SSCrazy Points: 2855 More actions · Answer 3

You actually had it right.... The banks lose a holiday when it falls on a Saturday...

Here is the quote from the web site:

http://www.federalreserve.gov/aboutthefed/k8.htm

"For holidays falling on Saturday, Federal Reserve Banks and Branches will be open the preceding Friday; however, the Board of Governors will be closed. For holidays falling on Sunday, all Federal Reserve offices will be closed the following Monday."

Thanks for getting me to double check.

o1390243 Newbie Points: 7 More actions · Answer 4

o1390243

Newbie

Points: 7

October 9, 2012 at 9:49 am

#1547270

great script

thank you very much

Sector7G Ten Centuries Points: 1040 More actions · Answer 5

o1390243 (10/9/2012)
great script
thank you very much

I'm glad someone found it useful.

Were you looking for this script because yesterday was a bank holiday, and something went wrong? 😉

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 6

akljfhnlaflkj

SSC Guru

Points: 76202

May 11, 2016 at 7:22 am

#1878214

Thanks for the script.

steve.melchert 72554 Grasshopper Points: 22 More actions · Answer 7

Excellent script. Has a bug, though. Should be "2 and 7", not "2 and 6".

Very useful, thanks a bunch!

Sector7G Ten Centuries Points: 1040 More actions · Answer 8

steve.melchert 72554 - Wednesday, May 30, 2018 3:46 PM
Excellent script. Has a bug, though. Should be "2 and 7", not "2 and 6".
Very useful, thanks a bunch!

Thank you for your feedback. I think this is correct as written. I have checked through several of the holidays that are generated by the script, and they appear to be correct. If you can point out a specific date you believe is wrong based on the original script, please comment here. I'd like to study that example to improve the script.

The goal of this script is to identify days when the Federal Reserve Bank is closed due to a holiday. Those can only be weekdays. That means Mon-Fri, or days 2-6. Saturday (day 7) cannot be a Federal Reserve Holiday. As noted in the original description, when a holiday like Christmas falls on Saturday, the Federal Reserve Bank is open for business as usual on the day before (Fri). When a holiday falls on Sunday, then they will be closed on Monday.

steve.melchert 72554 Grasshopper Points: 22 More actions · Answer 9

Ah, I see. I was a little myopic then in that I was looking for a script that would generate the actual holiday dates, to be used as an exclusionary indicator for when a job should not run. Wouldn't matter for some, matters for us. Specifically, any Saturday holiday was "missing".
Thanks for the clarification! The script saved me at least a half day.