Saxo Bank rolls out new version of OpenAPI for Excel

Maria Nikolova

Version 1.0.2 tackles a number of issues reported by API users and includes fixes for bugs and minor improvements, primarily concerning subscription functionality.

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

Version 1.0.2 tackles a number of issues reported by users and includes fixes for bugs and minor improvements under the hood, primarily concerning subscription functionality.

  • Enhancements

Log file link added to About box – The debugging experience is enhanced as the log file can now be opened straight from Excel by opening the About box.

System requirements check – If .Net Framework is not installed on one’s machine, the add-in will show a warning message.

  • Bug fixes & improvements

Stability of streaming functionality is improved. This should prevent streaming data from being interrupted.

Streaming functions restart properly when re-opening a spreadsheet that contains subscription functions.

Updates to logs to improve relevance and consistency.

Version 1.0.2 was released several days after the rollout of version 1.0.1 of the API. It included an UI update, along with a new functionality in the form of an About button, with helpful links to the developer portal and the version number of the add-in.

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.

The list of upcoming changes includes upgraded login flow. In the current setup, OpenAPI for Excel authenticates with Saxo Bank through a web page that is loaded on a side panel in Excel, which in turn uses Internet Explorer 9 to render the login page functionality. This requires a recent version of Internet Explorer (9 or higher). In order to eliminate this requirement altogether, version 1.1 will incorporate a completely independent authorization flow, which is sent through the user’s default browser. Security benefits and user experience are improved through this process, as the login is no longer dependent on (old) Internet Explorer software.

Saxo’s Developer Portal provides more information about Saxo Bank’s APIs.

Read this next

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.

Crypto Insider

Shining the Light in Crypto’s Dark Places

Something changed in regulators’ minds after the November crash of the FTX crypto exchange.

<