Login     Register

        Contact Us     Search

Menu

Calculating a Correlation Matrix in SQL Server

By Charles Flock on 3/25/2015 10:24 AM
Diversification is the basis for any sound investment strategy and the heart of diversification is finding uncorrelated risk in different asset classes. In this article we show you how to do that using the XLeratorDB table-valued function CORRM.
The WestClinTech Blog

Calculating internal rates of return using 30/360 day-count conventions

By Charles Flock on 3/17/2015 2:41 PM
We have added 5 new functions to help you calculate internal rates of return (IRR) for a variety of day-count methods. Used in conjunction with our other day-counting functions, you can calculate IRR using actual/actual, actual/360, actual/364, business days / 252, no-leap-year / 365 and others as well as for 30/360.
The WestClinTech Blog

Logistic Regression in SQL Server

By Charles Flock on 3/4/2015 10:08 AM
We have added 5 new functions in the latest release of XLeratorDB / statistics 2008. Four of these functions, LOGIT, LOGITSUM, LOGITPRED, and LOGITPROB are SQL Server implementations of the logistic regression, often referred to as the logit regression. The remaining function, VIF, estimates the variance inflation factor, tolerance, and R2 for a set of independent variables allowing you to test for collinearity.
The WestClinTech Blog

Search Blogs

Blog Archives

Copyright 2008-2025 Westclintech LLC         Privacy Policy        Terms of Service