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
Back to top

More Security Master Docs


Key Models


Contact Us

Questions? Reach out to us any time.