xirr | XIRR implementation in Java | Android library

How is the Basic wrapper call formed to run a LibreOffice Calc Python User Defined Function using non-integer spreadsheet ranges?

I'm not clear on how to declare the function properly for the values and excel_date arrays which are both arrays of real numbers, type Variant in Basic terminology I understand.

I've followed Calling a python function from within LibreCalc and ranges can be passed as integer arguments without defining them but these are real values. Both arrays are single-dimension so the multi-dimensional array issues do not apply as discussed in How can I call a Python macro in a cell formula in OpenOffice.Org Calc?

Basic code is:

I am trying to apply an XIRR Formula so that the percentage of each investment is calculated separately.

I Have data in excel file like:

https://i.stack.imgur.com/yqMiV.png

headers: Script,date,Values

result : Scrip and XIRR

Used Python library:

#pip install pyxirr

from pyxirr import xirr

I am Calculating for single script code like the below and appending it to a dataframe:

I am running into a roadblock and would appreciate some help on this.

Problem Statement:

I am trying to calculate XIRR for a cash flow over 30 years in Python.

What have I tried so far:

However, none of the established libraries(like numpy and pandas) seem to have support for this. After doing some research, I learned through this source (https://vindeep.com/Corporate/XIRRCalculation.aspx) that with some simple manipulation, XIRR can be calculated from IRR.

So, all I need is an IRR function that is implemented well. The functionality used to exist in numpy but has moved to this other package (https://github.com/numpy/numpy-financial). While, this package works, it is very very slow. Here is a small test:

I have been struggling with a macro for over a month now. The goal is to break up data by security identifier (in column C) by inserting a row every time the value in the column changes. Afterwards, I want to insert an XIRR formula in the blank row that was inserted. The issue is that every security has a different amount of rows, and I cannot get the row count to become dynamic in the XIRR formula. Here is the code I have been able to put together:

Having trouble implementing a rate of return calculation to compare to Excel's XIRR calc which is essentially an solver algorithm to find the discount rate at which the NPV of an investment is zero using provided cash flow and dates in a table.

Per MSFT documentation, the function loops through 100 times (not limited to this..I'm using 10,000 in my code below to test a wide range of rates)

https://support.microsoft.com/en-ie/office/xirr-function-de1242ec-6477-445b-b11b-a303ad9adc9d?ui=en-us&rs=en-ie&ad=ie

Here is the example with my dummy data to match the above in a single table

I'm trying to call the XIRR function using a filtered array of data, but I need to append one additional value to each array

The baseline idea is the following formula that gathers the cashflow/date arrays from the K/A columns using the FILTER function:

My report needs to display IRR from inception until the year and quarter selected in the slicer, while the same report has other metrics that display only for the year and quarter selected. I'm using XIRR formula.

The report has a slicer for Year, and another for Quarter.

If I make a selection in the slicer for year = 2020, and quarter = Q3, the other metrics display the correct values for Q3 of 2020 (since the data in the respective tables have columns for Year and Quarter), but the IRR metric will incorrectly show me the value for Q3 of 2020. I need that card to show me the IRR up to Q3 of 2020.

(For context, an IRR table usually consists of date, and the cash flow. When the asset is purchased, that date is the inception date and it has a negative cash flow associated with that date. During the life of the investment, there are cash distributions i.e. positive cash flow, and the last date consists the selling price of that asset. Hence showing the IRR for Q3 of 2020 only will result in an error, because the XIRR formula needs to see both positive and negative cash flows)

I'm using the same calendar lookup table for IRR and the other metrics in my data model.

I am using the following functions to perform IRR-Calculations with Python: