----- Original Message -----

From: mk_trading_911

To: twsapi@...

Sent: Thursday, July 04, 2002 6:04 AM

Subject: twsapi: Re: Help! Cancel order

Either: store in your application's globals the ID number of the
orders you are sending, and their status, or extract them from TWS
(Tws1.reqOpenOrders). Once you know the ID, then use:
Tws1.cancelOrder (orderId). It's all in the Excel spreadsheet VBA
Macros, and user's manual.
I hope this helps.

MK


--- In twsapi@y..., "Bruce Hawkins" wrote:
>? I have been struggling with this for 2 days, does anyone have VB
code for canceling a pending order. I 've tried 6
> ways from Sunday to make it work and I am totally lost.
>
> Thanks,
>
> Bruce



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



Your use of Yahoo! Groups is subject to the .

----- Original Message -----

From: mk_trading_911

To: twsapi@...

Sent: Thursday, July 04, 2002 6:21 AM

Subject: twsapi: Re: Help! Cancel order

Open the workbook, and press Alt-F11. Visual Basic for Applications
should appear. All the code for cancelling an order is on sheet2
(Orders).

What part of the code do you have a problem with, exactly?
MK

--- In twsapi@y..., "Bruce Hawkins" <hawkinsk001@h...> wrote:
> Thanks for the response, and if I was a little more savy regarding
VB what you sent would be helpful.
>
> I have looked at user's guide and Excel code trying to come up with
what I need and I can't figure it out.
>
> But thanks anyway.
>
> Bruce
>?? ----- Original Message -----
>?? From: mk_trading_911
>?? To: twsapi@y...
>?? Sent: Thursday, July 04, 2002 6:04 AM
>?? Subject: twsapi: Re: Help! Cancel order
>
>
>?? Either: store in your application's globals the ID number of the
>?? orders you are sending, and their status, or extract them from
TWS
>?? (Tws1.reqOpenOrders). Once you know the ID, then use:
>?? Tws1.cancelOrder (orderId). It's all in the Excel spreadsheet VBA
>?? Macros, and user's manual.
>?? I hope this helps.
>
>?? MK
>
>
>?? --- In twsapi@y..., "Bruce Hawkins" wrote:
>?? >? I have been struggling with this for 2 days, does anyone have
VB
>?? code for canceling a pending order. I 've tried 6
>?? > ways from Sunday to make it work and I am totally lost.
>?? >
>?? > Thanks,
>?? >
>?? > Bruce
>
>
>???????? Yahoo! Groups Sponsor
>?????????????? ADVERTISEMENT
>?????????????
>???????
>
>?? To unsubscribe from this group, send an email to:
>?? twsapi-unsubscribe@y...
>
>
>
>?? Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



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



Your use of Yahoo! Groups is subject to the .

----- Original Message -----

From: mk_trading_911

To: twsapi@...

Sent: Thursday, July 04, 2002 7:00 AM

Subject: twsapi: Re: Help! Cancel order

Bruce, it's really simple.

existingId = Cells(ActiveCell.row, 13).value

it means that existingId get's loaded with whatever there is in the
column 13 of the active row on the spreadsheet. then it passes that
number to tws1.cancelOrder, and it cancels it.

Since you don't have spreadsheet, you need to store that ID number
when you send your buy/sell order for execution. Or, a bit more
complicated, request open orders, get their IDs and use one of them
to cancel that order.

MK

--- In twsapi@y..., "Bruce Hawkins" wrote:
> First of all thanks for the response, here is the code in Excel
>
> Sub cancelOrder()
>???? clearError
>????
>???? ' get existing id
>???? Dim existingId As Long
>???? existingId = Cells(ActiveCell.row, 13).value
>
>???? ' cancel order
>???? Sheet5.Tws1.cancelOrder (existingId)
> End Sub
>
> Maybe I did not make it clear but I am trying to come up with a
stand alone program, that being said in the code above there
> is references to sheets and cells which don't exist in my prog. I
am not sure what to put in there place.
>
> Thanks,
>
> Bruce
>?? ----- Original Message -----
>?? From: mk_trading_911
>?? To: twsapi@y...
>?? Sent: Thursday, July 04, 2002 6:21 AM
>?? Subject: twsapi: Re: Help! Cancel order
>
>
>?? Open the workbook, and press Alt-F11. Visual Basic for
Applications
>?? should appear. All the code for cancelling an order is on sheet2
>?? (Orders).
>
>?? What part of the code do you have a problem with, exactly?
>?? MK
>
>?? --- In twsapi@y..., "Bruce Hawkins" wrote:
>?? > Thanks for the response, and if I was a little more savy
regarding
>?? VB what you sent would be helpful.
>?? >
>?? > I have looked at user's guide and Excel code trying to come up
with
>?? what I need and I can't figure it out.
>?? >
>?? > But thanks anyway.
>?? >
>?? > Bruce
>?? >?? ----- Original Message -----
>?? >?? From: mk_trading_911
>?? >?? To: twsapi@y...
>?? >?? Sent: Thursday, July 04, 2002 6:04 AM
>?? >?? Subject: twsapi: Re: Help! Cancel order
>?? >
>?? >
>?? >?? Either: store in your application's globals the ID number of
the
>?? >?? orders you are sending, and their status, or extract them
from
>?? TWS
>?? >?? (Tws1.reqOpenOrders). Once you know the ID, then use:
>?? >?? Tws1.cancelOrder (orderId). It's all in the Excel spreadsheet
VBA
>?? >?? Macros, and user's manual.
>?? >?? I hope this helps.
>?? >
>?? >?? MK
>?? >
>?? >
>?? >?? --- In twsapi@y..., "Bruce Hawkins" wrote:
>?? >?? >? I have been struggling with this for 2 days, does anyone
have
>?? VB
>?? >?? code for canceling a pending order. I 've tried 6
>?? >?? > ways from Sunday to make it work and I am totally lost.
>?? >?? >
>?? >?? > Thanks,
>?? >?? >
>?? >?? > Bruce
>?? >
>?? >
>?? >???????? Yahoo! Groups Sponsor
>?? >?????????????? ADVERTISEMENT
>?? >?????????????
>?? >???????
>?? >
>?? >?? To unsubscribe from this group, send an email to:
>?? >?? twsapi-unsubscribe@y...
>?? >
>?? >
>?? >
>?? >?? Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>?? Service.
>
>
>???????? Yahoo! Groups Sponsor
>??????????
>
>?? To unsubscribe from this group, send an email to:
>?? twsapi-unsubscribe@y...
>
>
>
>?? Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



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



Your use of Yahoo! Groups is subject to the .

"Flyin an airplane is really simple too if you know how to do it. LOL"

Yep....its the landings that are tricky....

Scott



--- In twsapi@y..., "Bruce Hawkins" <hawkinsk001@h...> wrote:

Flyin an airplane is really simple too if you know how to do it. LOL

Thanks for pointing me in the right direction I will see if I can

figure this out.

Have a safe holiday.

Bruce
----- Original Message -----
From: mk_trading_911
To: twsapi@y...
Sent: Thursday, July 04, 2002 7:00 AM
Subject: twsapi: Re: Help! Cancel order


Bruce, it's really simple.

existingId = Cells(ActiveCell.row, 13).value

it means that existingId get's loaded with whatever there is in

the

column 13 of the active row on the spreadsheet. then it passes

that

number to tws1.cancelOrder, and it cancels it.

Since you don't have spreadsheet, you need to store that ID

number

when you send your buy/sell order for execution. Or, a bit more
complicated, request open orders, get their IDs and use one of

them

to cancel that order.

MK

--- In twsapi@y..., "Bruce Hawkins" <hawkinsk001@h...> wrote:
> First of all thanks for the response, here is the code in Excel
>
> Sub cancelOrder()
> clearError
>
> ' get existing id
> Dim existingId As Long
> existingId = Cells(ActiveCell.row, 13).value
>
> ' cancel order
> Sheet5.Tws1.cancelOrder (existingId)
> End Sub
>
> Maybe I did not make it clear but I am trying to come up with a
stand alone program, that being said in the code above there
> is references to sheets and cells which don't exist in my prog.

I

am not sure what to put in there place.
>
> Thanks,
>
> Bruce
> ----- Original Message -----
> From: mk_trading_911
> To: twsapi@y...
> Sent: Thursday, July 04, 2002 6:21 AM
> Subject: twsapi: Re: Help! Cancel order
>
>
> Open the workbook, and press Alt-F11. Visual Basic for
Applications
> should appear. All the code for cancelling an order is on

sheet2

> (Orders).
>
> What part of the code do you have a problem with, exactly?
> MK
>
> --- In twsapi@y..., "Bruce Hawkins" <hawkinsk001@h...> wrote:
> > Thanks for the response, and if I was a little more savy
regarding
> VB what you sent would be helpful.
> >
> > I have looked at user's guide and Excel code trying to come

up

with
> what I need and I can't figure it out.
> >
> > But thanks anyway.
> >
> > Bruce
> > ----- Original Message -----
> > From: mk_trading_911
> > To: twsapi@y...
> > Sent: Thursday, July 04, 2002 6:04 AM
> > Subject: twsapi: Re: Help! Cancel order
> >
> >
> > Either: store in your application's globals the ID number

of

the
> > orders you are sending, and their status, or extract them
from
> TWS
> > (Tws1.reqOpenOrders). Once you know the ID, then use:
> > Tws1.cancelOrder (orderId). It's all in the Excel

spreadsheet

VBA
> > Macros, and user's manual.
> > I hope this helps.
> >
> > MK
> >
> >
> > --- In twsapi@y..., "Bruce Hawkins" <hawkinsk001@h...>

wrote:

> > > I have been struggling with this for 2 days, does

anyone

have
> VB
> > code for canceling a pending order. I 've tried 6
> > > ways from Sunday to make it work and I am totally lost.
> > >
> > > Thanks,
> > >
> > > Bruce
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > twsapi-unsubscribe@y...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms

of

> Service.
>
>
> Yahoo! Groups Sponsor
>
>
> To unsubscribe from this group, send an email to:
> twsapi-unsubscribe@y...
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.


Yahoo! Groups Sponsor
ADVERTISEMENT



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



Your use of Yahoo! Groups is subject to the Yahoo! Terms of

Service.

----- Original Message -----

From: jaba_z

To: twsapi@...

Sent: Thursday, July 04, 2002 8:32 AM

Subject: twsapi: Re: Help! Cancel order

Hey Bruce, and I thought that the project I put on my pitiful website
was good enough... :)

regards
Jaba

--- In twsapi@y..., "marinindextrader" <marinindextrader@y...> wrote:
> "Flyin an airplane is really simple too if you know how to do it. LOL"
>
> Yep....its the landings that are tricky....
>
> Scott
>
>
>
> --- In twsapi@y..., "Bruce Hawkins" wrote:
> > Flyin an airplane is really simple too if you know how to do it. LOL
> >
> > Thanks for pointing me in the right direction I will see if I can
> figure this out.
> >
> > Have a safe holiday.
> >
> > Bruce
> >?? ----- Original Message -----
> >?? From: mk_trading_911
> >?? To: twsapi@y...
> >?? Sent: Thursday, July 04, 2002 7:00 AM
> >?? Subject: twsapi: Re: Help! Cancel order
> >
> >
> >?? Bruce, it's really simple.
> >
> >?? existingId = Cells(ActiveCell.row, 13).value
> >
> >?? it means that existingId get's loaded with whatever there is in
> the
> >?? column 13 of the active row on the spreadsheet. then it passes
> that
> >?? number to tws1.cancelOrder, and it cancels it.
> >
> >?? Since you don't have spreadsheet, you need to store that ID
> number
> >?? when you send your buy/sell order for execution. Or, a bit more
> >?? complicated, request open orders, get their IDs and use one of
> them
> >?? to cancel that order.
> >
> >?? MK
> >
> >?? --- In twsapi@y..., "Bruce Hawkins" wrote:
> >?? > First of all thanks for the response, here is the code in Excel
> >?? >
> >?? > Sub cancelOrder()
> >?? >???? clearError
> >?? >????
> >?? >???? ' get existing id
> >?? >???? Dim existingId As Long
> >?? >???? existingId = Cells(ActiveCell.row, 13).value
> >?? >
> >?? >???? ' cancel order
> >?? >???? Sheet5.Tws1.cancelOrder (existingId)
> >?? > End Sub
> >?? >
> >?? > Maybe I did not make it clear but I am trying to come up with a
> >?? stand alone program, that being said in the code above there
> >?? > is references to sheets and cells which don't exist in my prog.
> I
> >?? am not sure what to put in there place.
> >?? >
> >?? > Thanks,
> >?? >
> >?? > Bruce
> >?? >?? ----- Original Message -----
> >?? >?? From: mk_trading_911
> >?? >?? To: twsapi@y...
> >?? >?? Sent: Thursday, July 04, 2002 6:21 AM
> >?? >?? Subject: twsapi: Re: Help! Cancel order
> >?? >
> >?? >
> >?? >?? Open the workbook, and press Alt-F11. Visual Basic for
> >?? Applications
> >?? >?? should appear. All the code for cancelling an order is on
> sheet2
> >?? >?? (Orders).
> >?? >
> >?? >?? What part of the code do you have a problem with, exactly?
> >?? >?? MK
> >?? >
> >?? >?? --- In twsapi@y..., "Bruce Hawkins" wrote:
> >?? >?? > Thanks for the response, and if I was a little more savy
> >?? regarding
> >?? >?? VB what you sent would be helpful.
> >?? >?? >
> >?? >?? > I have looked at user's guide and Excel code trying to come
> up
> >?? with
> >?? >?? what I need and I can't figure it out.
> >?? >?? >
> >?? >?? > But thanks anyway.
> >?? >?? >
> >?? >?? > Bruce
> >?? >?? >?? ----- Original Message -----
> >?? >?? >?? From: mk_trading_911
> >?? >?? >?? To: twsapi@y...
> >?? >?? >?? Sent: Thursday, July 04, 2002 6:04 AM
> >?? >?? >?? Subject: twsapi: Re: Help! Cancel order
> >?? >?? >
> >?? >?? >
> >?? >?? >?? Either: store in your application's globals the ID number
> of
> >?? the
> >?? >?? >?? orders you are sending, and their status, or extract them
> >?? from
> >?? >?? TWS
> >?? >?? >?? (Tws1.reqOpenOrders). Once you know the ID, then use:
> >?? >?? >?? Tws1.cancelOrder (orderId). It's all in the Excel
> spreadsheet
> >?? VBA
> >?? >?? >?? Macros, and user's manual.
> >?? >?? >?? I hope this helps.
> >?? >?? >
> >?? >?? >?? MK
> >?? >?? >
> >?? >?? >
> >?? >?? >?? --- In twsapi@y..., "Bruce Hawkins"
> wrote:
> >?? >?? >?? >? I have been struggling with this for 2 days, does
> anyone
> >?? have
> >?? >?? VB
> >?? >?? >?? code for canceling a pending order. I 've tried 6
> >?? >?? >?? > ways from Sunday to make it work and I am totally lost.
> >?? >?? >?? >
> >?? >?? >?? > Thanks,
> >?? >?? >?? >
> >?? >?? >?? > Bruce
> >?? >?? >
> >?? >?? >
> >?? >?? >???????? Yahoo! Groups Sponsor
> >?? >?? >?????????????? ADVERTISEMENT
> >?? >?? >?????????????
> >?? >?? >???????
> >?? >?? >
> >?? >?? >?? To unsubscribe from this group, send an email to:
> >?? >?? >?? twsapi-unsubscribe@y...
> >?? >?? >
> >?? >?? >
> >?? >?? >
> >?? >?? >?? Your use of Yahoo! Groups is subject to the Yahoo! Terms
> of
> >?? >?? Service.
> >?? >
> >?? >
> >?? >???????? Yahoo! Groups Sponsor
> >?? >??????????
> >?? >
> >?? >?? To unsubscribe from this group, send an email to:
> >?? >?? twsapi-unsubscribe@y...
> >?? >
> >?? >
> >?? >
> >?? >?? Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> >?? Service.
> >
> >
> >???????? Yahoo! Groups Sponsor
> >?????????????? ADVERTISEMENT
> >?????????????
> >???????
> >
> >?? To unsubscribe from this group, send an email to:
> >?? twsapi-unsubscribe@y...
> >
> >
> >
> >?? Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.




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



Your use of Yahoo! Groups is subject to the .