SQLFinancials extends the T-SQL scripting environment by adding financial analysis functions similar to those found in the MS Excel analysis toolpack, but which can be used directly within the database.
Performing data analysis from within the database tends to be much faster and more efficient than transporting the data across the network to a client application, and also allows simpler and cleaner application architectures.
All the financial functions which have an equivalent in Excel are numerically faithful to a very high degree of accuracy, enabling easy migration of Excel-based business operations to a database environment.
In addition, however, many of those functions are effective over a broader range of input values than their Excel counterparts, and there are some additional functions not found in Excel.
The list of available functions includes:
ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPDAYS, COUPDAYSBS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMIPMT, CUMIPRINC, DAYCOUNT, DAYSINYEAR, DB, DDB, DISC, DOLLARDE, DOLLARFR, DURATION, EFFECT, FV, FVSCHEDULE, INTRATE, IPMT, IRR, ISPMT, MDURATION, MIRR, NOMINAL, NPER, NPV, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PMT, PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RATE, RECEIVED, SLN, SYD, TBILLEQ, TBILLYIELD, VDB, XIRR, XNPV, YEARFRAC, YIELD, YIELDDISC, YIELDMAT
SQL Server 2005 or later
Like it? Share with your friends!
Other Windows Software of Developer «TotallySQL»:
SQLUtilities SQLUtilities extends the T-SQL scripting environment by adding 64 new general-purpose functions for text, date/time and numeric processing that can be used directly within queries and stored procedures at the database layer.
Date and time functions inc
SQLEngineering SQLEngineering extends the T-SQL scripting environment to add direct support for technical, engineering and scientific applications at the database layer.
Performing data analysis from within the database tends to be much faster and more efficient than
SQLStatistics SQLStatistics extends the T-SQL scripting environment so you can carry out statistical tests, calculate metrics and perform analyses on your data from within the database itself. This tends to be much faster and more efficient than transporting the data ac
SQLDistributions SQLDistributions extends the T-SQL scripting environment to by adding support for modelling and analysing probability distributions directly within the database.
Performing data analysis from within the database tends to be much faster and more efficie
Assembly Manager Assembly Manager is a windows application aimed at both SQL CLR developers and SQL DBAs that solves the problems of trying to manage CLR assemblies using just Visual Studio or SSMS.
It allows you to see in a tree-structured view all installed CLR assem
SQLRollingStats SQLRollingStats extends the T-SQL scripting environment with 31 windowed or cumulative functions (in which results for each row depend on previous rows) that can be used as regular functions in queries.
This allows metrics such as running totals or mov
SQLMath SQLMath extends the T-SQL scripting environment so you can perform mathematical operations on your data from within the database itself. This tends to be much faster and more efficient than transporting the data across the network to a client application,
SQLTuples SQLTuples is a FREE product that adds a number of tuple types and constructor functions within the T-SQL scripting environment that can be used anywhere that a compound type is needed.
Tuples of between 2 and 6 elements can be constructed easily using
Visual Basic 6.0 Extended Runtime This is the complete package of runtime files and redistributable libraries for running or redistributing applications written in Visual Basic 1.0 to 6.0 and together with some third-party redistributable components.
Disclaimer: Visual Basic 6.0 is a trad
CryptoSharp Security Library Speed up .NET development and create secure and trouble-free code. CryptoSharp Security Library provides complete data security throughout your .NET applications. Encrypt, store, and erase data securely. Saves time on development and debugging, and creates
MX Lookup Dll The dynamic link library, MX Lookup Dll, has a built in function, GetMX(domain and mx), to lookup the MX server. The MXLookup.dll can be called by Visual C++, VB, Java and other programs. A short program in VB is provided to demonstrate how to use MXLookup
Stitchcnv Library By using Stitchcnv library, you can quickly and easily convert an embroidery designs and make your own software. Save your money and time. Here is a full list of currently supported formats Babylock, Bernina, Brother .PEC, Babylock, Bernina, Brother .PES,
Mgosoft PDF Password Remover SDK Mgosoft PDF Password Remover is a simple, stand-alone application that can be used to decrypt password-protected Adobe Acrobat PDF files. It can help you generate PDF files with no password from the original PDF files which are not permitted to be edited,
CMATH for Delphi XE CMATH is a comprehensive library for complex-number arithmetics and mathematics.
The following features make CMATH an ideal replacement for the unit Complex coming with Delphi:
1. High-performance implementation in machine code leads to superior speed.
DuroBlend GUI Engine DuroBlend is a one-of-a-kind Windows class library which provides software developers and user interface designers with a fast, intuitive, unique, aesthetically stunning, and altogether seamless alternative to the blend Windows XP user interface for their
EWSoftware List Control Library EWSoftware List Control Library is a set of extended .NET Windows Forms list controls. The controls include an auto-complete combo box, a multi-column combo box, a user control drop-down combo box, a radio button list, a check box list, a data navigator co
ActMask EMF Virtual Printer SDK Help you develop own software based on ActMask EMF Virtual Printer SDK, export to EMF format from virtual printer driver. Simply print any file (Microsoft Office Document, .txt, .wri, .doc, .ppt, .xls, .htm, .jpg, and .bmp) to ActMask Virtual Printer from
Supported Operating Systems:
Windows XP |
Comments on :
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10