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?
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
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP