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.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+58- 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.
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.