top of page

Bulk operations from Excel

Front Office teams sometimes need to capture multiple trades at once from Excel spreadsheets. Operations teams may have to move a set of transactions to a new book or unwind a list of trades, all in one go.

 

Datascade acts as a bridge between Excel and a trading system: it converts the arrays of data contained in Excel into the specific format required by the trading system API.

​

In the following example Datascade calls a trading system REST API to import trades prepared in a spreadsheet.

Traders are free to structure their spreadsheet in the way they want. When they click the "Upload" button, the data is sent to a Datascade spreadsheet.

From that point each line in the spreadsheet will be reformatted in XML (something Datascade does easily) and sent to the REST API:

The trading system will then reply with a trade number which is sent back to the spreadsheet by Datascade:

The benefits of using Datascade as a bridge between Excel and a trading system are:

  • ease of maintenance

  • quality assurance (code versioning in Git)

  • security and audit trail

​

Back to the list of finance use cases

​

bottom of page