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»:
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
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
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,
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
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
Ubber Text Ubber Text is a simple text field program. It is not able to save files unfortunately. It is a good produce to temporarily store notes. This is good to prevent cluttering your system by avoiding unnecessarily saving useless items. This version is the first
TMS Smooth Controls Pack(Delphi 2005) TMS Smooth Controls is a set of smoothly animated VCL components for Delphi and C++Builder with a consistent sophisticated visual appearance. Underlying technologies used are the Microsoft GDI+ API that has support for complex gradients, drawing with opaci
Verax ICMP library for Java Verax ICMP library for Java/Windows is a high-performance, asynchronous and 100% JNI (Java Native Interface) implementation of the ICMP (Internet Control Message Protocol) ping for Microsoft Windows, independent of any third party libraries. Verax ICMP lib
Precision NCA Components for VCL Portable With Precision NCA Components for VCL, you can extend the form with application button. These components are drawn directly to the non-client area of the target window, so they work fast. This component extends your form with so called "application button"
SharePoint Short Url SharePoint Short Url allows users to create and use short links in a SharePoint environment instead of long and unattractive ones. Short URLs can be created for site pages, documents, views and list items.Requirements:Microsoft SharePoint Foundation 2010
Visual Studio .NET 2002 Service Pack 1 MFC70.DLL Security Update A security issue has been identified that could allow an attacker to compromise a computer running Visual Studio .NET 2002 Service Pack 1 and gain access to confidential data. You can help protect your computer by installing this update from Microsoft. Thi
SharePoint 2010 Clock & Weather Web Part Virto Clock & Weather is Free Web Part for SharePoint 2010 that allows to display Time and Weather for Different Time Zones. This fully free and extremely simple application is designed to be easily integrated with your SharePoint Sites. Virto Clock & Weat
ShellObjects.Net ShellObjects.Net is a set of components which allow your applications to create quick-launch like appbars with drag-docking and autohide functionality [ShellAppBar], display MSN/Office2003 style popups [ShellPopupNotification], create back-forward navigati
TAdvListEditor TAdvListEditor is a edit control to edit a list of values in a flexible way similar to the Microsoft Outlook or iOS email address input.Feature include where values can have a different display text from value text (name and email for example),values can h
Dew Lab Studio for .NET Dew Lab Studio includes Dew Math library and additional signal analysis (Dew Signal) and statistical analysis (Dew Stats) add.on packages. Features include: fast object oriented numerical library for VS2005, VS2008, VS2010, VS2012, VS2013. Support for 64bi
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