I am looking extract data from a csv file, (1) all open orders and (2) all closed orders within the last 90 days. Any recommendations. Thanks
Best answer by geomancer
Read the CSV file. Then filter the features:
All open orders will be the features where the attribute indicating the closing day is null (or zero? or ...?).
To determine all closed orders within the last 90 days calculate the number of days between today (@DateTimeNow()) and the attribute indicating the closing day for the features where this attribute is not null.
Some date conversions may be needed.
+47- Evangelist
- Best Answer
Read the CSV file. Then filter the features:
All open orders will be the features where the attribute indicating the closing day is null (or zero? or ...?).
To determine all closed orders within the last 90 days calculate the number of days between today (@DateTimeNow()) and the attribute indicating the closing day for the features where this attribute is not null.
Some date conversions may be needed.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.