How can I automatically import and update data in Excel?


8 0
Hello Everyone,

I am a systematic trend-following trader using foreign exchange pairs.

All of my systems development work is in Excel.

I am seeking to take live data from either IG ’s API (IG Labs) or MT4/5 and import it into Excel and I would like this to be an automatic process.

The data imported into an Excel worksheet could be any user-definable periodicity, for example, 1 minute, 5 minutes or 1 hour. Thus, a spreadsheet could contain (as an example), three worksheets, with Worksheet 1 containing 1 minute data, Worksheet 2 containing 5 minute data and Worksheet 3 containing hourly data.

Each worksheet would contain the last (as an example) 6 months’ worth of data for each of the three time frames – data should be “flushed” automatically.

I would like each of these worksheets to update automatically. Data should update automatically on a row-by-row basis with all system calculations in each row also updating automatically. System calculations (ie. formulae) should be able to be changed on an ongoing basis, with additional columns (containing formulae) also able to be added.

I am not a programmer and the technical skills required to achieve the above are beyond my ability.

Can anyone assist me in this matter?

I welcome all positive input. Many thanks. Nansen.


Senior member
2,176 528
Click this link you will find out how to import and update excel[/QUOTE

The OP wants to know how to use the IG API for this purpose - don't think the link covers it. Reasonably straightforward to do if you know what you are doing but otherwise I would suggest hiring a competent software engineer who should be able to do it quite easily. If OP doesn't have requisite skills it may not be cost-effective to waste trading time DIY.
  • Like
Reactions: nansen