ETF look through

Ideas šŸ’”
1

Does FT plan to incorporate ETF look through into the Insights data?

Now for ETF investors the insights information isnā€™t very helpful without the analysis of the underlying.

2

Thereā€™s a company that offers an API
Not sure how expensive this is but would be good info and automated

3

Iā€™m hoping they incorporate data for both ETFā€™s and investment trusts regarding top holdings and sector categorisation into the app. The holdings and sectors are key info which should be available in the app, would save me using other resources.

Also for the insights sector distribution I would hope that they account for ETF/Trust sector diversification in who they show our portfolio diversified. As currently if most of your money is in an ETF or trust the sector insights pie chart isnā€™t very helpful.

It is possible to do as Iā€™ve done it on my own spreadsheet Iā€™m assuming FT could automate it once they get ahold of the data and integrate it with FT.

1 Like
4

Voted :+1:t3::+1:t3:

5

Investment Trusts would be great too. Other than going directly to the company website I have found trustnet.com to be really good for IT data

2 Likes
6

Hereā€™s another

https://finki.io/etfData/etfSearch.php

3 Likes
7

Great idea! :+1:

8

@Freetrade_Team, any thoughts?

9

on the AMA call @Duncan mentioned ā€œpro modeā€ which would be improved data within the app. I hope they consider improved data for ETFs and Trusts as well as individual stocks

1 Like
10

For anyone on iOS, thereā€™s an app I have been working on for displaying ETF and Investment trust data. Currently it has around 200 listed (planning to add more).

11

2000 ETFs searchable here

https://finki.io/etfData/etfSearch.php

Super fast API to power your app too if you want it

100% of holdings, not just the 30 (ish) that I limit the webpage to

5 Likes
12

Iā€™d love to see your portfolio spreadsheet (if you have one) @finki! Iā€™d bet itā€™s amazing considering what your API can do

1 Like
13

Thanks @finki, Iā€™ll check it out.

1 Like
14

My spreadsheets are out of control

Multiple accounts, multiple currencies, ETF and IT look through to track cross holding %, dividend historical and future projects, fund fees and so on

Itā€™s borderline too much information

Thereā€™s a point where information is just noise and blinds you

My portfolio tends to grow if I donā€™t look at it

Tweaking too often is your enemy

Donā€™t take my advice. I donā€™t.

1 Like
15

I hear you with that. I think Iā€™ve just about got the perfect balance with mine but I find myself adding more too. I find it helps me ignore the red days if Iā€™m focusing on improving my spreadsheet :joy:

Iā€™d love to figure out a way to show my top holdings and their weighting using your ETF API though

16

The top 30 are on the website. No need for the API. The URL is structured and therefore reverse engineer-able. I wouldnā€™t tell you to ā€˜scrape my siteā€™ ā€¦butā€¦ itā€™s entirely easy to doā€¦ hack the ISIN and weightā€¦ spreadsheetā€¦ maths.

Honestly. Pretty easy if you can use importData in G Sheets or you know the xmlHttp method in Excel.

If that makes no sense. Email me your data.

:slightly_smiling_face:

2 Likes
17

Just brilliant

1 Like
18

Part time comedian. :confused:

19

stop!.. youā€™re killing meā€¦

Edit: I meant to say stop please. Excuse my manners

20

Love the site so please donā€™t take this as a complaint, but is there any reason why FSKY isnā€™t on there?

1 Like