Fabian Moa
  • Home
  • Resources
    • CFA
    • FRM Part I
    • FRM Part II
  • Blog
    • Blog – Financial Modelling
  • About
  • Contact
Select Page
Optimization of VaR and Trading Liquidity Risk in Excel: Unwinding a Position Optimally

Optimization of VaR and Trading Liquidity Risk in Excel: Unwinding a Position Optimally

Financial Modeling

If a trader needs to unwind a large position, he or she is exposed to: the potential loss from price movements, and trading liquidity risk The trader may wish to minimize the Value-at-Risk (VaR) after considering the trading costs (or cost of liquidation). What is the...
Modeling Value-at-Risk (VaR) and Conditional Value-at-Risk (CVaR) in Excel (Historical, Gaussian, and Cornish-Fisher)

Modeling Value-at-Risk (VaR) and Conditional Value-at-Risk (CVaR) in Excel (Historical, Gaussian, and Cornish-Fisher)

Financial Modeling

Value-at-risk (VaR) is a popular risk measure used in financial institutions to measure the risk in their portfolios. It measures the minimum loss within an interval period at a given probability (e.g. 1% or 5% being the commonly used figure). For example, if a...
Binomial Option Pricing Model with Excel VBA (for European Options)

Binomial Option Pricing Model with Excel VBA (for European Options)

Financial Modeling

The tree-based method is an easy-to-implement model for option pricing, and it can be used to value about any type of options (American options, barrier options, digital options, Asian options, etc). In this tutorial video, I will implement the popular Cox, Ross, and...
Modeling Interest Rate Immunization: Managing the Interest Rate Risk of a Single Liability

Modeling Interest Rate Immunization: Managing the Interest Rate Risk of a Single Liability

Financial Modeling

How do bond managers target their bond portfolios to meet a liability payment sometime in the future? Given that bond value fluctuates due to changes in interest rates and spreads, how do we maximize the chances that the bond portfolio will be sufficient to cover for...
Finding Option Implied Volatility using Goal Seek in Excel

Finding Option Implied Volatility using Goal Seek in Excel

Financial Modeling

When we model a problem, we will usually have a set of inputs, feed it into the model and we get the output. There are also times, when we have a target output and we want to know what the input value (out of all the other inputs) would be in order to achieve that...
« Older Entries

Recent Posts

  • Optimization of VaR and Trading Liquidity Risk in Excel: Unwinding a Position Optimally
  • Modeling Value-at-Risk (VaR) and Conditional Value-at-Risk (CVaR) in Excel (Historical, Gaussian, and Cornish-Fisher)
  • Binomial Option Pricing Model with Excel VBA (for European Options)
  • Modeling Interest Rate Immunization: Managing the Interest Rate Risk of a Single Liability
  • Finding Option Implied Volatility using Goal Seek in Excel

Recent Comments

    Archives

    • July 2020
    • April 2020

    Categories

    • Financial Modeling

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Fabian Moa

    • Facebook
    • X
    • Instagram
    • RSS

    Designed by Elegant Themes | Powered by WordPress