Kopernikus
New Member
- Joined
- Apr 28, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello
I´s my first post here.
Well, my challange is similar to following, but I didn´t get them. (Maybe it´s a little bit different, mybe I don´t understand this ☹ )
In my case I have also spreadsheet about stock holdings.
I have also a table with different columns: date, Amount and name.
Normaly the table is sorted by date, bus in such cases formula XIRR doesn´t work, because I can´t link it so a specific contract name.
So I have so sort the table by column name and to add manualy formula XIRR.
Therefore I´ve created a pit table (column G-H) .
Here it is easyly possible, to group date and values by contract name.
Unfortunately I´m not able, to add formula XIRR in pivot table.
Has someone any idea?
I´m sorry for my worse english, I´m not the best one, and my language correction does the rest.. ?
I´s my first post here.
Well, my challange is similar to following, but I didn´t get them. (Maybe it´s a little bit different, mybe I don´t understand this ☹ )
using xirr on dynamic pivot table
Hello - is anyone able to help with the below without the need for having to create a macro. I have a pivot table with 2 Report filters and 2 columns (Date in column A and cashflow in column B). The 'Row Labels' heading of the pivot is in cell A4 and the date start from cell A5 downwards, with...
www.mrexcel.com
In my case I have also spreadsheet about stock holdings.
I have also a table with different columns: date, Amount and name.
Normaly the table is sorted by date, bus in such cases formula XIRR doesn´t work, because I can´t link it so a specific contract name.
So I have so sort the table by column name and to add manualy formula XIRR.
Therefore I´ve created a pit table (column G-H) .
Here it is easyly possible, to group date and values by contract name.
Unfortunately I´m not able, to add formula XIRR in pivot table.
Has someone any idea?
I´m sorry for my worse english, I´m not the best one, and my language correction does the rest.. ?