Sometimes a file may contain trading activity that you do You can prevent some data from being uploaded by using the Do Not Upload List. This can be useful if you:
- Receive the same data from more than one source.
- Do not wish to track
...
- some accounts in PropReports.
- Wish to exclude certain data such as fees from being loaded for specific accounts.
To view the Do Not Upload List, click Upload / Excluded accounts:
and edit the list, navigate to the Upload / Excluded Accounts page:
Adding Accounts
To specify a single account to exclude,
...
select the
...
Source and enter
...
an Account Id to match. For example, entering 'ACCOUNTXYZ' and selecting Sterling as the source will exclude all activity for that account when importing data from Sterling:
...
Once an account is on the Do Not Upload list, all uploads for ACCOUNTXYZ that account and source will be disabledexcluded: Executionsexecutions, Adjustmentsadjustments, Locateslocates, Positions positions (if doing for reconciliation) and Buying Power buying power entries (if enabled). Existing data is not .
It is important to note that the Account Id is checked for exclusion before any rename rules are applied. Also, any data that is already loaded will not be affected.
Excluding Multiple Accounts
To exclude multiple accountseasily exclude more than one account, you can specify a pattern to match. Here Here are some examples:
...
| Expression | Will Exclude |
|---|---|
| .* | All accounts. |
| ABC.* | All accounts that start with ABC |
| (?!^ABC).* | All accounts that do not start with ABC |
| (?!^ABC)(?!^XYZ).* | All accounts that do not start with ABC or XYZ |
| ^[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 |
| (?!ABC12345)ABC.* |
The pattern syntax used is described here.
Testing the Do Not Upload List
| All accounts starting with ABC, except for ABC12345 |
The patterns used are Perl Compatible Regular Expressions. Their syntax is described in detail here.
It can be useful to combine an expression with a group. If you select a group, PropReports will exclude a matching account only if it already exists in PropReports and belongs to that group.
Testing the List
To see whether or not an account will be excluded, select the source:
Step 1: Click on the Test an Account Id
Step 2: Select the Source, enter the name Account Id and press test Test:
