Interactive Brokers Excel Real Time

F

feb2006

Would like to discuss development of software processing TWS quotes real time in Excel. Starting with a pre production version (v2,03) of my Excel-Ticker, see screenshot below.

Following soon:
video: Ticker_2,03inAction.avi.zip
manual: ManualExcelTWSv2,03.pdf
spreadsheet: Excel-TWSv2,03withBarData.xls

Regards, Martin
 

Attachments

To change the number of rows saved you have to open VisualBasic Editor with 'alt+F11'. Then goto Module 'ModuleTWSapi' to Sub 'ListeSchieben' and change the copy range 'Range("A11:C1009")'.

Regards
Martin
 

Attachments

Very interesting Martin and thanks for posting. I am totally new to any type of programming using Excel (or anything else for that matter) for trading.

I'll be following with great interest.
 
Hi,

Thanks for building this spreadsheet -- I'd like to try using it. I tried it and got the error described in the enclosed jpg. Thanks for taking a look!
 
Quote from johnnylambada:


Thanks for building this spreadsheet -- I'd like to try using it. I tried it and got the error described in the enclosed jpg. Thanks for taking a look! [/B]
More...
Hi Jonny, sure would I, but probably you didn't succeed uploading your jpg. Even had a look into my PMs but couldn't find any message with jpg attached.
So please try uploading your jpg again.
Regards, Martin

PS
Did you try to connect and disconnect several times? That's often the best way do solve problems.
To solve other problems from distance isn't easy - in principle you have to open Visual Basic Editor and set stop points or the line 'MsgBox "Test"' till the programming line creating this error is isolated.
And to know where to place these stop points a description is necessary after clicking what buttons the error occurred.

Does anybody else experience similar problems? I would appreciate reports of successful usage too.
 
You must log in or register to reply here.
Back
Top