In the context of us shipping Open Banking functionality this quarter, I wonder what you think of an integration like this:
Being able to easily export my transactions and holdings to excel will be amazing
Love a good spreadsheet and the use cases mentioned on the plaid website are great too
I use Simply Wall Street, Webull, My Stocks Portfolio, my own spreadsheet, LSE and possible others. What would be really nice if everyone got together and agreed a common data structure for transactions with all applications having an import/export so portfolio data can easily be transported between systems to benefit from the different strengths of each without the need for manual entry into each platform.
Definitely agree with standardising how to import data. Iâve had to redo a few times when Iâve moved portfolios.
This would be a great solution for me.
I donât feel that Freetrade should provide a full-blown portfolio tracker in the app (apart from providing the basic stats of course).
Iâve also noticed that some third party trackers link with the broker via Plaid. E.g. Wallmine links with Robinhood via Plaid.
Itâs not mobile first. Excel is still very much a PC era baby so not seeing any relevance to FT
This would be amazing!
Excel is not free as far as I know, but API calls similar to Google Finance that can work with free apps such as Google Sheets or LibreOffice would be awesome. More hardcore users can then customise own dashboards if they want to get more out of the Freetrade experience. Itâs similar to what trading, risk, etc folks use in Excel alongside their dedicated Bloomberg Terminal - but without the complicated plugin. Also, Python API(s) would be cool but thatâs too exotic. Hoping that each call/âGETâ/etc request per user doesnât cost a lot in terms of AWS/GCP and other fees (Bloomberg puts a limit on those but itâs a $20k+ a year machine).
Most people I can imagine just want an app that just works.
For those that want a seamless in-app experience without the spreadsheets, a more useful dashboard in the app would be great too - simple looking at first with options to expand and customise by tapping on various options. Stake and Degiro have a lot of useful data that they show in a âgood-enoughâ way in their web/native apps that can borrow for the main dash and âinsightsâ.
Iâd rather it be able to link to other apps such as simply wall st or others mentioned and google sheets seems better for this sort of thing than excel which looks like you need a personal/family 365 subscription so even my work sub wonât work.
just the ability to export would suffice, even if itâs just to receive a weekly email export to save dev effort in the app, Iâm getting bored of having to input data manually all the time
Hey @Mani - did you finish your spreadsheet by any chance? Would love to give it a try if you wouldnât mind sharing the template
You can actually use Microsoft office apps web version for free, without a a 365 subscription:
- You can find it in https://products.office.com/en-gb/free-office-online-for-the-web
- They offer less functionality than desktop versions
Hope this helps
PS: the above it is not an affiliate link
Just been tinkering with the tracker. Added EPS P/E, Price change. Also now included Historic data.
Hey @Julian_Alany Iâm having a few problems with it because Iâm actually not that great with spreadsheets
I built it with a mixture of functions either looking to Google Finance or Yahoo Finance. The problem is, I have had to change the function/formula slightly for different stock types. I donât know how to get around the problem either. Coincidentally, I started to use Simply Wallstreet which is a great platform that does everything I need.
I tell you what, Iâll share the spreadsheet by tomorrow, on Google Sheets, and leave an explanation as to how it works (and doesnât!) and leave it to the spreadsheet wizards to evolve it to another level!!
Since weâve all been messing around with google sheets, I threw this together over the weekend.
Itâs a simple set of sheets to allocate funds by percentage. (will calculate yearly yields too)
Main sheet is to split funds by type, then a sheet for each type to split funds across holdings.
(greyed out cells are auto populated, instructions on sheets)
supports whole or fractional shares (change with dropdown on main page)
The rows in each ETF planner sheet are arbitrary, purely for example.
feel free to use and abuse, any feedback is much appreciated!
as usual, this is not advice, capital at risk, you all know the drill.
Just trying to keep the open source dream alive
(have never used google sheets before this, so itâs probably horiffically inefficient and wrong, but i had a good time )
ATTENTION ALL SPREADSHEET WIZARDS!!!
Right⊠firstly, my apologies for the delay in sharing this. Secondly, I never got around to finishing the spreadsheet after I discovered the Simply Wall St. platform.
I built the spreadsheet predominantly based on Google Finance formulas. I discovered a formula to pull dividend information from Yahoo Finance which youâll see in the spreadsheet. It doesnât quite work as well as I wouldâve liked. Youâll notice the pricing formula is different in the row where I have a US stock in comparison to UK stocks (for example).
The spreadsheet is a bit clunky and itâs pretty obvious Iâm a novice at this! Iâve taken it as far as I can. So, rather than holding onto this hoping Iâll find time to finish it⊠Iâve shared this with those who are interested in taking it to another level and perhaps sharing it in this thread later on. Iâm looking forward to seeing where people can take this!
Please open the link and âsave a copyâ to have your very own version in Google Sheets. Good luck!!
Thanks and enjoy
Nice. You could add Dividend Data too so you can see upcoming payments using the âdividendDataâ, âdividendExDateâ functions on the finkiAPI
This is great, thanks for sharing! Iâve now signed up. I canât seem to find a couple of stocks though- Mediclinic and Smith DS?
Added in your API. for other users, you will need to add your API key on the config tab.
Many thanks finki
Nice @Hydra_King
You can now use the âdividendExDateâ type functions rather than those needing prefixing with âukâ or âusâ. The new âdividendExDateâ, âdivdendPayDateâ etc. functions are faster and more accurate.