Grafana for finance - compute XIRR?

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    Grafana for docker. Grafana v11.6.0 (d2fdff9ee4)

  • What are you trying to achieve?
    I have cashflow information in a mysql database (dates and cash-flows). I would like to have Grafana calculate the IRR (Internal Rate of Return) for these cash-flows.

  • How are you trying to achieve it?
    Computing these in mysql is very complicated (I have given up). If I could use Grafana to aggregate these columns and output IRR, it would be great.

  • What happened?
    n.a.

  • What did you expect to happen?
    n.a.

  • Can you copy/paste the configuration(s) that you are having problems with?
    n.a.

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    n.a.

  • Did you follow any online instructions? If so, what is the URL?
    Tried to look for IRR / XIRR and Grafana but no dice.

2

please share DDL and DML and sample data and the result you want from the sample data

3

Here follows a sample excel file with some data and the calculations I am doing. This data is exported from a mysql

This is an export from the following table:

CREATE TABLE `transactions_with_simulations` (
  `Carteira` varchar(255) DEFAULT NULL,
  `Legal Entity` varchar(255) DEFAULT NULL,
  `Intermediary Name` varchar(255) DEFAULT NULL,
  `Google Ticker` varchar(255) DEFAULT NULL,
  `Yahoo Ticker` varchar(255) DEFAULT NULL,
  `Unit Flow` double DEFAULT NULL,
  `Trx Date` varchar(255) DEFAULT NULL,
  `Unit Value` double DEFAULT NULL,
  `Unit Commissions` double DEFAULT NULL,
  `Unit Stamp Duty` double DEFAULT NULL,
  `Cash-flow` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
1 Like