Excel's Financial Trading System Capabilities
by Arthur Juneau
Are you considering how to implement a financial trading system for yourself or your firm? There are a tremendous number of places to start, but how do you sort it all out? Most importantly, what are the key considerations to ensure you do it right and end up with a solid system that doesn't waste lots of time and money?
One of the main challenges when buying or building a financial trading system is the sheer number of choices. Trading software ranges from cheap "every man" applications and shareware to full-blooded enterprise systems designed for the largest banks and hedge funds. So the first question is "where do I fit in the range of size and sophistication?" This helps define the features you need, the money you will spend, and the vendors you will buy from...or build if you like that path.
A smaller firm of 10 traders implementing different strategies doesn't require an elaborate financial trading system designed for a big i-bank. However, your traders are probably sophisticated enough to need real feature -- trading millions in stocks, futures and forex on a daily basis requires the ability to create and manage multiple strategies easily. A firm this size needs something configurable, componentized, transparent and flexible.
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.
From a trading strategy and analysis standpoint, Microsoft Excel tends to be one of the top 2 or 3 applications. You can easily program trading strategies directly in Excel with formulas, VBA, and manual user controls such as dropdowns, data entry cells, and macro buttons. A trader can quickly pull in market data (prices, volume, PE ratios, etc.) and combine it with technical and fundamental indicators with simple if-then statements and Excel's native calculation engine. Elaborate pre- and post-trade analysis can be done along with charting and trend analysis in Excel. That's why it's so widely used by Wall Street and City of London traders who have the best desktop trading systems in the world at their disposal.
Small trading shops and invidual traders can execute trades directly in the market by integrating with your broker's execution API. If your firm has an OMS with an API, trade signals originated in Excel can be routed through the OMS and executed at different prime brokers or liquidity centers. Different order types, VWAP and contingent orders can be implemented to ensure best execution.
Market data management, position management, profit and loss analysis, and risk management are separate specialty areas where you can buy different components and integrate them, or buy a complete middle or back office system to handle. Market data management requires specialized infrastructure to handle large volumes and massive speed requirements. Positions, P&L, risk, and accounting all rely on complex computations and are best handled together.
As you can see, there are lots of considerations in the trading technology area. Hopefully this helps you put together the best financial trading system for you.
Implementing a <a href="http://exceltradingmodels.com/free-getting-started-guide-1/">financial trading system</a> may involve Excel models for several components. Find out how to implement Excel for trading <a href="http://exceltradingmodels.com/free-getting-started-guide-2/">here.</a>
---------------------------------------------------
You are receiving this because you signed up for it on 2014-06-13 from IP
To fine-tune your selection of which articles to receive, just login here:
http://www.uniquearticlewizard.com/bloggers/
using your username:
To unsubscribe please use the following link:
http://www.uniquearticlewizard.com/unsubscribe.php?mail=mohsin926.world@blogger.com&code=130f4b3e06594df6daa30a602e9f4c8f
---------------------------------------------------
---------------------------------
New Unique Article!
Title: Excel's Financial Trading System Capabilities
Author: Arthur Juneau
Email: info@financial-edu.com
Keywords: financial trading system, excel trading system
Word Count: 545
Category: Finance
---------------------------------
No comments:
Post a Comment