Get Security by QUID

ftGetSecuritybyQUID

For a given QUID, returns description of all assets (including market symbols, lineage, QUID, QUIN) from multiple vendors as of a given point in time. Wild cards are supported.

Usage:


                        SELECT *
                        
  FROM ftGetSecurityByQUID(@QUID, @AssetCode, @AsOfDate)

Parameter	Type	Wildcard?	Pass NULL?	Description	Notes
@QUID	nvarchar(50)	Y		QUID
@AssetCode	nvarchar(50)	Y	Y	Asset Code	`NULL` ignores AssetCode filter
@AsOfDate	date		Y	As of date	`NULL` ignores date filter

Example:


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

Returns all BARRA assets with the supplied QUID as of 29 Feb 2012.

Back to top

More Security Master Docs

Key Models

Security Master Current Model
Risk Model

Contact Us

Questions? Reach out to us any time.