Financial functions in ClickHouse

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