Join or Sign In

Sign in to add and modify your software

Continue with Facebook Continue with email

By joining Download.com, you agree to our Terms of Use and acknowledge the data practices in our Privacy Policy.

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

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

Full Specifications

What's new in version 1.0

General

Date Added May 25, 2011
Version 1.0

Operating Systems

Additional Requirements None

Popularity

Total Downloads 52
Downloads Last Week 0
Report Software

Related Software

Access 2007 Download: Access Runtime

Free
Access 2007 Download: Access Runtime

Visual FoxPro 6.0 Setup Wizard

Free
Visual FoxPro 6.0 Setup Wizard

Microsoft Visual C++ 2005 SP1 Redistributable Package (x86)

Free
Microsoft Visual C++ 2005 SP1 Redistributable Package (x86)

Microsoft Visual C++ 2005 Redistributable Package (x86)

Free
Microsoft Visual C++ 2005 Redistributable Package (x86)

Best VPN Services for 2021

Best for privacy

3 months free with 1-year plan

Best for customer support

$39.99 for the first 12 months

Best for zero logs

$4.87.99/months for a 1-year plan

Best money-back guarantee

$2.99/months for a 3-year plan