Hello,

I have a dataset in which I have the amount issued by companies in different periods of time and in different currencies. I want to run a regression in which the amount issued by the companines is one of the independent variable. In order to do that I need the amount issued to be comparable, so I want to convert it all into the same currency. Is it possible to do that in an easy way using Stata?

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input double originalamountissued str3 principalcurrency int issuedate
7.500e+08 "EUR" 21846
1.000e+08 "HKD" 22265
1.000e+09 "EUR" 21945
3.000e+08 "HKD" 22330
1.500e+08 "EUR" 20146
1.000e+09 "EUR" 22448
2.000e+08 "HKD" 22308
7.500e+08 "GBP" 22315
 50000000 "GBP" 22175
3.000e+08 "HKD" 22265
1.000e+08 "HKD" 22306
2.500e+08 "HKD" 22300
3.000e+08 "HKD" 22257
4.000e+08 "HKD" 22299
 19600000 "USD" 22148
1.250e+09 "EUR" 21329
1.000e+08 "EUR" 21654
1.000e+08 "GBP" 22175
1.000e+08 "EUR" 20468
7.500e+08 "GBP" 22216
end
format %tdnn/dd/CCYY issuedate
Thanks!