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»:
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
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
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
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
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,
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
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
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
TMS Flexcel Studio for .NET(Microsoft Visual Studio .NET 2008) TMS Flexcel Studio for .NET generates Excel files from WinForms, WebForms ASP.NET, PocketPC applications, webservices on the fly and fast with FlexCel Studio for .NET. It is exceptionally fast and solid hand tuned .XLS and .XLSX engine capable of generatin
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 RadWindow Telerik 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 2007 Image 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 XE Image 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 Library Multimedia 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 DataGrid With 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-XMenus Mini-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
SMTP/POP3/IMAP Email Engine Library for Visual dBase MarshallSoft SMTP/POP3/IMAP dBase email component library (SEE4DB) uses a simple API to send and receive mail, including HTML, MIME Base64 and quoted-printable encoded attachments, from within a dBase application.
Features of SEE4DB include:
- Send ema
Foxit PDF SDK DLL (32-Bit) Foxit PDF SDK DLL (32-Bit) helps developer to integrate and customize PDF technology into their applications, the Foxit PDF SDK DLL (32-Bit) provides a PDF environment where developers have deep control over PDF feature modules. It enables PDF developers t
Supported Operating Systems:
Windows XP |
Comments on SQLFinancials:
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