在C#中查找财务汇率 [英] to find Financial Rate in c#

问题描述

我使用Microsoft.VisualBasic.Financial类来查找Rate

这是我使用过的以下代码，

i''ve used Microsoft.VisualBasic.Financial class to find Rate

here is the below code i''ve used,

lblEffcost.Text = (((Financial.Rate(_RATE_Param1, _RATE_Param2, _RATE_Param3, _RATE_Param4, 0, 0)) * 12) * 100).ToString();

在上面的某些参数中，Rate方法运行良好，对于其他一些参数，其显示异常错误为

here in above for some parameter the Rate method is working fine, for some other parameters its showing an exception error as

"Cannot calculate rate using the arguments provided"

但是对于这些参数，它们在Excel工作表中有效
----
我需要如何找到像Excel一样的Rate ....
有人可以给出想法或任何其他免费的dll或api或apk来获取Rate

but for those parameters are working in Excel sheet
----
Some how i need to find Rate as like excel....
can some one give idea or any other free dll or api or apk to get Rate

推荐答案

在这里，您可以使用一种可行的解决方案-

Here you a working solution - Financial Calculations in C#

通常来说，由于这些函数使用迭代方法，因此它们可能会产生不同的结果(取决于实现)行为.但是，它们看起来"非常相似，您确定要使用完全相同的参数同时馈送Excel函数和VB.NET吗?

Generally speaking, since those functions use iterative methods they may produce different (implementation dependent) behaviours. However, they ''looks'' pretty the same, are you really sure that you feed both Excel function and VB.NET with exactly identical parameters?

这篇关于在C#中查找财务汇率的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！