Quantitative finance collector
Apr 29

Finite Difference Method for EXCEL

Posted by abiao at 14:04 | Code » VBA/Excel | Comments(0) | Reads(7117)

Print
Finite difference method has been repeatedly introduced to solve partial differential equation (PDE), for example, in past entries Crank-Nicholson finite difference solution of American option, Crank-Nicolson for a European put, PSOR for American option, etc.

here is a Finite Difference Method for EXCEL addin which contains macro to solve numerically partial differential equations (PDE) and ordinary differential equations (ODE) with the Finite Differences Method (FD). Seems it can only be applied for two dimensional problem, but should be enough for normal cases me meet.

Document and macro are at: http://digilander.libero.it/foxes/diffequ/fdsolver_review.htm

Unclear about this post? Asking questions and receiving answers.
Add a comment
Emots
Enable HTML
Enable UBB
Enable Emots
Hidden
Remember
Nickname   Password   Optional
Site URI   Email   [Register]