Curve settings file

The curve settings CSV file is used to control curve-wide settings when loading curves into the system. It is used by the curve loader and curve calibration loader.

Format

The curve settings file is a simple CSV-formatted file with the following header row:

Curve Name,Value Type,Day Count,Interpolator,Left Extrapolator,Right Extrapolator

The columns may be specified in any order, however this is the recommended order. The meaning of each column is as follows:

Column name Description
Curve Name The name of the curve
Value Type The type of value in the curve, “Zero” for zero rates or “DF” for discount factors
Day Count The day count to use for dates in the curve
Interpolator The name of the interpolator, used when querying a value between two nodes on the curve
Left Extrapolator The name of the left extrapolator, used when querying before the earliest point on the curve
Right Extrapolator The name of the right extrapolator, used when querying after the latest point on the curve

See DayCounts for valid day count names. See CurveInterpolators for valid interpolator names. See CurveExtrapolators for valid extrapolator names.

These settings are used when loading individual curve nodes via the curve loader or curve calibration loader.

Example

This example file specifies the settings for two curves.

Curve Name, Value Type, Day Count, Interpolator, Left Extrapolator, Right Extrapolator
USD-Disc,   Zero,       Act/365F,  Linear,       Flat,              Flat
USD-3ML,    Zero,       Act/365F,  Linear,       Flat,              Flat

Note that Microsoft Excel prefers the CSV file to have no spaces after the comma.