Volatility#

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__'

A simple realized volatility proxy for an instrument over the interval, computed as the standard deviation of trade prices divided by their average, in percent.

VOLATILITY = STDDEV(PRICE) / AVERAGE(PRICE) * 100
import onetick.py as otp

data = otp.DataSource(db='LSE_SAMPLE', tick_type='TRD')
data = data[['PRICE']]

data = data.agg({
    'STDDEV_PRICE': otp.agg.stddev('PRICE'),
    'AVERAGE_PRICE': otp.agg.average('PRICE'),
})
data['VOLATILITY'] = data['STDDEV_PRICE'] / data['AVERAGE_PRICE'] * 100

result = otp.run(data,
                 start=otp.dt(2024, 1, 3, 8, 0),
                 end=otp.dt(2024, 1, 3, 16, 30),
                 timezone='Europe/London',
                 symbols='VOD')
result
Time STDDEV_PRICE AVERAGE_PRICE VOLATILITY
0 2024-01-03 16:30:00 4.799551 69.832494 6.872949