¿ªÔÆÌåÓý

ctrl + shift + ? for shortcuts
© 2025 Groups.io
  1. Twsapi
  2. Topics

twsapi: ANNOYING Missed events in Excel/VB

Brendon Cheves
 

Chas,

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
anything I can do to fix this or do I have to go back to the begining
and redesign it useing DDE??
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.

Brendon
Chas_watkins
 

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 would n't mind
helping.

I see that to get errors. You have to use ="cdemo|error!error however
when I do that I get the result invalid topic? Any ideas on how I can
track errors.

Also I use STP LMT orders and using the demo I can't seem to send STP
LMT orders. I have used both "STP_LMT" and also "STP LMT" but the
resulting DDE links all just show 0s.

Any thoughts.

Thanks for the help.

Regards

Chas

--- In twsapi@y..., Brendon Cheves <brendon@h...> wrote:
Chas,

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
anything I can do to fix this or do I have to go back to the
begining
and redesign it useing DDE??
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.

Brendon
Brendon Cheves
 

Chas,

Also I use STP LMT orders and using the demo I can't seem to send STP
LMT orders. I have used both "STP_LMT" and also "STP LMT" but the
resulting DDE links all just show 0s.
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
Chas_watkins
 

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>

Is that syntax for the error correct?

thanks For your help.

regards

Chas



--- In twsapi@y..., Brendon Cheves <brendon@h...> wrote:
Chas,

Also I use STP LMT orders and using the demo I can't seem to send
STP
LMT orders. I have used both "STP_LMT" and also "STP LMT" but the
resulting DDE links all just show 0s.
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
 

¿ªÔÆÌåÓý

Chas,
?
Try STPLMT (no space inbetween)
?
Good luck

----- Original Message -----
Sent: Tuesday, July 30, 2002 8:00 AM
Subject: Re: twsapi: ANNOYING Missed events in Excel/VB

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 would n't mind
helping.

I see that to get errors. You have to use ="cdemo|error!error however
when I do that I get the result invalid topic? Any ideas on how I can
track errors.

Also I use STP LMT orders and using the demo I can't seem to send STP
LMT orders. I have used both "STP_LMT" and also "STP LMT" but the
resulting DDE links all just show 0s.

Any thoughts.

Thanks for the help.

Regards

Chas

--- In twsapi@y..., Brendon Cheves wrote:
> Chas,
>
> > 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
> > anything I can do to fix this or do I have to go back to the
begining
> > and redesign it useing DDE??
>
> 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.
>
> Brendon



To unsubscribe from this group, send an email to:
twsapi-unsubscribe@...



Your use of Yahoo! Groups is subject to the .

1 - 5 of 5