Setting up the yield curve file

From Flametree Technologies
Revision as of 12:28, 27 April 2013 by Fiasys (Talk | contribs)
Jump to: navigation, search

Contents

Setting up the yield curve file

Yield curve download utilities

As a service to our users, we supply utilities to download daily sovereign zero coupon (or spot rate) yield curve data for USD, GPB, JPY, EUR, automatically updated every 24 hours. Data is sourced from central banks and is saved in FIA's required format. If you hold securities that require other yield curves, or if you wish to model credit curves, other sources of data are required.

Custom yield curves

You may prefer to use your own yield curves if (i) you are modeling securities for which we do not provide a sovereign curve; (ii) you need to use a particular set of rates; (iii) you are running credit analysis (FIA can handle multiple credit curves for the same market). FIA can use any data as long as it is supplied in the format shown below.

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

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

Column Field Type Example Required? Rules
Column 1 Curve name String AUD_CURVE Yes Must be a string with at least 3 characters
Column 2 Credit rating String AAA Yes The credit rating applicable to this curve, using Moodys, S&P or Fitch ratings. Click here to see a list of valid credit ratings.
Column 3 Maturity Real 0.25 Yes Tenor point on the curve for this sample, in years. Must be a non-negative real number
Column 4 Date Date 31/12/2000 Yes Date of current curve, using the date format supplied in the DateFormat or SecurityDateFormat strings
Column 5 Zero coupon rate Real 0.04554 Yes Yield of curve at given date and tenor point. Must be a real number.

Each row in the file contains the zero coupon rate for a given maturity, credit rate, date and curve. The tuple (Curve name, Credit rating, Date, Maturity) must be unique; duplicate curve points will generate an error.

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).

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.

Currency

This field contains a three-character currency code. Currency codes follow the global ISO 4217 standard.

Maturity

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

Zero coupon rate

This field contains the appropriate zero coupon rate for the supplied currency, credit rating, date and maturity.

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