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

Eurotrader taps MahiMarkets’ cross-asset trading technology for pricing and risk management

Eurotrader has tapped MahiMarkets’ cross-asset trading technology to manage its pricing and risk management on its fully licensed and regulated retail brokerage operation covering forex, stocks, indices, and commodities. 


STT doubles user base as Sterling OMS adopted by TradeZero, Avenue, Banco C6

Sterling Trading Tech (STT) has announced record growth of its order management system (OMS) offering, doubling its user base throughout the second half of 2022.

Retail FX

CMC Invest announces flexible stocks and shares ISAs amid changes in UK policy

In addition to a flexible ISA, the Plus plan provides members with a USD currency wallet for their general investment account (GIA), alongside the default GBP wallet that comes with all CMC Invest accounts. This means users will hold both a GBP wallet and a USD wallet. Saving customers money on FX fees.

Executive Moves

The Trading Pit snatches Skilling Daniela Egli from Skilling to lead Cyprus operation

“We feel privileged to have Daniela join The Trading Pit and bring her extensive expertise to our prop trading firm. We are confident in The Trading Pit’s ambition to provide the ultimate global trading environment for talented traders to enhance their skills and eventually become professional fund managers.”

Industry News

Worldpay taps SheerID to allow merchants to better target their audiences

SheerID verifies over 2.5 billion people via 20,000 authoritative data sources; provides global insights from hundreds of the world’s leading brands, and never shares or sells customer data.

Crypto Insider

Cardano (ADA) Price For 2022-23: Buy Cardano With NAGAX

Cardano (ADA) is probably one of the most renowned and well-known cryptocurrencies out there at the moment and is currently available on the majority of the crypto exchanges and platforms in the market.

Retail FX

ACY Securities recognized by Salvation Army NSW for its support to charity work

““Sitting in the backyard of those family friends, to see the devastation the floods had brought, was a real eye-opener, and a testimony to the Salvos who were on the ground helping every one of those in need during the recent NSW floods.”

Executive Moves

BNP Paribas announces senior executives of Global Markets Americas division

French bank BNP Paribas has appointed several senior executives to its Global Markets Americas division, demonstrating its ambition to grow its Global Equities, Global Credit, and Global Macro franchises in the region. 


Match-Trade expands partnership with Takeprofit Tech

California-based FX technology provider Match-Trade Technologies has expanded its partnership with fintech software developer Takeprofit Tech.