Creating Data Overrides
This article covers the following main sections:
- default overrides
- override override
- remove override
- seeing when overrides are used
- enabling/disabling overrides
Creating multiple overrides via CSV file upload
Commonly, clients encounter problems sourcing certain pieces of data. We recommend that you try and resolve these issues at source (as other systems might be reliant on the data), but otherwise, Rapptr has a Data Override function that can be accessed from the "Admin" menu.
What type of Data Override should be used?
Default is for populating fields that are blank or missing in the input file.
Override is for changing the value of fields when the input property matches a certain condition.
Remove is for removing extra fields that are present in the input file.
1. Replacing a property with a value when it is blank (Default)
In this case, Delta will be set to 1 when Delta is blank (Blank box is checked).
2. Replacing a property with a value when it is blank for a certain asset class (Default)
In this case, Delta will be set to 1 when Delta is blank or missing and the asset class is Option.
3. Setting the value of one property to the value in another
Sometimes it all gets a bit tricky and you need to copy the value of one property into another. With Rapptr, not a problem.
The trick here is the action "Replace with the value from another property" (rather than "Replace with a fixed value" as in the other cases). In the example above we will look for any assets which have a blank "MarketsListedIn". For such assets, we will copy the value in the Market property into the MarketsListedIn property. Another good example of this is if you cannot provide "ClassSharesOutstanding," you could copy the value of "TotalSharesOutstanding" into it.
1. Setting the value of a specific property for a specific asset to a certain value
In this case TotalSharesOutstanding will be set to 1234567 for any asset where the IssuerId=891011.
It's important to note that Rapptr matches on the EXACT value of the string in your input file when looking at the values you've specified under "When should this be applied?"
When creating overrides the Condition property should be of the same property class as the target property.
For example this override would not be able to be created using the ISIN. The IssuerId property is an Issuer property and the ISIN is an instrument property. As TotalSharesOutstanding is an issuer property, IssuerId can be used to create this override. To check the property classifications please check the Properties required for Shareholding Disclosure page.
2. Setting the value of a specific property for a specific asset to a certain value only as long as it is wrong
In the previous case the override will be active forever, i.e. TotalSharesOutstanding will always be set to 1234567 (or until "To date" or the override is disabled). In most cases you will know the wrong value being sent by your source system and can say "As long as it is this particular value, override it."
This case is exactly the same as before but will only apply when the IssuerId=891011 AND the value in TotalSharesOutstanding=1000000. As soon as the value coming from your source system changes from 1000000 the override will no longer apply.
In these cases, be sure to input the EXACT string/value contained in your raw input file (which is not necessarily what will be shown on Rapptr screens). For example, if your input file had specified a string/value of 1000000.000, then the value you insert into the "AND" condition will need to match your input file exactly (i.e. 1000000.000).
1. Removing a value
Sometimes things go wrong and you need to set a value to empty.
In this case for some reason, your source system is delivering equities with ULAssetClass set to Equity (an equity on an equity? Hmm. Not possible). So in this case we use the action "Remove value" on ULAssetClass when AssetClass = Equity.
Seeing when overrides were used
In the Results details screen, any properties where an override has taken effect are highlighted in blue. The original value that was provided is also displayed if you hover your mouse over the property.
can also view the last column of the Data Overrides table to see when an override was last applied, via the Last NAV date column:
Enabling / Disabling Overrides
In all cases when creating overrides you can select a specific From and To date as a period for the override to be active in.
Important: The From and To Date apply to the NavDate in the file uploaded, NOT the current date, so ensure that the From Date is before the NavDate, if you are uploading an old file.
Alternatively, you can leave overrides without a ‘To Date’ and manually enable and disable them by unclicking the "Override enabled" box.
Overrides can be deleted from the main menu and filtered depending on their current status.
For more information on managing data overrides please click here.
Important: The order in which data overrides are run by Rapptr is not guaranteed, so please ensure there are no dependencies in your overrides.
Creating multiple overrides via CSV file upload
In addition to adding or amending your data overrides via the UI, you may create new ones via a CSV file. This is explained in detail here.