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, 12: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, 12: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, 1: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, 2: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, 2: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, 3: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, 3: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, 4: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, 4: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, 5: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
Old Sep 22, 2003, 10:24pm   #11
Joined Apr 2002
too tired to read right throught the thread - not even too sure what Indexia is - but i guess some sort of charting or analysis thing - but i believe IB is accesible with API or DDE so u will probably need to enable one or the other specifically and also u might want to try putting a spread sheet in the middle of the probelm to get it all to work as a start point - so if indexia can access a specific cell in the sheet you can then use DDE to link that cell to IB with the correct formula

i can pretty much hook up any data feed to any other - so if u can be more specific in your problem in a scentence or two - i could try to help out

and u may also want to be careful using demos to get things to work at the start - i know that seems the better way - but normally these demo things issuing data can cause other problems and they are not the same as a real data feed - so your thing might be working - but the signal might just not be being issued - better to use the real feed
stevet is offline   Reply With Quote
Old Sep 22, 2003, 10:52pm   #12
Joined May 2003
good point steve

the feature may simply not be included in the demo version ?
__________________
Come fill the cup that clears
today of past regrets and future fears
bonsai is offline   Reply With Quote
Old Sep 23, 2003, 8:00am   #13
 
oatman's Avatar
Joined Feb 2003
oatman started this thread steve, I've got IB's API enabled (not the demo). As well as Indexia(chart package) I've got Updata's TA which says that I should be able to paste link the feed into a spreadsheet. This will then reveal the formula's setup. I can't get that to happen. At the moment paste and paste special are greyed out.
I need APPLICATION(which I believe is my account no.) for the feed,
TOPIC which in some feeds is the same in each field, others it's different. I think TOPIC has tik! involved.
ITEM again in some feeds is different, others the same.
IB's user guide covers it under API, DDE but I can't figure it out.
Additionally, Updata substitute an asterisk* for the instrument.
At the moment I'm running Tenfore Satellite(til next week) into Indexia so I don't really want to fiddle with that but the setup is similar. They use * and a number for bid/ask etc. under ITEM and the feed is designated as REALTIME in TOPIC.
Thanks
__________________
Every market has a bottom, every bottom has a hole in it.
oatman is offline   Reply With Quote
Old Sep 23, 2003, 9:25am   #14
Joined Jun 2003
Hi Oatman, I also noticed a lot of threads at www.elitetrader.com when I did search for IB and DDE.

Some of them mentioned for example : Metaserver RT (via DDE/Excel). Unfortunately I'm not knowledgable enough to furthermore search these threads for you.

Hittfeld
Hittfeld is offline   Reply With Quote
Old Sep 23, 2003, 11:12am   #15
 
Rognvald's Avatar
Joined Feb 2003
OM
You may be wrong in your reading of UD's TA dde. It is easy to dde out from the UD TA IP feed to a 3rd party spreadsheet in realtime but this is not what you are trying to do which is the reverse
__________________
Rognvald
Rognvald 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 3:47pm

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