frends-community - Frends.Community.ExcelFinancialFunctions 0.1.7

Package Description

PM> Install-Package Frends.Community.ExcelFinancialFunctions -Version 0.1.7 -Source https://www.myget.org/F/frends-community/api/v3/index.json

Copy to clipboard

> nuget.exe install Frends.Community.ExcelFinancialFunctions -Version 0.1.7 -Source https://www.myget.org/F/frends-community/api/v3/index.json

Copy to clipboard

> dotnet add package Frends.Community.ExcelFinancialFunctions --version 0.1.7 --source https://www.myget.org/F/frends-community/api/v3/index.json

Copy to clipboard 
<PackageReference Include="Frends.Community.ExcelFinancialFunctions" Version="0.1.7" />
Copy to clipboard 
source https://www.myget.org/F/frends-community/api/v3/index.json

nuget Frends.Community.ExcelFinancialFunctions  ~> 0.1.7
Copy to clipboard

> choco install Frends.Community.ExcelFinancialFunctions --version 0.1.7 --source https://www.myget.org/F/frends-community/api/v2

Copy to clipboard 
Import-Module PowerShellGet
Register-PSRepository -Name "frends-community" -SourceLocation "https://www.myget.org/F/frends-community/api/v2"
Install-Module -Name "Frends.Community.ExcelFinancialFunctions" -RequiredVersion "0.1.7" -Repository "frends-community"
Copy to clipboard

Browse the sources in this package using Visual Studio or WinDbg by configuring the following legacy symbol server URL: https://www.myget.org/F/frends-community/symbols/

Frends.Community.ExcelFinancialFunctions

Frends tasks for financial calculations using Excel Financial Functions

Actions Status MyGet License: MIT

Installing

You can install the Task via frends UI Task View or you can find the NuGet package from the following NuGet feed https://www.myget.org/F/frends-community/api/v3/index.json and in Gallery view in MyGet https://www.myget.org/feed/frends-community/package/nuget/Frends.Community.ExcelFinancialFunctions

Tasks

XIrrTools

Task calculates XIrr value using Newtons method

Properties

Property Type Description Example
Input string JArray string with values and dates. [{value: 1.234, date: "2021-05-25"}, {value: 2.345, date: "2022-05-25"}]

Options

Property Type Description Example
Tolerance double Tolerance used in calculations. 0.00000001
MaxIterations int Max. number of iterations while calculating Xirr value. 100

Returns

A result object with parameters.

Property Type Description Example
Value string Calculated XIrr value. 77.4425237947709

Usage: To fetch result use syntax:

#result.Value

Building

Clone a copy of the repository

git clone https://github.com/CommunityHiQ/Frends.Community.ExcelFinancialFunctions.git

Rebuild the project

dotnet build

Run tests

dotnet test

Create a NuGet package

dotnet pack --configuration Release

Contributing

When contributing to this repository, please first discuss the change you wish to make via issue, email, or any other method with the owners of this repository before making a change.

  1. Fork the repository on GitHub
  2. Clone the project to your own machine
  3. Commit changes to your own branch
  4. Push your work back up to your fork
  5. Submit a Pull request so that we can review your changes

NOTE: Be sure to merge the latest from "upstream" before making a pull request!

Change Log

Version Changes
0.1.1 Development still going on
0.1.2 First working version of the task
0.1.3 Changes to property namings
0.1.4 Test case created, README updated
0.1.5 Fixed input tab
0.1.6 Minor changes to descriptions
  • .NETFramework 4.7.1
    • Microsoft.CSharp (>= 4.7.0)
    • Newtonsoft.Json (>= 13.0.1)
    • System.ComponentModel.Annotations (>= 5.0.0)
  • .NETFramework 6.0
    • Microsoft.CSharp (>= 4.7.0)
    • Newtonsoft.Json (>= 13.0.1)
    • System.ComponentModel.Annotations (>= 5.0.0)
  • .NETFramework 8.0
    • Microsoft.CSharp (>= 4.7.0)
    • Newtonsoft.Json (>= 13.0.1)
    • System.ComponentModel.Annotations (>= 5.0.0)
  • .NETStandard 2.0
    • Microsoft.CSharp (>= 4.7.0)
    • Newtonsoft.Json (>= 13.0.1)
    • System.ComponentModel.Annotations (>= 5.0.0)
  • .NETFramework 4.7.1: 4.7.1.0
  • .NETFramework 6.0: 6.0.0.0
  • .NETFramework 8.0: 8.0.0.0
  • .NETStandard 2.0: 2.0.0.0
  • / / 
    
                        
    
                    
    
                    
    
                        
    
                            
                                
                                
                                
                            
                            
                                
    
                                    Assembly
                                    Assembly hash
                                    Match
                                
    
                                
                            
                                    
    
                                        /lib/netstandard2.0/frends.community.excelfinancialfunctions.dll
                                        
                                            
2c8093a2b002438db26a439d2f01c01cFFFFFFFF                                            
                                        
                                        
                                                

                                                
                                        
                                    
    
                                    
    
                                        /lib/net6.0/frends.community.excelfinancialfunctions.dll
                                        
                                            
485b0e77e8174197a85414625654c372FFFFFFFF                                            
                                        
                                        
                                                

                                                
                                        
                                    
    
                                    
    
                                        /lib/net8.0/frends.community.excelfinancialfunctions.dll
                                        
                                            
5134d77b9c6f4116a931e81db7328ae4FFFFFFFF                                            
                                        
                                        
                                                

                                                
                                        
                                    
    
                                    
    
                                        /lib/net471/frends.community.excelfinancialfunctions.dll
                                        
                                            
5f49bcfe0592426fbe7ce5afae195685FFFFFFFF                                            
                                        
                                        
                                                

                                                
                                        
                                    
    
                                
                        
    
                    
    



            
    
        
    
    
    
    
    
        
    
            
    
                
                    
    Owners
    
                            
                                FRENDS Community Feed User

                            

                    		
            
    

                
    
                    
                        
    Authors
    
                        HiQ Finland
                        		
                
    


                
    
                    
                        
    Project URL
    
                        https://github.com/CommunityHiQ/Frends.Community.ExcelFinancialFunctions
                        		
                
    

            
    
                
                    
    License
    
                    

                        Unknown

                    
                    		
            
    

                
    
                    
                        
    Tags
    
                        Frends
                        		
                
    


            
    
                
                    
    Info
    
                    17 total downloads
                    		
            
    
            
    
                
                    3 downloads for version 0.1.7
                
            
    
            
    
                
                     Download (21.29 KB)
                
            
    
                
    
                    
                         Download legacy symbols (47.28 KB)
                    
                
    
            

            
    
                
                    Found on the current feed only
                
            
    
        
    
    
    

    

        

    



            
    Package history
    
            
    
            
    
            
    
                
                    
    
                        
                        
                        Version
                        Size
                        Last updated
                        Downloads
                        Mirrored?
                        
                    
    
                    
                

                        
    
                            
                            
                                    
                                        
                                    
                            
                            
                                
                                
                                

                                
                                    0.1.7
                                
                            
                            21.29 KB
                            Mon, 10 Feb 2025 07:48:23 GMT
                            3
                            
                                    
                            
                            

                                

                            
                        
    
                        
    
                            
                            
                                    
                                        
                                    
                            
                            
                                
                                
                                

                                
                                    0.1.6
                                
                            
                            11.49 KB
                            Wed, 08 Jun 2022 13:59:22 GMT
                            14