SQLFinancials

SQLFinancials 1.0.0.0

No Image

SQLFinancials 5 Stars Award
Category: Development Tools / Components & Libraries
Publisher / Version: TotallySQL Ltd / 1.0.0.0
Added / Released: 13 May 2011 / 03 May 2011
License / Cost: Shareware / 199.00$, 149.00 EUR
File Size / Downloads: 522.0 KB / 43
Operating Systems: Windows XP, Vista, Win7 x32,Win7 x64,WinServer
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

Download | Order | Broken Link Report | More Info

Support Languages: English
Install Support: Install Only

Your Rating: 0 Star0 Star0 Star0 Star0 Star Our Rating: 5 Stars5 Stars5 Stars5 Stars5 Stars
Rate It:
Keywords:
Excel 7.0, Excel Add Ons, Excel Applications, Excel Ref, Excel To Pdf, Excel Vb Code, Excel Web, Human Resource Functions, Mysql To Excel, Shareware Excel, Sql Excel Functions, Sql Financial Functions, Sql Irr, Sql Npv

SQLFinancials Comments

Join to SQLFinancials discussion at FileGets! Let's see what our visitors think about it and write your own opinion! Rate this software to support developers or to make them work better! Also please write here if you want to see any additional features in this software.

Your Rating *
Your Name *
Email *
Comment Text *
Notice:  * - required fields