Advanced_modelling_in_finance_using_Excel_and_VBA（pdf） The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex what if scenarios.
Simple VaR Calculator provides:
- Evaluation of return distribution of single asset or portfolio of assets
- Volatility forecasts using moving average and exponential algorithm
- Value at Risk of single asset or portfolio measurement using parametric and historical simulation.
- Historical data can be obtained from simple text file or MS Excel using Matlab Excel Links.
