Charts in Excel from IB?

Discussion in 'Trading Software' started by chisel, Jan 29, 2004.

  1. chisel


    I want to create an Excel chart of weighted futures spreads using IB as the source for the futures quotes. I have IB's twsdde.xls worksheet, but would someone point me in the right direction on how to create a chart (and have it continuously update every minute e.g.)? Do I need additional software for this?

    I don't need the software for fancy charts as Excel is fine for this, but how do I get Excel to update a row and move the previous price up a row? Qlink from Qcharts can do this, but if there's no tick, it puts a 0 in the cell and screws up the chart.