Is there a site or tool that can have a list of etfs put in and come out with a visual representation of the total holdings and overlaps by company and nation etc?
Like if you held a msci world etf and an s&p500 and a Nasdaq etc it would show you the over lap from companies such as apple that are in all based on your individual weightings?
Or is it a case or youāll have to go to each etfs site/holdings list copy all of them into a spreadsheet and then set up a formula to calculate it from your weighting?
That sounds like an interesting tool. If there is a site that has data available showing names of holdings, percent of those holdings in the ETF, country of holding etc., I wouldnāt mind putting together some kind of interactive dashboard as a personal project.
It could be doable to put together a dashboard using R and RShiny or Python and Plotly.Dash
It could even be done in Tableau or Power BI and hosted online.
The only issue I can see is finding a website which houses all this data. Scraping it from the site or connecting to the service via an API would be doable. Putting together the dashboard would be the fun part then.
Yeah I was thinking if you just copied the holdings data from say blackrock/vanguard sites it would all be in differnt formats and manually sorting through 1000ās of stocks and putting them all in the same format every rebalance could be a nightmare
Itās that I only serve it up on a āunderlying holdingā basisā¦and quite slowly! Intentionally. Because, as youāve kinda found, it potentially has great commercial use if any broker wants to consume the data and feed their app on behalf of their clients - ie, you guys! Ask
T212 to get in touch! Itās available in a super fast API ā¦to integrate into the app
ā¦ but the database is there and ready to queryā¦ if I made it public!!!
Every U.K. ETF, Every holding , every %
Sorry bit confused youāve already scrapped holding data for all UK etfs and are updating it as they rebalance as a solo project?
How did you go about doing it? Because like you say it has commercial use Iām surprised if itās possible to do it and keep up to date as a one man team that t212 and similar apps arent all doing it
Tbh my thinking was more that it would need a commercial enterprise
Yes. Done it. Donāt be confused - it just takes a bit of effort. Can grab it daily. The transformation of displayed name to actual
Stock is painful if provider doesnāt state it, but , hey ho. One man team. A few synthetic ETFs are error prone but the rest are easy. Feed the dB. Query from the dB. Yes, everyone can do it. Question, as with every little micro service, is do you want to? If someone else does it already and faster, better, maybe cheaperā¦
Yeah I know what youāre saying but it does seem this service doesnt exist theres there morning star xray but it seems plagued with problems. So you might have the basis for an actual product. I mean if you actually got some backing Iām sure it would be possible to have many of the major etfs provide you with a more readily accessible holdings list?
Had a look through your site and Iāll probbaly be using it to have a look which etfs hold a specific stock (actually not something Iād thought of before your site so great feature!)
Who do I need to @ @trade212 to get them to throw money at you for the api
They really need my ISA API that live assesses every Assetās eligibility for holding in an ISAā¦ it flagged NIO and the like as ineligible months agoā¦ and it still flags errors on t212 asset universe todayā¦
Lots of good stuff at Finki that the new age brokers could utilise!!!
ETF search output is intentionally slow, limited and a few days out of dateā¦ but feel free to play with itā¦ it works on a per stock basisā¦ most people get confused and search for an ETF upfrontā¦ you search , for example , by TSLA not IUKD or iShares
Yeah I would have thought the flagging of ineligible ISAs would be a pretty straight forward tool to create. You could even spot that in Excel if you have the correct data available and the right conditional formatted set up.
Cool to see you have all that ETF data available. I wonāt step on your toes then if you want to try commercialise it to some extent.
Re ISA :: Much much harder than you would ever imagine ā¦ markets, segments, asset types, infinite exchanges, constant new issuesā¦etc etcā¦ clearly not impossible but really really quite hardā¦ itās quite nicheā¦ actually itās very niche.