Bars.MarketInfo.Holidays is Incomplete
Author: Panache
Creation Date: 12/10/2013 7:12 PM
profile picture

Panache

#1
Saturday, July 4, 2009 is shown as a market holiday, but the observed holiday, Friday, July 3, 2009 is not included. Is this stored as part of the Bars object of each symbol, or is it stored somewhere else? My real question is whether this is something I (or you) can fix or whether I have to do a work around?
profile picture

Cone

#2
Thanks for pointing this out. We'll have that corrected for the next release, but you can edit Markets.xml now yourself by making the change below.

Note! To edit the file, move it to your desktop, make the edit, save, and then move it back with Admin privileges.


// CHANGE THIS LINE
<dateTime>2009-07-04T00:00:00</dateTime>

// TO THIS
<dateTime>2009-07-03T00:00:00</dateTime>

Markets.xml is located here
(WL Developer)
C:\Program Files\MS123\Wealth-Lab Developer 6\Data\

(WL Pro)
C:\Program Files\Fidelity Investments\Wealth-Lab Pro 6\Data\
profile picture

Panache

#3
Thanks. While you are at it, you can also delete

7/4/1992 (Saturday) -- 7/3/1992 is already listed
7/4/1993 (Sunday) - 7/5/1993 is already listed
12/25/1993 (Saturday) - 12/24/1993 is already listed
1/1/1994 (Saturday) - I don't believe the Friday before is a holiday
12/25/1994 (Sunday) - 12/26/1994 is already listed
1/1/1995 (Sunday) - 1/2/1995 is already listed
7/4/1998 (Saturday) - 7/3/1998 is already listed
7/4/1999 (Sunday) - 7/5/1999 is already listed
12/25/1999 (Saturday) - 12/24/1999 is already listed
1/1/2000 (Saturday) - I don't believe the Friday before is a holiday
1/1/2005 (Saturday) - I don't believe the Friday before is a holiday

profile picture

Panache

#4
One more missing holiday - 04-27-1994
profile picture

Eugene

#5
Thanks.
profile picture

Panache

#6
I created a much larger version of Markets.xml which has NYSE holidays (but not early closings) back to 1928, which you are free to use.

Here's a zipped version
profile picture

Cone

#7
Great! Thanks Panache for the corrections and additions!