Saxo Bank releases Version 1.1.1 of OpenAPI for Excel

Maria Nikolova

The latest version of Saxo’s OpenAPI for Excel offers an improved authentication flow, reverse-populating Formula Builder window, updates to trading functionality and improved data handling.

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

Major updates have been pushed into version 1.1.1 to increase the capabilities and user-friendliness of Saxo’s Excel solution. With an improved authentication flow, reverse-populating Formula Builder window, updates to trading functionality, improved data handling, and a long list of bugs resolved, this update marks a milestone with regards to the evolution of the solution.

The latest version of the API makes 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.

In addition, the Formula Builder can now 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.

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

On top of that, trading functionality has been upgraded to the orders/v2/ endpoints. As with all UFDs, the trading functionality now follows intelligible naming conventions and references within Excel.

The add-in now correctly handles complex data formats in JSON (JavaScript Object Notation) structures. For nested elements such as lists and dictionaries, the add-in will automatically create new rows of data to cover all possible data formats and correctly convert them to the 2D arrays which can be handled in Excel and VBA.

The first full version of Saxo’s OpenAPI for Excel was released in August 2018 offering numerous enhancements to usability, especially for the Formula Builder, and ironing out a couple of inconsistencies that affected earlier versions such as uninformative error messages. The version was re-released version in December 2018 when it was signed with a fresh certificate (valid until November 30, 2020) to prevent errors from the Microsoft Excel Trust Center.

Read this next

Digital Assets

Zero Hash obtains AUSTRAC registration in Australia

Seed CX is expanding the reach of its crypto settlement solution, dubbed ‘Zero Hash,’ which has registered with the Australian Transaction Reports and Analysis Centre (AUSTRAC) as a digital currency exchange provider.

Digital Assets

UK advertising watchdog slams Arsenal over misleading crypto ads

The UK advertising watchdog has reprimanded Arsenal Football Club for promoting crypto assets without warning fans of the potential associated risks.

Retail FX

Swissquote profit slips as crypto revenue falls by two thirds

Swissquote Group, Switzerland’s provider of online trading services, reported that its H1 revenues dropped by nearly a quarter from a year ago as clients’ interest in crypto trading stagnated.

Digital Assets

Crypto.com granted approval to operate business in Cayman Islands

Crypto.com, one of the longest-established crypto platforms, has obtained a new registration in the Cayman Islands under the Virtual Asset Services Providers Act.

Executive Moves

United Fintech hires Mitch Vine and Danny Finnerty to expand US footprint

“United Fintech’s expansion in the US is pivotal to our mission of helping financial institutions digitize and gain access to best in class capital markets focused technology.”

Digital Assets

Ankr backed by Binance Labs after several initiatives in support of BNB Chain

Ankr has made a series of upgrades to the BNB Chain, including Erigon, the Archive Node, and the latest BNB Application Sidechain (BAS) scalability solution.

Retail FX

Financial Commission terminates membership of LordFX

The Financial Commission, an independent self-regulatory compliance specialist for the financial services industry, has expelled forex brokerage LordFX from its membership, according to a FinaCom statement.

Industry News

Match-Prime Liquidity sponsors Cypriot football club Omonoia FC

“We feel privileged to support Omonoia as it’s one of the largest teams in Cyprus, fandom size-wise, and we know it has a special connection with its supporters.”

Institutional FX

XTB’s X Open Hub adds 30 cryptos to white label offering for brokers

Its solutions include deep institutional liquidity on more than 5,000 global instruments, such as indices, shares, forex, cryptocurrencies, commodities, and ETFs, and a white label platform that can be fully customized and branded for each brokerage.

<