Because next time the equation was impossible, he wouldn't be searching his downloads. He'd be ready.
The magic happened in the loop:
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 . How To Code the Newton Raphson Method in Excel VBA.pdf
“The derivative is the problem,” Arjun whispered. He didn’t have a symbolic derivative. He had a messy Monte Carlo simulation in column G.
“You can’t solve for ‘x’ if it’s on both sides of the equation,” he muttered, sipping cold coffee. Because next time the equation was impossible, he
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ₙ) .
At 7:55 AM, he emailed Helena the results. He attached a clean sheet with one button: “Calculate Vol.” He didn’t tell her about the PDF. He didn’t mention the cold coffee or the 11:47 PM panic. Scrolling past a dozen forgotten files, he found
He saved his VBA module as "Module_Newton.bas" and placed the PDF in a new folder called “Weapons.”
He ran it.
He had spent two hours trying to use Excel’s Goal Seek. It was slow, clunky, and kept crashing when the volatility spiked above 200%. He needed speed. He needed precision. He needed the Newton Raphson method.