![How to remove bullets/numberings in Excel](https://dollarexcel.com/wp-content/uploads/How-to-copy-data-from-multiple-sheets-at-once-的複本-10-300x169.png)
![Value-at-Risk (VaR)| Risk Management in Excel](https://dollarexcel.com/wp-content/uploads/Value-at-Risk-VaR_-Risk-Management-in-Excel-300x169.png)
Value-at-Risk (VaR)| Risk Management in Excel
February 17, 2021
Value-at-Risk (VaR) is an important heavy-tail metric for financial portfolio. Let’s learn about historical/parametric approach of VaR calculations, and 4 different ways to present VaR.
![Binomial Option Pricing (Excel formula)](https://dollarexcel.com/wp-content/uploads/Binomial-Option-Pricing-Excel-formula-300x169.png)
Binomial Option Pricing (Excel formula)
January 6, 2021
Option pricing is a heated topic in quantitative finance, and let’s explore how we can use the binomial option pricing model in Excel to compute option price!
![How to Compute IRR in Excel (Basic to Advanced)](https://dollarexcel.com/wp-content/uploads/How-to-Compute-IRR-in-Excel-Basic-to-Advanced-300x169.png)
How to Compute IRR in Excel (Basic to Advanced)
December 22, 2020
Excel comes with great tools to compute the IRR on an investment. We are going to show you 3 methods in computing IRR and their limitations.
![Black-Scholes Option Pricing (Excel formula)](https://dollarexcel.com/wp-content/uploads/Black-Scholes-Option-Pricing-Excel-formula-300x169.png)
Black-Scholes Option Pricing (Excel formula)
December 22, 2020
Black-Scholes option pricing is one of the landmarks for quantitative finance. Let’s learn about the intuition and apply it to price options in Excel!
![Binomial Option Pricing (Excel VBA)](https://dollarexcel.com/wp-content/uploads/Binomial-Option-Pricing-Excel-VBA-300x169.png)
Binomial Option Pricing (Excel VBA)
December 17, 2020
Using the Excel VBA code presented, we can easily create a multi-period binomial tree to price European options with great flexibility and tweaking parameters.
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)