Data for November 27th stops at 1:30pm
Author: flashy3
Creation Date: 11/27/2013 10:48 PM
profile picture

flashy3

#1
The latest bar I am receiving for all symbols says 130pm even though the market was open on Wednesday November 27th until 4pm.

Any one else see this behavior?
profile picture

Eugene

#2
profile picture

Cone

#3
Actually, it's traditional that the markets close at 1:00pm on the Friday after Thanksgiving. To fix this, replace the dates following lines from the Markets.xml file. Right click and open in Notepad ...

(Wealth-Lab Pro)
C:\Program Files\Fidelity Investments\Wealth-Lab Pro 6\Data\Markets.xml:

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

Replace 2013-11-27 with 2013-11-29 (three places), save, and restart Wealth-Lab

<MarketSpecialHours>
<Date>2013-11-27T00:00:00</Date>
<OpenTimeNative>2013-11-27T09:30:00</OpenTimeNative>
<CloseTimeNative>2013-11-27T13:00:00</CloseTimeNative>
</MarketSpecialHours>

Edit:
Actually, this is going to be a little more challenging since Admin privileges are required to change files in Program Files directories. One way to accomplish it is by using this procedure:

1. From the Start Menu, type "Notepad"
2. Right click it in the list and select "Run as Administrator"
3. File > Open, navigate to the directory shown above.
4. For the file type, select "All Files *.*:
5. Open Markets.xml
6. Edit > Replace
7. Find 2013-11-27 and replace with 2013-11-29
6. Save.
profile picture

Cone

#4
For Wealth-Lab Developer customers upgrading to 6.6, this is a NON issue.

For Wealth-Lab Pro customers (6.6 or previous), instead of editing the file yourself, you can grab the attachment to this post and unzip to C:\Program Files\Fidelity Investments\Wealth-Lab Pro 6\Data\ overwriting Markets.xml.

Make sure to use an Admin account for this operation, and when you get the "Destination Folder Access Denied" dialog, just click "Continue".
profile picture

kazuna

#5
It looks like the cached intraday data won't be updated to reflect the correction from 1pm to 4pm.
I had to use the DataTool to truncate after 2013/11/26 to get the data corrected.
profile picture

flashy3

#6
Can you be more specific how you fixed the data from 11/27 onwards?

I am in Data Manager and can not see how to rectify except to clear out the data for each symbol and start over - how do you truncate only for the last week?
profile picture

Eugene

#7
Using the Data Tool's Truncate feature as explained in the Wiki. Click here to download the extension (restart WLP to apply).