Login Page - Create Account

Support Board


Date/Time: Wed, 08 May 2024 11:52:45 +0000



Post From: Getting the Account Balance from Interactive Brokers into SC spreadsheet

[2014-08-06 14:43:23]
CarlRostron - Posts: 80
I am trying to use a Sierra Chart Spreadsheet and automatically get the Balance of my Interactive Brokers Account to put into my SC spreadsheet. The reason for this is because I use some extensive Money Management algorithm and I always need to keep track of my latest Account Balance in Interactive Brokers in all of the currencies that are in the Account.

I use these balances to automatically establish how much I have in my home currency (GBP) in real-time using the SC exchange rates in the spreadsheet.

The problem I am having is working out how to get my Interactive Brokers Balances (in the multiple currencies) into a SC spreadsheet?

I can also use ASCIL if this will help if you can point me in the right direction?

Regards and thanks