Live excel graph from live stock data

Discussion in 'Technical Analysis' started by arman555, Jul 5, 2019.

  1. arman555

    arman555

    Hello,

    I am trying to implement a live graph of live data in excel. It obiviously wont be in a table form. Most likely it will be a single cell with updating value. So i want the graph to keep plotting the value against time. Some help please.
    Is there any other software that can do this?
     
  2. Times

    Times

    What kind of data? maybe thinkorswim can do it which is free. Or Sierra chart is customizable with excel.
     
  3. arman555

    arman555

    Data will be coming from IB tws. But the question is to graph that data.
     
  4. minmike

    minmike

    You need a macro to save the data. If you insert a row with new data at the top it can work. But excel won't automatically save a snap shot.