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 code.
By PM, I send you a Simulator XL Wkb with ticker request.
BR
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!'0012CSNA3;3'
>
> where
>
> =TWSVR|CMA! is the DDE SERVER link
>
> 0012CSNA3 is the ticker code (0012 is the origin - BOVESPA and CSNA3 is the
> ticker itself
>
> 3 refers to the field at the quote sheet (1=last, 3=buy, 3=sell, etc)
>
> I tried to configure the dde fields like described before but can't get any
> connection. I left =TWSVR|CMA on the SERVER and '0012{ticker};1' on the
> LAST
> field (as an example) but got no connection.
>
> Any ideas on how to fix it?
>
> Regards
>
> Antonio
>
>
------------------------------------
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
amibroker-dig...@yahoogroups.com
amibroker-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
