TransWikia.com

How To Calculate Daily Volatility?

Personal Finance & Money Asked by rms on December 20, 2020

I’m working in SQL Server and I’m trying to find the daily volatility of a stock’s price. Is it simply day2price/day2price-1? Is that considered daily volatility? Or, is there something else to it? Thanks?

One Answer

You could use something like a standard deviation formula.

SQL server has STDEV.(But you should use something like Python, R, C++ or Google Sheets)

So if the average stock price is $100 with a STDEV of $10 over the last 6 months.

With 1 standard deviation, its 68% likely the price should fall between $110 and $90 tomorrow. if the empirical rule is correct.

If you want I can make a google sheet and link it as an example if you would like?

Answered by Chris Evans on December 20, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP