Need a SpreadSheet like TWS

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,

nitro

 

In the past, I have experiment with this efficient library available in .NET now:

http://www.roguewave.com/products/stingray/objectivegrid/

also this:

http://www.infragistics.com/products/grids.asp

and this metasite for components:

http://www.componentsource.com/catalog.asp?sc=CS&vw=br

Hope this will help you!

 

Thanks,

I will look into those.

nitro

 

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

 

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

Next release even will have an Excel sheet for trading.

Dierk

 

Dirk,

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

nitro

 

alan,

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.

nitro

 

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


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


Hope this helps

Bernd Kuerbs

 

Bernd,

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

Dierk

 

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.