Exit Ask Bid Prices for an Order#
Each example is a self-contained script that can be run against the OneTick Cloud sample databases.
# onetick-py WebAPI configuration for OneTick Cloud
import os
os.environ['OTP_WEBAPI'] = '1'
os.environ['OTP_HTTP_ADDRESS'] = 'https://rest.cloud.onetick.com'
os.environ['OTP_ACCESS_TOKEN_URL'] = 'https://cloud-auth.parent.onetick.com/realms/OMD/protocol/openid-connect/token'
os.environ['OTP_CLIENT_ID'] = '__FILL_IN__'
os.environ['OTP_CLIENT_SECRET'] = '__FILL_IN__'
The exit price is the prevailing quote captured when an order leaves the book,
i.e. when it is fully executed (STATE = 'F') or canceled (STATE = 'C').
The prevailing quote is joined “as of” to each exit message; if an
order has more than one exit message, the first exit quote is taken per order ID (group_by=['ID']).
import onetick.py as otp
order = otp.DataSource(db='S_ORDERS_LSE_SAMPLE', tick_type='ORDER')
order = order.where((order['STATE'] == 'F') | (order['STATE'] == 'C'))
order = order[['ID']]
qte = otp.DataSource(db='LSE_SAMPLE', tick_type='QTE')
qte = qte[['ASK_PRICE', 'BID_PRICE']]
joined = otp.join_by_time([order, qte])
data = joined.agg({
'EXIT_ASK_PRICE': otp.agg.first('ASK_PRICE'),
'EXIT_BID_PRICE': otp.agg.first('BID_PRICE'),
}, group_by=['ID'])
result = otp.run(data,
start=otp.dt(2024, 1, 3),
end=otp.dt(2024, 1, 4),
timezone='Europe/London',
symbols='VOD')
result
Time |
ID |
EXIT_ASK_PRICE |
EXIT_BID_PRICE |
|
|---|---|---|---|---|
0 |
2024-01-04 |
233402424600089290 |
70.39 |
70.37 |
1 |
2024-01-04 |
233402424600163510 |
70.30 |
70.28 |
2 |
2024-01-04 |
233402424600242327 |
70.73 |
70.69 |
3 |
2024-01-04 |
233402424600242348 |
70.73 |
70.69 |
4 |
2024-01-04 |
233402424600242354 |
70.73 |
70.69 |
.. |
… |
… |
… |
… |
25 |
2024-01-04 |
233402424601044819 |
69.98 |
69.97 |
26 |
2024-01-04 |
233402424601076779 |
69.89 |
69.88 |
27 |
2024-01-04 |
233402424601108653 |
69.96 |
69.95 |
28 |
2024-01-04 |
233402424601108753 |
69.95 |
69.93 |
29 |
2024-01-04 |
233402424601134016 |
69.88 |
69.86 |