ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   volatility calculation (https://www.excelbanter.com/excel-worksheet-functions/27458-volatility-calculation.html)

volatility calculation

volatility calculation
 
how I can calculate volatility in excel?

Mangesh

volatility of ...?
if you are talking about derivatives, then you can try the goal seek method.
i have a UDF for black-scholes if you are interested.

Mangesh


"volatility calculation" <volatility
wrote in message ...
how I can calculate volatility in excel?




Bob Phillips

How would you do it on paper? Then just create functions to do that.

--
HTH

Bob Phillips

"volatility calculation" <volatility
wrote in message ...
how I can calculate volatility in excel?





All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com