Wall Street uses Excel for trading on a daily basis. The average investor or trader doesn't use Excel this way, but the techniques for implementing Excel in a trading environment are relatively simple. You just need to know how you intend to use Excel, and what kind of trading workflow works for you.
There are many ways to use Excel for trading, and your first consideration should be narrowing down your intended use of the tool. Will you use it to compute trading signals? Is your interest importing data automatically into Excel? How about calculating profits, drawdowns, risk and other analytics? Do you have many open positions you need to track? Would you like to integrate Excel with a charting platform? Are you interested in automating your workbooks with VBA to increase speed and accuracy?
Bringing price and volume data into a spreadsheet automatically is one way to implement Excel for trading. This uses DDE links to a price data database, either an internal or vendor provided database. DDE links are efficient and can capture fast moving prices (with certain limitations relevant to algorithmic trading). Importing price and volume data into Excel with web query functionality is an alternative to DDE links. This works if you want to capture a smaller volume of prices or economic data from websites like Yahoo Finance, Google Finance, etc. You can also import data into Excel using the Data from Other Sources function. This connects to SQL Server, MS Analysis Services, XML files and ODBC -- this is a good option for the technically minded.
Once you have your data into Excel for trading purposes, then what will you be doing with it? You can create a position blotter, watch list, profit and loss statement, trade history log, or a big price history database. These can then be used for current day and historical trend analysis, evaluating your trading performance using common statistics like standard deviation, sharpe ratio, drawdown, maximum drawdown, etc. There are virtually unlimited uses of Excel for trading workflows.
You should spend some time planning your spreadsheet designs before you implement Excel for trading. A good modular design helps understand the data flows and makes testing for accuracy much easier. Being able to find what you need when you need it is critical during a trading session. Several simple spreadsheets linked together can often be better and more efficiency than a single large spreadsheet with multiple tabs. It really depends on your preference and your system resources available. As you build out your spreadsheets keep in mind that it's easier to manage small workbooks and the tend to run faster. Whether you have single or multiple workbooks, each spreadsheet should have a specific purpose. A few caveats: external links can become corrupted and slow things down so be careful with them. More than 15,000 rows of data can slow Excel down. Make sure you back things up regularly. Charts should be used sparingly for intraday use, as your charting program is probably much better at this than Excel and charts tend to bloat your files.
These ideas should help you get started using Excel for trading to improve your trade processes and increase profits with less risk.
There are many ways to use Excel for trading, and your first consideration should be narrowing down your intended use of the tool. Will you use it to compute trading signals? Is your interest importing data automatically into Excel? How about calculating profits, drawdowns, risk and other analytics? Do you have many open positions you need to track? Would you like to integrate Excel with a charting platform? Are you interested in automating your workbooks with VBA to increase speed and accuracy?
Bringing price and volume data into a spreadsheet automatically is one way to implement Excel for trading. This uses DDE links to a price data database, either an internal or vendor provided database. DDE links are efficient and can capture fast moving prices (with certain limitations relevant to algorithmic trading). Importing price and volume data into Excel with web query functionality is an alternative to DDE links. This works if you want to capture a smaller volume of prices or economic data from websites like Yahoo Finance, Google Finance, etc. You can also import data into Excel using the Data from Other Sources function. This connects to SQL Server, MS Analysis Services, XML files and ODBC -- this is a good option for the technically minded.
Once you have your data into Excel for trading purposes, then what will you be doing with it? You can create a position blotter, watch list, profit and loss statement, trade history log, or a big price history database. These can then be used for current day and historical trend analysis, evaluating your trading performance using common statistics like standard deviation, sharpe ratio, drawdown, maximum drawdown, etc. There are virtually unlimited uses of Excel for trading workflows.
You should spend some time planning your spreadsheet designs before you implement Excel for trading. A good modular design helps understand the data flows and makes testing for accuracy much easier. Being able to find what you need when you need it is critical during a trading session. Several simple spreadsheets linked together can often be better and more efficiency than a single large spreadsheet with multiple tabs. It really depends on your preference and your system resources available. As you build out your spreadsheets keep in mind that it's easier to manage small workbooks and the tend to run faster. Whether you have single or multiple workbooks, each spreadsheet should have a specific purpose. A few caveats: external links can become corrupted and slow things down so be careful with them. More than 15,000 rows of data can slow Excel down. Make sure you back things up regularly. Charts should be used sparingly for intraday use, as your charting program is probably much better at this than Excel and charts tend to bloat your files.
These ideas should help you get started using Excel for trading to improve your trade processes and increase profits with less risk.
About the Author:
The best Excel for trading systems are created by using Excel's spreadsheets, formulas, and VBA code together to build a cohesive yet flexible system. Get your FREE guide on building trading models in Excel by visiting ExcelTradingModels.com
Aucun commentaire:
Enregistrer un commentaire