The Excel RTD app 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 app enables traders to do two distinct things:
For example, once the Excel RTD app is running, the formula for displaying the equity on account number 123789 - updating in real time - is simply as follows:
=RTD("FIXI Markets.ExcelRTD", , "123789", "equity")
Other examples of formulas include the following:
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 app 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 such as the following, which could be linked to a button on a spreadsheet:
Set cmd = CreateObject("FIXI Markets.ExcelCommand")
strResult = cmd.SendCommand("123789", "BUY", "s=EURUSD|v=10000", 5)
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.
FIXI PLC 1 King Street,
London, EC2V 8AU,
Submit your message
FIXI Markets, FIXI Select, FIXI eFX & FIXI Trade are trading names of FIXI PLC. FIXI Plc is authorised and regulated by The Financial Conduct Authority (FCA). FRN: 448399. For further information with regards to our authorisation at the FCA please click here.
FIXI Plc is registered in England & Wales under Company Number 05577579. Registered address 1, King Street London, EC2V 8AU, United Kingdom
CFDs, spread betting and rolling spot forex are complex instruments and come with a high risk of losing money rapidly due to leverage.
66% of retail investor accounts lose money when trading CFDs with this provider.
You should consider whether you understand how these instruments work and whether you can afford to take the high risk of losing your money.
The information and content provided on the website (“the Information”) you are going to access, has been compiled and presented in accordance with UK laws and regulations. The Information is not intended for distribution to, or use by, any person or entity in any jurisdiction or country where such distribution or use may be contrary to any of the laws or regulations of that jurisdiction. The products and services described herein may not be available in all countries and jurisdictions. Those who access this site do so on their own initiative, and are therefore responsible for compliance with applicable local laws and regulations. The release does not constitute any invitation or recruitment of business.
© Dec 2017 FIXI PLC