Topic: Data check warnings. Wrong high of bar. Wrong low of bar.

Hi.

After downloading data history i get these messages in "loading input" in the history center:

Wrong Low of bar 3075 at 2016-10-31 00.00.
Wrong High of bar 3075 at 2016-10-31 00.00.
Wrong Low of bar 3076 at 2016-11-01 00.00.
Wrong High of bar 3076 at 2016-11-01 00.00.
Wrong Low of bar 3077 at 2016-11-02 00.00.

And so on...

Anyone have suggestions what to do?

Thank you.

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

Open the data file in a text editor and check the values for the given dates.
Post the bars data for these dates to see what is happening.

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

Hi.

Here are the data opened in Notes. I copied few lines before and after the dates I posted in the first post.

2016-10-30    23.58    1,09840    1,09840    1,09828    1,09828    43
2016-10-30    23.59    1,09826    1,09826    1,09820    1,09820    57
2016-10-31    00.00    1,09821    1,09821    1,09815    1,09815    53
2016-10-31    00.01    1,09814    1,09814    1,09787    1,09800    103
2016-10-31    00.02    1,09801    1,09811    1,09801    1,09805    75

2016-10-31    23.58    1,09705    1,09706    1,09704    1,09706    149
2016-10-31    23.59    1,09705    1,09708    1,09704    1,09707    88
2016-11-01    00.00    1,09708    1,09708    1,09695    1,09695    115
2016-11-01    00.01    1,09695    1,09695    1,09688    1,09693    67
2016-11-01    00.02    1,09692    1,09705    1,09687    1,09701    76

2016-11-01    23.58    1,10544    1,10547    1,10543    1,10547    47
2016-11-01    23.59    1,10548    1,10555    1,10548    1,10553    48
2016-11-02    00.00    1,10555    1,10574    1,10555    1,10574    96
2016-11-02    00.01    1,10573    1,10592    1,10565    1,10592    76
2016-11-02    00.02    1,10593    1,10598    1,10589    1,10590    76

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

FSB Pro doesn't recognize the time column. It must be 23:58 instead of 23.58.

Try to search and replace . with : in the whole file.

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

That did the trick :-)

Thanks again for your quick reply Popov.

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

I am having some data check warning issues too, could anyone advise as to what is causing the problems in the Loading Output box?  I checked MT4 and saw that there was a huge spike on the date of the Big Range bar, so that is clear, but what could be causing some of the bars to have the wrong time?, and why is Data Horizon cutting off 18625 bars?

https://i.imgsafe.org/60e7f126d6.png

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

For data horizon, I think you have the max bar number hit. That is 50k, and therefore earlier bars are cut off until there are 50k bars.

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

"Wrong Time" means that the program cannot parse the time parameter for a bar record.

It is possible the format to be different. Also is possible the time to not correspond to the time frame. For example, on H1 chart the program will not accept time where the hour is not round:
2016-11-24 11:00 is ok for H1
2016-11-24 11:30 is not ok for H1

9 (edited by Simon 2016-12-04 16:00:41)

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

This is correct, I have found in the M5 data that instead of :00 and :05, it is :01 and :06 after my most recent import of data.

https://i.imgsafe.org/42e1c07ff2.png

Is this some issue with the "Export Data to CSV" script? How can this be solved/prevented?

Thank you

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

I do not think there is much wrong with the script.... but there may be something wrong with the source of your data.

Metatrader is not the most reliable in any area.

We can expect some errors based on the volume of data bars, the complexities of the internet.

I also get a few errors from time to time, my solution has been to ignore them as I do not expect perfection based on the above.

My 'secret' goal is to push EA Studio until I can net 3000 pips per day....

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

In this case, it would be good to fix the one minute shift, so that I can use the 1700 recent bars that have been cut off. I would worry that a strategy created on data with a 1700 bar gap would be less than reliable. I'll google what could be the possible cause.

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

I just loaded GBPNZD using MT5  data...... 100,000 bars..... no errors.....

That might indicate that your broker data is in err.

Perhaps you can check into that.

My 'secret' goal is to push EA Studio until I can net 3000 pips per day....

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

Yes, it is the broker data.

I'm now trying to figure out how to use notepad++ to bulk edit the 1's and 6's into 0's and 5's.

Re: Data check warnings. Wrong high of bar. Wrong low of bar.

You can do it with Notepad++

Use Replace (Ctrl + H)

The select "Regular Expressions" at the lower left corner.
Use the flowing search and replace patterns to change 1 to 0:
Find what: (;\d\d.\d)(1)
Replace with: \10
Then click "Replace all" button.

http://s12.postimg.org/izune3rnh/screenshot_2016_12_05_at_09_10_54.png


Then use the following to replace 6 to 5.
Find what: (;\d\d.\d)(6)
Replace with: \15