----- 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 .