Logout / Access Other products Drop Down Arrow
Get live help Monday-Friday from 7AM-7PM ET (12PM-12PM GMT)  •  Contact Us
Check out our new FAQ section!
RSS Feed
TitleUsing Data Buffet: Translate currencies
AuthorPhillip Thorne
Question

Can Data Buffet perform foreign exchange adjustments? That is, for a time series expressed in one local currency, can I automatically translate it to another currency?

Answer

Data Buffet offers you "canned" controls to convert frequencies and to apply analytic transformations.  There is no comparable mechanism to translate between currencies, but you can write an explicit formula.

Instructions

For example, concept code FWGDPLQ is "forecasted nominal gross domestic product in local currency."  FWGDPLQ.IAUS is in Australian dollars, FWGDPLQ.IDNK is in Danish krone, FWGDPLQ.IJPN is in Japanese yen, etc.  Do you want to see them all expressed in euros?  There is no pushbutton way to do this; instead, you will need to manually apply an exchange rate series.  For example, FWTFXIEUZNQ.IAUS is "forecasted nominal exchange rate, AUD per EUR."  Our bilateral exchange rate forecast series reside in the catalog under:

Forecast - Global national » Financial markets » Exchange rates

You can download the two series separately and apply a computation, or you can synthesize them using a Data Buffet formula:

(FWGDPLQ.IAUS * (1/FWTFXIEUZNQ.IAUS))

You will need to write one formula per country.  You cannot write a basket formula that will bulk-apply exchange rates, because wild cards and geo lists cannot be combined with formulas. For example, this expression is rejected:

(FWGDPLQ.I^^^ * (1/FWTFXIEUZNQ.I^^^)) 

However, you can do something similar with a map of countries, because the "%geo%" parameter is automatically set for each area in the map template:

(FWGDPLQ.%geo% * (1/FWTFXIEUZNQ.%geo%))

Background

Formulas can be used in baskets, charts and maps.  Formulas must be contained within parentheses.  Rather than debug a complex formula, build it progressively by separately testing its operands and sub-expressions, to verify they exist and have values over the date interval of interest.