Saxo Bank rolls out new version of OpenAPI for Excel

Maria Nikolova

Version 1.3.0 introduces a couple of potentially breaking changes for users of the API.

Online trading and fintech services provider Saxo Bank has earlier this week released a new version of its OpenAPI for Excel.

Version 1.3.0 is the first major update since version 1.1.1 to introduce a couple of potentially breaking changes for users.

Trade functions are now deprecated and removed from the add-in. This important change comes on the back of developments in the market requiring applications with trade access to declare order types (manual or automated). The required changes are minor for most clients, and performance improvements can be expected when switching over from the now-deprecated trade UDFs. This change only applies to clients that use Excel to place trades.

With version 1.3.0, all UDFs in the “OpenAPI Trading” category have been removed from the add-in. To comply with requirements for algo trading tools, users on the Excel platform will have to construct orders ‘from scratch’ using the provided HTTP request functions in Excel:

  • OpenAPIPost() to create a new order, either to open a position or close an existing position.
  • OpenAPIPatch() to modify the details of an existing order.
  • OpenAPIDelete() to remove an existing order.

Except for OpenAPIDelete(), these functions require a body to be provided in the request, which contains the details of the order. This body has to be constructed separately in VBA and should include the required fields as specified by the /trade/v2/orders endpoint. The body is a string containing JSON-structured data.

The following UDFs will no longer be supported:

  • OpenAPIPlaceOrder()
  • OpenAPIEditOrder()
  • OpenAPICancelOrder()
  • OpenAPIAddRelatedOrder()
  • OpenAPIClosePosition()

Clients on earlier versions of the add-in will not directly be blocked from using these functions. It is advised to migrate timely, as new requirements for order placement will not be implemented for deprecated functions. These UDFs will stop working altogether once the requirements for order placement are enforced (planned Q3 2019).

Further, Saxo’s OpenAPI will soon be updated to require algo apps to provide an additional field in order requests indicating whether the order was generated automatically, or sent in manually by a user. The Excel add-in is classified as algo app, since it can be used to completely automate order placement through VBA.

The upcoming change, which is planned to go live during the third quarter of 2019, will block any order that does not identify its origin using the “ManualOrder” field. Orders without this field will be rejected, as it will constitute a hard requirement by the OpenAPI.

In practice, the only change required for current clients on OpenAPI for Excel will be to add the “ManualOrder” field to their order requests. Each individual order is required to have this flag set to either “true” for a manual order, or “false” for an automated order.

Read this next

Metaverse Gaming NFT

DCentral Miami brings together all of Web3, NFT, DeFi, Metaverse

The world’s biggest Web3 meeting entitled DCENTRAL Miami is set to take place November 28-29, featuring a lineup of some of the biggest and most influential names in the blockchain space.

Digital Assets

Crypto ban expands across UK banks as Starling joins ‎crackdown

UK digital bank Starling has banned ‎all customer payments related to cryptocurrencies, another blow for the crypto traders ‎who recently saw a sizable number of banks deciding not to ‎finance the wobbly asset class.‎


Markets Direct at FIA EXPO 2022: Traders know what they want from brokers

The FIA Expo 2022, one of the most prestigious events within the global derivatives trading industry, took place in Chicago on 14 & 15 November.


FIA Expo 2022: TNS addresses public cloud limitations with hybrid infrastructure

November is the month of the FIA Expo, one of the largest futures and options conferences in the world, bringing together regulators, exchanges, software vendors, and brokers in one place: the Sheraton Grand Chicago Riverwalk. 

Retail FX

Italy’s regulator blacks out Finance CapitalFX, MFCapitalFX

Italy’s Commissione Nazionale per le Società e la Borsa (CONSOB) has shut down new websites in an ongoing clampdown against firms it accuses of illegally promoting investment products in the country.

Retail FX

Suspected leader of Honk Kong ramp-and-dump scam appears in court

A leader of a sophisticated ramp-and-dump scheme made his first court appearance in a Hong Kong court today, charged with market manipulation and various criminal offences. The case stems from an earlier joint operation of Hong Kong’s financial watchdog, the Securities and Futures Commission (SFC), and the local police. 

Institutional FX

Cboe’s James Arrante discusses growing demand for fixed income, FX algo

We caught up with James Arrante, senior director of FX & US treasuries product and business management at Cboe Global Markets, to uncover emerging trends in the FX and fixed income markets and learn more about the bourse operator’s recent initiatives.

Retail FX

Eurotrader acquires UK broker Petra Asset Management

Eurotrader Group has formally entered into the UK market with the acquisition of FCA-regulated broker, previously named Petra Asset Management Ltd. The new entity operates under the brand name Eurotrade Capital Ltd.

Inside View, Retail FX

The Game of Chess Continues – OPEC, China and the Oil Market

Over the past decade, the US has been complaining about the amount of power which the BRIC group, and specifically China, has on the global economy. BRIC stands for Brazil, Russia, India and China; these were the world’s fastest growing economies. Only in the past 10 months, the US has turned their attention toward OPEC due to the prices of fuel. Nevertheless, China seems to have a strong influence even over the price of crude oil.