The Cancel Order Request
The purpose of this functionality is to provide the client, a way to cancel QST orders via Excel.
The reqCancelOrder format
reqCancelOrder( Provider | Account | OrderId | ConfirmationType)
The standard call of the RTD function which uses reqCancelOrder:
=RTD(“qst.rtd”, “”, “reqCancelOrder( Provider | Account | OrderId | ConfirmationType )”)
The reqCancelOrder parameters are explained below:
Provider – the order entry provider, ex. PTS, QOR
Account – account on which the order will be placed (QST needs to be connected to this account)
OrderId – the id of the order to be canceled
ConfirmationType – if this parameter is missing it will try to cancel the order immediately; If the value ON is provided, a cancel order confirmation dialog will be launched in QST to confirm the cancellation;
Note
The order of these parameters is mandatory, ex. Parameter 1, Provider, cannot be switched with parameter 2, Account.
Example of reqCancelOrder request
After selecting any desired cell from the Excel spreadsheet, copy paste the RTD function in the formula bar, having replaced the RTD parameters accordingly.
Cancelling an order with id 3451639:
*reqCancelOrder( PTS | 886 | 3451639 | )*