...
| No Format |
|---|
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/Time | Yes | MM/DD/YYYY HH:MM:SS |
| Date on which the adjustment should postand time of the locate in Eastern time. If time is unknown, specify as 00:00:00. | ||
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) |
| Optionally, name of the opposite account for the locate fee being charged. If there is no fee, this field will be ignored. | ||
Qty | Yes |
|
| DECIMAL(18, 8) UNSIGNED |
| Number of shares located. |
Symbol | Yes |
|
| CHAR(48) |
| Ticker symbol of the instrument being located. Please follow the symbol naming convention. |
Cost | No |
| DECIMAL(15, 4) UNSIGNED |
| Total fee associated with this locate. Both positive and negative values will be processed as a fee (there is no way to post a credit). | |
| Cost Per Share | No | DECIMAL(18, 8) UNSIGNED | 0.25 | Per share fee associated with this locate. Please only specify either Cost or Cost Per Share when uploading locatescolumn but not both. | ||
| Locate Id | No | CHAR(25) | ABC-123 | An external id associated with this locate. Locate Ids are not case-sensitive. |
Enabling the Upload
| Note |
|---|
Before uploading for the first time, you must to make sure the Generic data source is enabled |
...
To load the file into PropReports, please follow these instructions. Load the file as "Locates" in order to upload the locate events and as "Adjustments" in order to post associated fees.