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.