Financial functions in ClickHouse
Mark Needham
In this video, we dive into the new financial functions introduced in ClickHouse 25.7. These additions bring powerful tools for financial analysis right into your database queries.
We'll explore two key functions: internal rate of return (IRR) and net present value (NPV), demonstrating their practical applications with real-world examples.
- Learn how to calculate the internal rate of return on investments using Apple stock as an example
- Discover the extended IRR function that allows for specific date inputs
- Understand net present value calculations and their importance in financial decision-making
- See how to use the extended NPV function with precise date ranges
Recent videos
View all Videos
Open House
Open House 2026: Day 1 Keynote
The latest ClickHouse announcements, featuring real-world use cases from Shopify, Zoox, Visa, and Cisco.
Open House
Fireside Chat: The state of data and AI with Bret Taylor (Sierra) and Aaron Katz (ClickHouse)
Aaron Katz (CEO, ClickHouse) and Bret Taylor (Co-Founder Sierra, Chairman of the Board, OpenAI) have an open conversation on the state of AI.
Open House, ClickHouse
How to build a great database (Alexey Milovidov)
The principles behind building a great database, and the new frontiers shaping the field.
Open House
Fireside Chat: Ecosystem and technology trends (Vercel, dbt Labs, CoreWeave)
Aaron Katz (CEO, ClickHouse), Guillermo Rauch (CEO, Vercel), Tristan Handy (CEO, dbt Labs), and Lukas Biewald (SVP of AI, CoreWeave) discuss how AI is changing the data landscape.
Follow us
