“If you cannot calculate the analytic derivative, use the Secant approximation: f’(x) ≈ (f(x + δ) − f(x)) / δ.”

He’d downloaded it six months ago and never read it. “Classic,” he sighed.

He saved his VBA module as "Module_Newton.bas" and placed the PDF in a new folder called “Weapons.”

In four iterations, the Newton Raphson method had done what Goal Seek couldn’t do in forty. It converged like a hawk diving on a mouse. The portfolio’s implied volatility: .

He double-clicked. The PDF was short—only seven pages—but it was beautiful. Page one had a diagram: a curved function, a tangent line kissing the x-axis, and an arrow labeled xₙ₊₁ = xₙ − f(xₙ)/f’(xₙ) .

He minimized Excel and opened his downloads folder. Scrolling past a dozen forgotten files, he found it: How To Code the Newton Raphson Method in Excel VBA.pdf .

Arjun leaned back. The PDF lay open on his second monitor. He realized the file wasn't just a tutorial. It was a key. For years, he had treated Excel like a glorified calculator. Now, he saw it as a numerical engine. The Newton Raphson method wasn't about roots—it was about control. It was about telling the computer, “Here is the rule. Now find the truth.”