SAS XIRR计算收益率 重谢!!

jingju11 发表于 2015-1-19 11:39
you had a typo above. it should be ...+pmt * (1+rate*type)*(((1+rate)**nper-1)/rate)+fv;

beca ...

您好，计算xirr对我来说非常关键，下面的工作都需要先计算这一步，所以真的很希望您能帮助我，非常抱歉打扰您，谢谢您！！

yingxin0824 发表于 2015-1-20 18:49
您好，计算xirr对我来说非常关键，下面的工作都需要先计算这一步，所以真的很希望您能帮助我，非常抱歉打 ...

Hi,
For id=1, there are two numbers of 1001 and 1002. I don't know how to combine these two numbers into one XIRR computation.

JingJu

jingju11 发表于 2015-1-21 03:06
Hi,
For id=1, there are two numbers of 1001 and 1002. I don't know how to combine these two numbe ...

想请问您一下，那个xirr计算公式中的d1:第0个支付日期指的是哪一天啊？谢谢您！

hehe. You should know how to compute xirr. we can only help you when you are not familiar with SAS. Sorry about that.
JingJu