financial

pig build pkg pg_financial;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_financial;		# install via package name, for the active PG version
pig install financial;		# install by extension name, for the current active PG version

pig install financial -v 18;   # install for PG 18
pig install financial -v 17;   # install for PG 17
pig install financial -v 16;   # install for PG 16
pig install financial -v 15;   # install for PG 15
pig install financial -v 14;   # install for PG 14

CREATE EXTENSION financial;

CREATE EXTENSION financial;

-- Basic XIRR calculation
SELECT xirr(amount, time ORDER BY time) FROM transaction;
-- 0.0176201237088334

-- With explicit initial guess (Excel-compatible default is 0.1)
SELECT xirr(amount, time, 0.1 ORDER BY time) FROM transaction;

-- Per-portfolio XIRR
SELECT portfolio, xirr(amount, time ORDER BY time)
FROM transaction
GROUP BY portfolio;

-- As a window function
SELECT xirr(amount, time) OVER (ORDER BY time)
FROM transaction;