Examples of Data Overrides - Common Cases
Please note the below are recommendations. Please keep in mind that it is the sole responsibility of the client to ensure the accuracy of the data sent to the service and data overrides.
Target Property | Recommended Condition Property | Property Class |
TotalSharesOutstanding | IssuerId | Issuer |
TotalVotesOutstanding | IssuerId | Issuer |
TotalVotingRightsInTreasury | IssuerId | Issuer |
TotalSharesInTreasury | IssuerId | Issuer |
Delta | InstrumentId or ISIN | Instrument |
ParValue | InstrumentId or ISIN | Instrument |
Price | InstrumentId or ISIN | Instrument |
AssetClass | InstrumentId or ISIN | Instrument |
ClassSharesOutstanding | InstrumentId or ISIN | Instrument |
InstrumentId or ISIN | Instrument | |
VotesPerShare | InstrumentId or ISIN | Instrument |
MarketValue | AssetId | Asset |
AssetId | Asset | |
Quantity | AssetId | Asset |
FundApps recognise that some clients may have many InstrumentIds mapped to a single ISIN. In these cases, FundApps would recommend using ISIN as the recommended condition property to use for properties with a Property Class of Instrument.
For more info on creating Data Overrides please see Creating Data Overrides.
Validation Rules for Data Overrides
We have enforced validation rules on data overrides to ensure data consistency. Here are some validations to be aware of:
Condition & Target Property
The "Condition Property" type must match the "Target Property". For example, you can only override TotalSharesOutstanding with IssuerId/IssuerName. If you try to override TotalSharesOutstanding with InstrumentId or ISIN, that would fail validation since one is an Issuer property and the other is an Instrument property. This makes sense as TotalSharesOutstanding will be identical across all share classes held in a specific issuer.
Target Property & Target Source
Our data overrides are advanced enough to allow you to override the value from another property. For example, if IssuerId=X, you can override TotalSharesOutstanding with a value in TotalVotingRights. Just like earlier scenarios, the property classifications need to match.
Case Sensitive
If you are creating data overrides in the UI, it will have a drop-down menu once you start typing the property name to make it easy to use. If you are, however, bulk editing/creating data overrides using the CSV import, the Property names must be in the correct format. For example, IssuerId instead of IssuerID, or IssuerId.
Edge Cases
AssetId
When creating a data override for an AssetId, it has to be the AssetId provided in the positions file.
For example, if 5 shares of Google Class A have AssetId= 545 and belong to Fund A with PortfolioId=FdA -> In the UI, the AssetId will be displayed as FdA_545.
Correct data override: AssetId=545
Incorrect data override: AssetId=FdA_545
Inheritable properties
Properties that are inheritable (IsInheritable = true) are only applicable to the most granular underlying asset classes such as Equity, Preferred Equity, and Units as per the data spec. If you are trying to override an inheritable property such as ClassSharesOutstanding, TotalSharesOutstanding, IssuerName, TotalVotingRights, VotesPerShare etc you must override the data point on the underlying instrument (asset class for which the property is valid) as the value will get copied up from this instrument. For additional information on inheritable properties please read this article.