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:

Related Topics / How To

Ticker Symbol Import Rules