help with a csv export

kidhudi · #1 (**permalink**) 05-15-2007, 01:24 AM

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.

asmdev · #2 (**permalink**) 05-15-2007, 01:44 AM

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 · #3 (**permalink**) 05-15-2007, 01:50 AM

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 · #4 (**permalink**) 05-15-2007, 03:25 AM

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

Hazel · #5 (**permalink**) 09-24-2008, 04:04 AM

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 · #6 (**permalink**) 09-24-2008, 04:22 AM

Quote:

Originally Posted by 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 MTPredictor.

Other links:

RSI data to CSV

Working with Excel (tools, indicators, conversion ...)

basza · #7 (**permalink**) 10-08-2008, 03:05 AM

Quote:

Originally Posted by 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 · #8 (**permalink**) 10-08-2008, 03:46 AM

Quote:

Originally Posted by 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.