<p>NO, it is not redundant. Controlling for nominal effects gives you a better picture, and makes more sense on a theoretical level. To transform assets into USD use</p>

<p>$\textit{asset}_{USD}=\frac{s_t P_{t,JPY}}{P_{t,USD}} \textit{asset}_{JPY}$ </p>

<p>where the fraction is the real exchange rate, $P_t$ is the respective price level and $s_t$ the nominal exchange rate.</p>

<p>Alternatively, you can work with differences</p>

<p>$\Delta rer =\frac{\Delta s_t \pi_{t,JPY}}{\pi_{t,USD}}$.</p>

<p>Note that the real exchange rate is far from perfect, but it is common practice in macroeconomics. Also, it does not matter which transformation you do first, as its purely multiplicative.</p>

CC BY-SA 3.0
2017-01-21T08:34:52.617Z
2017-01-21T08:34:52.617Z
Chris tie
<p>I’m not sure if this is typically done, but suppose my data point is in 2013 JPY and I want to express in 2016 USD. Do I apply CPI to express data in 2016 JPY, and then apply exchange rate to 2016 USD? Or do I apply exchange rate to obtain 2013 USD first, then apply CPI to bring forward to 2016 USD? Or is this all redundant? </p>

CC BY-SA 3.0
2017-01-18T15:31:02.540Z
Depends on what you are trying to do. Please elaborate.
Giskard
CC BY-SA 3.0
2017-01-18T21:33:51.517Z
@denesp - To add to the description under the question: This is strictly for the purpose of intellectual analysis and not for practical purposes. I have insurance claims data for companies in Japan from 2010-2016. I'd like to understand the shape of the loss per claim (severity) vs. limit (sum insured) curve and then compare this curve visually to those from other countries. Obviously, the companies will not transfer their portfolio, but without converting to USD and adjusting for inflation (some countries I'm analyzing such as Mexico experiences serious inflation) I can't compare the curves.
jkoe
CC BY-SA 3.0
2017-01-21T09:07:06.803Z
"Applying CPI" means multiplying by the relevant price index. "Applying the exchange rate" means multiplying by the exchange rate. A basic property of multiplication is *commutivity*: changing the order in which multiplications are performed does not affect the outcome. So it doesn't matter which you do first.
Ubiquitous
<macroeconomics><inflation><exchange-rates><foreign-exchange>
How should I adjust data for both inflation and foreign exchange rate?
jkoe
# How should I adjust data for both inflation and foreign exchange rate?

(Asked by: username_0 on 2017-01-18)

I’m not sure if this is typically done, but suppose my data point is in 2013 JPY and I want to express in 2016 USD. Do I apply CPI to express data in 2016 JPY, and then apply exchange rate to 2016 USD? Or do I apply exchange rate to obtain 2013 USD first, then apply CPI to bring forward to 2016 USD? Or is this all redundant?

**Tags:** macroeconomics, inflation, exchange-rates, foreign-exchange

> **Comments:**
> **username_1**: Depends on what you are trying to do. Please elaborate.  
> **username_0**: @denesp - To add to the description under the question: This is strictly for the purpose of intellectual analysis and not for practical purposes. I have insurance claims data for companies in Japan from 2010-2016. I'd like to understand the shape of the loss per claim (severity) vs. limit (sum insured) curve and then compare this curve visually to those from other countries. Obviously, the companies will not transfer their portfolio, but without converting to USD and adjusting for inflation (some countries I'm analyzing such as Mexico experiences serious inflation) I can't compare the curves.  
> **username_2**: "Applying CPI" means multiplying by the relevant price index. "Applying the exchange rate" means multiplying by the exchange rate. A basic property of multiplication is *commutivity*: changing the order in which multiplications are performed does not affect the outcome. So it doesn't matter which you do first.  

---

## 1 answers

### Answer by username_3 on 2017-01-21. Score: 1

NO, it is not redundant. Controlling for nominal effects gives you a better picture, and makes more sense on a theoretical level. To transform assets into USD use

$\textit{asset}\_{USD}=\frac{s\_t P\_{t,JPY}}{P\_{t,USD}} \textit{asset}\_{JPY}$

where the fraction is the real exchange rate, $P\_t$ is the respective price level and $s\_t$ the nominal exchange rate.

Alternatively, you can work with differences

$\Delta rer =\frac{\Delta s\_t \pi\_{t,JPY}}{\pi\_{t,USD}}$.

Note that the real exchange rate is far from perfect, but it is common practice in macroeconomics. Also, it does not matter which transformation you do first, as its purely multiplicative.


---

