Saxo Bank releases Version 1.1.1 of OpenAPI for Excel

Maria Nikolova

The latest version of Saxo’s OpenAPI for Excel offers an improved authentication flow, reverse-populating Formula Builder window, updates to trading functionality and improved data handling.

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

Major updates have been pushed into version 1.1.1 to increase the capabilities and user-friendliness of Saxo’s Excel solution. With an improved authentication flow, reverse-populating Formula Builder window, updates to trading functionality, improved data handling, and a long list of bugs resolved, this update marks a milestone with regards to the evolution of the solution.

The latest version of the API makes logging in easier. Instead of opening a side bar and resizing the Excel window, the login prompt now appears as pop-up. In addition, it runs a few quick checks before handing control back to the user to ensure a smooth transition into the app without hiccups.

In addition, the Formula Builder can now be used in reverse, which means it has become extremely easy to adjust a formula quickly and pull out updates. Users have to select any part of the array that is returned on the sheet and click the Formula Builder button.

Also, the User-Defined Functions (UDFs) that are included in the add-in now have proper built-in documentation with correct naming and help URLs sending users straight to the Function Documentation section on this website.

On top of that, trading functionality has been upgraded to the orders/v2/ endpoints. As with all UFDs, the trading functionality now follows intelligible naming conventions and references within Excel.

The add-in now correctly handles complex data formats in JSON (JavaScript Object Notation) structures. For nested elements such as lists and dictionaries, the add-in will automatically create new rows of data to cover all possible data formats and correctly convert them to the 2D arrays which can be handled in Excel and VBA.

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.

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.

<