Are you interested in a financial trading system for yourself or your investment business? There are many starting points. There are several important considerations to ensure it gets done right and you arrive at a strong system.
The first challenge is laying out what you want to achieve on the trading side versus position-keeping, accounting and trade processing. There are a plethora of software platforms available from those less than $200 to massive systems used by global financial institutions. At the beginning you should ask "what do we really need versus want in terms of trader tools?" The answer will help guide the decision-making process as you look at each component of the trader's tool chest.
So, let's say you are a small firm of 10 traders with a range of different strategies you implement every day in the markets. This size firm doesn't merit a massive financial trading system designed for a big investment bank. But the firm's traders also are not small fry -- they trade millions in shares and commodity futures on a daily basis. What they need is something that is highly configurable, modular, easy to understand, easy to change, and does the trick.
The main parts of a financial trading system are the trading strategy builder, watch lists, execution methods, price-volume data module, position tracker, P&L reporting and risk analytics. Depending on your needs, two more components to consider are accounting and an OMS. The boundary between your trading, accounting and order management systems is up to you. You can rely on your broker for much of this.
Excel software is one of the most popular solutions for a financial trading system. Excel allows traders to program simple or elaborate strategies with formulas and VBA. It takes some time to learn the skills, but learning is incremental and the resources are essentially free. Excel actually has a full software coding module with the ability to add subroutines, integrate other code into the VBA, and add User controls such as buttons, charts, lists and dropdowns. This allows you to recreate the functionality of very expensive software platforms at a fraction of the cost. Prices and fundamental information can be automatically imported via DDE link. Technical indicator packages are available or can be hand-coded. There are no limits to the trading strategies that can be implemented in Excel. Pre- and post-trade limits, market risk, sensitivities and other analytics can be added.
Trade execution in a financial trading system is best left to dedicated broker systems, either retail or prime broker. In the case of a corporate treasury, this may be a sell-side investment bank's online system, or even direct order entry into electronic markets, ECNs, dark pools and other liquidity centers. Typically, this is accomplished by dedicated order management systems (OMS) with accessible APIs and a wide range of order types. There is really no point trying to use anything else.
Building a financial trading system in Excel involves strategy definition, data management, position sizing, P&L reporting, backtesting and a variety of other processes. You can build or integrate third-party components for these functions. Excel can also be used for basic back office trade processing, though there are dedicated systems available which are better at this. Real time market executions require special infrastructure to handle large volumes and low-latency speed -- Excel is less suited to this than software coded in C# or java.
If you're planning to implement a financial trading system, Excel is likely to become a major part of your trading operation. Hopefully, these insights will help make the right decisions for your trading success.
The first challenge is laying out what you want to achieve on the trading side versus position-keeping, accounting and trade processing. There are a plethora of software platforms available from those less than $200 to massive systems used by global financial institutions. At the beginning you should ask "what do we really need versus want in terms of trader tools?" The answer will help guide the decision-making process as you look at each component of the trader's tool chest.
So, let's say you are a small firm of 10 traders with a range of different strategies you implement every day in the markets. This size firm doesn't merit a massive financial trading system designed for a big investment bank. But the firm's traders also are not small fry -- they trade millions in shares and commodity futures on a daily basis. What they need is something that is highly configurable, modular, easy to understand, easy to change, and does the trick.
The main parts of a financial trading system are the trading strategy builder, watch lists, execution methods, price-volume data module, position tracker, P&L reporting and risk analytics. Depending on your needs, two more components to consider are accounting and an OMS. The boundary between your trading, accounting and order management systems is up to you. You can rely on your broker for much of this.
Excel software is one of the most popular solutions for a financial trading system. Excel allows traders to program simple or elaborate strategies with formulas and VBA. It takes some time to learn the skills, but learning is incremental and the resources are essentially free. Excel actually has a full software coding module with the ability to add subroutines, integrate other code into the VBA, and add User controls such as buttons, charts, lists and dropdowns. This allows you to recreate the functionality of very expensive software platforms at a fraction of the cost. Prices and fundamental information can be automatically imported via DDE link. Technical indicator packages are available or can be hand-coded. There are no limits to the trading strategies that can be implemented in Excel. Pre- and post-trade limits, market risk, sensitivities and other analytics can be added.
Trade execution in a financial trading system is best left to dedicated broker systems, either retail or prime broker. In the case of a corporate treasury, this may be a sell-side investment bank's online system, or even direct order entry into electronic markets, ECNs, dark pools and other liquidity centers. Typically, this is accomplished by dedicated order management systems (OMS) with accessible APIs and a wide range of order types. There is really no point trying to use anything else.
Building a financial trading system in Excel involves strategy definition, data management, position sizing, P&L reporting, backtesting and a variety of other processes. You can build or integrate third-party components for these functions. Excel can also be used for basic back office trade processing, though there are dedicated systems available which are better at this. Real time market executions require special infrastructure to handle large volumes and low-latency speed -- Excel is less suited to this than software coded in C# or java.
If you're planning to implement a financial trading system, Excel is likely to become a major part of your trading operation. Hopefully, these insights will help make the right decisions for your trading success.
About the Author:
To learn more about building a financial trading system in Excel, visit ExcelTradingModels.com
No comments:
Post a Comment