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
Open House
Scaling ClickHouse to petabytes of logs at OpenAI
Open House
How ClickHouse helps Anthropic scale observability
Open House, User stories
How Capital One Slingshot cut infrastructure costs by 50%
Engineering leaders at Capital One Slingshot share how they cut infrastructure costs by 50% and reduced average dashboard load time from 5+ to under 500ms with ClickHouse Cloud.
Follow us
