In the short video below, I show how to compute Active Share. The accompanying excel file with the formulas can be found here.

I start by computing the active share for two hypothetical funds, and then examine the active share of a few live ETFs.

External link to the video here.