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 =)

That's not a CSV (comma separated value) file, that's a SSV (semicolon separated value) file, a format that nobody uses. And there's no timestamp in the first column, which is required.

So your first error is that your source material is no good. Fix that.

Here's an example of a good CSV file, with a header line included (also supported by Zorro):
Once you fix your source material, write the format string to match the format of your file. The manual spells this out very clearly, and there are examples in the example script.

In the docs i found this in https://zorro-project.com/manual/en/data.htm :

ss... - for an extended text field of size 4n-1, where n is the number of 's'. Occupies n adjacent fields in the dataset, while field 0 counts as 2 fields.

since the dummy csv file contains only one line with "AAA;BBB;CCC" i told myself that the format should be "sss,sss,sss" here is my code :



but its not working i get this message error :

Why didn't you change the source CSV file yet like I suggested? Do it. I don't understand why you continue to work with this bad file.

I am sorry the previous message was sent before I saw your last message here is what I did after reading your last response :


I did replace the CSV file content with the sample you provided but nothing is solved



but I still get this error message unfortunately :

It looks like the parser tried to read the header line for some reason. The default is one line, but try manually setting it to 1 using the Format string field.