How to Import Live Forex and CFD Data in Excel Using Our Add-In
09/22/2021 at 11:05AM
Following these simple steps, you’ll be able to use the TraderMade REST API to get live data into Excel;
Step 1 – Open Excel
Step 2 – Download the XLAM file using this link https://tradermade.com/static/fx_rates.xlam
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: https://www.youtube.com/watch?v=HtrgvKt_89s
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 8 – Login to your TraderMade account (https://marketdata.tradermade.com/myAccount) 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 https://www.youtube.com/watch?v=HtrgvKt_89s
If you have any questions, email support@tradermade.com or visit https://tradermade.com and Live Chat with one of the team.
