2
$\begingroup$

I have a very detailed dataset - for each minute I can see 3 best bid and ask prices with associated quantities. Which measure of volatility would you use in such dataset? Some volatility measures use only the close price; Garman-Klass uses Open, low, high and close; but here it is much more detailed.

Here I would like a number which tells me how volatile day it was. I am thinking about simple standard deviation of the mid-price for each day. Are there some better estimates? Sorry if the question is obvious - I am not an expert in finance. Thanks!

$\endgroup$
4
  • $\begingroup$ You should try several methods and see what works best for your purpose. $\endgroup$
    – amdopt
    Commented May 11, 2023 at 10:45
  • $\begingroup$ Thanks! Could you give a few suggestions what it could be? $\endgroup$
    – Avocado
    Commented May 11, 2023 at 10:58
  • 3
    $\begingroup$ You should try and look into different realized measures, if the goal is a daily volatility estimate recovered via intraday samples. See eg. this paper for an overview of different realized measures (they also provide a data-cleaning section in the appendix that might be of help). $\endgroup$
    – Pleb
    Commented May 11, 2023 at 12:19
  • 3
    $\begingroup$ Downloadable version of above paper papers.ssrn.com/sol3/papers.cfm?abstract_id=2214997 $\endgroup$
    – nbbo2
    Commented May 11, 2023 at 14:10

1 Answer 1

1
$\begingroup$

Standard deviation is typically computed on the return distribution, not the price itself. You should maybe :

  • (1) backtest your strategy with a given initial equity
  • (2) each time you place a market order, you cross the order book with the 3 prices and sizes you talked about. You can then compute the price all inclusive (i.e., including bid ask spread, order book layers, and potentially broker fees). This will be more precise than the mid price
  • (3) compute the return of each minute
  • (4) compute the standard deviation of the return distribution, and maybe annualize it by multiplying by $\sqrt{365}$

Ps: if you really want to compute the standard deviation on the price itself and make any prediction out of it, you need to make sure your prices are stationary, otherwise moments (i.e., mean, standard dev etc) do no hold in time and your estimate may be useless.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.