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

Industry News

Bursa Malaysia introduces Trading Reminders

The Trading Reminder flag aims to alert investors to exercise caution when encountering a stock displaying persistent unusual price and/or volume movements after the listed company’s UMA response.

Industry News

21 Republican representatives want to “End the Fed”

“Americans are suffering under crippling inflation, and the Federal Reserve is to blame.”

Retail FX

Scope Markets launches unleveraged trading

“Whilst our traditional contract for difference (CFD) products continue to prove incredibly popular, the Invest account is unleveraged and only allows ‘long’ positions to be taken, a combination that significantly reduces the risk of capital losses.”

blockdag

Unlocking Profit Potential: Earn Returns with DecodeEX Experience Bonus!

DecodeEX, the innovative brokerage subsidiary of Decode Global, announced its experience bonus campaign, offering every user the opportunity to maximize their strategic trading potential with up to $10,000 in experience bonus. 

Market News

Pretiorates’ Thoughts 28 – Precious metals and base metals out of control

Ten days ago we mentioned in Pretiorates’ Thoughts 26: Chapter 2 should start with Precious Metals.

Retail FX

Webull launches discount brokerage in Malaysia

“Making investing more inclusive and accessible to all, Webull Malaysia brings best-in-class tools and information to empower investors of all levels with knowledge and skills to help them make better investment decisions and achieve their investment goals.”

Digital Assets

Hidden Road adds OKX’s Nitro Spreads into prime brokerage

“Hidden Road continually seeks to increase market access and capital efficiency through expanded prime brokerage offerings. Integrating OKX’s Nitro Spreads product builds upon this philosophy by extending our counterparties’ ability to execute risk-managed arbitrage strategies.”

blockdag

Dev Release 31: BlockDAG’s SHA-3 Upgrades Propel Crypto Mining Innovation as Miner Sales Approach 5800 Units

Learn about BlockDAG’s 31st Development Release, which includes advanced SHA-3 updates and a significant increase in miner sales, driving advancements.

blockdag

BlockDAG Dominates 2024 Crypto Trends: Surpasses $28M in Presales Amid Strategic Partnerships

Explore BlockDAG, Shiba Inu, and Kaspa Killer’s rise in 2024’s crypto market, focusing on BlockDAG’s $28M presales, strategic partnerships, and innovative technology.

<