0

I was asked to make a DSS (using QlikView) as a task for a university course in computational finance and it is suggested to implement a geographic dimension for the equities in a portfolio.

The historical data comes (as .csv files) from Yahoo! Finance, but for foreign equities/stock exchange, I also get them in foreign currencies! As long as I'm supposed to plot them (if not something more), it makes sense to me that, in order to be comparable, they also have to have the same currency.

So… I'm looking for a simple and effective way to get those data without being crazy with historical currency changes. Any idea ?

Thanks in advance!

dezzeus
  • 200
  • 1
  • 9
  • P.S.: As for now, I've thinked to write a bash script that, given the historical currency changes (if available) and a .csv file, generates a new .cvs file or the same with an added column; but that goes *very* beyond the purpose of the task/course. – dezzeus Jan 07 '15 at 20:03
  • Can you post (or give a link) to some sample data? – Stefan Stoichev Jan 08 '15 at 17:16
  • @StefanStoichev Sure, just click the "Download to Spreadsheet" [here](https://finance.yahoo.com/q/hp?s=CAT&a=00&b=1&c=2000&d=00&e=1&f=2015&g=d) and suppose I want them in Euro. – dezzeus Jan 11 '15 at 18:07
  • Can you check it the qvw file from the link is the result you need? https://drive.google.com/file/d/0BxjGsOE_3VoOVVlSOGNQU1h2Ync/view?usp=sharing – Stefan Stoichev Jan 12 '15 at 10:06

0 Answers0