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

Kraken exits Middle East, closes UAE office

Digital currency exchange Kraken will close down its operations in Abu Dhabi, UAE and lay off the majority of its team focused on the Middle East and North Africa.

Industry News

CFTC comments on ION Cleared Derivatives issues after Russian-linked hack

“The ongoing issue is impacting some clearing members’ ability to provide the CFTC with timely and accurate data. As this incident unfolded, it became clear that the submission of data that is required by registrants will be delayed until the trading issues are resolved.”

Industry News

FCA took down 14 times more misleading ads in 2022 thanks to technology

The FCA has made significant improvements to the digital tools it uses to find problem firms and misleading adverts. These improvements have enabled it to work through a much larger number of cases compared with 2021.

Executive Moves

HKEX appoints ex-Goldman Sachs Matthew Cheong to lead platform’s focus on derivatives

“He has worked for a number of the world’s leading investment banks and his experience will be invaluable to HKEX as we continue to enhance our derivatives product offerings and build on our innovative and robust platform business, connecting capital with opportunities.”

Digital Assets

Zodia Custody and SBI Digital Asset Holdings launch JV for crypto asset custodian in Japan

“Zodia Custody is both proud and excited to be working with SBI DAH to help set up SBI Zodia Custody; the first tier 1 crypto asset custodian for institutions in Japan.”

Digital Assets

Paxos opens R&D center in Israel to focus on transaction signing and crypto custody security

“Paxos is looking to expand its team in Israel in 2023 and beyond, giving engineers the opportunity to work on cutting-edge financial products and shape the future of the global economy.”

Executive Moves

Stash appoints Liza Landsman as CEO to further grow investing app

Stash is an investing and banking app with over 2 million active subscribers. Its subscription plans start at just $3 a month, and offer a range of products including investing, banking, education, and advice.

Institutional FX

Invast Global ramps up its offering with 10 soft commodity CFDs

Sydney-based prime-of-prime provider Invast Global has expanded its offering with the addition of ten soft commodity CFDs, which increases their index and commodity CFD offering to 35 instruments.

Retail FX

FF Simple and Smart Trades says Goodbye to CySEC authorization

The Cyprus Securities and Exchange Commission (CySEC) confirmed that it has wholly withdrawn the Cyprus Investment Firm (CIF) licenses of FF Simple and Smart Trades Investment Services Ltd.

<