Finance

Correlation of time based variables in MySQL

I often find it useful to calculate the correlation of two time-based variables directly inside MySQL. For example:-

SELECT calcCorrelation('BHP','RIO','3600');

Where the first two inputs are the variable selections and the third is the time based quantization to use. Since MySQL does not have any built-in corr() function you need to do the heavy lifting yourself with a stored function.

Recession Specials on Craigslist

The US recession is bringing out some epic specials at the moment on the like of Craigslist. Check out results for search terms for things like "moving", "must sell" or "out of business" - you'll get the idea.

Madoff's new job

Madoff sending everything down the sink, though it really seems too kind to think of him employed.

Syndicate content