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

Banxso announces 8.7% interest rate on deposits in South Africa

“With Banxso, they can enjoy the benefits of both worlds – earning competitive interest and having the freedom to trade, all within the same platform.”

Industry News

FINRA to publish transaction details in U.S. Treasury securities

“Consistent with our longstanding practice, FINRA is introducing greater transparency in a calibrated and careful manner, benefiting liquidity and resilience in this critical market while also mitigating potential information leakage concerns.”

Institutional FX

OpenYield launches “cheap and easy” fixed income trading for brokers

“We’re on a mission to make bonds cheap and easy to trade, and are excited about the opportunity to build generational capital markets infrastructure.”

Digital Assets

Sumsub and Mercuryo publish a guide for VASPs: “Mastering Travel Rule Compliance”

“At Sumsub, we’ve concentrated our efforts on filling the gap in understanding the complexity of Travel Rule regulation and helping organizations find the best solution to stay safe and compliant while minimizing costs and avoiding potential risks of non-compliance. This guide we created with Mercuryo, our trusted partner, is the ultimate navigation tool all VASPs can consult.”

Digital Assets

Bitget Wallet Leads with Record Swap Volume & New Crypto Innovations

This week, Bitget Wallet achieved a milestone by surpassing Metamask with a record 388,757 Swap order transactions, securing the global lead. The significant 7-day trading volume, almost 68,000 more than its rival, underscores its liquidity and user trust. This robust activity signals Bitget Wallet’s prominent role and reliability in the dynamic crypto market.

Digital Assets

Embarking on a Digital Currency Journey

Imagine you’ve stumbled upon a treasure map, leading you to untold riches hidden in the vastness of the internet. Instead of gold coins and jewel-encrusted goblets, this treasure comes in the form of digital currencies, the modern-day loot coveted by many.

Reviews

Traders Union Experts Share The Trading Analyst Review For 2024

Navigating options trading in rapidly shifting markets poses a considerable challenge. This is where options trading alert services become invaluable. They aid traders in keeping abreast of evolving opportunities and market trends. In this assessment, Traders Union experts scrutinize The Trading Analyst alert service to ascertain its efficacy. 

Digital Assets

BlockDAG’s Presale Achieves $9.9M: Aiming For A 5000-Fold ROI As Cardano’s Price Rises And Fantom Launches Sonic

Explore Cardano’s surge, Sonic’s efficiency, and why BlockDAG’s growth makes it the top crypto choice. A deep dive into the future of blockchain investments.

Digital Assets

US, UK probe $20 billion Tether transfers tied to Russian exchange.

U.S. and UK authorities are investigating the movement of $20 billion in the USD-pegged stablecoin tether (USDT) through Moscow-based exchange Garantex.

<