Curve groups file
The curve groups CSV file is used to define a curve group when loading curves into the system. It is used by the curve loader.
A curve group is used to assign a purpose to a coherent set of curves. For example, a group might contain three curves, one for USD discounting, one for the USD Fed Fund index and one for the USD LIBOR 3 month index. Alternatively, the group might contain one curve used for all three purposes.
Format
The curve groups file is a simple CSV-formatted file with the following header row:
Group Name,Curve Type,Reference,Curve Name
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 |
|---|---|
| Group Name | The name of the curve group |
| Curve Type | The type of curve, “Discount” for a discounting curve, or “Forward” for a forward curve |
| Reference | The reference for which the curve is used, such as the currency or index |
| Curve Name | The name of the curve |
A discount curve must have a 3 letter ISO currency code as the reference, such as “USD”. A forward curve must have an index as the reference, such as “USD-LIBOR-3M”. See the indices page for Strata’s default index names.
The groups file refers to curve names that are defined in the curve settings file.
Example
This example file specifies a single group, “USD-DSCON-LIBOR3M”, with two curves, “USD-Disc” and “USD-3ML”. The “USD-Disc” curve is used as both a USD discounting curve and as a Fed Fund forward curve. The “USD-3ML” curve is only used as a forward curve for 3-month USD LIBOR.
Group Name, Curve Type, Reference, Curve Name
USD-DSCON-LIBOR3M, Discount, USD, USD-Disc
USD-DSCON-LIBOR3M, Forward, USD-FED-FUND, USD-Disc
USD-DSCON-LIBOR3M, Forward, USD-LIBOR-3M, USD-3ML
Note that Microsoft Excel prefers the CSV file to have no spaces after the comma.