Thursday, January 10, 2013

Support for International Stocks

As mentioned before, the data used by EzBacktest is from Yahoo!Finance. The good news is, that Yahoo provides services worldwide, you just have to know how to reach that data in Yahoo prior to trying to test it in EzBacktest.

For a very quick example, I entered the Yahoo finance sites for Germany, France and UK and looked for ANY stock out there and the relevant page for its historical prices. I then looked at relevant download link at the bottom of the page, here are the results:


German: http://ichart.finance.yahoo.com/table.csv?s=DBK.DE&d=0&e=10&f=2013&g=d&a=0&b=3&c=2000&ignore=.csv

French: http://ichart.finance.yahoo.com/table.csv?s=CO.PA&d=0&e=10&f=2013&g=d&a=0&b=3&c=2000&ignore=.csv

UK: http://ichart.finance.yahoo.com/table.csv?s=LLOY.L&d=0&e=10&f=2013&g=d&a=11&b=28&c=1995&ignore=.csv

USA: http://ichart.finance.yahoo.com/table.csv?s=LQD&d=0&e=10&f=2013&g=d&a=6&b=31&c=2002&ignore=.csv


Notice that all of these downloads are from the same web address, without specific difference in parameter indicating a different currency expectancy. The only major difference is the suffix of the stock ticker.

A German stock ends with .DE and the data downloaded is in Euros.

A French stock ends with .PA and the data downloaded is in Euros.

A UK stock ends with .L and the data downloaded is in British Pound.

Conclusion: You can test international portfolios, the actual currency is relevant to the download and isn't imposed by EzBacktest. EzBacktest uses percentage based allocation, so the currency and stock price doesn't affect test results. It works!

Cheers!

No comments:

Post a Comment