In a previous post, we presented a method for calculating a stock beta and implemented it in Python. In this follow-up post, we are going to implement the calculation in Excel. We continue to use Facebook as an example. Recall that, In finance, the beta (market beta or beta coefficient) is a measure of how…
Read More How to Calculate Stock Beta in Excel-Replicating Yahoo Stock BetaIn the previous post, we introduced the Garman-Klass volatility estimator that takes into account the high, low, open, and closing prices of a stock. In this installment, we present an extension of the Garman-Klass volatility estimator that also takes into consideration overnight jumps. Garman-Klass-Yang-Zhang (GKYZ) volatility estimator consists of using the returns of open, high,…
Read More Garman-Klass-Yang-Zhang Historical Volatility Calculation – Volatility Analysis in PythonIn the previous post, we introduced the Parkinson volatility estimator that takes into account the high and low prices of a stock. In this follow-up post, we present the Garman-Klass volatility estimator that uses not only the high and low but also the opening and closing prices. Garman-Klass (GK) volatility estimator consists of using the…
Read More Garman-Klass Volatility Calculation – Volatility Analysis in PythonIn the previous post, we discussed the close-to-close historical volatility. Recall that the close-to-close historical volatility (CCHV) is calculated as follows, where xi are the logarithmic returns calculated based on closing prices, and N is the sample size. A disadvantage of using the CCHV is that it does not take into account the information about…
Read More Parkinson Historical Volatility Calculation – Volatility Analysis in PythonIn a previous post, we touched upon a stock’s volatility through its beta. In this post, we are going to discuss historical volatilities of a stock in more details. Also referred to as statistical volatility, historical volatility gauges the fluctuations of underlying securities by measuring price changes over predetermined periods of time. It is the…
Read More Close-to-Close Historical Volatility Calculation – Volatility Analysis in PythonIn finance, beta measures a stock’s volatility with respect to the overall market. It is used in many areas of financial analysis and investment, for example in the calculation of the Weighted Average Cost of Capital, in the Capital Asset Pricing Model and market-neutral trading. In this post, we present a concrete example of calculating…
Read More What is Stock Beta and How to Calculate Stock Beta in PythonIn the previous post, we presented a system for trading VXX, a volatility Exchange Traded Note. The trading system was built based on simple moving averages. In this post, we are going to examine the time series properties of VXX in more details. The figure below shows the VXX and its 200-day moving average for…
Read More Stationarity and Autocorrelation Functions of VXX-Time Series Analysis in PythonTime series analysis is an important subject in finance. In this post, we are going to apply a time series technique to a financial time series and develop an investment strategy. Specifically, we are going to use moving averages to trade volatility Exchange Traded Notes (ETN). Moving averages are used on financial time series data…
Read More A Volatility Trading System-Time Series Analysis in PythonWe have written many blog posts about the increase in volatility of volatility. See, for example Is Volatility of Volatility Increasing? What Caused the Increase in Volatility of Volatility? Similarly, last week Bloomberg reported, The sudden rise in volatility in February and March showed that even with strong growth fundamentals, financial markets remain vulnerable. Since…
Read More Black Swan and Volatility of VolatilityThe US equity market just reached new highs, and it broke many records. For example, Bloomberg reported that the US market had not been overbought like this in 21 years. The S&P 500 Index’s superlative start to 2018 is making a contrarian technical indicator look silly. The benchmark gauge is poised to end trading Thursday…
Read More Correlation Breakdown