...
| No Format |
|---|
Date/Time,Account,Offset Account,Qty,Symbol,Cost,Locate Id 03/31/2009 13:25:55,ACCOUNT1,ACCOUNT2,1000,AAPL,40.0,ABC123 |
Fields
Name | Mandatory? | Format | Sample | Introduced in Version | Description |
|---|---|---|---|---|---|
Date/Time | Yes | MM/DD/YYYY HH:MM:SS |
| All | Date and time of the locate in Eastern time. If time is unknown, specify as 00:00:00. |
Account | Yes | CHAR(20) |
| All | Name of the account (PropReports Account Id). Anything after the first 20 characters will be ignored. |
Offset Account | No | CHAR(20) |
| All | 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 |
| All | Number of shares located. |
Symbol | Yes | CHAR(48) |
| All | Ticker symbol of the instrument being located. Please follow the symbol naming convention. |
Cost | No | DECIMAL(15, 4) UNSIGNED |
| All | 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 | All | Per share fee associated with this locate. Please specify either Cost or Cost Per Share column but not both. |
| Locate Id | No | CHAR(25) | ABC-123 | All | An external id associated with this locate. Locate Ids are not case-sensitive. |
| Source | No | CHAR(32) | Sterling | 1.5.95.50 | Source of the data being uploaded (see list of source names). If the column is not present, the source defaults to Generic. |
...