Follow

Creating Data Overrides

mceclip0.pngCommonly, 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 which can 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.

Default

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 fix 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.

 

Override

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 ISIN = GB0005405286.


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?"


Tip: Consider the "When should we override" carefully. It might be more advantageous to match AssetName = HSBC Holdings PLC or even Issuer = HSBC rather than ISIN = GB0005405286.

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 for HSBC (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 ISIN = GB0005405286 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).

 

Remove

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.

mceclip2.png

 

Enabling / Disabling Overrides

In all cases when creating overrides your 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.

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. A sample format can be found on GitHub, this method is useful when you need to create multiple similar overrides quickly. 

Once you have populated the CSV file, it can be imported via the import button on your Data Overrides page. Do remember to have the date formatting set as yyyy-mm-dd for the file to pass validation

mceclip0.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.