I need a spreadsheet for stock portfolio that calculates a running rate of internal return or loss involving deposits or withdrawals of unpredictable and uneven amounts on any given day from any number of different sources at any time .
for example I want to be able to add a deposits received at different times in varying amounts or withdrawals that are varying amounts at various times. I then want to observe the current portfolio value and current date and have the spreadsheet calculate the internal rate of return taking into account uneven deposits / withdrawals on random dates over time always involving uneven amounts of money for each deposit // or withdrawal.
This will take into account the various time values of each deposit/withdrawal regardless of how much money is involved with regard to each deposit/withdrawal.
I had a spread sheet that did this that I designed years ago that was permanantly lost to me when my Office was ransacked by thieves a few years back and I forgot how I did it .