Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've been trying to download the national interest rates for some countries. When i use Datastream, it only gives me the currency return (while i need yield).

Can someone please tell how to download the series. I do use the correct Mnemonic ( BBJPY3M SNGTB3M ADBR090 HKEFB3M). Should i use maybe Thomson instead?

I know this is kind of a nooby question, but i've been dealing with this over 2 hours now.

Help is highly appreciated!

share|improve this question
up vote 0 down vote accepted

There is no such thing as a single domestic "risk-free rate". At the very least, you need an investment horizon to be able to find the corresponding risk-free rate on a domestic interest rate curve. The curve itself is typically constructed out of an interpolation of government bond yields, which may or may not be "risk-free".

I don't have access to Datastream but Reuters codes tend to be similar across platforms.

For example, let's say you're looking at a 2-Year risk-free rate for the US and the Euro. Mnemonics will likely follow this pattern:

[cc][tt]T=RR

Where [cc] is the 2-digit country code [US and EU respectively].

[tt] the horizon, with M = Month and Y = Year. e.g. 3M, 2Y.

In the case in question you would be looking at pulling "US2YT=RR" and "EU2YT=RR". You will then need to pull a mid-yield for each of these tickers.

Bloomberg also provides a similar function.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["                    <li><a href=\"//area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2016 Stack Exchange Inc; user contributions licensed under <a href=\"https://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2016.5.4.3538\r\n            </div>\r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Quantitative Finance Stack Exchange works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n   "], "copyright__copyright__copyright": [" and EU respectively].\n\n[tt] the horizon, with M = Month and Y = Year. e.g. 3M, 2Y.\n\nIn the case in question you would be looking at pulling \"US2YT=RR\" and \"EU2YT=RR\". You will then need to pull a mid-yield for each of these tickers.\n\nBloomberg also provides a similar function.\n\nshare|improve this answer\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}