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»:
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
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
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
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
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
Aspose.Tasks for .NET Aspose.Tasks is a .NET project management component that enables .NET applications to read, write and modify Microsoft Project documents as well as MPX (Microsoft Project eXchange), MPP projects (native MS Project 98 - 2007 format), MPD format (MS Project
TMS Advanced Charts for IntraWeb(Delphi 6) TMS Advanced Charts for IntraWeb includes multipane financial graphs and 2D feature rich charting components. It features single or multi pane chart view component, wide range of 2D chart types: Line, Bar, Area, Pie, Stacked Bars, Stacked Area, OHLC, Candl
StarBurn SDK This software development kit allows you to add optical media recording and mastering capabilities to your application in a minutes. All MMC compatible CD/DVD recorders (CD-R/W, DVD-R/W, DVD+R/W, BD-R/BD-RE and DVD-RAM) are supported; UDF file system maste
UseOffice .Net UseOffice. Net is a reliable component for converting between DOC, DOCX, RTF, XLS, XLSX, HTML, PPT, CSV, Text and PDF documents with tables, images, fonts, colors. The component is created with C # and helps developers to easily create a ASP.Net server and
Universal Data Access Components UniDAC (Universal Data Access Components) is a powerful library of non-visual cross-database data access components for direct access to various database servers from RAD Studio 10.1 Berlin, Embarcadero RAD Studio 10 Seattle, Embarcadero RAD Studio XE-XE8,
jQuery Selected Text Sharer Jquery Selected Text Sharer is a promoting and enhancing plug-in focusing to increase the site usage. This plug-in display a widget having links to search or share, above the selected text. Features include cross browser supported, customizable interface,
TWebUpdate(Delphi 5,6,7,2005 and C++Builder 5,6) The TMS TWebUpdate component is designed to make distribution of application updates easier. TWebUpdate can handle network file transfer, FTP or HTTP/HTTPS based distribution methods. Formats for distributing updates can be LZ compressed files, CAB files,
Advanced Graphics Library Since Microsoft GDI+ library do not include important shapes; Advanced Graphics Library came with a solution to this now using the Advanced Graphics Library you can draw round rectangles, triangles, and arrows using our rich set of functions and procedures
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