SQLFinancials v.1.0.0.0

Advertisement
Advertisement

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

SQLFinancials extends the T-SQL scripting ... 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 ...

sql financial functions, sql excel functions, sql npv, sql irr

 
  • SQLFinancials
  • 1.0.0.0
  • 07 Jun 12
  • TotallySQL Ltd
  • WinXP, WinVista, WinVista x64, Win7 x32, Win7 x64, WinServer
  • Shareware
  • 522 Kb
  • 605
  • $199.00
 
 

Review SQLFinancials

  • captcha
 

Other software of TotallySQL Ltd
  • SQLEngineering  v.1.0.0.0SQLEngineering 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 ...
  • SQLFile  v.1.0.0.0SQLFile extends and enhances your T-SQL programming environment by adding a suite of 117 functions to support direct access to the file system from within T-SQL scripts and stored procedures. SQLFile capabilities include: * Easy processing and ...
  • SQLMath  v.1.0.0.0SQLMath 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 ...

New Components & Libraries software
  • DotConnect for PostgreSQL  v.7.18dotConnect for PostgreSQL is an enhanced data provider built over ADO.NET architecture and a development framework with a number of innovative technologies. It supports Entity Framework, NHibernate, and LinqConnect ORMs.
  • Mgosoft PCL Converter SDK  v.9.2.9Convert PCL (pcl, pxl, px3) files to PDF, XPS, Text, PS and dozens of image formats, such as TIFF, JPEG, PNG, BMP, PCX, GIF, WMF, EMF, TGA and so on, it retains the layout, images, text, line, ellipse, color, and formatting of the original PCL file.
  • DotConnect for MySQL  v.8.18dotConnect for MySQL is an enhanced data provider built on ADO.NET architecture and a development framework with a number of innovative technologies. It supports Entity Framework, NHibernate, and LinqConnect ORMs.
  • DotConnect for SQLite  v.5.16dotConnect for SQLite is a data provider built on ADO.NET architecture. With Entity Framework and LinqConnect support it introduces new approaches for designing applications, boosts productivity, and leverages database applications.
  • DF_MailStuff  v.4.0.411.15DF_MailStuff is a freeware .NET component useful in any circumstances you need to validate/check email address input by the user. DF_MailStuff is also much more: isEmailValid: use this method for validating email address checking syntax (even bad ...
  • PCL to TIFF 32-bit / 32-bit .NET  v.11.6PCL Tool SDK - Option IV. for Capturing and Transforming PCL to TIF, PCL to EMF, PCL to PNG and PCL to Text. Option IV. converts COMPLEX PCL into raster/vector file formats while extracting text. Option IV. Includes: PCLXForm, PCLCodes, PCLSplit, ...