Need a SpreadSheet like TWS

Discussion in 'Trading Software' started by nitro, Mar 16, 2004.

  1. nitro


    I was wondering if someone knew of a spreadsheet control, like the one TWS uses to display rows of data, that is as fast as what Interactive Brokes is using.

    When I use the built in controls that come with C# (listview, listbox) they are terribly slow and all kinds of blinking and ghosting happen - not really usable when realtime data is involved.

    It can be a .Net or an activeX contol.

    Thanks in advance,

  2. nitro



    I will look into those.

  3. alanm


    FWIW, I chose to use Excel (from VC++6), simply because I like and am used to the user interface. Implementing it was a little ugly, but there's an article in the KB that gets you mostly there. It's not particularly fast, either - particularly with writing to the spreadsheet, so I write through a cache, which speeds things up for my particular use. There are a number of things I want to try in order to speed it up, like lazy writing, caching the Range objects for the cells, etc. There's also some ugliness that you have with any single apartment (or whatever it's called) COM object relating to having to isolate it to it's own thread and pass everything back and forth from the rest of your app, though that still seems better than marshalling.

    I guess this isn't really a recommendation :)
  4. NinjaTrader_Dierk

    NinjaTrader_Dierk ET Sponsor

    You might want to take a look at I included a control to display market data.

    Next release even will have an Excel sheet for trading.

  5. nitro



    I get stuff in German, with a no smoking sign thru the text.

    nitro :confused:
  6. nitro



    Thanks for the suggestion. I have thought about Excel, and it works nicely for "slower" stuff, but as you point out, it is not really crisp on realtime data.

    To be honest, I mean, anyone that codes, try writing a little program that updates say 40 symbols on one of the built in spreadsheet like controls and then compare the performance of that to the TWS from IB.

    IBs spreadsheet does a great job.

  7. BKuerbs


    *LoL*, remove the dot after ".net", the correct address is

    A weakness of the board/browsersoftware: it should ignore the syntactically correct point after a webaddress.

    Hope this helps

    Bernd Kuerbs
  8. NinjaTrader_Dierk

    NinjaTrader_Dierk ET Sponsor


    Thanx. Funny, didn't notice that one ...

  9. It may be stating the obvious, but TWS almost certainly uses the swing JTable class for it's 'spreadsheet'. It's actually quite easy to use. So if you're willing to use Java .....

    I know nothing about .NET, but I must say I find it a little surprising that this is a problem. Java has to do this stuff cross platform. One would think that .NET could do a better job on just Windows.
    #10     Mar 17, 2004