Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

Comments on How to deduce which ETF is redundant? a of ETF1's holdings in ETF3, a of ETF2 in ETF3, b of ETF1 are in ETF2, b of ETF2 in ETF1.

Post

How to deduce which ETF is redundant? a of ETF1's holdings in ETF3, a of ETF2 in ETF3, b of ETF1 are in ETF2, b of ETF2 in ETF1.

+1
−1

According to https://www.etfrc.com/funds/overlap.php,

  1. 47.2% of FIW's 37 holdings $\in$ AQWA's 38 holdings.

  2. 47.2% of PHO's 36 holdings $\in$ AQWA.

  3. 77.8% FIW's holdings $\in$ PHO.

  4. 77.8% PHO's holdings $\in$ FIW.

My two goals. I must

  1. buy $\ge 1$ Water ETF, such as the 3 above.

  2. minimize overlap, duplication of stock holdings.

Which of the 3 above is redundant?

I don't affiliate or associate with any of these ETF's or websites.

History
Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

1 comment thread

zero (2 comments)
zero
whybecause‭ wrote over 2 years ago

I suspect this question isn't stated fully enough, and also should probably be stated as a pure math problem rather than relying on any domain knowledge about ETF's. If you're minimizing overlap and want to buy as few as possible, and those are literally the only constraints ... then choose zero of everything.

You'll probably get better answers if you can frame this problem in terms of something more purely mathematical, and then ask a precise constrained optimization question. For instance it seems like perhaps we could model this by probability theory. Say X is a probability space with events A, B, C, D. And P(A)=.472, and so on. In this setting you want ... what? To select some combination of events to all hold simultaneously, minimize the joint probability, minimize the number of events, and ... maximize something? Subject to some constraint, like at least two events occurring?

Chgg Clou‭ wrote over 2 years ago

thanks for your reply. I corrected my post. I don't want 0 as the answer. As an investor, I covet exposure to AT LEAST 1 water ETF. Feel free to edit my post. I afraid that if I generalize or broaden my question into a pure math problem, I won't understand it!