HELP! DDE Formula

This is a discussion on HELP! DDE Formula within the Techies Corner forums, part of the Trading Career category; Hello DDE and programming experts Back on this again. I'm trying to feed IB into Indexia. It accepts any RT ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Sep 22, 2003, 1:09pm   #1
 
oatman's Avatar
Joined Feb 2003
HELP! DDE Formula

Hello DDE and programming experts
Back on this again. I'm trying to feed IB into Indexia. It accepts any RT DDE feed. According to IB User Guide, they use standard DDE format =topic|item!data. For Indexia, I need APPLICATION, TOPIC and ITEM. Then presumably Source Code and Epic Code. APPLICATION is my account number. ITEM appears to be the same in each field, that is, tik! . Then somewhere you'd enter Bid, Ask, Last or whatever.
IB give an example of =edemo|tik!id0?req?IBM_STK_SMART
So if edemo is my account no. and I want to show YM contract, can you help please? I've tried a few combinations into a spreadsheet but it gives error warnings. Once I can see the way their formula runs, I should be able to feed it in
ps. I don't know anything about programming.

Thank you
__________________
Every market has a bottom, every bottom has a hole in it.
oatman is offline   Reply With Quote
Old Sep 22, 2003, 1:39pm   #2
Joined Jan 2003
Don't know anything about IB and Indexia, but for an SSRT feed into Excel, the cell entry looks like this (for JJB Bid price)

=SharescopeDDE|JJB!BID

Hope it helps.
Fish is offline   Reply With Quote
Old Sep 22, 2003, 2:02pm   #3
 
oatman's Avatar
Joined Feb 2003
oatman started this thread Ok thanks, but I think it's the IB format that I need.
Still trying.....
__________________
Every market has a bottom, every bottom has a hole in it.
oatman is offline   Reply With Quote
Old Sep 22, 2003, 3:14pm   #4
Joined May 2003
oatman
its likely to be application specific, so I would give IB a ring
and ask them
__________________
Come fill the cup that clears
today of past regrets and future fears
bonsai is offline   Reply With Quote
Old Sep 22, 2003, 3:34pm   #5
Joined Jun 2003
Hi Oatman,

One posssibility waould be to check the IB community and IB API usergroup (accessible from their webpage www.interactivebrokers.com. There is also a usergroup at groups.yahoo .com

Hittfeld
Hittfeld is offline   Reply With Quote
Old Sep 22, 2003, 4:39pm   #6
 
oatman's Avatar
Joined Feb 2003
oatman started this thread Hi, Bonsai, I've emailed IB and they're not very helpful. They said all the information is in the user guide under API. It's all a bit confusing. I can see more or less what I think i need but can't seem to get it together into a working formula.
Hittfeld, I've been on the IB sites and they're not very active, although I'm still searching.
Thanks
__________________
Every market has a bottom, every bottom has a hole in it.
oatman is offline   Reply With Quote
Old Sep 22, 2003, 4:50pm   #7
Joined May 2003
oatman
it occurs to me that if you are trying to create the link in Indexia
you will need to use only their format.
so it may be

application=IB
topic=epic(IB's)
item= bid ?
__________________
Come fill the cup that clears
today of past regrets and future fears
bonsai is offline   Reply With Quote
Old Sep 22, 2003, 5:10pm   #8
 
oatman's Avatar
Joined Feb 2003
oatman started this thread The application name is your account number. That's about the only thing I think I've got right at the mo. I know more or less where to put things in Indexia but I have to know IB's set up. All feeds do it differently.
In the Topic column, some feeds apparently use the same entry which in IB's case i think it's tik!. Then I've got to enter the contract and as you say Bid,Offer,Last or whatever. I'm trying to look in their Demo. There's a dummy spreadsheet which might reveal all. Someone must know their format.
Thanks
__________________
Every market has a bottom, every bottom has a hole in it.
oatman is offline   Reply With Quote
Old Sep 22, 2003, 5:44pm   #9
Joined May 2003
well you know best

but its not clear to me how Indexia will know you are trying to connect with IB .

dont explain, but when you make a connection will be interested
in final content of your link.

(I assume you have IB up and running when you try to make the link ?)
__________________
Come fill the cup that clears
today of past regrets and future fears
bonsai is offline   Reply With Quote
Old Sep 22, 2003, 6:15pm   #10
 
oatman's Avatar
Joined Feb 2003
oatman started this thread Yes, IB is enabled "out" and I enter the name of the feed ie. my account number in the feed provider box in the receiving prog. Then the problem is the format IB use. I suppose if I fiddle with it long enough i might stumble on it.
Thanks
__________________
Every market has a bottom, every bottom has a hole in it.
oatman is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Here's the 20/20 bar formula that I used botelho64 Trading Software 4 Feb 24, 2008 5:06pm
Formula 1 Chicken Curry The Foyer 24 Dec 5, 2007 9:10am
Formula Help rsrobinson Trading Software 2 Feb 21, 2007 12:44pm
Help with formula martindelica Trading Software 1 Jan 6, 2007 4:46pm
Formula help jensfrode Trading Software 33 Aug 19, 2006 4:47pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)