开云体育

Here is what the readme says for the DDE interface New DDE-supported tag for displaying errors Another DDE-supported tag has been added for returning errors on Excel spreadsheets. The syntax is

Does anyone know if there is a way to get Market Depth data from IB in EXCEL using DDE or some other way for that matter? regards -fm

Giving a quick look I see two things: 1) You set the label to the new value and then compare it to the new value, which will always result in "equal". You need something like PrevSize =

Can someone help with this problem? I'd like show the change of bid and ask price with different colours: higher prices = green, lower prices = red. I've written the following code, which,

I don't think it is possible. While the demo account can run 24/7, regular accounts cannot, as the system shuts down for a short period at night.

It appears that when you change an order that has not been transmitted, the order is transmitted after the change! Here are the steps in the edemo account: 1) Place limit order to buy (but not

Chas, Try STPLMT (no space inbetween) Good luck

has anyone found a way to reset this via VB or turn this feature off once and for all?

Yes I guess I have had the same issues with coding against the demo. I will go as far as I can with the demo and then try it live. Trouble is I only trade Futures so that is a little dificult <grin>

Chas, I had endless problems when using the demo account. I switched to my real account and only traded small lots in a slow moving stock for testing purposes and things went much smoother. Brendon

Thanks Brendon Wish I had checked it more carefully to start with. I have ben looking at the DDE and it seems to be reasonably straight forward. I have a couple of questions if you or someone else

Chas, I had the same problems and redesigned the whole thing in DDE and everything works well now. IB has specifically recommended against using VB with Excel for TWS because of the dropped events.

OK have happily created my App in Excel but every now and then IB fills an order and I do not get the event to handle. This happens if I have multiple orders being filled at the same time. Is there

I have come across the same issue. As far as I know, you can only get account information after you place your first order. I can't get the openOrder1 and openOrder2 events either. Only the final

Hello Friends, I am new to TWS API. I am trying to get stock for a particular account.For this API said that that we have to call requestAccountUpdates method. and the API will response through

Try using this: Application.Goto ThisWorkbook.Names("Name").RefersToRange where "Name" is your rangename in quotes.

I like the way the program works so far. Is it possible to make it smaller? I have a laptop and space is at a premium. It would be helpful to shrink the buttons a bit and remove some of the empty

IB claims that activeX should not be used with excel spreadsheets. They recommend the DDE interface. Search for info on IB's site. Andy M. my my others?

Here is a yahoo group that might be helpful. xltraders@... Also I have asked these people about 30 ?.'s and if I don't get a response in 6 hours it is unusual.

I set my Excel application to work today connected live with IB. Several times it gave me errors. I am not sure why? Application.Goto Reference:="Name" Gives errors sometimes Where "Name" is a defined