Calculating quarterly investment returns---XIRR or anotherfunction??
Errata*2....
On Jan 7, 8:54*am, I wrote:
On Jan 7, 3:56*am, "Carl LaFong" wrote:
=((1+XIRR(B7:B14,A7:A14,0))^((A14-A7)/365)-1)*100
[....]
I would use "^(365/4)" instead in order to normalize quarters.
Brain fart! Of course that should be simply "^(1/4)".
sub meaCulpa()
for i = 1 to 10000
debug.print "I will not post when I am late for an appointment."
next
end sub
|