{"repo":"fsprojects/ExcelFinancialFunctions","free":true,"listed":false,"github":"https://github.com/fsprojects/ExcelFinancialFunctions","clone":"git clone https://github.com/fsprojects/ExcelFinancialFunctions.git","description":".NET Standard library providing the full set of financial functions from Excel.","language":"F#","stars":203,"topics":["financial-functions","fintech","dotnet-core","nuget-package","excel"],"license":null,"category":"trading","readme_excerpt":"Excel Financial Functions This is a .NET Standard library that provides the full set of financial functions from Excel. The main goal for the library is compatibility with Excel, by providing the same functions, with the same behaviour. Note though that this is not a wrapper over the Excel library; the functions have been re-implemented in managed code so that you do not need to have Excel installed to use this library. Goal: Match Excel We replicate the results Excel would produce in every situation, even in cases where we might disagree with Excel\\'s approach. Please have a look at the Compatibility page for more detail on this topic. Microsoft\\'s official documentation on Excel Functions is the best place to learn more about how the functions should work. The scope for this library is the full set of functions in the \"Financial Functions\" category. Thoroughly tested As of last count, the library is validated against 199,252 test cases. ExcelFinancialFunctions.Tests: Unit tests checking against previously-determined truth values from Excel 2010. Inputs and expected outputs are read from data files. ExcelFinancialFunctions.ConsoleTests: Test cases comparing the library results directly to running Excel code via interop. These should be run on a Windows machine with Excel 2013 (or later) installed. Difference #1: CoupDays There are two notable areas where we judged that Excel was sufficiently incorrect such that we needed to deviate from the primary goal of matching Excel pre","default_branch":null,"files":null,"tree":[],"storefront":"/r/fsprojects","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fsprojects/ExcelFinancialFunctions/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}