Topic: csv to json

I have Data files in *.csv which I would like to use for a test in EA-Studio, but EA-Studio seems to only import *.json format.
How can I convert a set of files from csv to json to be able to import it, or is there a possibility to use csv?

Re: csv to json

Hello Hans,

The ".json" data files contain the history data series as well as all account and market environment parameters.

Here is an example of a data file:

   "terminal":"MetaTrader 4",
   "company":"MetaQuotes Software Corp.",
   "server":"MetaTrader-Demo",
   "symbol":"AUDUSD",
   "period":15,
   "baseCurrency":"AUD",
   "priceIn":"USD",
   "lotSize":100000,
   "stopLevel":0,
   "tickValue":1.00000,
   "minLot":0.01,
   "maxLot":1000.00,
   "lotStep":0.01,
   "serverTime":8698919,
   "spread":10,
   "digits":5,
   "bars":20000,
   "swapLong":0.75,
   "swapShort":-6.70,
   "commission":10

We don't have these data in the CSV files. Exporting .json files with the provided scripts is the easiest and safest way to set proper testing environment.

Re: csv to json

Thank you for the explanation, I understand

4 (edited by yonkuro 2016-08-22 02:04:05)

Re: csv to json

bru1 wrote:

How can I convert a set of files from csv to json to be able to import it, or is there a possibility to use csv?

You can import those csv files to metatrader, just go to "Tools" -> "History Center", click on pairs, double click on your preferred Timeframe, click "Import" then browse the CSV file and hit "OK" button.

Then just open the chart and run the script.

do or do not there is no try

Re: csv to json

Thank you

Re: csv to json

Hi! If you know little programming then it's not hard to convert csv files to json with some scripts like php or python.  I'm not an expert but found this one really good and easy to use http://www.kodingmadesimple.com/2016/04 … g-php.html else you can try some free online tools to convert it.

Re: csv to json

Thank you for your suggestion

Re: csv to json

Hello

I have tried to import the current csv files that i have into Meta trader, but it dosnt accept it.
I want to export it after that as json files to test in EA studio as Popov says that this is the proper way

What could be the reason that i can not import the csv into MT4. They were exported from there anyway, i am just adding new data every month so i can collect more bars.

Thank you indeed.

Re: csv to json

Do MT shows any errors or warning when you try to import the data?

Please check the Journal and also the MT logs. You may find something useful for understanding the reason for the rejection.

Re: csv to json

No Nothing there... when i select the open button- nothing appears, its like not loading the file...

Re: csv to json

I read that it takes couple of minutes if the file is long, but stil even longer it is not uploading

Re: csv to json

yonkuro wrote:
bru1 wrote:

How can I convert a set of files from csv to json to be able to import it, or is there a possibility to use csv?

You can import those csv files to metatrader, just go to "Tools" -> "History Center", click on pairs, double click on your preferred Timeframe, click "Import" then browse the CSV file and hit "OK" button.

Then just open the chart and run the script.


i downloaded from Hisdata and successfully imported to MT4