Sometimes a file may contain trading activity that you do not wish to track. PropReports has the ability to exclude one or more accounts from an upload.
To view the Do Not Upload List, click Upload / Excluded accounts:
To specify a single account to exclude, just select the source and enter the account name. For example, entering ACCOUNTXYZ and selecting Sterling as the source will exclude all activity for that account when importing data from Sterling:
Subsequently, all uploads for ACCOUNTXYZ account will be disabled: Executions, Adjustments, Locates, Positions (if doing reconciliation) and Buying Power entries (if enabled). Existing data is not affected.
To exclude multiple accounts, you can specify a pattern. Here are some examples:
| Expression | Will Exclude |
|---|---|
| ABC.* | All accounts that start with ABC |
| (?!^ABC).* | All accounts that do not start with ABC |
| ^[0-9]+$ | All numeric accounts. |
| ^.*CAD$ | All accounts ending in CAD. |
| ABC[0-9][0-9][0-9] | All acounts starting with ABC followed by three digits. |
The pattern syntax used is described here.
Testing the Do Not Upload List
To test whether or not an account will be excluded, select the source, enter the name and press test:
