Account Import Rules
You can configure how PropReports imports new accounts by creating Account Import Rules. The rules allow you to automatically assign clearing firm information, change account naming conventions and consolidate multiple trading accounts into one.
Note that when adding a new rule, it will only be applied to all subsequent uploads. To correct any data that has already been uploaded, you will have to either re-upload the appropriate file, or move the historical data manually via the Audit / Executions page. For more information on how to complete these workflows, please visit our moving a trade between accounts and how to upload a file support pages.
How to Create an Import Rule
Step 1: Navigate to the Upload / Account Import Rules page.
Step 2: Select the Field (Account Id, Clearing Id, Clearing Firm or Display Name, etc.) you would like to change and enter the information required. Click Add Rule to enable your rule for all future uploads.
Step 3: A conformation banner will appear upon success and your rename rule will appear below if you should ever need to delete it.
Regular Expression Patterns
You can use regular expression patterns in the match and replace fields. Use regular expressions to specify a broad number of identifiers you would like changed. In the example below, all accounts whose Account Id starts with the letters ABC will be replaced with XYZ:
Visit our Regular Expression Patterns support site for a list of other helpful patterns, as well as more information on the topic.
Variables
When specifying the replacement value you can use variables. In the example below, any account with a Clearing Id that starts with 'ETC' will have its Display Name changed to its Account Id:
Below is a list of the different variables you can use for each field being set. Note that the variables are as specified in the upload file - before any renaming takes place.
| Account Id | Aggregation Unit | Clearing Id | Display Name | Offset Account Id |
|---|---|---|---|---|
| {ACCOUNT_ID} | {AGGREGATION_UNIT} | {CLEARING_ID} | {DISPLAY_NAME} | {OFFSET_ACCOUNT_ID} |
| {CLEARING_ID} | {DISPLAY_NAME} | {ACCOUNT_ID} | {ACCOUNT_ID} | {ACCOUNT_ID} |
| {TRADER_NAME} | {ACCOUNT_ID} | {TRADER_NAME} | {CLEARING_ID} | {CLEARING_ID} |
| {TRANSACTION_CURRENCY} | {CLEARING_ID} | {TRANSACTION_CURRENCY} | {TRADER_NAME} | {DISPLAY_NAME} |
| {TRADER_NAME} | {TRANSACTION_CURRENCY} | {TRADER_NAME} | ||
| {TRANSACTION_CURRENCY} | {TRANSACTION_CURRENCY} |
Related Topics / How To