IPR Strategies - Value-Factor

For the D&B Project:

• Ignore iprstrat_IPR-ValueFactor_sample_2007-2020.csv.gz

• Ingest: iprstrat_IPR-ValueFactor_backfile_2007_01-2021_04.csv.gz - this full backfile includes all history up until the most recent valuation slice as of 2021-04-30.

• Monthly updates: In the future, they will upload deltas since historical data remain unchanged (until there is a new valuation version).

• For dunsification, please see match logic file. Note that the primary_ISIN needs to go through ISO code substitutions.

Data Dictionary as of 05/12/2021:

ISO Code Substitutions:

For Match Logic, please see the latest file on:

To match the data,

• add a new field called ISIN_country and populate this field by extracting the first two chars of the primary_ISIN field

• add a new field called ISIN_countryISOAlpha2Code and populate this field by using ISO code substitution on top of ISIN_country (e.g. if ISIN_Country = ‘PR’, then ISIN_countryISOAlpha2Code = ‘US’)

Match Input fields explanation:

• name → name

• country → countryISOAlpha2Code

  • if country = null, use ISIN_countryISOAlpha2Code → countryISOAlpha2Code

• town_or_address → addressLocality

Acceptance rules (to be confirmed with D&B)

• Accept all confidence code >=7

• If ConfidenceCode <7, accept matches where matchGrade has the following pattern A*

• Apply '1' AcceptanceIndicator to all above conditions