B bines May 17, 2010 #1 Hello , Where I can find an example in spreadsheet on Yang-Zhang volatility ? thanks !
dtrader98 May 17, 2010 #2 If you are familiar with VBA, have a look here. http://excel.itags.org/microsoft-excel/105552/ It may not be perfectly functioning, but the meat is there. In addition, you may want to pick up "volatility trading," by E. Sinclair, as it addresses a lot of your questions, and might have the estimator for excel included. There is also a matlab estimator if you look around a bit.
If you are familiar with VBA, have a look here. http://excel.itags.org/microsoft-excel/105552/ It may not be perfectly functioning, but the meat is there. In addition, you may want to pick up "volatility trading," by E. Sinclair, as it addresses a lot of your questions, and might have the estimator for excel included. There is also a matlab estimator if you look around a bit.