The Modeller's Miscellany - #47

Hagglebot Olympics // Is LAMBDA the ultimate Excel function?

· Modellers Miscellany

The Modeller's Miscellany is a weekly bulletin of useful stuff for financial modellers.

Sign up below to receive it in your inbox every Sunday.

Article // Is Lambda the ultimate Excel worksheet function?

Microsoft certainly thinks so. This article by Andy Gordon and Simon Payton Jones, both researchers at Microsoft, explains how LAMBDA is the result of an ongoing research project to transform Excel formulas into a fully-fledged programming language. The key benefit we see straight away is the ability to create functions more transparently, and eliminate the need to rewrite formulas that are used multiple times. It looks set to be a game-changer for modellers.

Book // Writing with clarity and impact

Jon Moon will be talking to the Full Stack Modeller community as a guest speaker in early April. His "Words in tables" concept is simple but hugely effective, and his book "Clarity and Impact" is a classic. We have 3 free copies to give away in return for sharing useful modelling related stories to the Miscellany. Email your submission to

Meetup // Women in Financial Modelling

Danielle Stein Fairhurst's excellent online meetup series continues on Monday with the next Women in Financial Modelling meeting. This week the topic is "How to get a financial modelling qualification". Register here

Article // Automate negotiations with Hagglebots

The 11th annual Hagglebot Olympics, a competition for AI negotiation bots, took place earlier this month. One of the founders of the game, Tim Baarslag, reports that "AI is getting close to matching human negotiators in some situations." These bots are starting to see real-life application in corporates such as BP who use AI tools to speed up contract negotiations with suppliers. Read more 

And finally // Dashboard humour

It's funny because it's true...

Get the Miscellany delivered to your inbox every Sunday.

No spam. No silliness. Just modelling goodness.

All Posts

Almost done…

We just sent you an email. Please click the link in the email to confirm your subscription!