I am trying to take returns for each quarter of a year and calculate the
compounded return for the year. I tried using the XIRR function, but that
isn't returning me a correct value. I think it wants to use the actual value
in the equation, not the returns for each of those periods. Can anyone help?