Sampling H4, D1 Irreguarities result in MT4 data mismatch

General discussion about the Tickstory Lite software package.
Post Reply
twingo
Posts: 5
Joined: Tue Jun 18, 2019 6:56 pm

Sampling H4, D1 Irreguarities result in MT4 data mismatch

Post by twingo »

See attached XLSX for detailed analysis of an MT4 data mismatch error isolated to Tickstory H4 Sampling
a) download TS data
b) export TS data to MT4
c) using MT4 history centre export M1, H4, D1 to CSV
d) assemble all the data in attached

Sheets
Log - shows the MT4 error and the TS download parameters
Comp - shows the differences in H4 high prices and D1 closing prices when manually creating same with M1 data
M1.M5,M15,M30,H1,H4,D1 - show the MT4 history centre export CSV content (zeroed in on just that area around Jan 25, 2008
Data Used: GBPJPY 2008.01.25
Bar in Question : 20:00

Auxiliary analysis shows that this tends to happen on weekends only, that is on Fridays before the weekend. This suggests some sort of glitch on TS algo for H4 and D1 as recreating TS sampled M5,M15,M30,H1 from M1 TS checks out perfectly.

Also confirmed that when i take that TS M1 hst and use the MT4 PeriodConverter Script, it samples correctly resulting in NO data mismatch errors.

Please advise.

2019.07.17 Update
-Further reading suggests Dukas Copy's MT4 data is GMT+3,+2 timestamped though Tickstory manual says the tickdata is GMT +0 timestamped.
-Running the Tickstory Export WITH GMT=0 (no offset) gives NOT mt4 data mismatches.
-The reason for exporting to GMT+2/3 (DST on/off) is that my broker uses that timezone setting for the endof the daily bar aka NY 5pm close.

So how can i eliminate the data mismatches ? (some flag in Tickstory export and/or settings or discard all but M1 from tickstory and run period converter ?) Without knowing what exactly is going on it's difficult to trust even the M1 data ...
Attachments
MT4MismatchTSn2-HistCentre.xlsx
summary of analysis
(568.36 KiB) Downloaded 1088 times

Sabre
Posts: 1
Joined: Tue Jul 23, 2019 7:09 pm

Re: Sampling H4, D1 Irreguarities result in MT4 data mismatc

Post by Sabre »

Good day

I have a similar problem as mentioned above. Could someone please assist?

tickstory
Posts: 4883
Joined: Sun Jan 06, 2013 12:27 am

Re: Sampling H4, D1 Irreguarities result in MT4 data mismatc

Post by tickstory »

Hi Twingo,

Before we can look into more detail on this, you should check the following:

- Ensure your MT4 terminal is disconnected from your broker. This will prevent any mixing of data from your broker and Tickstory which will result in problems. To disconnect, go to File->Login to Trade Account in MT4 and type in an incorrect password.
- Close your MT4 terminal to prevent any cached data and export your data range entirely again. To prevent any time-zone confusion, leave the time-zone offset to "None" and check "Include weekends" to ensure all the data comes out unfiltered.
- Restart MT4 and check that your MT4 history center data reflects the same date ranges you exported. If not, something has been exported incorrectly.
- If you are performing any back-tests, ensure you are getting 99% modelling quality in your back-test report.

If you continue to have issues, appreciate if you can distill the information down to a specific instance of where you think there is an issue and outline the current result versus what you expect. If you believe there is an issue with the data, please highlight this in a single instance so we can analyze it efficiently. For example, if there is a mismatch in M1/H4/D1 for a particular day, please only give us this data.

Thanks.

Post Reply