Skip to main content
Data Checklist
Updated over 3 weeks ago

Overview

According to the computing acronym "GIGO," more commonly known as the "Garbage In, Garbage Out" principle, the quality of your data input will directly impact the quality of FundApps output. For that reason, it is extremely important to ensure the data being provided is accurate and mapped correctly.

Our data specification page, linked here, contains a full list of all the data elements required and additional background for each one. Here are the noteworthy ones we'd like to highlight:

IssuerId

This value must remain consistent over time. Please don't use LEI or Issuer Name; more on this here.

Market

It is critical that for any market, segment MICs are provided for these properties. In ISO’s official FAQ for the MIC standard under the section “MIC LEVELS”, it is important to take note of the definitions of “market segment MIC” and “operating MIC” and the point that “The use of market segment MICs provides more accuracy.” Each operating MIC is also a segment MIC, so in practice, one can only be said to provide an “operating MIC” where it happens to be identical to the segment MIC (e.g. where it is the main board or the only venue for an exchange).

These properties help to inform the system which securities are in the scope of which jurisdictions. Especially for these properties, inaccurate data leads to a significant risk of inaccurate rule calculations and, therefore, a risk of missed disclosures.

FundApps is unable to validate whether our clients are providing the MICs at the granularity of segment MIC, so if you are not 100% confident, we strongly recommend that you re-confirm with your data provider(s) that MICs are provided at segment MICs level.

MarketsListedIn

This list must include all MICs at the segment MIC level where the instrument is trading (see the ISO MIC FAQ under "MIC LEVELS" for details).

MaturityDate

For Convertibles, Rights, and Warrants, it should be the first day the security can be converted into the underlying.

AssetId

It must remain consistent and not change over time; more on this here.

TotalSharesOutstanding

If you are sourcing this value from Bloomberg, please contact them. We have heard from some clients that Bloomberg value can include Treasury Shares for certain countries, in which case your denominator can be overstated, leading to inaccurate holding calculations.

ClassSharesOutstanding vs TotalSharesOutstanding

As per the data specifications provided here, ClassSharesOutstanding is the total amount of shares in circulation for this share class. TotalSharesOutstanding is the total amount of issued shares in circulation (held by investors) for an issuer and includes the outstanding shares from all share classes (excludes treasury stock). This means if the issuer has multiple share classes, TotalSharesOutstanding will always be greater than ClassSharesOutstanding.

MarketValue

For derivatives, market value should be provided with accrued interest. For non-derivative assets, market value should be provided without accrued interest. For bonds, face value * dirty price to calculate the market value.

Did this answer your question?