This is the primary interface to relate assets between vendors historically. Given the many-to-many nature of asset codes between vendors for the same security, this function makes it simple to eliminate duplicates.
Map ONE (top) asset per
ToSource for each
as of a given point in time (using
QUIDs) and return descriptions from
both sources (market symbols, lineage,
Used to map assets between two or more vendors and always includes all assets in
Wildcards are supported.
FROM ftGetSecurityBySource(@FromAssetCode, @AsOfDate, @ToAssetCode)
|@FromAssetCode||nvarchar(50)||Y||Asset Code to translate from|
|@AsOfDate||date||As of date|
|@ToAssetCode||nvarchar(50)||Y||Asset Code to translate to|
Questions? Reach out to us any time.