Hi there! I'm looking to do statistical analysis on a currency pair in excel, but the problem is getting the data into excel. The Windows version of excel has a tool to do this, but i have a mac, and have no idea how to write a web query to pull such data into excel. Any tips or alternatives?
Did you find what you were looking for? I ran into this while looking around the Oanda stuff. I've never tried it though. What kind of stats are you interested in working on? What are you looking into? http://www.oanda.com/rates/currency-data/currency-feed-xml