The Number of Positions Request

The purpose of this functionality is to provide the number of positions for a particular provider, account, and optionally: instrument and position type.

The nrOfPositions format

The nrOfPositions request receives a total of 4 parameters which will filter the number of positions.

The parameters are separated by a vertical bar ‘|’ character. Parameters in [ ] can be omitted.

nrOfPositions( Provider | Account | [Instrument] | [PositionType] )

The standard call of the RTD function which uses nrOfPositions:

=RTD("qst.rtd", "", "nrOfPositions( Provider | Account | [Instrument] | [PositionType] )")

The nrOfPositions parameters are explained below:

Provider – the order entry provider, ex. PTS, QOR
Account – filter by account number
Instrument – [optional] filter by a specific instrument, if missing it will filter by provider and account
PositionType – [optional] filter by the type of positions: ALL (open positions and fills), NET (net positions), OPEN (only open positions), FILLS (only fills); if missing it will display all open positions and fills

Note

The order of these parameters is mandatory, ex. Parameter 1, Provider, cannot be switched with parameter 2, Account. The parameters are not case sensitive.

Example of nrOfPositions 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. Or enter the parameters separately and combine them for the RTD request.

In the examples below, the nrOfPositions parameters are passed to the main request as a concatenation function, ex: =RTD(“qst.rtd”,””,”nrOfPositions(” & CONCAT(B1,”|”,B2,”|”,B3,”|”,B4) & “)”), where CONCAT(B1,”|”,B2,”|”,B3,”|”,B4) would be equivalent to the string PTS|886||ALL.

Requesting the number of all positions from account 886:

=RTD("qst.rtd", "", "nrOfPositions( PTS | 886 | | ALL )")

Requesting the number of fills from account 886 and instrument ESU26:

=RTD("qst.rtd", "", "nrOfPositions( PTS | 886 | ESU26 | FILLS)")

Requesting the number of net positions from account 886:

=RTD("qst.rtd", "", "nrOfPositions( PTS | 886 | | NET )")