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

Retail FX

ThinkMarkets expands CFDs lineup to over 4000 ETFs and shares

ThinkMarkets has expanded its service offering by incorporating 2500 new CFDs on shares and ETFs on its ThinkTrader platform.

Retail FX

France regulator warns investors of Omega Pro,

France’s financial markets regulator alerted investors that scams related to Omega Pro Ltd are beginning to circulate, with the blacklisted firm capitalizing on the situation to run a range of “unrealistic” offers.

Digital Assets

Web3 platform Grand Time paid $2 million in token earnings to date

Community-driven Web3 platform Grand Time said its offering – which includes a multifaceted platforms and its native token – has been gaining significant traction highlighted by impressive operational metrics.

Institutional FX

FX volumes at MOEX halved in April as ruble gains gorund

Currency trading at Moscow Exchange (MOEX) halted its upward route in April as monthly volumes nearly halved from a month earlier.

Digital Assets

FTX US adds stock trading, fractional shares to crypto platform

FTX US, the American subsidiary of crypto exchange FTX has kicked off stock trading feature to its customers in an effort to compete with popular platforms such as Robinhood and eToro.

Industry News

UK FCA empowered to remove brokers’ permissions in 28 days

Businesses with permissions they don’t need or use, risk misleading consumers. These new powers will enable us to take quicker action to cancel permissions that are not used or needed.

Industry News

CFTC charges $44m Ponzi scheme but millions may have fled to foreign crypto exchange

The CFTC alleged that defendants transferred millions of dollars to an off-shore entity that, in turn, may have transferred funds to a foreign cryptocurrency exchange. None of these funds were returned to the pool.


Saxo Bank deploys Adenza to address Basel and EBA requirements

The integration of ControllerView will enhance Basel-driven capital calculations and reporting at Saxo Bank in support of the bank’s multijurisdictional capital and liquidity reporting requirements throughout Denmark, Switzerland and UK, with plans to expand into the Netherlands.

Executive Moves

ComplySci appoints CTO, CPO, and CLO to further regtech’s product expansion

ComplySci offers compliance software used by more than 1400 global institutions to identify risk and address regulatory compliance challenges.