I would like to get real time (read only) data from my IB account into Google Sheets, mostly for portfolio tracking purposes. I tried a lot of things already:
I am aware I can replicate a portfolio in Google Sheets, but that’s not good enough for me
you can get it work with a local Java client, but I don’t like that
you can get a daily “flexquery” csv import (I have that, it’s just not real time)
there is a web flex query gateway, but it’s only updated 1x per day
there is a Yahoo Finance integration, I could scrape the data in real time from there
Does anyone have a better idea, or maybe a 3rd party tool they use?
I wonder what is not good enough with that?
Googlefinance function is quite rich, should be able to cover whatever IB provides you (daily, total P/L, etc.)
Yes it may have up to 5min delay, but so does the official IB mobile app - I don’t see it as a terrible issue.
It’s a good question! I have lots of exotic stuff at IB (puts, small cap values, short ETF etc) that I haven’t found in Google Finance. Unless I am missing something there? I assume there is no way to query the IB database via Googlefinance, correct?
Hi, I’m late to this chat but I’ve got the same issue trying to view my IBKR data from Google Sheets as Thurston. I reached out to www.movinglake.com which seems to use some kind of connector between IBKR and Google Sheets; anyone have any luck with them or any other solution?
1 Like
By reading and partipating to this forum, you confirm you have read and agree with the disclaimer presented on http://www.mustachianpost.com/
En lisant et participant à ce forum, tu confirmes avoir lu et être d'accord avec l'avis de dégagement de responsabilité présenté sur http://www.mustachianpost.com/fr/
Durch das Lesen und die Teilnahme an diesem Forum bestätigst du, dass du den auf http://www.mustachianpost.com/de/ dargestellten Haftungsausschluss gelesen hast und damit einverstanden bist.