Get Security Primary by QUID


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.


  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.