Empresa de Investimentos de Próxima Geração
Telefone:  +44 20 3670 9945 Ligue-nos 24/7

Utilizamos cookies para personalizar conteúdo e anúncios, fornecer funcionalidades de redes sociais e analisar o nosso tráfego. Também partilhamos informações acerca da sua utilização do site com os nossos parceiros de redes sociais, de publicidade e de análise, que as podem combinar com outras informações que lhes forneceu ou recolhidas por estes a partir da sua utilização dos respetivos serviços. Concorda com os nossos cookies se continuar a utilizar o nosso website.

EXANTE + MS Excel: algotrading for everyone

EXANTE + MS Excel: algotrading for everyone


Algorithmic trading is a very promising streamline in trading, especially when it comes to managing long positions. Instead of watching charts and quotes for hours in anticipation of perfect market conditions to set an order, traders create algorithms that overtake these routine operations. Moreover, if automated, the assessment of conditions is much more precise: the human eye cannot perceive minor fluctuations, and in many cases perfect conditions do not last long.

To those who have never tried programming, using algorithmic trading seems to be too hard — or sometimes even impossible. For these cases we have developed a special instrument that allows creating trading robots in one of the easiest forms — in the form of Excel macros. 

Excel supports all COM-compatible programming languages and, in particular, Visual Basic for Applications (VBA), which is a rather simple programming language that can easily be mastered (to the sufficient degree) by anyone in a few days.

In order to start trading in Excel, if you already have an account at EXANTE, please first of all download the installation file suitable for your operating system. At the moment Excel automatization is only available for Windows.

After the successful installation, let’s first of all try to display current quotes and volumes in the Excel window. For that, use the RTD function (the name may differ according to the localization of your MS Excel). You can download data on any instrument available in the EXANTE terminal, you should only know its ExanteID (the name displayed in the Instruments tree of the terminal). For example,


You can now try to obtain quotes (bid, ask) and/or volumes (bid_size, ask_size) for the instruments interesting to you.

With the help of the RTD function you can also display the current state of your account and your open positions. For the detailed description, please refer to our user manual.

More interesting opportunities of automatization, and the algotrading in Excel itself, is also described in the user manual. There you can find information on how to automate market, limit and stop orders, and how to set their parameters.

Once you start learning VBA, you will be surprised how many automatization opportunities Excel offers to you. With EXANTE and Excel integration, you will have much more capabilities for successful trading. If you have any questions, please do not hesitate to address our support team: support@exante.eu. We are always happy to make your trading experience a little bit easier!

Próximo artigo
Criada por profissionais para profissionais.
Escritório de representação mais próximo:  EXANTE LTD.
1 Fore Street,
England, +44 20 3670 9945
Versão 0.4.96
EXANTE Foi Designada a Melhor Plataforma Comercial de 2019

A revista Global Banking and Finance Review atribuiu à EXANTE o prémio "Melhor Plataforma Comercial 2019". A EXANTE foi reconhecida pela sua tecnologia pioneira e pela extensa oferta de ativos globais.