Latest version of Saxo Bank’s OpenAPI for Excel offers substantial speed improvements

Maria Nikolova

In particular, clients using the app in Asia are set to notice significant improvements in performance.

Multi-asset trading and fintech services provider Saxo Bank has rolled out a new version of its OpenAPI for Excel

The latest version of the solution (1.2.1) includes an important update to OpenAPI for Excel’s request/response performance that significantly increases the pace at which the add-in communicates to the OpenAPI. Saxo says that speed improvements of 50-75% can be achieved using this new version. In particular, clients using the app in Asia are set to notice significant improvements in performance.

The preceding version of Saxo’s OpenAPI for Excel, released less than a month ago, was enhanced with some useful features that were requested by Saxo API’s users. Updates include refresh options (to either refresh all OpenAPI formulas in the workbook, or just for the single sheet), fixes made to the trading functions in preparation of upcoming requirements, and a fix to properly handle data from OpenAPI endpoints that follow a non-standard data model (such as the AutoTrade endpoint).

Version 1.1.1 of the API, which was rolled out in April 2019, offered improved authentication flow, reverse-populating Formula Builder window, updates to trading functionality, improved data handling, and a long list of bugs resolved, that update marked a milestone with regards to the evolution of the solution.

Version 1.1.1 of the API made logging in easier. Instead of opening a side bar and resizing the Excel window, the login prompt now appears as pop-up. In addition, it runs a few quick checks before handing control back to the user to ensure a smooth transition into the app without hiccups.

Also, that version enabled the Formula Builder to be used in reverse, which means it has become extremely easy to adjust a formula quickly and pull out updates. Users have to select any part of the array that is returned on the sheet and click the Formula Builder button.

Finally, the User-Defined Functions (UDFs) that are included in the add-in got proper built-in documentation with correct naming and help URLs sending users straight to the Function Documentation section on this website.

Read this next

Executive Moves

Christine Kiener joins Saxo Markets UK as Head of Institutional Sales

“I have been very impressed by the strong track record, clear strategic pathway and ambition of the Saxo business. I am excited to start working with the team to further grow the institutional footprint which has been established in the UK.”

Industry News

CFTC charges Rathnakishore Giri with $12m Bitcoin ponzi scheme

“Identifying and policing fraud in these emerging markets may be difficult or delayed in light of the agency’s limited visibility in these markets”, said CFTC Commissioner Kristin Johnson.

Institutional FX

AbbeyCross raises $2.47m to develop FX market infrastructure for EM currencies

Many EM currencies are currently traded without full-price discovery, creating an unlimited compliance and regulatory risk.

Digital Assets

YouHodler enhances Multi HODL: faster rates and execution, lower fees

“We know some traders mentioned freezing issues when opening or closing a Multi HODL deal. Now, those problems are completely gone”.

Industry News

ASIC bans Funds United Pty director for six years

The six-year ban will prevent Ms. Hutchinson from controlling an entity that carries on a financial services business, and performing any function within the industry.

Inside View

Brave new world: Recruitment of fintech talent in the new UK immigration environment

In this article, solicitor Denise Osterwald outlines what UK businesses should do to attract top talent from abroad.

Digital Assets, Interviews

FX goes Crypto: Exclusive interview with BVNK’s Jonathan Cumberlidge

BVNK is the new name in the City of London. Co-founded by ex-TradFi Chris Harmse, Balfour Group founder Jesse Hamson-Struthers, and ex-TrueLayer George Davis, the firm provides a single platform to bridge fiat and crypto together. 

Digital Assets

AAX ranked world’s second largest spot exchange, only behind Binance

Crypto trading volumes experienced their first surge in activity since March as the majority of digital assets began their recovery from the recent grim price action, according to a new report by Cryptocompare.

Digital Assets

Bitpay teams up with Cardlytics to provide 15% cashback rewards

Crypto payment service provider Bitpay announced a partnership with Cardlytics Inc (NASDAQ:CDLX), which it says will offer more rewards for BitPay cardholders on its platform.

<