Security Normalization

Security Normalization

Overview

Security normalization is a process that identifies and gathers complete information associated with a security. The process uses the information aggregated from a consumer's account and compares it against Yodlee’s proprietary reference data. The comparison is performed by a complex set of algorithms that can handle multilevel matching using the security’s data attributes. The following pieces form the core of security normalization:

  • Aggregated data
  • Yodlee security master (i.e., reference data)
  • Normalization algorithm


Aggregated Data

Yodlee syncs and aggregates data from more than 3,000 sites in the wealth domain. After a consumer links an account with Yodlee, all the information related to the positions, transactions, and investment options from the account are aggregated. The position data is then run through the normalization process to accurately identify securities as shown in the image that follows.


Yodlee Security Master

Yodlee maintains a proprietary security master that has more than 4 million securities across 80+ exchanges and a dozen asset classes. The master database stores all important information about the security including ticker symbol, CUSIP (Committee on Uniform Security Identification Procedures), ISIN (International Securities Identification Number), SEDOL (Stock Exchange Daily Official List), traded exchange, currency, latest trade price, security type, etc. Third-party data providers such as Standard & Poor's (S&P), Envestnet, and Xignite are used to keep the security master updated with the latest information about public securities from around the world. Yodlee also provides support for private securities including hedge funds and private equity/venture capital investments.


Normalization Algorithm

The security normalization algorithm uses information from the aggregated data and attempts to identify the exact security by matching aggregated security data against the Yodlee security master reference data. When financial institutions do not provide complete security data, the normalization process helps identify the correct security. Using the algorithm, all positions aggregated from the consumer's account are normalized, thereby updating and enriching the missing information to provide a more complete picture of the consumer's portfolio.

The security normalization algorithm performs the following steps:

  1. Security Identification – The identification process keeps running through the scenarios in the following order until single security is identified from the security master:
    1. Match using the CUSIP, ISIN, SEDOL, and VALOREN
    2. Match using the ticker symbol
    3. Machine learning-based scientific approach to match holdings using the security description.
    4. Machine learning-based price model used as the selection criteria for securities.
  2. Security Elimination – If the security identification process identifies multiple securities, then the security elimination or refining process is performed using exchange, currency, and domicile/region.
  3. Security Verification – If single security is successfully identified after the security identification or elimination process is complete, the verification process is done to ensure the accuracy of the security identified. The verification process compares multiple data elements from the aggregated security with the security master data. Key fields such as CUSIP, ISIN, SEDOL, VALOREN, exchange, currency, ticker symbol, trade price, etc., are used for the security verification comparison process.


Normalization 2.1 Benefits

Normalization 2.1 is our latest version. The benefits of Normalization 2.1 are as follows:

  • Machine learning to identify securities
  • More complete coverage of security types and account types
  • Centralized logic for security type and account type identification
  • Comprehensive security master


Security Types

Security Type Id

Security Type

API Response Value

2

Agency Bond

AGENCY_BOND

3

Annuity Fund

ANNUITY_FUND

4

Corporate Bond

CORPORATE_BOND

5

Certificate of Deposit

CERTIFICATE_OF_DEPOSIT

6

Common Stock

COMMON_STOCK

7

Exchange Traded Fund

EXCHANGE_TRADED_ FUND

8

Employee Stock Option

EMPLOYEE_STOCK_ OPTION

10

Limited Partnership

LIMITED_PARTNERSHIP

11

Money Market Fund

MONEY_MARKET_FUND

12

Municipal Bond

MUNICIPAL_BOND

13

Mutual Fund

MUTUAL_FUND

14

Preferred Stock

PREFERRED_STOCK

17

Right

RIGHT

19

US Treasury

US_TREASURY

20

Unit Investment Trust

UNIT_INVESTMENT_TRUST

21

Warrant

WARRANT

23

Other

OTHER

24

Cash

CASH

25

Commodity

COMMODITY

26

Currency

CURRENCY

27

Future Contract

FUTURE_CONTRACT

29

Mortgage Backed Security

MORTGAGE_BACKED_SECURITY

30

Closed End Fund

CLOSED_END_FUND

31

Peer to Peer Loan

PEER_TO_PEER_LOAN

32

Restricted Stock Unit

RESTRICTED_STOCK_UNIT

33

Restricted Stock Award

RESTRICTED_STOCK_AWARD

39

Collateralized Mortgage Obligation

COLLATERALIZED_MORTGAGE_OBLIGATION

40

Asset Backed Securities

ASSET_BACKED_SECURITIES

41

Convertible Preferred

CONVERTIBLE_PREFERRED

42

Convertible Bonds

CONVERTIBLE_BONDS

43

Foreign Bond

FOREIGN_BOND

44

Government Bond

GOVERNMENT_BOND

45

Call Option

CALL_OPTION

46

Put Option

PUT_OPTION

47

TIPS

TIPS

48

Variable Annuity

VARIABLE_ANNUITY

51

Structured Notes

STRUCTURED_NOTES