English

Excel RTD

Excel RTD

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.

 

VBA programming

 

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

 

REGULATION AND LICENCING

CFDs and Spot FX are leveraged products and carry a high degree of risk to your capital. It is possible to lose more than your initial investment so only speculate with money you can afford to lose. CFDs and Spot FX may not be suitable for all investors so please ensure you fully understand the risks involved, seeking independent advice if necessary. 

BlackPearlFX is a trading name of Black Pearl Securities Limited (Company number 08823678). Black Pearl Securities Limited is authorized and regulated by the Financial Conduct Authority, Financial Services Register Number 688456. Registered office address: 23 Austin Friars, London, EC2N 2QP. United Kingdom

Relationships listed throughout the website may be directly or indirectly established with Black Pearl Securities Limited or its trading name BlackPearlFX. The Entities listed include custodian banks, clearing partners, liquidity providers, technology providers, news & market data vendors, among others. Names and Logos of listed entities are the property of their respective owners. 

BlackPearlFX’s Payment and Foreign Currency Exchange Services are provided by Ebury Partners UK Limited. Ebury Partners UK Limited is authorised and regulated by the Financial Conduct Authority as an Authorised Payment Institution (Financial Services Register No. 522933).

The information on this site is not directed at residents of the United States, Japan, Afghanistan, Algeria, Angola, Bosnia and Herzegovina, Cuba,Guyana, Iran, Iraq, Lao PDR, Myanmar, North Korea, Papua New Guinea, Sudan, Syria, Uganda, Yemen or any particular country outside the United Kingdom and is not intended for distribution to, or use by, any person in any country or jurisdiction where such distribution or use would be contrary to local law and regulation.

www.blackpearlfx.com is owned and operated by Black Pearl Securities Ltd.

Website Terms and Conditions | Risk Warning Notice | Customer Terms and Conditions

REGULATION AND LICENCING

CFDs and Spot FX are leveraged products and carry a high degree of risk to your capital. It is possible to lose more than your initial investment so only speculate with money you can afford to lose. CFDs and Spot FX may not be suitable for all investors so please ensure you fully understand the risks involved, seeking independent advice if necessary. 

BlackPearlFX is a trading name of Black Pearl Securities Limited (Company number 08823678). Black Pearl Securities Limited is authorized and regulated by the Financial Conduct Authority, Financial Services Register Number 688456. Registered office address: 36 Whitefriars Street, London, EC4Y 8BQ. United Kingdom

Relationships listed throughout the website may be directly or indirectly established with Black Pearl Securities Limited or its trading name BlackPearlFX. The Entities listed include custodian banks, clearing partners, liquidity providers, technology providers, news & market data vendors, among others. Names and Logos of listed entities are the property of their respective owners. 

BlackPearlEX’s Payment and Foreign Currency Exchange Services are provided by Ebury Partners UK Limited. Ebury Partners UK Limited is authorised and regulated by the Financial Conduct Authority as an Authorised Payment Institution (Financial Services Register No. 522933).

The information on this site is not directed at residents of the United States, Japan, Afghanistan, Algeria, Angola, Bosnia and Herzegovina, Canada, Cuba,Guyana, Iran, Iraq, Lao PDR, Myanmar, North Korea, Papua New Guinea, Sudan, Syria, Uganda, Yemen or any particular country outside the United Kingdom and is not intended for distribution to, or use by, any person in any country or jurisdiction where such distribution or use would be contrary to local law and regulation.

www.blackpearlfx.com is owned and operated by Black Pearl Securities Ltd.

Website Terms and Conditions | Risk Warning Notice | Customer Terms and Conditions