Adjustments

Download sample file: adjustments.csv

This file is used to create adjustments in bulk. For information on how to upload adjustments using this file, see Upload adjustments.

Column Name	Description	Required	Value Example
taskId	The ID of the related task. You should find this in the task viewer of the UI.	Y	1
reason	The reason for the adjustment.	Y	Invalid input
comment	A comment associated with the adjustment to be performed.	Y	The pricing model is producing an incorrect value for this trade id
adjustmentType	The type of adjustment.	Y	VAR_ROLL_OVER
validFrom	The date the adjustment is valid from.	Y	2023-09-28
validTo	The date until which the adjustment is valid.	Y	2023-09-29
location	The location of the adjustment.	Y	name=AsOfDate|value=2023-09-28|memberPath=[Dates].[Date].[2023-09-28];name=MarketDataSet|value=Official EOD|memberPath=[MarketData].[MarketDataSets].[Official EOD];name=Desk|value=Equities|memberPath=[Booking].[Desks].[AllMember].[Equities];name=Book|value=EQ_LARG_DM|memberPath=[Booking].[Books].[AllMember].[EQ_LARG_DM];name=TradeId|value=EQ_OPT_Dell 3eab66e4|memberPath=[Booking].[Trades].[AllMember].[EQ_OPT_Dell 3eab66e4];
measures	The list of measures the adjustment apply to. This list is semicolon (;) separated.	Y	VaR
input	The value of the adjustment: data used to fulfill the adjustment. Format may vary depending on the type of adjustment.	Y	name=AsOfDate|value=2023-09-27;

Location

name=name1|value=value1|memberPath=memberPath1;name=name2|value=value2|memberPath=memberPath2;

Resulting in a List of NamedValueDTOs separated by semicolons ; (List<NamedValueDTO>).

We get:

name=name1|value=value1|memberPath=memberPath1

and

name=name2|value=value2|memberPath=memberPath2

These NamedValueDTOs are made from the split by the pipe |. Each become:

name=name1
value=value1
memberPath=memberPath1

and

name=name2
value=value2
memberPath=memberPath2

Input

Similar to Location

name=name1|value=value1;name=name2|value=value2;

becomes a List of:

name=name1|value=value1
name=name2|value=value2