A wide variety of market participants use Excel for trading on a daily basis. The steps you need to take to implement Excel correctly for trading are relatively simple. You need to think about your desired workflows, then build the various spreadsheets and data sources and integrate them.
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.
Best practices of Excel for trading involve planning your spreadsheet workflows and relationships so everything works together correctly and you can find what you need when you need it. You have a choice here of building a multiple spreadsheet environment or creating a single workbook with lots of tabs. The prior approach is modular and tends to work well because each separate workbook is for a specific purpose, small, and easy to manage. The downside is you may need to manage lots of links and Excel links have a tendency to break and get corrupted. Big workbooks with lots of sheets can be useful in Excel for trading since you have everything in one place. However, Excel tends to bog down and the files get huge when you start using more than 10,000 rows of data, charts, and multiple tabs together. It can also be a bit risky to have your whole daily trading operation in one file. Just make sure you back up your files in an external location every day!
Considering these factors beforehand will help you put together the best Excel for trading layout to achieve your specific needs.
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.
Best practices of Excel for trading involve planning your spreadsheet workflows and relationships so everything works together correctly and you can find what you need when you need it. You have a choice here of building a multiple spreadsheet environment or creating a single workbook with lots of tabs. The prior approach is modular and tends to work well because each separate workbook is for a specific purpose, small, and easy to manage. The downside is you may need to manage lots of links and Excel links have a tendency to break and get corrupted. Big workbooks with lots of sheets can be useful in Excel for trading since you have everything in one place. However, Excel tends to bog down and the files get huge when you start using more than 10,000 rows of data, charts, and multiple tabs together. It can also be a bit risky to have your whole daily trading operation in one file. Just make sure you back up your files in an external location every day!
Considering these factors beforehand will help you put together the best Excel for trading layout to achieve your specific needs.
About the Author:
Want information about Excel for trading? Visit this site for a FREE GUIDE on building trading models in Excel.
No comments:
Post a Comment