HELP! DDE Formula

oatman

Senior member
2,879 22
Hello DDE and programming experts :cool:
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 :rolleyes:
ps. I don't know anything about programming. :cheesy:

Thank you
 

Fish

Member
79 3
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.
 

Hittfeld

Well-known member
437 12
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
 

oatman

Senior member
2,879 22
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
 

bonsai

Veteren member
4,106 10
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 ?
 

oatman

Senior member
2,879 22
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
 

bonsai

Veteren member
4,106 10
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 ?)
 

oatman

Senior member
2,879 22
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
 

stevet

Established member
917 5
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
 

oatman

Senior member
2,879 22
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
 

Hittfeld

Well-known member
437 12
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
 

Rognvald

Established member
916 15
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
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock