Backexcel video

How to Import Live Forex and CFD Data in Excel Using Our Add-In

22 September 2021

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

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_rates.xlam 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 UK100) in column A and write Bid and Ask in cells B:1 and C:1 respectively;


Step 8Login 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 UK100 now appear


If you have any questions, email or visit and Live Chat with one of the team.