| Category: .NET |
View Full Details
|
Triplets finder application |
| Submitter: vanna |
Date: 2011/2/7 |
|
|
Description:
Finds cointegrated triplets from yahoo finance, which can be used to create a trading strategy. Uses Johansen's test to find coingeration vectors, and sorts them by half life. Table prerequisite:
CREATE TABLE `mytable1` (
`idmytable1` int(11) NOT NULL,
PRIMARY KEY (`idmytable1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$
delimiter $$
CREATE TABLE `cointegrationdata3` (
`symbolA` varchar(30) NOT NULL,
`symbolB` varchar(30) NOT NULL,
`symbolC` varchar(30) NOT NULL,
`evalue` decimal(10,6) NOT NULL DEFAULT '0.000000',
PRIMARY KEY (`symbolA`,`symbolB`,`symbolC`,`evalue`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$
Got a question or problem with this link? Just enter your message and click on submit. No registration is required.
|
426 0 bytes C# .NET WPF MySQL http://www.quantcode.com/ |
|
Discuss this file. Just enter your message and click on submit. No registration is required.