UpdateRelationshipData
The UpdateRelationshipData() function updates relationship data in the Quintessence database.
Related functions: RelationshipData, UpdateRelationship
Syntax:
Qx.UpdateRelationshipData(Entity, Relationship Type, Constituent Data, Relationship Date, Factor, Unit, Period, [IAAD], Attributes, Source, Strategy, [ShowError])- In Excel with Quintessence add-in versions prior to 25.1, use:
UpdateRelationshipData() - In the Quintessence Editor (Studio) using Quintessence language, use:
UpdateRelationshipData() - In the Quintessence Editor (Studio) using Python language, use:
Qx.UpdateRelationshipData()
ⓘ See parameter descriptions
| Entity | An entity in the Quintessence database is any element with associated data that is identified by a code, such as an instrument, portfolio, country, or manager. |
| Relationship Type | The relationship between the child and parent entities. |
| Children | The constituents to add, remove, or set for the relationship. |
| Relationship date | The date on which the relationship applies. |
| Factor | The type of TimeSeries values requested. |
| Unit | The code of the unit type associated with the relationship data. |
| Period | The period related to the values under consideration. Possible values: • NA – Not Applicable• D – Day• W – Week• M – Month• B – Bi-Monthly• Q – Quarter• S – Semi-Annual• Y – Year |
| IAAD (optional) | The as at date specifies the point in time for the information. Any data declared after the IAAD is ignored. |
| Attributes | The attribute(s) of the values under consideration. |
| Source | The source provider of the data. |
| Strategy | Defines how the update should be applied. Valid values: • Set – Replace the entire list.• Add – Add the specified children.• Remove – Remove the specified children.• None – Update relationship data only, not the relationship itself.Set can also be combined with: • Always – Always make the change.• OnChange – Only make the change if the set has changed.Example: Set, Always |
| ShowError (optional) | If TRUE, an error message is displayed when the function fails. |
Remarks:
- Unless changed by an administrator, the default parameter is:
- IAAD: today
- This function is executed by clicking Execute Selected or Execute Sheet in the Quintessence ribbon.
- To update the relationship itself, see UpdateRelationship.
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Update the Holding value of a specific constituent
Initial data:
| Parent | Relationship | Source | Date | Child | Holding |
| 5010 | Constituent | PortfolioAdministrator1 | 2015/02/02 | XDU | 6000 |
| 5010 | Constituent | PortfolioAdministrator1 | 2015/02/02 | KVJ | 8500 |
We want to update XDU’s Holding from 6000 → 6500 for 2 Feb 2015.
Data supplied in Excel (A1:B1):
| XDU | 6500 |
Assume the relationship data has:
- Unit:
ZAR - Period:
D - Attribute:
Interim
Formula:
=Qx.UpdateRelationshipData("5010", "constituent", A1:B1, "2 Feb 2015", "Holding", "ZAR", "D", , "Interim", "PortfolioAdministrator1", "None")Result:
| Parent | Relationship | Source | Date | Child | Holding |
| 5010 | Constituent | PortfolioAdministrator1 | 2015/02/02 | XDU | 6500 |
| 5010 | Constituent | PortfolioAdministrator1 | 2015/02/02 | KVJ | 8500 |