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

Requirements:

SQL Server 2005 or later

Limitations:

30-day trial

Like it? Share with your friends!

Other Windows Software of Developer «TotallySQL»:

SQLStatisticsSQLStatistics 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

Assembly ManagerAssembly 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

SQLDistributionsSQLDistributions 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

SQLEngineeringSQLEngineering 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

SQLMathSQLMath 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,

SQLRollingStatsSQLRollingStats 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

SQLUtilitiesSQLUtilities 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

SQLTuplesSQLTuples 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

TMS Scripter Studio(Delphi 2005)TMS Scripter Studio(Delphi 2005) adds the ultimate flexibility and power into your applications with native Pascal or Basic scripting. It allows modification of the application behaviour without needing to update the full application.End users can add tota

Telerik RadWindowTelerik RadWindow is a component that can replace the standard browser dialogs and alert/prompt/confirm boxes. Developers can build modal and non-modal dialogs and windows, individually or in groups that mimic the behavior of the Windows taskbar. Version 1

ImageFX for C++ Builder 2007Image FX is an image processing component library for Delphi and C++ Builder. ImageFX use only hardware acceleration for image processing. It abstracts the pixel-level manipulation process required when applying a filter to an image, making it simple for a

ImageFX for Delphi XEImage FX is an image processing component library for Delphi and C++ Builder. ImageFX use only hardware acceleration for image processing. It abstracts the pixel-level manipulation process required when applying a filter to an image, making it simple for a

Multimedia LibraryMultimedia Library allows you to play audio and video files in almost all formats, you can control the playback of audio and video files using the rich set of function and procedures in the Multimedia Library.Requirements:Windows 95/98/Me/2000/XP, Microsof

ASP Ajax DataGridWith this behavior you can insert in your ASP pages an Ajax-Asp DataGrid
Lightweight but rich data grid with resizable columns and a scrolling data to match the headers, this behavior populate the DataGrid from an existing recordset in your page using A

Mini-XMenusMini-XMenus is a .NET component that adds custom menu items to the Windows Explorer context menu. Menu items can be selectively shown based on which items are selected in Explorer. Menu items can include custom icons, fonts and colors, sub-menus, separator