Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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 ShareNo  Per share fee associated with this locate. Please only specify either Cost or Cost Per Share when uploading locates.
Locate IdNo   

Enabling the Upload

Before uploading for the first time, you must to make sure the Generic data source is enabled

  1. Click on the 'Upload' menu.
  2. Click on the 'Sources' sub-menu.
  3. 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.

  • No labels