Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Name

Mandatory?

Format

Sample

Introduced in Version

Description

Date/Time

Yes

MM/DD/YYYY HH:MM:SS

06/17/2010 16:00:00

All

Date and time of the locate in Eastern time. If time is unknown, specify as 00:00:00.

Account

Yes

CHAR(50)

ABC1234567

All

Name of the account (PropReports Account Id). Anything after the first 20 characters will be ignored.

Offset Account

No

CHAR(50)

1234567

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

5000

All

Number of shares located.

Symbol

Yes

CHAR(48)

IBM

All

Ticker symbol of the instrument being located. Please follow the symbol naming convention. To specify a ticker in a different format you can name this column "Sterling Symbol," "Reuters Symbol," "Nasdaq IP Symbol," "Bloomberg Symbol" or "Wedbush Symbol".

Columns below are optional and can be in any order.
CategoryNoCHAR(20)P/L1.5.96.13AllIf the locate has a fee, this is the name of an adjustment category to use. Enter a category currently defined in PropReports or one of: SoftwareQuotes, InterestDividendCash In/Out and Stock Locate. Leaving blank or entering an unknown category will default to Fee: Stock Locate.

Cost

No

DECIMAL(15, 4) UNSIGNED

40.0

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 ShareNoDECIMAL(18, 8) UNSIGNED0.25AllPer share fee associated with this locate. Please specify either Cost or Cost Per Share column but not both.
PriceNoDECIMAL(18, 8)1.2341.13.54.3Execution price
Locate IdNoCHAR(25)ABC-123AllAn external id associated with this locate. Locate Ids are not case-sensitive.
Display NameNoCHAR(50)John1.5.97.14.57AllThe account name you and the traders will see in reports (see Account Names). If an account already exists, the display name will only be updated if it has not been already set.
Clearing IdNoCHAR(50)ABC-1231.5.97.14.57AllThe Clearing Id is the Account Id at your clearing firm (see Account Names ).  
SourceNoCHAR(32)Sterling1.5.95.50AllSource of the data being uploaded (see list of source names). If the column is not present, the source defaults to Generic.

...