如何实现MS Excel的价格和收益函数到VB.Net？ [英] How can I implement the Price and Yield Function of MS Excel to VB.Net?

问题描述

大家好，自去年12月以来，我们遇到了这个问题。方案是我们想要在我们的VB.Net项目中实现MS Excel的价格和收益函数，而不使用任何MS Excel库文件。我们的主管希望我们从头开始，尽管MS Excel为我们提供了精确公式，但我们无法从互联网上找到任何关于如何在不使用MS Excel的库文件的情况下实现这些功能的来源。谁知道如何实现这些功能，请帮忙。谢谢你和新年快乐

解决方案

这看起来像一个非常简单的功能，你看看帮助文档并查看他们使用的公式吗？



您是否尝试过实现该功能？



Excel价格函数 [ ^ ]和 Excel收益函数 [ ^ ]



收益率1更简单，没有累积，甚至可以给出变量名称......

Hi Guys, we are having this problem since December last year. The scenario is we want to implement the Price and Yield Functions of MS Excel in our VB.Net project without using any MS Excel library files. Our supervisor wants us to do it from scratch, though MS Excel gives us the Exact Formula, we cannot find any source from the Internet on how to implement these functions without using MS Excels' library files. Who among you know how to implement these functions, please help. Thank you and Happy New Year

解决方案

It seems like a pretty simple function, did you look at the help documentation and see the formula that they use?

Have you tried implementing the function at all?

Excel Price Function[^] and Excel Yield Function[^]

The yield one is even simpler, no accumulations, and they even give variable names...

这篇关于如何实现MS Excel的价格和收益函数到VB.Net？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！