Anthony's VBA Forum

[NB]

Do you know how to make the Yield Curve using Qubic Spline Method in VBA?

Now, I'm trying to draw the Qubic Spline Yield Curve from the Major Market Data(ex. LIBOR & Swap Rate).
If using the pre-installed Excel-Solver-Addon, I can do it.
But, that way make the calculation speed terrible slowly.

So, I'd like to calculate all procedures in VBA.

Anyone have, or know the Solver/Optimize Module like Excel Solver in VBA?

*VBA Code:[SolverOK ...], is not difference to using solver on spreadsheet.
*Solver DLL(Solver.com) is expensive for me

[Data]

Don't know about that yield curve, but if you can explain what you need to get from solver may be we can help. There might be some numerical methods out there that can do it.
_________________
Data
Knowledge is Power