What to Look for in an Excel Correlation and Regression Template Package
There are multiple Excel correlation and regression packages in the market that alleviate you of the need to build the calculations and worksheets yourself. For correlation trading, be sure the package you choose includes the following features: Correlation matrix...A Simple Correlation Trading Model in Excel
As an example, we will show how a simple yet effective correlation trading model can be built in Excel with free data and some basic statistical formulas. The idea here is to compare two closely related stocks of similar size and volatility in the same industry,...Correlation and Regression Trading in Excel
One type of trading strategy is commonly known as regression trading or correlation trading. Essentially the idea is to compute a “typical” price relationship between two securities, indexes, or curves over a period of time using regression and correlation...Make Sure You Back Test Your Excel Model First!
Fully automating your trade execution directly from Excel to your broker is one of the final steps toward creating a “trading robot”. However, it is very important to test your trading model and Internet connection thoroughly before allowing it to send...Automated Order Execution from Excel to a Broker’s System
If you want to fully automate your Excel trading model, you will want to execute buy and sell orders directly through your broker’s system. Several brokers such as Interactive Brokers provide an Application Programming Interface (API) that allows you to send....
