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

Retail FX

The Funded Trader is back? Traders report account closures

Prop trading firm The Funded Trader has updated its website with a few banners, nearly three weeks after it ceased all operations, with claims for a relaunch in the near future. However, there was no official statement on the relaunch on its website, Discord channel, or social media accounts yet.

Executive Moves

NAGA lures former Tickmill compliance exec Loukia Matsia

NAGA Group, a provider of brokerage services, cryptocurrency platform NAGAX and neo-banking app NAGA Pay, appointed Loukia Matsia as their new Head of Compliance and Anti-Money Laundering (AML).


Explore 2024’s Top Cryptocurrencies: BlockDAG Leads With 30,000x ROI Potential, Among Surge Predictions For Bitcoin And Ethereum

Navigating the vast ocean of cryptocurrencies might feel overwhelming for many investors, whether seasoned or newbies.

Tech and Fundamental, Technical Analysis

EURUSD Technical Analysis Report 18 April, 2024

EURUSD currency pair can be expected to fall further toward the next support level 1.0600 (which reversed the price earlier this month).

Digital Assets

Binance ordered to remove Changpeng Zhao to get Dubai license

Binance, the world’s largest cryptocurrency exchange, has obtained a Virtual Asset Service Provider (VASP) license in Dubai.

Crypto Insider

Evolution and current state of global crypto adoption

Every four years, the crypto world gets hyped for the Bitcoin halving. Past halvings, like the one of May 2020, saw a massive increase in BTC transactions, which was driven by growing adoption and community involvement.

Digital Assets

Binance set to re-enter India with $2 million fine settlement

Binance, the world’s largest cryptocurrency exchange, is preparing to re-enter the Indian market after agreeing to pay a $2 million fine, according to a report by the Economic Times.


Over 1,000 Builders, Partners, Investors and Enthusiasts Gather at Inaugural Global Event to Celebrate Sui

Last week in Paris, over 1,000 blockchain enthusiasts from 65 countries gathered at the inaugural Sui Basecamp during Paris Blockchain Week. This milestone event showcased major announcements and drew a global community, highlighting Sui’s impactful strides in blockchain technology.


Powered by Qualcomm, Aethir Unveils Game-Changing Aethir Edge Device to Unlock the Decentralized Edge Computing Future

Aethir, in collaboration with Qualcomm, unveils Aethir Edge, the pioneering authorized mining device. Integrated with a distributed cloud network, it offers advanced edge computing, decentralized access, and exclusive rewards. Dive into the decentralized future with Aethir Edge and unlock new dimensions in computing.