Как Excel На Форекс

If you are looking to download historical forex data into excel for free use our Add-in by following these simple steps, you’ll also be able to get live Forex data into Excel;

Before we move further to the steps, you can also read these tutorials for obtaining Forex data on Excel using our Excel Power Query:

Import Currency Rates Into Excel With Power Query - Part 1

Import Currency Rates Into Excel With Power Query - Part 2

Now, let us continue with the steps:

Step 1 – Open Excel

Step 2 – Download the XLAM file using this link eunic-brussels.eu

Step 3 – Now in Excel, open “Options”

Step 4 – Then click on “Add-ins”

Step 5 – Now, to Manage the Excel Add-ins, click “Go”

Step 6 – Ok great, now find the fx_eunic-brussels.eu file that you downloaded earlier, select this and press “OK” then “OK” again when the next prompt appears to confirm your selection;

Step 7 – We are now ready to start calling the API live rates endpoint, just a couple more steps that we need to follow.

Now, open a new worksheet in Excel. From here add some instruments (i.e. EURUSD, GBPUSD, USDJPY and UK) in column A and write Bid and Ask in cells B:1 and C:1 respectively;

Step 8 – Login to your TraderMade account and then copy your REST API Key (as below);

Step 9 – Now paste this REST API Key into your Excel spreadsheet, here into cell E2;

Step 10 – Next, in cell B2, type =TraderMadeLive and press the Tab button

Then select the instruments by clicking on cells A2:A5

Now we have to select the API Key cell, so the request should look like =TraderMadeLive(A2:A5,E1)

The Live Rates for EURUSD, GBPUSD, USDJPY and UK now appear

If you have any questions, email [email protected] or visit eunic-brussels.eu and Live Chat with one of the team. 

With the Currencies data type you can easily get and compare exchange rates from around the world. In this article, you'll learn how to enter currency pairs, convert them into a data type, and extract more information for robust data. 

Use the Currencies data type to calculate exchange rates

1. Enter the currency pair in a cell using this format: From Currency / To Currency with the ISO currency codes.
   
   For example, enter "USD/EUR" to get the exchange rate from one United States Dollar to Euros.

2. Select the cells and then select Insert > Table. Although creating a table isn't required, it'll make inserting data from the data type much easier later.

3. With the cells still selected, go to the Data tab and select the Currencies data type.
   
   If Excel finds a match between the currency pair and our data provider, your text will convert to a data type and you'll see the Currencies icon  in the cell.

   Note: If you see    in the cell instead of the Currencies icon, then Excel is having difficulty matching the text with data. Correct any mistakes and press Enter to try again. Or, select the icon to open the Data Selector where you can search for a currency pair or specify the data you need. 

4. To extract more information from the Currencies data type, select one or more converted cells and select the Insert Data button  that appears or press Ctrl/Cmd+Shift+F5.

5. You'll see a list of all the fields available to choose from. Select the fields to add a new column of data.
   
   For example, Price represents the exchange rate for the currency pair, Last Trade Time represents the time the exchange rate was quoted.

6. Once you have all the currency data that you want, you can use it in formulas or calculations. To ensure your data is up to date, you can go to Data > Refresh All to get an updated quote.

   Caution: Currency information is provided "as-is" and may be delayed. Therefore, this data should not be used for trading purposes or advice. See About our data sources for more information. 

See also

Stocks and geography data types

How to write formulas that reference data types

FIELDVALUE function

#FIELD! error 

Import FOREX data to Excel for Technical Analysis

Technical vs Fundamental Analysis in FOREX

FOREX Technical Analysis Timeframe

FOREX Technical Analysis Spreadsheets

Use Cases supported

Demo or Live Accounts

• eunic-brussels.eu

• eunic-brussels.eu

Commonly used parameters

• UserID - Username or ID of your eunic-brussels.eu account.
• Password - Password for your live or demo account.
• Brand - Brand key. e.g. "GAPI".
• Currency Pair - A currency pair supported by eunic-brussels.eu e.g. "EUR/USD".

Download the free Spreadsheets for importing Forex data (Forex Technical Analysis Software)

System Requirements

• Windows 7, Windows 8 or Windows 10
• MB RAM
• 5 MB of Hard Disk space
• Excel , Excel , Excel or Excel

eunic-brussels.eu (ZIP Format - KB)



Use this FOREX data for analysis, charting and backtesting.

Back to TraderCode Technical Analysis Software

In this guide, you will learn about how to connect your MetaTrader software to Microsoft Excel software and view items live. You can watch Bid price, Ask price, High, Low and so on directly in a connected Excel spreadsheet.

In order to do this, you need to first launch your MT4 platform. Then find Tools->Options->Server item on the menu. Then find the Enable DDE server checkbox in this window and tick it. You need to launch the eunic-brussels.eu file inside the installation folder of your MT4 (same folder where your platform's executables are).

This Excel spreadsheet is now connected to your MT4 platform. You can see the table of contents displaying values like Bid and Ask prices for some currency pairs. If you want, you can also add more pairs to this list. This is how you can use an Excel spreadsheet to view items live for various currency pairs. Unfortunately, there isn't much you can do with it.

If you want to ask questions or offer your suggestions on how to best sync your MetaTrader 4 platform with an Excel spreadsheet, please do so on Forex forum.

If you want to get news of the most recent updates to our guides or anything else related to Forex trading, you can subscribe to our monthly newsletter.