Import/Link IB quotes into Excel using DDE

Discussion in 'Retail Brokers' started by thereuare, Jul 3, 2002.

  1. I can't for the life of me figure out how to use a DDE link (or any ohter method) to view quotes from IB in an excel spreadsheet.

    All i want to view is the last trade on the ES and NQ.

    Can anybody post the code OR info that goes into the formula bar to do this, or at least point me in the right direction.

    I've already tried searching here and have played around with the sample spreadsheet that IB offers.

    Thanks for any help.
  2. vikana

    vikana Moderator

    Why don't you just take a look at the spreadsheets IB makes available at their web site?

    Also, the Excel sheet is downloaded with all TWS installs into the jts/excel directory.
  3. vikana

    vikana Moderator

    Not trying to be a smart*** here, but I just loaded up the spreadsheet that IB provides, and it just works???

    Are you using a futures account ?
    Do you have TWS loaded ?

    Both are required.
  4. After your replies i went back to the basics and am able to get it to work by copying the link formulas from their "Sample Spreadsheet" and pasting the formulas into a new spreadsheet (i pasted the actual link formulas, and not a PASTE SPECIAL>> PASTE LINK).

    However, i'm trying to get the links to work directly into the new spreadsheet, without first going thru the "sample spreadsheet."

    Without going into too much needless detail, i have 2 other spreadsheets open (1 for data, 1 for charting). By going thru the sample spreadsheet, i now have to have 3 spreadsheets open, and i'd rather have just the two.

    Therefore, i'd like to make it so that my data spreadsheet gets the quotes directly from IB (instead of going thru the sample spreadsheet) so that there is one less step in the process.

    Did i explain this well enough?

    Thanks again, and please feel free to reply with add'l question if you need more info to assist me in getting the quotes into a spreadsheets without using the sample spreadsheet.

  5. if you use the IB help manual (Help -> user's guide from TWS) it will give you a good tutorial on getting it to work.

    don't forget to enable DDE integration and to modify your zone alarm settings to allow local server (and to allow javaw.exe to be an internet server).
  6. So after i get it to work (using 3 spreadsheet), i shut it down and restarted, and now i just get N/A# in cells of the Sample Spreadsheet.... any ideas.

    Also, how do i knew about enabling the DDE under settings, but how do i modify my ZONE ALARM and allow JAVAW.exe be INTERNET SERVER?

  7. Thereuare,

    I have had this same trouble. I finally just used QQL for my spreadsheet instead of TWS. Now I am using E-signal. I have no trouble using either of these, but I can't figure out TWS (without the sample worksheet) either. If you figure this out, will you please post your discoveries. If anyone else is using a DDE link with TWS can you please help.
  8. just open up the "programs" section of ZA, and right click on javaw.exe - you'll be able to change these settings from that menu.
  9. vikana

    vikana Moderator

    One more thought: IB uses Visual Basic to do much of the work. YOu will also have to copy the VBA routines to your own spreadsheet. to make things work.
  10. Thereuare, I hope you don't mind me butting in again, but I would like to know how to do this.

    With Esignal I can enter the formula WINROS|BID!QQQ and get a quote for QQQ bid entered into that cell and updated constantly. WINROS|ASK!QQQ. and I get the ask, and so on. All I have to do is start Esignal, and open the spreadsheet. I can enter these formulas anywhere I want, on any spreadsheet I want, and make other formulas using the info in these cells. Very simple and effective. Can this be done with TWS? If so, how? Thanks for any help.
    #10     Jul 3, 2002