This is a list of Financial Functions that i've developed in the past years. You can use them to do amortization schedule calculations and so. Please make good use of them, you can do whatever you like, there's no copyright.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Payment (PMT) | |
* (SQL Server) | |
* AzsaturnDx (2020) - No copyright at all | |
* | |
* Calculates the payment for a loan based on constant payments and a constant interest rate. | |
* | |
* @Rate FLOAT - Required. The interest rate for the loan. | |
* @Periods INT - Required. The total number of payments for the loan. | |
* @Present FLOAT - Required. The present value, or the total amount that a series of future payments is worth now; also known as the principal. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Future Value (FV) | |
* (SQL Server) | |
* AzsaturnDx (2020) - No copyright at all | |
* | |
* Calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment. | |
* | |
* @Rate FLOAT - Required. The interest rate for the loan. | |
* @Periods INT - Required. The total number of payments for the loan. | |
* @Payment FLOAT - Required. The payment made each period; it cannot change over the life of the annuity. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Interest Payment | |
* (SQL Server) | |
* AzsaturnDx (2020) - No copyright at all | |
* | |
* Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. | |
* | |
* @Rate FLOAT - Required. The interest rate per period. | |
* @Period INT - Required. Specifies the period and must be in the range 1 to nper. | |
* @Periods INT - Required. The total number of payment periods in an annuity. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Effective Annual Interest Rate | |
* (SQL Server) | |
* AzsaturnDx (2020) - No copyright at all | |
* | |
* Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. | |
* | |
* @Rate FLOAT - Required. The nominal interest rate. | |
* @Periods INT - Required. The number of compounding periods per year. | |
* @return FLOAT Effective Annual Interest Rate. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Principal Payment | |
* (SQL Server) | |
* AzsaturnDx (2020) - No copyright at all | |
* | |
* Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. | |
* | |
* @Rate FLOAT - Required. The interest rate per period. | |
* @Period INT - Required. Specifies the period and must be in the range 1 to nper. | |
* @Periods INT - Required. The total number of payment periods in an annuity. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Prevent user session closing | |
* (Code onTime) | |
* AzsaturnDx (2020) - No copyright at all | |
* | |
* Prevents the user from logging out by constantly refreshing userToken (re-logging-in according to: daf.js) | |
* | |
* REQUIRES: Your COT project must have the Account Manager enabled. | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Hide Roles controls | |
* (Code onTime) | |
* AzsaturnDx (2020) - No copyright at all | |
* | |
* Hides all role-based controls from user. | |
* | |
*/ | |
// Expressed in milliseconds |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Reloads a dataView every periodically | |
* (Code onTime) | |
* AzsaturnDx (2020) - No copyright at all | |
* | |
* Reload data from the contextDataview | |
* | |
* Implementation: | |
* 1.- Copy this to a file. | |
* 2.- Copy this file to (...)/app/js/ |
OlderNewer