Stock Record Report

The Stock Record report shows Long and Short positions in each CUSIP, based on the inventory positions computed by the inventory engine. Long positions represent ownership or ‘source’ of securities, and Short positions represent location or ‘use’ of securities. The sum of the Long positions in a given CUSIP should always exactly equal the sum of the Short positions in that CUSIP.

Stock Record positions can arise from ANY securities activity, including (but not limited to) all of the following: Purchases and Sales, Repos and Reverse Repos, Securities Lending vs Cash, Securities Lending ‘Free’, Securities Lending vs Collateral, Buy/Sellbacks, Pledges, Free Deliveries of securities, etc.

Stock Record positions are settlement date positions - All trades/transactions with a ‘value date’ greater than the current business date will be ignored.

From the Calypso Navigator, navigate to Reports > Nostro / Custodian Positions > Stock Record Report (menu action reporting.ReportWindow$NewStockRecord) to bring up the report.

You can check / uncheck to display / hide the search criteria.

You can change the pricing details at the bottom of the window - By default, the pricing environment comes from the User Defaults, and the valuation date is the current date and time.

Enter search criteria as needed and click

By default, the report loads the full version, including every CUSIP in which a non-zero position exists.

You can check "Exception Report" to load only those CUSIPS where there is a "break" (the total of the LONG positions does not equal the total of the SHORT positions).

You can select a template and click

to display the number of objects that will be loaded from the database before loading the report.

You can click

to print the report results.

Note that for the Pivot view and the Aggregation view, the print icon is disabled.

You can use [Ctrl+P] or [Ctrl+L] to print the report, or you can export the report to Excel and print it from there.

Each Stock Record position can be categorized as being one of the following types.

FIRM P/S Position

This represents a Firm Position resulting from P/S trades. Firm P/S positions may be either Long or Short. They are computed by the inventory engine: THEORETICAL positions.

Firm securities (i.e. those owned by your firm) are fungible and shown by book.

FAIL Position

This represents a position of transfers in Failed status.

It is identified by FTD (failed to deliver) and FTR (failed to receive).

COLLATERAL Position

A collateral position is represented by individual financing trades (Repo, Reverse Repo, etc.), as well as margin call positions computed by the inventory engine.

Note that for netted GCF Repo positions, the book is set to GCF - Original GCF Repo trade positions (i.e. against the GCF Generic CUSIPS) are EXCLUDED from the Stock Record.

BOX Position

Position at a Depository (Agent) Account computed by the inventory engine: ACTUAL positions.

See Inventory Position for information on computing inventory positions using the inventory engine.