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

Inside View

Industry Leaders Share Insights on Framing Crypto Payments into FX Brokerage Business

While the allure of crypto payments is strong, caution is essential. The potential benefits in terms of speed, lower fees, and blockchain efficiency need to be weighed against the risks associated with cryptocurrency volatility. 

Institutional FX

FXSpotStream volumes hit 14-month high in November

FXSpotStream’s trading venue, the aggregator service of LiquidityMatch LLC, reported its operational metrics for November 2023, which moved higher on a monthly basis.

Digital Assets

Circle denies ties with Palestinian groups, TRON founder

Stablecoin issuer Circle has denied allegations that it facilitates funding for terrorist organizations.

Retail FX

CySEC hits operator of Titanedge, TradeEU with €90,000 fine

The Cyprus Securities and Exchange Commission (CySEC) announced that it has imposed a fine of €90,000 on Titanedge Securities Ltd due to shortcomings in their regulatory obligations.

Institutional FX

Cboe FX volumes retreats slightly in November 2023

Cboe’s institutional spot FX platform today announced its trading volume for the month ending November 2023, which took a step back after a strong rebound in October.

Institutional FX

Alpha Group seals Cobase majority acquisition

Foreign exchange service provider Alpha Group International plc (AIM: ALPH) has finalized its acquisition of Financial Transaction Services, operating as Cobase.

Digital Assets

TMNG Tokens Successfully Listed on MEXC Crypto Exchange

TMN Global proudly announces the successful listing of its native TMNG token on the MEXC crypto exchange, effective December 1st, 2023. This strategic partnership marks a significant milestone for TMN Global in the crypto space.

Institutional FX

Marex completes acquisition of TD Cowen’s PB business

London-headquartered commodities broker Marex has completed the acquisition of TD Cowen’s prime brokerage and outsourced trading business, which will be integrated into Marex’s capital market division. This division was established following the acquisition of ED&F Man Capital Markets in 2022.

Digital Assets

Talos introduces decentralized liquidity and onchain settlement with Uniswap and Fireblocks

“At the cornerstone of the DeFi ecosystem, Uniswap has the breadth of assets and depth of liquidity that institutional traders need. And to have this partnership powered by Fireblocks, a digital assets infrastructure provider trusted by some of the most renowned institutions, is very fitting.”