Author Topic: I made a tool that shows how much you have in each holding of your index funds  (Read 6630 times)

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
I was browsing through index funds holding details on Vanguard website and came up with the idea to make an interactive tool to display some stats about our beloved index funds.

One week of coding later I have

https://stocked.honeymoney.io

You can enter what index funds you have, and how much you have invested in each, and then see all your holdings by sectors or countries with some stats and charts.

For example, I was pleasantly surprised how much I have in Blizzard, Electronic Arts, Nintendo and other video games companies :) And not so much with almost $3k in Tobacco and $1.5k in Gambling.

Hope you guys like it. Any feedback is welcome.

bluewater

  • 5 O'Clock Shadow
  • *
  • Posts: 27
Cool tool! Thanks for sharing, look forward to playing around with it more tomorrow.

SubL stache

  • 5 O'Clock Shadow
  • *
  • Posts: 74
That is awesome, good work.

laserlady

  • 5 O'Clock Shadow
  • *
  • Posts: 60
Very cool.  I was surprised to see that I've got about $10k in Amazon.  That makes sense, with Amazon being so huge, but it's still higher than I would have expected.

seattlecyclone

  • Walrus Stache
  • *******
  • Posts: 7254
  • Age: 39
  • Location: Seattle, WA
    • My blog
Looks neat! I've long considered making something like that. Glad I don't have to anymore. Plus if I did it, it would have a text-based interface. I'm more of a backend engineer. :-)

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
Thank you for the kind words. I'm glad you liked it.

Very cool.  I was surprised to see that I've got about $10k in Amazon.  That makes sense, with Amazon being so huge, but it's still higher than I would have expected.

I have CAD$3.6k in Amazon, having 20% Canada, 80% the rest of the world allocation.
I was surprised that my top holding is not Apple but Royal Bank of Canada :)
Apple is #3. My top 10 holdings are 7 Canadian stocks (4 of them are banks) and 3 US.


Looks neat! I've long considered making something like that. Glad I don't have to anymore. Plus if I did it, it would have a text-based interface. I'm more of a backend engineer. :-)

I was a back-end developer before but then switched more to project management and front-end.
Stocked is a completely static website, no server side at all.

Roothy

  • Stubble
  • **
  • Posts: 123
This is lovely; thank you!!

I'm a red panda

  • Walrus Stache
  • *******
  • Posts: 8186
  • Location: United States
Very cool.  I was surprised to see that I've got about $10k in Amazon.  That makes sense, with Amazon being so huge, but it's still higher than I would have expected.

Wow, you've got a lot in VTSAX :)

Money Maker Mike

  • 5 O'Clock Shadow
  • *
  • Posts: 7
  • Age: 29
  • Location: Foot of the lake
I didn't realize how badly I wanted this until now. Thank you!

ILikeDividends

  • Bristles
  • ***
  • Posts: 459
Your willingness to share your efforts with others is a generous gesture; which makes it even more unpleasant for me to be the one to pee on the picnic.  :(

Vangaurd's condition of use here:

{Link removed, see update below}

"Except as otherwise stated in these Terms of Use or as expressly authorized by Vanguard in writing, you may not (or enable others to):

    Modify, copy, screen capture, distribute, forward, transmit, post, display, perform, reproduce, publish, broadcast, license, create derivative works from, transfer, sell, or exploit any reports, data, information, content, software, RSS and podcast feeds, products, services, or other materials on, generated by or obtained from this Site, whether through links or otherwise (collectively, "Materials");"


They also have very specific conditions governing how you can link to their site (at the same TOS URL).

I don't think anyone who is using your website is in violation of these terms; however, I find it hard to imagine how your website is sourcing its data while remaining TOS-compliant, assuming you don't have a written agreement with Vanguard.

Certainly not a condemnation on my part.  Just an FYI.

I plead protection under the bearer of bad news articles of sanctuary.

Update to add: It turns out that even linking to their TOS page here is a violation, so I removed the link.  You can find the link I removed by searching Google: Vanguard Terms and Conditions of Use.
« Last Edit: August 30, 2018, 08:32:35 PM by ILikeDividends »

mrmoolaman

  • 5 O'Clock Shadow
  • *
  • Posts: 16
  • Age: 27
  • Location: BC
Why would Vanguard have an interest in stopping this sort of site?

ILikeDividends

  • Bristles
  • ***
  • Posts: 459
Why would Vanguard have an interest in stopping this sort of site?

You would have to ask Vanguard that question.  Those are their terms of service, not mine.

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
Your willingness to share your efforts with others is a generous gesture; which makes it even more unpleasant for me to be the one to pee on the picnic.  :(

Vangaurd's condition of use here:

{Link removed, see update below}

"Except as otherwise stated in these Terms of Use or as expressly authorized by Vanguard in writing, you may not (or enable others to):

    Modify, copy, screen capture, distribute, forward, transmit, post, display, perform, reproduce, publish, broadcast, license, create derivative works from, transfer, sell, or exploit any reports, data, information, content, software, RSS and podcast feeds, products, services, or other materials on, generated by or obtained from this Site, whether through links or otherwise (collectively, "Materials");"


They also have very specific conditions governing how you can link to their site (at the same TOS URL).

I don't think anyone who is using your website is in violation of these terms; however, I find it hard to imagine how your website is sourcing its data while remaining TOS-compliant, assuming you don't have a written agreement with Vanguard.

Certainly not a condemnation on my part.  Just an FYI.

I plead protection under the bearer of bad news articles of sanctuary.

Update to add: It turns out that even linking to their TOS page here is a violation, so I removed the link.  You can find the link I removed by searching Google: Vanguard Terms and Conditions of Use.

I agree with you about using their data.
I'll ask them via twitter.

Some of the points of their agreement are not enforceable though.
For example, this is just their lawyers' wishful thinking that you don't have to follow:
"The text of the Link must read either "The Vanguard Group," "Vanguard," "Vanguard Group," "Vanguard.com," or "www. vanguard. com."

You can link to them with "the company with overprotective terms of linking" text, and it will be ok :)
« Last Edit: August 31, 2018, 01:44:42 AM by beee »

Kalergie

  • Stubble
  • **
  • Posts: 221
This is why I still take part in forums!
Thank you so much!

laserlady

  • 5 O'Clock Shadow
  • *
  • Posts: 60
Very cool.  I was surprised to see that I've got about $10k in Amazon.  That makes sense, with Amazon being so huge, but it's still higher than I would have expected.

Wow, you've got a lot in VTSAX :)

Yep.  :)  I read J.L. Collins' stock series before I started investing, and since then I've been putting basically everything into VTSAX like he recommended.  And it's been working out quite well for me.

ILikeDividends

  • Bristles
  • ***
  • Posts: 459

Some of the points of their agreement are not enforceable though.


Only true if you're talking about the kind of enforcers who wear expensive suits and alligator skin shoes.

The propeller cap, knit tie, tennis shoe wearing enforcers that work in the IT department could block your website's IP address much more cost-effectively; basically shutting your website down by adding one extra line to their .htaccess file.

At any rate, I hope Vanguard appreciates the value your work brings to their very own customers, and extends whatever formalities are required to keep you up and running.

Good luck!
« Last Edit: August 31, 2018, 05:51:02 PM by ILikeDividends »

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
The propeller-cap, knit tie, tennis shoe wearing enforcers that work in the IT department could block your website's IP address much more cost-effectively; basically shutting your website down.

That would be true if I would scrape information dynamically from their website.
Well, I don't. I just download the portfolio holdings excel file from them manually and then prepare it for a website.

I do hope too that it won't be a problem. In the worst case, I'll have to switch to another provider with similar index funds.

salmo trutta

  • 5 O'Clock Shadow
  • *
  • Posts: 11
Nice work Beee - I like the tool and find it very useful.

Here is a cool "quantitative toolbox" that is a simulator that may be of interest. It models an optimal Vanguard portfolio using the popular 4 fund blend of VTI, VXUS, BND, and BNDX.

https://letyourmoneygrow.com/2016/10/16/a-simple-scenario-simulator-for-vanguard-optimal-portfolio/


beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
Just updated the tool with the most recent holdings data.

Most recent finding: we own $78 in Take-Two Interactive Software Inc., which owns Rockstar Games, developer of the Red Dead Redemption 2 :) Nice!

thunderball

  • 5 O'Clock Shadow
  • *
  • Posts: 79

This is so cool!  What's strange is seeing a breakdown of say, VTSAX lessens my desire to buy individual stocks.

Thank you beee!!

JustFixIt

  • 5 O'Clock Shadow
  • *
  • Posts: 17
  • Location: Texas
Thanks Beee!

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
Discovery of today: we have almost $800 in weed stocks :)

I'm a red panda

  • Walrus Stache
  • *******
  • Posts: 8186
  • Location: United States
My husband's company just got bought out.  Found out we have $160 in the new company. LOL

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
Discovery of today: we have 3.66% in Real Estate related holdings.

This fact and this white paper
https://www.pwlcapital.com/wp-content/uploads/2018/06/WhitePaper_BenjaminFelix_Housing-Investment_05-2018.pdf
satisfied my desire to invest in Real Estate.
« Last Edit: December 12, 2018, 12:23:22 PM by beee »

jinga nation

  • Magnum Stache
  • ******
  • Posts: 2696
  • Age: 247
  • Location: 'Murica's Dong
cool tool cool @beee !

So it's a violation if a MMMForums post links to the ToS but OK for Google to? Bologna Sandwich.

I personally think the fact that you are periodically updating data on a few funds using an excel file is no biggie, as you're not costing VG a lot of GET requests.

ToS seems canned... must have paid a cheap lawyer to craft a boiler-plate do-all statement that gets slapped on everything. Typical VG, good fast cheap.

Billy B. Good

  • 5 O'Clock Shadow
  • *
  • Posts: 33
Love the tool. Thank you.

When I put in that I have $100k in VFIAX the tool tells me: "You have $99,691 (99.69% of portfolio) in 509 holdings."

Same thing with VTSAX.

I'm not nit picking, I'm just curious about the remainder. Is it the expense ratio?

I am as far from a computer coder as anyone could be so I really admire the ability to create a tool like this.
« Last Edit: December 15, 2018, 10:56:18 AM by BillyBGood »

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
Love the tool. Thank you.

When I put in that I have $100k in VFIAX the tool tells me: "You have $99,691 (99.69% of portfolio) in 509 holdings."
I'm not nit picking, I'm just curious about the remainder. Is it the expense ratio?

It's cash, short-term reserves, and some other stuff vanguard doesn't want us to know :) Check out the info inside their holding details file:

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
Discovery of today:

1) Watched Dubai 2019 fireworks video:
https://www.youtube.com/watch?v=T0pvUKs-0ZQ
2) Noticed "EMAAR" word
3) Googled it: https://en.wikipedia.org/wiki/Emaar_Properties (TLDR: they're the developer behind Burj Khalifa)
4) Checked Stocked
5) Noticed that we have around $35 in this company
6) Nice!

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
Just updated the tool with the most recent holdings data.

beee

  • Stubble
  • **
  • Posts: 244
  • Age: 36
  • Location: Edmonton, Canada
    • HoneyMoney.io
Just updated the tool with the most recent holdings data.

Random discoveries:

If you have $100k in Total World index, then here're your holdings in Apparel Retailers:
https://stocked.honeymoney.io/?portfolio=VT_100000&sectors=Apparel%20Retailers

TJX Cos. Inc. is Winners, Marshalls, HomeSense, HomeGoods, Sierra.
Kering is Gucci, Saint Laurent, some other luxury brands.
"Industria de Diseno Textil SA" is Zara.
Hennes & Mauritz AB Class B is H&M.

Retireatee1

  • Stubble
  • **
  • Posts: 209
  • Location: Fort Mill, SC
    • Retireator.org
Pretty cool.  Fidelity has an "Analysis" tool that is similar.  I don't think theirs can build a hypothetical portfolio, though.


 

Wow, a phone plan for fifteen bucks!