O'Reilly logo

Quantitative Finance by Matt Davison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix 3: Naming Variables in Excel

It is easy to understand the formula

PV=Y(1+rn)nT

This means that we are using compound interest rate for bond pricing.

However, it might not be nearly as easy to figure out what this formula means:

D5=A2(1+B2C2)C2D2

This is despite the fact that the two formulas code the exact same idea! So, can we transfer the second kind of formula into the first kind using Excel? The answer is yes! First, we have to set up Excel. This functionality exists for Excel 2007 and after. Open Excel, and click on the “File.”

Then choose “Option,”

Then we click on “Quick Access Toolbar,” go with “Formula Tab,” ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required