Home > Business Databases, Business Libraries > Risk Free Rates on Datastream

Risk Free Rates on Datastream

A couple of business library blogs have mentioned the risk free rate recommendations on the Thomson Reuters Datastream extranet – see Risk free rates, T-Bills, Benchmark bonds (Databaser, Oct 2013) and Datastream – Risk free rate (Aberconway Library, Sept 2011). The first recommendation is to use 3 Month Treasury Bills where possible (Thomson Reuters, 2009). Unfortunately, these recommendations have not been updated recently. Some of the series mentioned are now dead (i.e. do not give up to date data), including those for the US and UK.

Thomson ReutersThere are alternative sources for 3 Month Treasury Bills (T-Bills) on Datastream:

US

  • USTBL3M – 03/07/1989 – 01/05/2007, Daily, US TREAS.BILL 3M(USE FRTBS3M)’DEAD from Financial Times
  • FRTBS3M – 04/01/1954 – present, Daily, US T-BILL SEC MARKET 3 MONTH from Thomson Reuters
  • FRTBW3M – 08/01/1954 – present, Weekly, US T-BILL SEC MARKET 3 MONTH (W) from Federal Reserve, United States
  • TRUS3MT – 04/01/1954 – present, Daily, TR US T-BILLS BID YLD 3M from Thomson Reuters

UK

  • UKGBILL3 – 31/01/1972 – 31/10/2011, Monthly,  UK 3 MONTHS TREASURY BILLS YIELD from UK Office for National Statistics (ONS)
  • UKTBTND – 04/01/1985 – present, Weekly, UK TREASURY BILL TENDER 3M from UK Debt Management Office
  • TRUK3MT – 02/01/1975 – present, Daily, TR UK T-BILLS BID YLD 3M from Thomson Reuters

By default these express the 3 Month T-Bill rate as an anualised percentage yield (comparison chart below). However FRTBS3M and UKTBTND also have datatype RI – total return index – which makes calculating a monthly/weekly/daily return easier.  See comment March 3 1014 below.

UK 3 month T-Bill rates (click to expand)

UK 3 month T-Bill rates (click to expand)

Other countries

Thomson Reuters have government bond benchmark lists by country – Datastream code LTRXXBMK where XX is the country code. In total Datastream has benchmark lists for 47 countries with 32 having a 3 month rate, e.g. TRNL3MT for the Netherlands. (For example see comment March 2014)

For the examples above, LTRUKBMK is the UK list and LTRUSBMK is the US list, with TRUK3MT the UK 3 month rate and TRUS3MT the US 3 month rate.

Additional notes

The choice of the 3 Month Treasury Bill as the risk free rate is very common but not universal. Some choose 1 Month Treasury Bills (4 week) where these are available – see Risk Free Rate and Fama French Factors (Jan 2013)

Risk Free Rate for UK and US (August 2011) is a good starting point if you are looking for alternative sources.

The Thomson Reuters extranet recommendations (Thomson Reuters, 2009) have been mentioned in a previous post Risk Free Interest Rate (November 2009) and do not seem to have been updated since then.

References

Thomson Reuters (2009) Risk free interest rates. Available at: (Datastream extranet) http://extranet.datastream.com/data/Exchange%20&%20Interest%20Rates/RiskFreeInterestRates.htm (Accessed: 25 October 2013).

Appendix

US risk free rate (click to expand)

US risk free rate (click to expand)

A comparison between the US risk free rate returns from Datastream ( PCT#(FRTBS3M(RI),1Y) ) and annual factors from Ken French – see comment below.

The 2000 figure is 6.05 from Datastream and 5.88 from Ken French’s annual factors.

We would not expect these to be identical since one is based on the return of 3 month treasury bills and the other on 1 month treasury bills.

Advertisements
  1. Kate.R
    25 October 2013 at 9:53 am

    I can’t remember it was the function GRR or GGR, but if you type one of those in Bloomberg, you can get those rates much easier and just right click to export to Excel.

    • markgreenwood
      25 October 2013 at 11:54 am

      I think it is GGR – “much easier” so long as you have easy access to Bloomberg (which at the moment I don’t so I can’t double-check)

      Bloomberg generic bond (treasury) rates also seem to have limited historical data. The 3 month UK GUKG3M Index only goes back to Dec 31 2008, though the 3 month US USGG3M goes back to March 1954.

  2. 25 October 2013 at 10:33 am

    Reblogged this on Aberconway Library blog.

  3. markgreenwood
    19 February 2014 at 11:27 pm

    http://researchfinancial.wordpress.com/2014/02/06/risk-free-rate-data-sources/ includes Datastream as one of three recommended sources.The others are OECD Stat Extracts and IMF International Financial Statistics.

  4. markgreenwood
    3 March 2014 at 1:47 pm

    One difference between the 3-month treasury bill series mentioned above is the datatypes available. If you are looking for RI (total return index) then UKTBTND or FRTBS3M have this datatype – others only have IR/RY (the yield to redemption expressed as an annual percentage rate).

    A quick check shows that the US 3 month treasury series FRTBS3M has a monthly return that correlates well with the monthly risk free return figures published on Ken French’s website – see https://bizlib247.wordpress.com/2013/01/18/risk-free-rate-and-fama-french-factors/

  5. 15 March 2015 at 8:13 am

    i want risk free return of japan, U.S. ,Singapore,china, hong kong

    3 month t-bill monthly rate from march 2009 to April 2014

  1. 25 October 2013 at 10:55 am
  2. 25 October 2013 at 4:53 pm
  3. 20 November 2013 at 11:53 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s