Look for TwsDde.xls
DDE for Excel API Sample Spreadsheet Updates
The DDE for Excel API sample spreadsheet (TwsDde.xls) has been updated
with the following user interface improvements:
http://www.interactivebrokers.com/en/p.php?f=connAltern&p=i&ib_entity=llc
Le 22/02/2010 16:37, Antonio J
<*>[Attachment(s) from reinsley included below]
A simple XL example
Le 22/02/2010 16:37, Antonio Jordao Jr a écrit :
>
>
> Hi all,
>
> I am trying to import data from a dde server to get real time quotes from a
> local feeder.
>
> The command line to import in an Excel cell is :
>
> =TWSVR|CMA!
Hi,
I did that a long time ago with IB.
You could try to validate with IB demo account.
The syntax is
=mylogin|tik!id0?last
=mylogin|tik!id0?lastsize
Mylogin could be edemo, as far as I remember.
NB : IB gives a full XL Workbook with macros to send orders to TWS, that
can show you the VBA c
Hi all,
I am trying to import data from a dde server to get real time quotes from a
local feeder.
The command line to import in an Excel cell is :
=TWSVR|CMA!'0012CSNA3;3'
where
=TWSVR|CMA! is the DDE SERVER link
0012CSNA3 is the ticker code (0012 is the origin - BOVESPA and CSNA3 is the
ti
