Developer Claims Branchless Algorithm Solves NASD 30/360 and IRR Without Conditionals
A developer and independent researcher has published an open-source Excel and VBA framework on GitHub that aims to resolve longstanding issues with the NASD 30/360 day-count standard and Internal Rate of Return calculations in financial software. The author argues that existing implementations, including Excel's built-in functions, contain date-boundary bugs that break time continuity at month-ends. The proposed solution uses branchless logic — eliminating all conditional expressions — to compute calendar intervals with claimed precision spanning hundreds of thousands of years. The work is accompanied by a peer-reviewed paper published through Lomonosov Moscow State University and a separate research record registered on CERN Zenodo. The author positions the Excel and VBA environment as a portable, hardware-agnostic pseudocode layer that engineers can translate into languages such as C, Python, or Rust.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.


Discussion (0)
Log in to join the discussion and vote.
Log in