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

09/22/2021 at 11:05AM

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;

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.

For an in-depth look watch video on how to pull live and historical rates into Excel, by visiting the following link:

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


For a video on how to pull live rates into Excel, click this link for our YouTube Channel

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