Problem with two csv files on MT5

[theandor]

Hi Tickstory,

I'm using your great tool for a few days now and I found 2 tick data series that are not working correctly when downloaded as csv files on MT5. They are GOLD (XAUUSD) and the British index FSTE100. No matter how many times I try, as soon as the file is completely downloaded and imported into my MT5 platform, the information within is not available. I tried a dozen other assets and all of them work perfectly fine once downloaded as csv files. The issue seems to be specific of those 2. I enclose some screenshots.

1. I created a custom symbol normally. In this example, UK100.

https://ibb.co/Lhg6Vq9

Then I try to import the tick data from the csv file and this happens:

https://ibb.co/3dD6td8

No tick data is visible and the import is stuck forever.

Could you please confirm your tool is working correctly?

Best regards,

[tickstory]

Hi Theandor,

Thank you for your kind feedback. We are getting some discussion regarding import issues into MT5 however we have not attributed anything to an issue in Tickstory at this stage. The fact that MT5 is hanging suggests there is something going wrong with it during the import process, however we couldn't say what this might be.

How large is your exported data - perhaps the data file is too large for MT5? Have you tried reducing the size to say 1 month and seeing if that helps at all? Did you make sure you apply any pending updates to your MT5 terminal?

You might also want to check out this active thread we have on a similar topic to see if any of the mentioned suggestions help you.

Thanks.

[theandor]

I confirm I selected the unlimited bars option., but to no avail. Additionally, no downloaded csv file is working any more! No matter what symbol I select, no tick information is imported. Could you please confirm your data is correct?

[theandor]

I forgot to say that I selected the last 30 days period from 6 different symbols. Not a single one was successfully imported. I tried on 2 different MT5 platforms, but to no avail.

[tickstory]

Hi Theandor,

Please open the exported file in a text editor that can handle large files like Notepad++ and make sure that the data looks correct.

The 1-minute bar data should look similar to:

Code: Select all

20150101,23:00:00,1183.949,1184.229,1183.23,1183.409,38,38,1100
20150101,23:01:00,1183.41,1184.05,1183.409,1183.78,36,36,931
20150101,23:02:00,1183.779,1184.029,1183.779,1184.029,27,27,832
20150101,23:03:00,1184.089,1184.239,1183.949,1184.11,47,47,482
20150101,23:04:00,1184.109,1184.18,1184.039,1184.089,43,43,551

And the tick data should look similar to:

Code: Select all

20240516,00:00:00,0.91095,0.91111,0.91095,5
20240516,00:00:00,0.91095,0.91113,0.91095,1
20240516,00:00:00,0.91094,0.91111,0.91094,5
20240516,00:00:01,0.91095,0.91112,0.91095,5
20240516,00:00:01,0.91094,0.91113,0.91094,1

When you say "not a single one was successfully imported", what does that mean? Is your MT5 platform still hanging? If so, this is not an issue with the Tickstory's exported data but something with MT5.

Please let us know more precisely of any errors you are getting. If you like you can upload your exported CSV data to this site. Send us the download link and we can take a look to verify it is correct.

Thanks.

[theandor]

Thank you very much for the notepad++ info. I tried it and I found the issue is here:

https://ibb.co/YjWTvdS

This format cannot be recognised by MT5. However, this one can:

https://ibb.co/X3y7Smt

I managed to import the data with the second format and it's working fine now.

[tickstory]

Hi Theandor,

Good to hear it's solved. Just remember that you can also more easily select the "Export to Metatrader 5 (bar/ticks)" option in Tickstory by right-clicking on the symbol. It automatically selects the correct export format for MT5 for both bars and ticks. More is explained in this guide if you haven't gone through already.

Thanks.

[theandor]

Sorry for bringing more bad news but it doesn't work either. Although the Notepad++ app can see the data, MT5 cannot read it. I tried to open it as a standard chart, but to no avail. There is a serious problem there.

[tickstory]

Hi Theandor,

Could you please provide further information and screenshots? What does "MT5 cannot read it" mean exactly - are you getting an error when importing? Is there the same problem if you use the method you previously said was working?

Make sure you are not trying to import CSV tick data into MT5 as bars (or CSV bar data into MT5 as ticks). This will definitely cause an error because the two formats are different.

If that doesn't solve it, please detail as much information about the problem as you can so we can help you further. If the issue is with bars, please post a 10-line sample of the data you are trying to import along with a screenshot of the error you are getting.

Thanks.

[theandor]

After A LOT of tests I finally found the reason of the problem. I'm interested in comma separated value files only, so this is why I'm so insisting on them. I found that some (not all) downloaded CSV files can change substantially in size. I mean I downloaded the exact same symbol for the exact same time period and some times I git a 11Gb file while other times it was 24 Gb. In those cases the file was never correctly imported/identified by Notepad++ or the MT5 platform. Just by downloading and trying the same symbol over and over and over there is a chance to get the 'good' one that works. It is really weird and time consuming but it works.

I have no idea why the size of the same file can be so different from one download to the next one, but definitely there is an issue there. Now I got all symbols I need and all of them work fine, but boy, I needed 3 weeks to get them!