Thank you that’s exactly what I was looking for. Too bad new new URL is already not working… For reference the new URL now looks something like that (replace the ISIN with the one you are interested in):
One question, how do you get a csv of your transactions from IB to enter into Exirio?
Really liked the solution since there are random things that I like to track like watches, bonds that aren’t listed, etc and I liked the flexible to input “current value”
You probably solved it already but for others that follow this thread, use
=VALUE(muFunds(“nav”, $F2))
Where F2 contains ISIN
If you are using Morningstar ID of the fund then you use ‘morningstar-ch’ in the query as you did. But I found that to be finicky and throwing errors frequently.
I’m lazy and boring.
So I just make my yearly tax return - and then add the balance of my retirement accounts.
(I actually haven’t found a convenient and easy-to-use portfolio tracking tool that would let me track at least my IBKR account completely. My canton’s tax software seems almost the easiest one)
Parqet may do what you want. You can import ibkr data that you create with a flex query. They have a tutorial how to do it and once set up, it‘s just a few clicks to export and then import the data.
Most recent one I tried.
Felt quite convenient and nicely designed.
Failed to import some Japanese stocks - one of which that seems to be a constituent of the MSCI Japan Index (which I could add manually - but they don’t provide any price updates since 2022).
How relaxed are other people about, during plugin installation, clicking yes to “this plugin can read all your google sheets, change them all and delete them all”?
I just don’t feel “safe enough” to do that.
Firstly I have a personal data (yes, I know google is reading it) which I like to limit spread of, and secondly I don’t like the possibility of it all being gone.
Am I being neurotic? What could go wrong?
Any tips on how to limit plugin rights, or at least limit the extent if something “goes wrong”.
Since end of November last year these CSV exports are not updated anymore (no new NAV price although the URL is still valid). Does anyone know if there is a new source to get this information programmatically?
Thanks for the tip. At least Yahoo Finance has historical data but didn’t find any download links. To be more precise I am looking for a direct download link (CSV, XML, JSON, etc) where I can parse the data with Python code for example.
Mit dem Lesen und der Teilnahme an diesem Forum bestätigst du, dass du die Forum-Richtlinien gelesen hast und damit einverstanden bist sowie den Haftungsausschluss auf http://www.mustachianpost.com/de/ akzeptierst.