Forex rates historical data

Find technical support, product updates, training sessions and more. For any questions regarding our solutions and services, our customer service representatives are here to help.

Home Data Catalog Pricing data Foreign exchange. Industry leading FX data. Foreign exchange pricing data. Request details. Overview Request details. Why choose our foreign exchange pricing data? What you get with our foreign exchange pricing data. Foreign exchange content. Historical data. Broker and trading venue pricing. Unrivaled pricing discovery. Superior forwards content.

Reuters Polls.

1. a list of forex brokers!
2. Live Currency Rates;
3. API Introduction?
4. gm employee stock options.
5. Tables of historical exchange rates to the United States dollar!
6. penny stock trading strategies!
7. Exchange Rates - Bank of Canada.

How it works. Find out how our foreign exchange pricing data works. Tullett Prebon Leading provider of pricing information across the full range of financial and energy sectors, and their related derivative markets.

Tradition One of the largest interdealer brokers in OTC and commodity related products. Find out more. Relevant FX products.

Explore all products. FX indices. Build your trading and investment products using the leading venue in interbank liquidity to create your benchmarks, tracking the performance of globally strategic currencies. Eikon - foreign exchange. Manage risk, identify opportunities, and effectively differentiate your FX trading strategy with Eikon's premium foreign exchange data, Reuters news, and analysis.

FXall is the flexible electronic trading platform that provides the choice, agility, efficiency, and confidence that traders want, from liquidity access to straight-through processing. Hello there, is there any solution for this request since the rest of the code and way of exporting information is perfect only need this to implement it in my sheets so it can populate all currencies needed at once.

OANDA now has also changed the historical data page and calls it …historical-rates-classic.

I tried to code my macro to download from this page but I guess they also changed the format of the date in the link. I checked with your excel sheet, ForexExcelImport. Do you know of another website that has historical forex data that I can download with the definition of a period? I guess, you have not downloaded correct sheet. Your means of describing the whole thing in this post is actually nice, all be able to simply be aware of it, Thanks a lot.

This is excellent, thanks Samir! Hi all!

Our use of cookies

The code is just fantastic and works fine on my US laptop! I only had a problem using it on a german Excel version in my office as the decimal separator was not correctly recognized. I am trying to use this tool to streamline some financial information but there seems to be a bug in the code I downloaded. No matter what I fill in in the excel sheet, the code always seems to extract the same period between today and a month ago, whereas I need much older data. How far back does the code go? AS Simon said this is not working properly anymore?

Is there any alternative way of getting the data? Could this be fixed?

I download the latest version of ForexExcelImport. This spreadsheet is really awesome. I am looking to expand the date range, however, it appears that the data is being drawn from a csv file which is automatically set to the last 30 days. How do you code the excel spreadsheet to draw from the csv file from the past 1 year? Hi there — thanks for producing this spreadsheet it is very useful!

Is it possible to have a version without a password for the code? If anyone could help please contact me on zineb. Hi, looks like the Oanda link in the Macro for historical FX rates has stopped working. This may be due to Oanda stopping providing the service for free. Any idea what the syntax would be for getting the FX data from Yahoo Finance? I only discovered your tool two or three months ago and have enjoyed convenience and accuracy the macro has allowed me to build reports for work for internal use, not a publicly traded company , but it appears that sometime since April 1 Oanda has changed something in the structure of their databases that renders the workbook outdated.

I discovered there was a problem when I started updating my reports for April data and the macros did not update my main table as I expected. This tool was amazing and curious if there is a fix or something similar? Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website.

These cookies do not store any personal information. Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

Thanks Reply. Pingback: Quora. Hi It looks like a terrific tool to use with excell.

When you loaded the spreadsheet in Excel, did you give the macro permission to run? I tried the worksheet. Delete Next qt End Sub Reply. It is possible to modify to show the open, high, low, and close? Thanks in advance , Lance Reply. Just a remark on my side: you first set all calculations to manual and I personally prefer having them automatic, so I just added the following at the end of the GetData macro: Application. Hi Sam, Thank you so much for this. Thanks Maria Reply. You can now choose either the bid, ask or mid rate Reply.

Hi, Great tool. Thanks very much. Keith Reply. Hello Samir! Impressive tools for the data-driven! If you could spare a moment to address these I would be very appreciative. Thank you! Hi, Thanks for such good website. Best, Philipp Reply.