Topic: Data loading error

Hello Miroslav,

This is my problem, and I can't get it solved:

http://s4.postimage.org/nilpgdb8/error.jpg

Data file is attached below, it seems normal, but it doesn't load up, if I use a week older data, everything works fine, if I edit the data file manually, same error pops up. Can it be fixed?

Re: Data loading error

When FSB loads a data file, it tries to determine what column is High and what column is Low.
The program recognizes two formats:
1. Open High Low Close
2. Open Low High Close

To do that FSB uses the following formulas (for the first format):
High > Open + pip AND High > Close + pip AND Low < Open - pip AND Low < Close - pip

In your file (4378 lines) there is no even a single line that matches this pattern.

...
2011.06.30, 02:28, 1.44700, 1.44800, 1.44570, 1.44800, 2344
2011.06.30, 04:05, 1.44700, 1.44770, 1.44600, 1.44600, 1064
2011.06.30, 04:54, 1.44700, 1.44800, 1.44620, 1.44800, 480
2011.06.30, 05:24, 1.44800, 1.44900, 1.44770, 1.44900, 186
2011.06.30, 05:27, 1.44900, 1.45000, 1.44850, 1.45000, 275
2011.06.30, 05:31, 1.45000, 1.45100, 1.44870, 1.45100, 1156
2011.06.30, 06:00, 1.45000, 1.45190, 1.44900, 1.44900, 4614
...

There is no line where High is greater then other prices and Low is lower then others.

You can easily change slightly the file in order to make it acceptable for the program.
For example the first line of the file is:

2011.02.10,02:09,1.37300,1.37400,1.37200,1.37200,1191

You see that Low is equal to Close. If you reduce Low by two point (1.37198), FSB will load the file correctly.

Corrected first line is:

2011.02.10,02:09,1.37300,1.37400,1.37198,1.37200,1191

Re: Data loading error

Hmm, I'll try it, thanks.