Saxo trading in Excel
The OpenAPI plugin for Excel works both as a supplement to the SaxoTraderPRO platform and as a complete stand-alone solution. Use it to create your own custom workspaces with native VBA and excel functionality.
OpenAPI for Excel makes it possible to create a custom trading experience unhindered by the restraints of a platform. OpenAPI for Excel includes the ability to send automated bulk trades, conduct automated hedging, trade on algo output, trade at specific times based on dynamic data – and much more.
OpenAPI for Excel lets you trade specific times based on dynamic data, bulk trade on behalf of multiple clients or accounts, get access to real time data on positions, orders and balances directly in Excel for reconciliation purposes or risk monitoring – and much more.
If you are new to Saxo you can test the solution in our demo environment for up to one month. If you are already a client with us you can get a ‘view only’ access (trading disabled) to your live account free of charge.
Already a client?
You can use your existing account in view only mode (non trading access) together with OpenAPI for Excel.
As a Saxo client to be enabled for trading in OpenAPI for Excel you need to be a Platinum or VIP client and submit the below documentation to your account manager.
Please note that certain requirements need to be met in order to trade non-FX products due to exchange regulations and that Saxo reserves the right to reject or revoke access to trading in OpenAPI for Excel at any point. Read more about our terms and conditions.
Get started with Saxo’s OpenAPI plugin by using or building on our ready-made Excel templates. Each template is designed to serve as inspiration and a demonstration of the countless possibilities for customization.
For instructions on how to use and setup the excel plugin itself, please refer to our user manual here.
The OpenAPI for Excel Example sheet contains a selection of tools and views allowing you to get started with trading from Excel. The sheets gives you access to trading, FX price data and position management. All the underlying code is exposed allowing you to further tailor the Excel sheet to your liking.
FX Spot ladder
The FX spot ladder allows you to calculate and visualize your exposure and P/L at different prices given your current positions and pending orders. Simply input an FX pair and press refresh. It is also possible to simulate and even place orders directly from the sheet.
The timed orders sheet showcases how orders can be timed for placing at a specific time given certain conditions. This allows you to place orders when you are away from the computer and removes the human element from your trading.
"Who can benefit from this tool?"
All operations are formulated and executed in Microsoft Excel using native functionality requiring a high level of proficiency. This tool is generally intended for advanced traders or professional fund managers.
"Which market data is available? "
Via the API plugin, you can stream real-time data for more than 200+ forex pairs.
"How can I enable my account for trading via the OpenAPI Excel plugin? "
Both demo and live accounts are able to access real-time data on positions, orders and balances by default. Placing trades and orders via Excel is likewise enabled by default for demo accounts, but requires approval before being enabled for live accounts. You can request having your live account enabled for live trading via the plugin by contacting your account manager.
"Do I have to close down my trading platform to run the Excel plugin? "
No, the OpenAPI excel plugin enables you to work in Excel while simoultaneously being logged in to the SaxoTraderPRO platform.
Didn’t find what you were looking for?
Visit the complete introductory guide here.