Setting up the yield curve file

From Flametree Technologies
(Difference between revisions)
Jump to: navigation, search
(Overview)
(Overview)
 
(6 intermediate revisions by one user not shown)
Line 3: Line 3:
 
===Differences from Version 1===
 
===Differences from Version 1===
  
Please note that the format of the yield curve file has changed from the format used in version 1 of FIA. The changes are:
+
Please note that the format of the yield curve file has changed from that used in version 1 of FIA. The changes are:
  
 
* No credit rating column is used, so there are now four columns instead of five.  
 
* No credit rating column is used, so there are now four columns instead of five.  
 
* The order of the columns has changed.
 
* The order of the columns has changed.
 +
* In versions 2.0.6 and later, the requirement that there be at least three points for each yield curve at each date has been removed. A curve can now be defined by a single point at each date, which specifies the level of the curve at all maturities. In this case, the curve is flat.
  
 
===Overview===
 
===Overview===
Line 12: Line 13:
 
The yield curve file supplies information about yield curves for various ratings over time. Any number of rows may be entered into the file, but there must always be exactly four columns as shown below.
 
The yield curve file supplies information about yield curves for various ratings over time. Any number of rows may be entered into the file, but there must always be exactly four columns as shown below.
  
The yield curve file can be used to store zero curves, par curves, sector curves, swap curves, or any other type depending on the requirements of the securities you are modelling.
+
The yield curve file can be used to store zero curves, par curves, sector curves, swap curves, or any other type depending on the requirements of the securities you are modelling.  
  
  '''Yields must be entered in decimal format. For instance, a 5% yield is recorded as 0.05.'''
+
Unused or unreferenced curves are ignored.
 +
 
 +
  '''Yields are recorded in decimal format. A 5% yield is recorded as 0.05.'''
  
 
All rows in the yield curve file must conform to the following format:
 
All rows in the yield curve file must conform to the following format:
Line 46: Line 49:
 
|0.25
 
|0.25
 
|Yes
 
|Yes
|Tenor point on the curve for this sample, in years. Must be a non-negative real number
+
|Tenor point on the curve, for the following rate, in years. Must be a non-negative real number
 
|-
 
|-
 
|4
 
|4
Line 60: Line 63:
 
|}
 
|}
  
Each row in the file contains the yield for a given curve name, date and maturity. The tuple <tt>(Curve name, Date, Maturity)</tt> must be unique; duplicate curve points will generate an error.
+
Each row in the file contains the yield for a given curve name, date and maturity. The tuple <tt>(Curve name, Date, Maturity)</tt> must be unique, and duplicate curve points within the same file will generate an error.
  
 
=== Date ===
 
=== Date ===
  
Entries in the Date column must conform to the relevant date format string in the project’s configuration file (see [[Chapter_4:_Setting_up_the_configuration_file|Chapter 4]], ''Setting up the configuration file'').
+
Entries in the Date column must conform to the relevant date format string in the project’s configuration file .
  
 
Yield curve data can be supplied at any frequency you wish, including daily, weekly or monthly. We recommend daily data for most accurate results. If a few days are missing, FIA will use the most recent data available up to that point for attribution.
 
Yield curve data can be supplied at any frequency you wish, including daily, weekly or monthly. We recommend daily data for most accurate results. If a few days are missing, FIA will use the most recent data available up to that point for attribution.

Latest revision as of 03:40, 13 April 2018

Contents

Setting up the yield curve file

Differences from Version 1

Please note that the format of the yield curve file has changed from that used in version 1 of FIA. The changes are:

Overview

The yield curve file supplies information about yield curves for various ratings over time. Any number of rows may be entered into the file, but there must always be exactly four columns as shown below.

The yield curve file can be used to store zero curves, par curves, sector curves, swap curves, or any other type depending on the requirements of the securities you are modelling.

Unused or unreferenced curves are ignored.

Yields are recorded in decimal format. A 5% yield is recorded as 0.05.

All rows in the yield curve file must conform to the following format:

Column Field Type Example Required? Rules
1 Curve name String AUD_CURVE Yes Must be a string with at least 3 characters
2 Date Date 31/12/12 Yes Date of current curve, using the date format supplied in the DateFormat or YieldcurveDateFormat strings
3 Maturity Double 0.25 Yes Tenor point on the curve, for the following rate, in years. Must be a non-negative real number
4 Rate Double 0.04554 Yes Yield of curve at given date and tenor point.

Must be a real number.

Must be entered in absolute terms (ie 3.5% yield is recorded as 0.035, not 3.5)

Each row in the file contains the yield for a given curve name, date and maturity. The tuple (Curve name, Date, Maturity) must be unique, and duplicate curve points within the same file will generate an error.

Date

Entries in the Date column must conform to the relevant date format string in the project’s configuration file .

Yield curve data can be supplied at any frequency you wish, including daily, weekly or monthly. We recommend daily data for most accurate results. If a few days are missing, FIA will use the most recent data available up to that point for attribution.

Maturity

This field holds the position of the current yield along the yield curve from the current date, in years. For instance, a value of 5 refers to the 5-year point on the current yield curve.

Rate

This field contains the yield for the supplied curve, date and maturity.

Personal tools
Namespaces
Variants
Actions
Manual
Attribution methodology
Data
Configuration
Running FIA
Reporting
Tutorials
Additional information
Company
Downloads
Toolbox