Excel is widely used by hedge funds and professional traders to manage trades, calculate P&L, compute buy and sell signals, and much more. These capabilities are available to the average trader, many of whom already use charting software to help with their trade strategies, often with limited success. Including Excel in your trading workflow process can deliver high value in terms of profitability, discipline and consistency. There are a few things you need to learn, but it is achievable with a little effort and the benefits can be very significant to your bottom line.
One of the first considerations is how you will use Excel for trading. Will you be importing price data into a spreadsheet? Will you track your positions, profits, and losses there? Do you intend to integrate it with an existing trading platform? Do you want to develop a complete Excel for trading system with VBA, charts, order entry, and such?
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.
One of the first considerations is how you will use Excel for trading. Will you be importing price data into a spreadsheet? Will you track your positions, profits, and losses there? Do you intend to integrate it with an existing trading platform? Do you want to develop a complete Excel for trading system with VBA, charts, order entry, and such?
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:
Want information about Excel for trading? Visit this site for a FREE GUIDE on building trading models in Excel.
0 komentar:
Post a Comment