Saxo Bank’s OpenAPI for Excel set for more enhancements

Maria Nikolova

The developer team is considering a reverse-populating Formula Builder, which is useful for making changes to existing formulas in worksheets and reverse-engineering.

Multi-asset trading expert Saxo Bank continues to expand the functionality of its OpenAPI. OpenAPI for Excel, Saxo’s home-built Excel add-in that ports a broad range of OpenAPI functionality straight into Excel is set to enjoy more enhancements.

Some of the functionality that is currently being reviewed for future iterations of the OpenAPI for Excel add-in includes:

  • A reverse-populating Formula Builder, which is useful for making changes to existing formulas in worksheets and reverse-engineering.
  • Improved documentation within the add-in describing functionality of formulas in-depth and providing links to this developer portal for more information.
  • Improved authentication flow that is no longer reliant on a sidebar but instead loads the user’s default browser.
  • A brand-new ‘order builder’ tool which reduces complexity for writing order functions and prevents user errors.

One can find out more about the Saxo OpenAPI for Excel and submit feedback here.

The developer team has shed some light on Version 1.1.

For this version of OpenAPI for Excel, the Saxo developer team is aiming to professionalize the overall experience by introducing an improved login flow and changing UI elements to be more consistent. In addition, a new button is added to the OpenAPI ribbon, which displays detailed information on the version of the current add-in and incorporates links to the Developer Portal and other resources.

  • 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.

  • The ‘About’ button

To further improve user-friendliness and enhance the process of debugging, this version of OpenAPI for Excel will include a brand new button, labelled ‘About’. This button shows some basic information on the add-in, such as version number, release date, and resource links.

  • UI updates and bug fixes

To improve consistency across the add-in’s functionality, the Saxo developer team has reviewed the language, links, and other information to be consistent with the overall branding of the solution and general OpenAPI conventions. In addition, some minor bugs have been repaired, which crash Excel in edge-case scenarios.

Let’s recall that Version 1.0.0 of Saxo’s OpenAPI for Excel was released in August 2018. This first full release of Saxo’s OpenAPI for Excel included numerous enhancements to usability, especially for the Formula Builder, and ironed 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

Institutional FX

Robeco taps FlexTrade EMS to access Goldman Sachs pre-trade analytics

Broker-neutral technology firm FlexTrade Systems announced that its solution FlexTRADER EMS has been certified for integration with Dutch asset manager Robeco.

Executive Moves

B2C2 elevates Nicola White to CEO of US business

Cryptocurrency market maker and liquidity provider, B2C2 has elevated Nicola White to take an expanded role as CEO of its US business.

Executive Moves

Invast Global promotes Riana Chaili to head EMEA business

Sydney-based prime-of-prime provider Invast Global has once again made a key appointment to its executive personnel group, this time promoting Riana Chaili to head its EMEA business.

Retail FX

CySEC sounds regulation alarm on Sharesforextrade, GoldenShare and LevelProfit

The Cyprus Securities and Exchange Commission has once again stepped up its fight against unauthorized brokers.


Satellite Imagery Analytics: A Helping Tool For Financial Institutions

EOS Data Analytics provides agri-banks with satellite monitoring solutions to streamline loan risk assessment

Digital Assets

MultiBank’s cryptocurrency arm rebrands as

MultiBank Group, which is in the midst of developing a “one-stop—shop” for cryptocurrency, has unveiled the new brand identity of its blockchain and digital assets arm.

Digital Assets

Frank McCourt’s crypto startup taps Polkadot to disrupt social media

Project Liberty, which leverages blockchain technology to democratize social media data, is joining forces with Polkadot to collaborate on the first implementation of the Decentralized Social Networking Protocol (DSNP).

Digital Assets

t3rn launches Smart Contract Hub Testnet on Rococo

t3rn, a cross-chain smart contract hub for Polkadot, has deployed its testnet parachain on the network’s primary testing bed, Rococo. Named t0rn, the network is now plugged into the rest of the ecosystem’s parachain testnets.

Interviews, Metaverse Gaming NFT

Exclusive interview with Play-to-Earn pioneer Shaban Shaame on gaming and NFTs

Spells of Genesis (SoG), generally regarded as the very first play-to-earn blockchain game, marked its fifth anniversary by opening a virtual NFT history museum.