I have the monthly closing prices and dividends of a stock in 2 separate
column. I want to calculate the IRR for a seven year period, i.e the investor
bought the stock and held it for 7 years and received the dividends. I am
able to calculate it , but the thing is that I have to do it 156 times. Is
there a quick way to replicate it easily using a formula or something else?

Thank you very much!

Maxime Isabel