You must be expert in handling Rest api.
Make an wrapper for api [login to view URL]
To make it work in google spreadsheet using google app scripts. You should have used google app scripts in past and stong in java scripting.
I want to access all functions of the API and data in a google spreadsheet. Like get live data , orders, holdings for multiple symbols together. Place modify cancel orders.
Various function available in api be provided as google app script functions so that i can call them in spreadsheet.