Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: John Ryle

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

A Stock Price Correlation Matrix

Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function  Read more...
By John Ryle 2012/05/14 | Source: SQLServerCentral.com | Category: tvp
Rating: |  Discuss |   Briefcase | 5,910 reads

Calculating Stock Returns Using the ROW_NUMBER function and CTEs

In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.   Read more...
Rating: |  Discuss |   Briefcase | 5,417 reads
   Items 1 to 2 of 2