Get Security Primary by QUID

ftGetSecurityPrimarybyQUID

For a given QUID, returns description of ONE (top) asset from each vendor (including market symbols, lineage, QUID, QUIN) as of a given point in time. Wild cards are supported. Since vendors can use multiple codes to identify the same security over time, this function returns the top candidate per source.

Usage:

SELECT *
  FROM ftGetSecurityPrimaryByQUID(@QUID, @AsOfDate, @AssetCode)
Parameter Type Wildcard? Pass NULL? Description Notes
@QUID nvarchar(50) QUID
@AsOfDate date As of date NULL ignores date filter
@AssetCode nvarchar(50) Y Y Asset Code to translate to Use wildcard to limit target asset codes

Example:

SELECT *
  FROM ftGetSecurityPrimaryByQUID('XYZABC1212', '2012-02-29', NULL)
 ORDER BY QUID, AssetCode

Returns the primary asset from each vendor for the supplied QUID as of 29 Feb 2012.

Back to top

More Security Master Docs

Key Models

Contact Us

Questions? Reach out to us any time.