Search code examples
excelpowerquery

Yield to maturity / IRR in Power Query M

Do you have any ideas about how to calculate YTM / IRR in Microsoft Power Query? For instance, I have a variable called Table and it contains data 

    Date        Payment
    2020-01-01  -1000
    2020-02-01  300
    2020-03-01  800

and I would like to call some scalar function, which calculates YTM.

Solution

  • Seems like now the only way is to solve this equation yourself. I've found code in this blog post. I have a laptop with Win 10, Excel 2016, i3-6100 2.3GHz, 4 ram. It takes 0.10 sec to calculate for deal with 10 payments.