Currency Question

noodler

Hey guys,

wondering if anybody can help me with some illustration I am trying to do.

I am trying to put together a graph illustrating the performance of the Korean won over the last 5 years aginst the Euro and the Yen.

I need this on the same graph so need to illustrate the two lines in a €/Won AND a ¥/Won fashion.(is that right or is it the otherway around?)

Anyone know a website that does this?

Anonymous1987

I think it should be the other way round i.e. KRW/JPY and KRW/EUR as you want the "price" of the Korean Won (KRW) in terms of Yen and Euro? Not sure though.

Google Finance illustrates the relative performance between the two rates from a fixed point in time 5 years ago. I'm not sure if can download the raw data for each rate for plotting in Excel though.

Économiste Monétaire

I get confused by direct and indirect price quotations too. Usually, the first currency is the base currency, so EUR/KRW can be read as: How many Won can I get for one Euro? What is the price of Euro in terms of Won? How many Won do I need in order to get one Euro? They all mean the same thing.

You could just download the currencies with Euro as the base and use the fact that €1 = X KRW, €1 = Y¥, so

X KRW = Y¥

1 KRW = (Y/X)¥

1 KRW = (1/X)€

Then plot them in Excel (or whatever) and put one of them on the secondary axis. Here's a link for daily data on EUR/YEN; another link for EUR/KRW.

noodler

Two gents.

I'll try screengrabbing, editing and printing the googlefinance charts first before I try my hand at excel.

Thanks.

PS: Even during Macro exams, I'd find myself constantly second guessing myself regarding expressions of one currency in terms of another.