MathGroup Archive 2009

[Date Index] [Thread Index] [Author Index]

Search the Archive

Need to calculate daily risk free rate from Fed data

The St. Louis Federal Reserve makes a great set of data available for financial analysis at their FRED (Federal Reserve Economic Data) site at

I've downloaded treasury bill rates from 1984 to the present (they have lots of rates available at:

The data set gives me the yearly interest rate on 3-Month T-Bills for each day i.e:

1984-12-31,	0.008120
1985-01-01,	0.008120
1985-01-02,	0.008100
1985-01-03,	0.008070
1985-01-04,	0.008080
1985-01-07,	0.008060
1985-01-08,	0.008060
1985-01-09,	0.007950
2008-12-30,	0.000100
2008-12-31,	0.000110
2009-01-01,	0.000110
2009-01-02,	0.000080
2009-01-05,	0.000140
2009-01-06,	0.000140

I need to calculate the daily risk free rate for each interval in the data set based on the yearly rate give for each day.

I've gotten as far as this:

1 + yearlyRate == (1 + dailyRate)^360

Does this make sense?  
If so, how do I implement this in Mathematica?  
If not, how would I do it?

A couple of related questions:

Can one use FinancialData[] to access Treasury or Libor rate information or access a risk free rate directly?


  • Prev by Date: Web question
  • Next by Date: floating point comparison
  • Previous by thread: Re: Web question
  • Next by thread: Re: Need to calculate daily risk free rate from Fed data