Get Security

ftGetSecurity

For a given Asset, returns descriptions (market symbols, lineage, QUID, QUIN) as of a point in time. Wild cards are supported.

Usage:

SELECT *
  FROM ftGetSecurity(@AssetCode, @AsOfDate)
Parameter Type Wildcard? Pass NULL? Description Notes
@AssetCode nvarchar(50) Y Y Asset Code Example: 'BARRA-%'
@AsOfDate date Y As of date NULL ignores date filter

Example:

SELECT *
  FROM ftGetSecurity('BARRA-%', '2012-02-29')
 ORDER BY AssetCode, FromDate

Returns all BARRA assets as of 29 Feb 2012.

Back to top

More Security Master Docs

Key Models

Contact Us

Questions? Reach out to us any time.