Icon of program: SQLFinancials

SQLFinancials for Windows

By TotallySQLFree

Key Details of SQLFinancials

  • Get Microsoft SQL Server financial functions library for T-SQL scripts & stored procedures
  • Last updated on 05/25/11
  • There have been 0 updates within the past 6 months
  • The current version has 0 flags on VirusTotal badge_icon

Developer's Description

Get Microsoft SQL Server financial functions library for T-SQL scripts & stored procedures.
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

Explore More


Full Specifications

GENERAL
Release
May 25, 2011
Latest update
September 3, 2020
Version
1.0
OPERATING SYSTEMS
Platform
Windows
Operating System
Windows 10, Windows 2003, Windows Vista, Windows XP, Windows Server, Windows 7
Additional Requirements
None
POPULARITY
Total Downloads
53
Downloads Last Week
1
Report Software

Related Software