To load a batch of stock locates and stock locate fees into PropReports, a comma-separated values (CSV) file can be used. Please follow RFC 418 guidelines when creating CSV files. Notably, if you will have field values with commas, the field value must be in quotes.
Click here for a Locates file CSV Template.
Sample Data:
Date/Time,Account,Offset Account,Qty,Symbol,Cost,Locate Id 03/31/2009,ACCOUNT1,ACCOUNT2,1000,AAPL,-40.0,ABC123
Field | Mandatory? | Format | Sample | Description |
|---|---|---|---|---|
Date | Yes | MM/DD/YYYY | 06/17/2010 | Date on which the adjustment should post. |
Account | Yes | CHAR(20) | 1234567 | Name of the account (PropReports Account Id). Anything after the first 20 characters will be ignored. |
Offset Account | No | CHAR(20) | 1234567 | Optionally, name of the opposite account for the locate fee being charged. If there is no fee, this field will be ignored. |
Qty | Yes |
|
|
|
Symbol | Yes |
|
|
|
Cost | No |
|
| Total fee associated with this locate. Both positive and negative values will be processed as a fee. |
| Cost Per Share | No | Per share fee associated with this locate. Please only specify either Cost or Cost Per Share when uploading locates. | ||
| Locate Id | No |
Enabling the Upload
Before uploading for the first time, you must to make sure the Generic data source is enabled
- Click on the 'Upload' menu.
- Click on the 'Sources' sub-menu.
- If the Generic source is in the Disabled Sources list, click Enable next to it.
Uploading the File
To load the file into PropReports, please follow these instructions.