Data export question

New comment
 

Is there a way to change the data format of MT4 export file

I am looking for the ASCII.csv but need the data to be in the following format;

DATE TIME OPEN HIGH LOW CLOSE

date and time format as;

Date Format: MM/DD/YYYY

Time Format: HHMM

any help appreciated. Is this even possible?

Thanks

 

You neglected to mention what delimination to use, comma, spaces etc ?

 
 
donb01:
Is there a way to change the data format of MT4 export file

I am looking for the ASCII.csv but need the data to be in the following format;

DATE TIME OPEN HIGH LOW CLOSE

date and time format as;

Date Format: MM/DD/YYYY

Time Format: HHMM

any help appreciated. Is this even possible?

Thanks

You can do this like this:

1) export data from history center to csv

2) open file with excell

3) change what you want in excell file (columns placement, data format etc.)

4) save file in required format (csv or any that is provided by excell)

 

you guys are awsome

Thank you both so very much.

 

I am finding this indicator extremely useful even though for my needs I would need it to export this way:

1) separate columns (we only want: time, high, low and close)

2) only for the last 1000 bars

3) and puts it upside down (last on top)

4) saves it in a folder that i already have on my desktop (maybe a browse function to select which one?)

Thanks

 
MFM:
I am finding this indicator extremely useful even though for my needs I would need it to export this way:

1) separate columns (we only want: time, high, low and close)

2) only for the last 1000 bars

3) and puts it upside down (last on top)

4) saves it in a folder that i already have on my desktop (maybe a browse function to select which one?)

Thanks

Some more indicators that export data and could fill your needs are here and here

 

Thanks, I will have a look

 

Export data in Ninjatrader format

Linuxser:
Some more indicators that export data and could fill your needs are here and here

Hi

I hope someone can help me with the following.

I want to export minute data in the format used by Ninjatrader - which is:

yyyyMMdd HHmmss;open price;high price;low price;close price;volume

I cannot do this with excell (I am actually using OO Calc) since Excell files are saved with commas as the delimiter (I require ; ) and the is a space only between the date and time columns.

All help will be appreciated

 
verge:
Hi

I hope someone can help me with the following.

I want to export minute data in the format used by Ninjatrader - which is:

yyyyMMdd HHmmss;open price;high price;low price;close price;volume

I cannot do this with excell (I am actually using OO Calc) since Excell files are saved with commas as the delimiter (I require ; ) and the is a space only between the date and time columns.

All help will be appreciated

No problem.

Form OO calc go to Save As and select TEXT CSV in type.

A Warning message should appear. Select Yes and change in the field separator , to ;

 
Linuxser:
No problem.

Form OO calc go to Save As and select TEXT CSV in type.

A Warning message should appear. Select Yes and change in the field separator , to ;

Thank you Linuxuser for the quick response. Forex TSD surely is the best.

Here are some feedback for the benefit (hopefully) of other users.

Changing the field separator in OO Calc works as Linuxuser said - except make sure that the "edit filter settings" tick box is ticked on the "save as" dialog.

I managed to combine the date and time fields in to one by simply doing a "A1 + B1" function. Date is in column A and time is in column B. (Using concatenate does not work)

I add the date and time in a sheet 2 and copy the the prices over from sheet1 (where it is pasted to start) and since when OO Calc saves a text file it only saves the active sheet (sheet2) I end up with exactly what I need.

Thanks again

Regards

Verge

New comment
Reason: