Unlimited History.
Security Master.

No more data wrangling.
Unite all of your investment data, across any source and time.

QUID* MSCI FTSE Barra HOLT Russell S&P Axioma StarMine MarketQA
AGRI BANK OF CN
   32011375360
071C365EF8D42C5408B90A87D829C494BEF3D9EEC558F943
ALPHABET A
   78932244745
03F9B88F12FA8D75C6C051AEE5127CD84227438D2B221636D14EFC404916CD7A
ALPHABET C
   78932244747
03F9B8E875FA8D75C6C051AE27127CDBE13664800FEA81168D66C96A0B0A5E5D
CLS HOLDINGS
   78393145976
7C390FC8DAD376690B4C846EDB27E8925FAB17EE1342BE6E08F30DA8
COCA-COLA FEMSA
   78933521874
02E03483C2D70FD349E8FC6200279592C4D2E6963742FC7108DECDE0
FUJIAN ANJOY A
   32011466491
0A29313788D5485549B89C822A901CACF16EC169
NINTENDO CO
   78933520913
0277F16D32C0562C0C1D43045125CD87EABD7B0C80422A7748DECD07
TLG IMMOBILIEN
   42074853882
CD92A7F49AD26F3509E99AA3349D9C392B617073
TRIPLE POINT SO
   78393476386
9D9350CE92C04B69BA0B9096A2D06D6A766DDE73
WUHAN GUIDE INF
   32011375397
07153A41F8D43C54499D9C68CA29C4942B444033665FF047

* Identifiers have been obfuscated for compliance.

Case Example

Mix, Match, Identify

In the sample table shown above, the same HOLT asset is linked to both share-classes for Alphabet. Qualis helps disentangle these small but crucial distinctions.

QUID Example

Unlimited History

No limits on length of history. Our typical configurations include 30+ years of history per data source.

Vendor-Agnostic

Qualis Security Master generates a unique identifier for each security, linking across any and all vendors.

Algorithmic Matching

Accurately identify securities across ticker, CUSIP, SEDOL, and other market symbol changes.

Data Provenance

Get complete visibility across your data.

Qualis algorithmically untangles decades of historical data across all your data sources through a single unique identifier (QUID).

Issuer Identifiers

BBGID

PERMCO

MSCI Issuer Code

GVKEY

Instrument Identifiers

CUSIP

PERMNO

Global Share Class FIGI

MSCI Security Code

RIC

S&P STOCK KEY

GVKEY+IID

Listing Identifiers

SEDOL

Exchange Level FIGI

Ticker

Reconciliation

Corporate Actions

Symbol Reuse

Vendor-Specific Data Models

In-House Data Assets

Deployment Options
...

Available as managed cloud,
private cloud, or on-prem deployments.

Whether you want us to take care of everything, or you want to use your own infrastructure, Qualis Security Master can be up and running in a matter of days or weeks.

Defining Your Data End-State

We start out with a short conversation to determine how to plug in Qualis to quickly maximize return. We can provide a fully managed service with our secure cloud, or you can opt for a private install to your own cloud or on-prem servers.

Ready, Configure, Load

Set your configuration parameters and connect your existing data sources. Particularly challenging situations? Let's talk, we've probably seen in it before!

Data-as-a-Service

Qualis can publish security cross-reference to SQL database, Snowflake, or cloud data share.

Case Example

See Security Master in Action

Qualis links multiple records, time periods, and vendor identifiers as a single security, and assigns it a unique identifier (QUID). All data, history, and logic is linked through the QUID, allowing for powerful, historical analytics.

This example below shows 7 vendors tracking a single asset over time using varying number of proprietary IDs and market symbols and yet, Qualis arrives at a single QUID algorithmically. Start/End dates are automatically calculated by the Qualis de-duplication engine.

QUID:
VenCode Start End Name Currency CUSIP SEDOL ISIN
Vendor A - Asset - 1
4c6657111994-12-301997-02-18TEVA PHARMACEUTILS3A31BD7035BB6676
4c6657111997-02-181997-02-26TEVA PHARMACEUTILS3A31BD7035BB1242
4c6657111997-02-262000-01-12TEVA PHARMACEUTILSB45C227C3A31BD7035BB1242
4c6657112000-01-12TEVA PHARMACEUTILSB45C227C351EED4435BB1242
Vendor A - Asset - 2
4c67e5e12001-03-30TEVA PHARMACEUTEURB25171022512131336723A42
Vendor A - Asset - 3
4c67e4912011-03-22TEVA PHARMACEUTMXNB25171022512131341529510
Vendor A - Asset - 4
563d6c412014-11-262017-01-03TEVA PHARMACEUTCHFB2517102251213134770E095
Vendor A - Asset - 5
5075a8911994-12-30TEVA PHARMACEUTUSDB25171022512131331BB0B48
Vendor B - Asset - 1
c61333042019-05-10TEVA PHARMACEUTILS351EED4435BB1242
Vendor C - Asset - 1
325501322019-03-01TEVA PHARMA INDB25171022512131331BB0B48
Vendor D - Asset - 1
450024311960-01-012019-11-08TEVA PHARMA IND36723A42
450024312019-11-08TEVA PHARMA IND2512131336723A42
Vendor D - Asset - 2
450024321960-01-011997-02-18TEVA PHARMA IND35BB6676
450024321997-02-182019-11-08TEVA PHARMA IND35BB1242
450024322019-11-08TEVA PHARMA IND351EED4435BB1242
Vendor D - Asset - 3
450024332011-03-222019-11-08TEVA PHARMA IND41529510
450024332019-11-08TEVA PHARMA IND2512131341529510
Vendor D - Asset - 4
450024342014-11-012019-11-08TEVA PHARMA IND4770E095
450024342019-11-08TEVA PHARMA IND251213134770E095
Vendor E - Asset - 1
000500211960-01-011993-03-16TEVA PHARMACEUTB2517102
000500211993-03-162019-11-08TEVA PHARMACEUTB251710231BB0B48
000500212019-11-08TEVA PHARMACEUTB25171022512131331BB0B48
Vendor E - Asset - 2
eb45c2241994-03-152003-11-04TEVA PHARMACEUT413136B8
eb45c2242003-11-042019-11-08TEVA PHARMACEUTB45C227C413136B8
eb45c2242019-11-08TEVA PHARMACEUTB45C227C351EED44413136B8
Vendor F - Asset - 1
003207a11995-01-031997-04-15Teva PharmaceutILS35BB6676
003207a11997-04-15Teva PharmaceutILS35BB1242
Vendor F - Asset - 2
0030b0242019-02-012019-10-01Teva PharmaceutUSDB251710231BB0B48

* Identifiers have been obfuscated for compliance.

Traditional Challenges

  • Vendors provide minimal, inconsistent information for asset name, market symbols.

  • Vendors often use multiple codes (VenCode) for the same asset.

  • Corporate actions, data errors, vendor data schema changes, and other factors require historical reconciliation.

Qualis Security Master

  • Qualis de-dupes content to reduce the number of records (with Start and End).

  • Qualis mastering algorithm links all these assets from different vendors with a single linking identifier (QUID).

  • Start, End, QUID columns are output from Qualis; rest are vendor supplied.

  • Qualis Security Master has capacity for unlimited historical data.

Data as a Service

Refined Data, Easily Accessed

QUID to vendor asset mapping information is programmatically accessible via on-demand APIs, and also published in easy‑to‑read, de‑normalized SQL tables in a separate read‑only database. Our data-as-a-service offerings make it easy to access Qualis from your analytical tool of choice.

ftGetSecuritybySource

Relates assets between vendors historically, eliminating duplicates.

Read more

ftGetIssuerQUIDbyQUID

Primarily used to identfy other share-classes and asset classes from the same issuer.

Read more

ftGetSecuritybyQUID

For a given QUID, returns descriptions of all assets from multiple vendors as of a given point in time.

Read more

* Some integrations require a custom API

Case Study

See Qualis in Action

See how Qualis Security Master helped one of our customers
make sense of 300+ years of historical data.

Learn More
Get started

We're Ready to Talk

Learn more about the Qualis platform and applications today.

Book a demo