Spreadsheet Streaming Quote Downloads

[Jaba122]

Swish

you might consider checking myTrack out. I believe they have what you need in a basic package. Hope this helps.

 

[voodoo_invest]

Neo,

DDE is basically a protocol that lets two different applications talk to each other. So you could have a program that talks to the TWS and sends in orders for you. Pretty much the only reason to do that is to automate order entry, either partially (you still make the trading decisions but automate the order entry to make it faster, for example by having a program determine the size, limit, executing a basket of stocks you've chosen, etc.,) or completely (have a program trade for you without any human intervention.)

voodoo

 

[vikana]

Originally posted by the_dude

PS - If DDE/excel are fast enough, does anyone know of a good source to quickly learn the VB code you need to create orders?

just look at the code that IB wrote. It's very clear what you need to do if you've programmed a bit before. The code is included in the Excel spreadsheet you can download from IB web site.

I responded to the Excel performance question on the seperate thread you created.

 

[vikana]

Originally posted by WarEagle
Wow, I never knew that was there. I have Office 2000, so the PC Quote option is not there, now it gets quotes from MSN MoneyCentral (why doesn't that surprise me? )

Kirk

I found it by chance several years ago. Not advertised much.

 

[BeenHere]

>just look at the code that IB wrote. It's very clear
>what you need to do if you've programmed a bit
>before. The code is included in the Excel spreadsheet
>you can download from IB web site.

While close, the VBA code from the IB Excel spreadsheet will not work if simply pasted into VB. There is some differences between Excel VBA, Word VBA and VB (thanks a bunch Microsoft).

 

[qwiktrade]

Qcharts has a little program called Qlink that will allow you to import streaming quotes into excel.. i am actually going to Atlanta today to buy office xp to use for this very purpose.. ill let you know how it works.. here is the link to qcharts if it interests you..

www.qcharts.com this will redirect you, but eventually you will get to the info..

-qwik