Help with a csv export

To add comments, please log in or register
kidhudi
167
kidhudi  

hi guys i have this file i have been messing with called agdata. it exports metatrader data into a csv file (intraday data in "end of day" data format). i finally got it so close but the only problem is when i export the csv file it looks great in excel but in notepad it is missing something. i download a csv file from yahoo and open it in notepad there is a little square at the end of every line. and when i open the file exported by agdata there is no square. i will attach the export files and the indicator file. if any of you guys can help me i would really appreciate it. i am so close and have no idea what to do now.

Files:
files.rar 240 kb
agdata.mq4 5 kb
asmdev
71
asmdev  

different symbol for end of line is used. AUDUSD.cvs has 0x0d0a(hex #) and table.cvs has 0x0a. It's different convention.

Notepad is simple program and doesn't recognize everything.

I am not familiar though which method is correct for cvs file, probably table.cvs.

kidhudi
167
kidhudi  

hey guys the only problem i have is to get the first line to look like this

Date,Open,High,Low,Close,Volume,Adj Close(with the square right here)

and that is all that has to be done. this is probably easy for one of you guys. i hope someone can help me.

kidhudi
167
kidhudi  

GOT IT!!!!!! took me 3 days but i did it

Hazel
31
Hazel  

How to export data to CSV

Hi guys,

Very good forum first of all.

Just started to do the programming. Can anyone show me a script for exporting data. I know this can be done. Just don't know how. Need an example.

Cheers

Linuxser
5921
Linuxser  
Hazel:
Hi guys,

Very good forum first of all.

Just started to do the programming. Can anyone show me a script for exporting data. I know this can be done. Just don't know how. Need an example.

Cheers

Hi.

I moved your post to here where there is one tool. Another thread is https://www.mql5.com/en/forum/general.

Other links:

https://www.mql5.com/en/forum/175997

https://www.mql5.com/en/forum/175464

brumsey
491
brumsey  

Help with date formate please

kidhudi:
hi guys i have this file i have been messing with called agdata. it exports metatrader data into a csv file (intraday data in "end of day" data format). i finally got it so close but the only problem is when i export the csv file it looks great in excel but in notepad it is missing something. i download a csv file from yahoo and open it in notepad there is a little square at the end of every line. and when i open the file exported by agdata there is no square. i will attach the export files and the indicator file. if any of you guys can help me i would really appreciate it. i am so close and have no idea what to do now.

Hi kidhud

This looks like what I have been searching for. The only problem is the date format. When loaded into excel the date looks like this: 19300112 When I try to convert it to a date format, all I end up with is a very long line of : ###########

Could any one please help or tel me where I am going wrong.

Thanks in advance

Basza

Linuxser
5921
Linuxser  
basza:
Hi kidhud

This looks like what I have been searching for. The only problem is the date format. When loaded into excel the date looks like this: 19300112 When I try to convert it to a date format, all I end up with is a very long line of : ###########

Could any one please help or tel me where I am going wrong.

Thanks in advance

Basza

Try to wide your column till you can see some numbers and then post a picture.

brumsey
491
brumsey  
Linuxser:
Try to wide your column till you can see some numbers and then post a picture.

Hi Linuxser

It has something to do with negative dates or times.

I have widen it to 1230 pixles and still the same

Thanks

Basza

Linuxser
5921
Linuxser  
basza:
Hi Linuxser

It has something to do with negative dates or times.

I have widen it to 1230 pixles and still the same

Thanks

Basza

Try to upload the file. I will convert the date for you.

brumsey
491
brumsey  
Linuxser:
Try to upload the file. I will convert the date for you.

Hi Linuxser

Do you want the .cvs file?

Or can you alter the indi at the top of this topic?

Thanks for helping out

Cheers

Basza

To add comments, please log in or register