Computer Aided Finance – Excel, Matlab, Theta Suite etc.
Tools, Algorithms, Simulation, Risk Management: Efficiency for Mathematical Finance.
Comprehensive List of Free Historical Market Data Sources.
Often people ask me where they can find historical data of stock prices, commodities, interest-rates, bonds, fx rates … . In previous posts, we already looked at live data feeds for Matlab, and Excel. Then, we looked at how to load historical data. Now, we want to focus on where to get the data itself.
Previous posts.
Sites with Summaries.
scraperwiki (The community collects free data from the web and converts it into CSV, etc.) wikiposit (The author collects free data from the web and converts it into CSV, etc.) ( recommendation ) Quandl (Successor of wikiposit: great full-text search, XLS, CSV, JSON export) Matlab Trendy (The community collects free data from the web and converts it into plots)
Foreign Exchange, Forex, FX.
forexite (Forex, 1 minute ticks), CSV download ratedata. gaincapital (Forex, tick data), CSV download oanda (Forex, daily), CSV download truefx (Forex tick data) after login dukascopy (Forex, ticks), CSV fxtop/de/historische-wechselkurse. php? MA=1 (Forex, long histories), Table.
bitcoincharts/charts/mtgoxUSD (Daily, many exchanges), Table quandl/markets/bitcoin (summary of exchanges)
Debt/ Interest Rates/Futures.
historical time series euribor-ebf. eu (Interest-Rates: “Euribor, Eonia”), Excel download databank. rbs (Exchange Rate, Interest Rate, Consumer Price Inflation (CPI), Commodities: “Brent Spot, Henry Hub Spot, I P E Brent crude futures 1-pos, I P E Natural Gas Index, OPEC Fixing, US EIA Crude Imports, WTI Daily”), Excel download ecb. int Interest-Rates and Government Bonds, web tables and partly Excel download (German) boerse-duesseldorf. de (Bonds, daily), Website table only (German )bundesbank. de German money and interest-rate statistics mrci/ohlc/ (many different future contracts, daily snapshots only) current (German) baadermarkets. de (Bonds) (German) westlbmarkets (2012-07-12: Just went offline, hopefully online again soon), Swaps, Caps, Floors, CSV download boerse-stuttgart. de (web table only) yield curves of bonds per rating and maturity interest-rate derivatives (new in the list) erstegroup Caps, Floors and Collars in form of Warrents.
Stock / Indices.
historical time series finance. yahoo/(Stocks, Indices), Excel download google/finance, partial Excel download, otherwise website table only ariva. de, (Stocks, Indeces), Excel download, German only. nasdaq (Nasdaq), Excel download mba. tuck. dartmouth. edu (portfolio data), text download (German) finanzen. handelsblatt investopedia, Website table only nasdaq, Website table only, intraday, daily standardandpoors (S&P 500, daily, yearly) current finance. yahoo (Stocks, Indices) bloomberg (Stocks, Indices)
Investment Fonds.
Issuer Union Investment (CSV)
EU epexspot/de/marktdaten/intraday-handel (German), Website table only US gdfsuezenergyresources/index. php? id=33 CSV download.
General Historical.
(German) onvista. de (Stocks, Indices, Warrants, ETFs …, daily Quotes) Website indexmundi World-wide econometric data and commodities measuringworth US, UK, Japan, China with interest rates, GDP, inflation, gold and silver prices, cool long term, Website table only historicalstatistics. org Many countries, especially Sweden, GDP, population and much more, links to other sources (German) oktoberfest. de (Price of beer at Octoberfest in Munich, 1817-current)
Economic data.
Eurostat ecb. int destatis. de Statistisches Bundesamt.
Federal Reserve Economic Data – FRED census. gov bls. gov ssa. gov treasury. gov sec. gov economagic (Web, Excel download after login) standardandpoors/indices/sp-case-shiller-home-price-indices (Shiller-House Price Index) data. gov Public data of all US government organizations.
boerse-frankfurt. de (German Dax)
(I did not try any of these, but they look interesting.)
Conclusion.
Please leave a comment if you have other good sources or is any link breaks.
Post navigation.
Leave a Reply Cancel reply.
Woah this weblog is excellent i love reading your articles. Keep up the good work! You recognize, a lot of individuals are looking around for this information, you can help them greatly.
wikiposit. org is a good source of all kinds of data reformatted to a consistent format.
Though the IMF data seems to be mostly non-functional at the moment.
Yes, you are right. I like the wikiposit approach, too. I wrote about it earlier.
And if it is a little more mature, I will add it to this list.
As it turns out I am working on a more mature wikiposit right now (quandl). I would like to connect with you directly to discuss this and get some insights from you. Can you me?
Hi, thanks for sharing.
I could get 20 years free end of day data on klowdi for US and Europe market.
If you want historical options prices history for all U. S. Equity options including stocks, Indexes and ETFs then visit our site. historicaloptiondata.
Here is another stock market data downloader:
Its highly customizable and supports storage of multiple data types including tick level, intra-day bar and daily data. CSVs, relational databases or binary formats storage possible. It allows for different formats of data and the user has the ability to mix and match all the different types.
For some useful data sets about S&P 100/500 and NASDAQ-100 companies, check this site:
You can export e. g. historical market caps, enterprise values, dividend yields and index components to Excel.
Not free but you can rent from QuantGo (quantgo/)
For those countries where we have historical data, we don’t need to use QuantGo.
But for those countries where we don’t have historical data and they are not available cheaply, we would definitely consider QuantGo and renting data from them.
Check out PanBI’s live dashboards. (panbi. co/live-dashboards). They are amazing, Customize the data visualizations and chart types the way you want to see it, and get a feel of how easy it is to understand data.
You can find historical data of major economies’ macroeconomic indicators and stocks, bonds, currencies, commodities in assetmacro/market-data/
I use MarketXLS for this. It worked great for me.
nice info About market data.
I use intradata. co to get both daydata and 1 minute bars from 30 stock exchanges. They also have forex so it works good for forex strategies also. I would recommend them.
Here is a new one – marketgrind. It has intraday data, end of day data, and fundamentals.
I precisely desired to appreciate you yet again. I do not know what I would’ve accomplished in the absence of the type of secrets documented by you over this concern. It was actually a difficult concern in my position, nevertheless encountering the skilled tactic you handled it forced me to weep over fulfillment. Now i am happier for your service and as well , wish you know what an amazing job you happen to be accomplishing instructing most people by way of your blog post. Most probably you haven’t met any of us.
Landing page redirects will negatively impact your page load speed.

Get forex data excel

api. efxnow/WebServices2.x/service. asmx Demo and test accounts:
Commonly used parameters.
UserID - Username or ID of your Forex account. Password - Password for your live or demo account. Brand - Brand key. e. g. "GAPI". Currency Pair - A currency pair supported by Forex e. g. "EUR/USD". Notes - The VBA source code of the spreadsheets is provided under the GPL license for inspection and audit that the user passwords and information are not stored by the software internally for any other purposes. However, since the passwords are entered on the spreadsheet itself, it is important to remember not to send the spreadsheets to others without removing the passwords.
Download the free Spreadsheets for importing Forex data (Forex Technical Analysis Software)
System Requirements Windows 7, Windows 8 or Windows 10 512 MB RAM 5 MB of Hard Disk space Excel 2007, Excel 2010, Excel 2013 or Excel 2016 Open Source - GPL License.

HistData.
Free Forex Historical Data.
Welcome To HistData!
If you’re looking for Free Forex Historical Data, you’re in the right place!
Here, you’ll be able to find free forex historical data ready to be imported into your favorite application like MetaTrader, NinjaTrader, MetaStock or any other trading platform.
Since the data is delivered in. CSV format (comma separated values), you can use it in any almost any application that allows you to import from CSV.
Free Forex Historical Data… Why Free?
Like you, tons of traders and developers are looking for data to backtest their trading systems. We are developers and traders too and, since we need also this information, why not sharing it with you?
Where To Start the Download?
You can download the Free Forex Historical Data here: Download Free Forex Historical Data.
You Need To Download It Faster?
We can allow you to download the data via FTP (File Transfer Protocol) or SFTP (Secure File Transfer Protocol) in a more convenient way. Find out how here: Download By FTP Free Forex Historical Data.
The FTP/SFTP Access, Will it cost you money?
Keep in mind that we’re giving you the chance to download it for free in this website here.
But, if you need speed for your own convinience you’ll need to help us pay the traffic costs (we’re not selling the data. ).
How can you activate the FTP/SFTP and get your account credentials?
You’ll need to send us $27 USD for the following PayPal account e-mail:
After recieving the payment, we’ll send you the FTP Account Credentials and all the FTP access details to your e-mail that you used to pay the $27 USD via PayPal. We don’t support any other payment method.
Is The Data Reliable?
Since it’s free data, you’ll not get from us any kind of warranty or certification. Use the data at your own will and risk.
But, to give you a hand on any possible headache, for EACH file you download, you’ll be able to get its status. The file status will tell you:
The Maximum GAP found in miliseconds; All the gaps (in seconds) that you’ll be able to find inside the files; The average tick interval in miliseconds;
(Keep in mind that some of the gaps can be due to normal Forex Trading pause periods.)
We’re measuring all the gaps bigger than 1 minute. It’s normal that you’ll find gaps in average of > 90 seconds when the market is with low trading volumes.
For Which Pairs?
Currently we have available historical data for the following Forex Pairs:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP.
What are they? Only Currencies?
No, not only currencies. Most of all are forex currency pairs but other are futures/commodities.
In our data you’ll be able to find some futures/commodities data feeds. Here some examples:
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
For Which TimeFrames?
We can only deliver you time ordered Tick and M1 (1 minute) data.
The data that we have available is organized by forex-pair/year/month.
Wanna Know More About?
Please, take some time to check our F. A.Q. section here: F. A.Q. (Frequently Asked Questions)
HistData Language Translations.
HistData is translated automatically to help all our users to have the content in their mother language. However, the translations may not be 100% accurate. Sorry if any of the site content (Blog Posts or Pages) is not correctly translated.
Here are the languages where you can find the WebSite translated:
Free Forex Historical Data Update for December 2017 (2nd Update)
We’ve updated the Free Forex Data Files with the last week quotes for December 2017.
The last update includes:
Data quotes until 15/December/2017 inclusive.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.
All this, Free and Easy, always!
Free Forex Historical Data Update for December 2017.
We’ve updated the Free Forex Data Files with the last week quotes for December 2017.
November 2017 has already all the quotes for the complete month.
The last update includes:
Data quotes until 08/December/2017 inclusive.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.
All this, Free and Easy, always!
Free Forex Historical Data Update for November 2017 (2nd Update)
We’ve updated the Free Forex Data Files with the last weeks quotes for November 2017.
The last update includes:
Data quotes until 17/November/2017 inclusive.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.
All this, Free and Easy, always!
Free Forex Historical Data Update for November 2017.
We’ve updated the Free Forex Data Files with the first weeks quotes for November 2017.
The last update includes:
Data quotes until 10/November/2017 inclusive.
All the October 2017 data is completed as well.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.
All this, Free and Easy, always!
Free Forex Historical Data Update for October 2017 (3rd Update)
We’ve updated the Free Forex Data Files with the latest week quotes for October 2017.
The last update includes:
Data quotes until 27/October/2017 inclusive.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.
All this, Free and Easy, always!
Free Forex Historical Data Update for October 2017 (2nd Update)
We’ve updated the Free Forex Data Files with the latest week quotes for October 2017.
The last update includes:
Data quotes until 20/October/2017 inclusive.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.
All this, Free and Easy, always!
Free Forex Historical Data Update for October 2017.
We’ve updated the Free Forex Data Files with the first week quotes for October 2017.
The last update includes:
Data quotes until 06/October/2017 inclusive.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.
All this, Free and Easy, always!
Free Forex Historical Data Update for September 2017 (3rd Update)
We’ve updated the Free Forex Data Files with the latest September 2017 quotes.
The last update includes:
Data quotes until 15/September/2017 inclusive.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.
All this, Free and Easy, always!
Free Forex Historical Data Update for September 2017.
We’ve updated the Free Forex Data Files with the latest September 2017 quotes.
The last update includes:
Data quotes until 15/September/2017 inclusive.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.
All this, Free and Easy, always!
Free Forex Historical Data Update for August 2017 (5th Update)
We’ve updated the Free Forex Data Files with the last quotes of August 2017 quotes.
This last update completes August 2017 quotes.
The last update includes:
Data quotes until 25/August/2017 inclusive.
The 66 forex pairs are available to download:
EUR/USD, EUR/CHF, EUR/GBP, EUR/JPY, EUR/AUD, USD/CAD, USD/CHF, USD/JPY, USD/MXN, GBP/CHF, GBP/JPY, GBP/USD, AUD/JPY, AUD/USD, CHF/JPY, NZD/JPY, NZD/USD, XAU/USD, EUR/CAD, AUD/CAD, CAD/JPY, EUR/NZD, GRX/EUR, NZD/CAD, SGD/JPY, USD/HKD, USD/NOK, USD/TRY, XAU/AUD, AUD/CHF, AUX/AUD, EUR/HUF, EUR/PLN, FRX/EUR, HKX/HKD, NZD/CHF, SPX/USD, USD/HUF, USD/PLN, USD/ZAR, XAU/CHF, ZAR/JPY, BCO/USD, ETX/EUR, CAD/CHF, EUR/DKK, EUR/NOK, EUR/TRY, GBP/CAD, NSX/USD, UKX/GBP, USD/DKK, USD/SGD, XAG/USD, XAU/GBP, EUR/CZK, EUR/SEK, GBP/AUD, GBP/NZD, JPX/JPY, UDX/USD, USD/CZK, USD/SEK, WTI/USD, XAU/EUR, AUD/NZD.
For your information, in our data feeds you’ll be able to find some futures/commodities data feeds.
Here some examples:
FRX/EUR = FRENCH CAC 40 in EUR.
UDX/USD = US DOLLAR INDEX in USD.
ETX/EUR = EUROSTOXX 50 in EUR.
WTI/USD = WEST TEXAS INTERMEDIATE in USD.
BCO/USD = BRENT CRUDE OIL in USD.
For all csv data formats including Generic ASCII, MetaTrader, Ninja Trader and MetaStock;
For both time frames like 1 Minute and Tick Data;
To start the free download, follow the following url: Download Free Forex Historical Data.
To have more details about all our data feed, please check this url: Data Files – Detailed Specification.

Real-Time Forex Rates in Excel.
Get real-time live foreign exchange rates in Excel with this free spreadsheet. The quotes are delayed by about 15 or 20 minutes but are updated every minute or so.
Everything is automated in VBA. The VBA can be viewed and modified. The nuts and bolts of the code is a QueryTable that extracts the most recent forex rates from finance. yahoo for the two specified currencies.
All you have to do is type in two three-letter currency codes, and click a button (you can find a list of currency codes here).
The VBA then downloads the the most recent foreign exchange rates from Yahoo into Excel, using a query table.
Excel then downloads the previous close, open, and current bid/ask rates for the currency pair. Clicking the button again refreshes the quotes with the most recent values.
Automatically Updated Real-Time Forex in Excel.
Now, here’s where we can be clever and get Excel to automatically update the exchange rates live.
1. Select the QueryTable as shown below, right-click and select Data Range Properties .
2. In the External Data Range Properties menu, place a check in the Refresh every option, and pick an update time (you can only choose an integer number of minutes). Now click OK .
Excel now updates the data in the QueryTable automatically, without you needing to click buttons or run macros. Cool, eh?
I use a variant of this spreadsheet to keep track of the sterling value of my foreign savings. You can, for example, modify the VBA to download Forex rates for many currency pairs (let me know if you want this spreadsheet).
Another Excel spreadsheet retrieves daily historical exchange rates between two dates.
9 thoughts on “ Real-Time Forex Rates in Excel ”
i appriciate your site.
but instead of adding 40 something queries just save a. iqy-file and change the query to:
and assign an input cell to this parameter (data-connections-properties-definition).
no vba required and combined with offset etc. a very handy tool.
there has been a formatting error in my previous comment.
This is very useful. I’m running Excel 2013 and tried to copy the sheet but had different rows and columns so copied the cells to my workbook but get a runtime error 1004.
Ideally I’d like to have 3 conversions in a single sheet at the end of my financial workbook so I can pickup USD/GBP, AUD/GBP and EURO/GBP real time exchange rates. How do I do this?
Thanks for your help Anthony.
I’m getting the following error message:
Unable to open finance. yahoo/q? s=USDCAD=X. Cannot download the information you requested.
I want to export the Bid and the Ask to another application that accepts DDE (Dynamic Data Exchange). How do I do that?
Please do everything for me. I cannot research or anything so I rely on people that work hard to provide me something of great value for absolutely nothing, out of the goodness of their hearts and with no effort on my part. Fix MY problems for me!
Great spreadsheet! This will come in very handy for me and I appreciate your hard work. I may have some issues with it working but I will fix it myself. Thanks!
Great code! Works beautifully.
Could you share the multiple currency pair XLS too, please?
Hey thanks for this! Saved a ton of time 🙂
Very nice code….but I am facing some problem..(i am not a programmer.. 🙁 …) and got stuck.. I. tried to add e second pair of rates (USD and BRL), by simply coping the table on another sheet changing the sheet name…and the Macro immediately crashed.. You surely defined the sheet name in the Macro…but I was not able to modify it..
Will you be so kind to help me…and send me the corrected Macro?
Sorry to be so cheeky..but I really do not know how to get out..