Excel RTD puts real-time account, ticket and price data into Excel using simple formulas – no macros, no programming. Traders who do have basic programming skills can also customise the tool to send trading commands from Excel.
The Excel RTD tool is a very adaptable trade monitoring, analysis and reporting tool which allows traders to interact with trading platforms using their Excel skills rather than having to learn complex programming languages.
The tool enables traders to do two distinct things:
- Put real-time account, ticket, and price data into Excel using only Excel's built-in RTD() function. No macros, no programming. Only standard Excel knowledge is required.
- Send simple trading commands from VBA code in Excel (or from any other language which supports COM).
Traders can build simple spreadsheets, without programming, which display and analyse account and price data in real-time. They can also build a single spreadsheet which compares data across multiple accounts.
Like any cells in Excel, the RTD data can be linked to a chart, or to conditional formatting - for example, highlight losing trades or accounts in red. Therefore, sophisticated traders who have built market models in Excel can use the app to combine the model with real-time prices (and open-position data), using standard Excel features to notify themselves when positions should be opened or closed.
The Excel RTD tool is supplied with a user guide and also an example spreadsheet. Using nothing other than the RTD() function described above, this example spreadsheet demonstrates how to implement a complete trader dashboard with charts showing the floating P/L on multiple accounts, price comparisons, and a combined ticket list for multiple accounts.
Traders with minimal knowledge of VBA programming can also use Excel to send simple trading commands (or to read data) using code that can be linked to a button on a spreadsheet.
In other words, traders with basic programming skills can use Excel for anything from constructing their own customised deal ticket through to automated trading based on a financial model in Excel.
The ability to send commands and read data can in fact be used from any programming environment which supports COM, not just Excel VBA. For example, a trader could create anything from a simple .vbs script which closes all positions through to a complex trading algorithm written in C#, both of which place trades by sending commands to the Excel RTD app.
Click here to download the user guide: BlackPearlFX – Excel RTD.pdf