I need a XIRR function that would only compute the XIRR for specific ISINs.
This is a picture of a sample file with unnecessary info deleted:
<tbody>
</tbody>
For example a single line function:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">=XIRR(I33:J33;D31:E31)
</code>What I want would be the same function that can do it for non-contiguous ranges based on the ISIN condition. I.e. do XIRR which takes into account all dates in columns D:E and cash flows in columns I:J that are for the same ISIN.
This is a picture of a sample file with unnecessary info deleted:
ISIN | DATE OF INVESTMENT | DATE OF SALE | BUY VOLUME | SELL VOLUME | |||||
US7475251036 | 18.11. 2015 | 2421 | -385,86 | ||||||
US3546131018 | 3.12. 2015 | 4.11. 2019 | 1470,92 | -1021,68 | |||||
US6826801036 | 7.12. 2015 | 4.5. 2016 | 1514,9 | -2736,58 | |||||
US3546131018 | 11.12. 2015 | 4.11. 2019 | 1487,97 | -1582,69 | |||||
US0378331005 | 7.1. 2016 | 31.7. 2019 | 1475,3 | -3370,39 |
<tbody>
</tbody>
For example a single line function:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">=XIRR(I33:J33;D31:E31)
</code>What I want would be the same function that can do it for non-contiguous ranges based on the ISIN condition. I.e. do XIRR which takes into account all dates in columns D:E and cash flows in columns I:J that are for the same ISIN.