Real Time EXCEL Charts

Discussion in 'Trading Software' started by Eldredge, Nov 17, 2008.

  1. Eldredge


    I use IB's API worksheet with DDE to feed an Excel worksheet. I would like to create a dynamic intraday chart from this data, but I can't seem to find any info on how to do this. Can someone tell me where I can find some information, or what this type of chart is called? Thanks for the help.
  2. Eldredge


    Anyone have any suggestions? I assume this is possible - basically just making a regular real-time chart usingExcel.
  3. Eldredge


    Maybe I can do this using a table? Is there anyone who has done this? Any suggestions on where to find some info would be greatly appreciated.
  4. pwa2


    it can be done with a little VBA in one of the excel event functions for the worksheet.

    these functions are called when an event in excel occurs eg excel recalculates itself and the function Worksheet_Calculate() would be called for that sheet

    you could use this event to store your dde tick prices in the sheet as they happen.

    In case you dont already know, you can access the vba worksheet events vba space by double clicking on say Sheet1 (if you've got a shhet1) for the workbook in the VBA prject bit of the vba editer. Above the blank space for vba statements there are two dropdown boxs the left one will have a worksheet option - select this, thien in the right one you'll see all the event functions that you can implement in VBA for this sheet when that event occurs. When i did this for storing data for charts i used this i used the Worksheet_Calculate() event as mentioned above.

    I aslo made the sheet live (volatilie) by adding =now() somewhere in the sheet - you'll need this anyway as next to each tick price you'll want the time, say done in columns.

    hopefully this it enough to get going. There are a few other bits and bobs to address to get it into a usfull tool that is in the same ballpark as a chart package but that is all tinkering around with it.
    Unless excel is the only option for this and you only have a small number of things to monitor in this way realtime I would consider another way else you'll likely be repeatedly crashing excel and perhaps causing problems with tws etc .

    Also try and do this with RTD rather than DDE for obvious reasons. People have implemtneted RTD interfaces for TWS and other platforms for very little $$.
  5. Eldredge


    Thanks for the detailed reply. I was hoping to use this to moniter ES, YM, and NQ every 15 seconds. I was wanting to monitor 2ES-YM-2NQ as one "item", and be able to chart the bid, ask, last. Perhaps I need to find a better solution though. Thanks again for the help. I really appreciate it.
  6. A little application called 'QTXL' might be able to do what you're looking for.

    You can make real time streaming charts in excel, its kinda cool.

    Play around with it, I think it has a free trial.

    <IMG SRC= width=800>
    (click on attachment to enlarge)
    • qt.png
      File size:
      8.8 KB
  7. Eldredge


    Thanks Ang 99. I will check it out.