I've been struggling with trying to figure out IRR for a while. I'm glad I found this page because it was something of a breakthrough. The question is how to convert rates between continual, yearly, and daily compounding (as well as any other arbitrary period). What is confusing is that I've been using an excel irr plugin that I believe is actually calculating things wrong. It says it is compounding daily, when I think it is actually compounding yearly.