Hello guys,

I need to use this function to read some CSV file, I am unable to figure out how this function works

dataFromCSV (int Handle, string Format, string Filename, int Column, int Offset)

what I don't understand is the Handle, the Format and Offeset.

cheers,

The dataset function arguments (Handle, Format, and Offset) are described near the bottom of the manual page:
https://zorro-project.com/manual/en/data.htm

I tried my friend i used this code :





all I get is : Error 058: Bad code 'C' for '2, "1.7 Cub' in aaa.csv

PS: I have the CSV file in the history folder

"CSV" isn't a string format and "aaa" isn't a file name. Please read the link again that Andrew has provided.

When you still receive a 058 message after fixing this then have a look at the error message section.

https://zorro-project.com/manual/en/errors.htm

Also, definitely check out the CSVtoHistory script included with Zorro for some excellent sample code.

Not all CSVs are made the same, so you will need to edit the CSV format to suit. See, you have different kinds of time stamps and field values to work with. Plus the sort order can be backwards.

Hello guys, thanks for the replies, really appreciate it

this CSV file contains some breakouts that I detected using a python script, I want to take those break out and add them as signals in my zorro script so the format is irrelevant I guess since the format of the column is as follow: "YYYY/MM/DD strong up" or "YYYY/MM/DD medium up" or "YYYY/MM/DD weak down" etc. I just want to get the values from the CSV, regardless of what format is being used.

By the way Andrew I use occasionally CSVtoHistory to convert my data to T format, and I don't see datafromCSV used in the script...

What are you trying to do with the CSV, exactly?

I want to extract the data from that CSV, every cell contains a date followed by "strong up" or "medium down" etc. but the format is as follows: "YYYY/MM/DD strong up"
every cell contains values extracted from an end-of-day candles break-out detector that I coded in python.

and I will write a c lite script to check if I am on a break-out day and then try some intraday strategies to see the result, how to get the CSV values? lol

First convert your data to CSV. You only need a comma after the date, a simple find/replace should do.

Then read the CSV with dataParse.

ok i will try, i found this line here in an example in documentation : int Records = dataParse(1,Format,"History\\BTCEUR.csv");

the only thing I am not understanding is the Format argument, what should I do in Format in my case ?? Let's say for example that the CSV contains one line: "AAA;BBB;CCC" how to get this value from within the CSV ?? what format should I use ??

Thanks a lot my friend =)