Theories and research about the stock market have stated that the semi-strong form of market efficiency seems to hold. This means that all public information is accurately reflected in the price of a financial instrument. This makes the job of a portfolio manager primarily managing the desired risk appetite of the client and not explicitly trying to outperform the market. This fact in combination with Finance professionals all around the world looking for that 'edge' to make their investment decisions as profitable as possible, makes it so the average joe can not compete.
Therefore, the term 'Passive Investing' is often coined around. This refers to buying funds (either ETFs or Mutual Funds) that follow the index (i.e. S&P 500, Dow Jones Index) or a broad market (Developed Markets, MSCI World) for diversification benefits. This means that a sudden decrease in performance of one stock within the index does not (on average) lead to a significant decline in the index as a whole. This allows the holder to spend limited time monitoring his holdings, therefore the term 'Passive'.
With a large increase in ETFs available (over 5,000 in 2020), it can become difficult to make the best choice in what you wish to invest. There are many different providers (iShares, Vanguard, Invesco) as well as with changes to the underlying stocks (i.e. High Yield, Super Dividends, Equal Weighted). This is quickly reflected when looking for a S&P 500 ETF as there are over 20 different ETFs available. With this package, I wish to make investment decisions easier to make and manage.
An example of the output can be found in the GIF below. This depicts several ETFs collected from the Top ETFs according to Yahoo Finance.
The package can be installed via the following commands:
pip install thepassiveinvestor- Alternatively, download this repository.
- (within Python)
import thepassiveinvestor as pi
The functions within this package are:
collect_data(ticker)- collects the most important data for ETFs as listed in the Functionality section.create_ETF_report(tickers, filename, folder=None)- uses collect_data to create an Excel report with data, as depicted in the GIF above, per sheet for each ticker.
Therefore, if you wish to collect data on an ETF or create a report of a selection of ETFs you can use the following example:
import thepassiveinvestor as pi
# Collect data from a specific ETF
vanguard_sp500 = pi.collect_data('VOO')
# Show the data
vanguard_sp500Which returns the following:
{'long_name': 'Vanguard 500 Index Fund', 'summary': "The fund employs an indexing investment approach designed to track the performance of the Standard & Poor's 500 Index, a widely recognized benchmark of U.S. stock market performance that is dominated by the stocks of large U.S. companies. The advisor attempts to replicate the target index by investing all, or substantially all, of its assets in the stocks that make up the index, holding each stock in approximately the same proportion as its weighting in the index.", 'image_URL': 'https://s.yimg.com/lq/i/fi/3_0stylelargeeq2.gif', 'sector_holdings': {'realestate': '2.75%', 'consumer_cyclical': '10.13%', 'basic_materials': '2.4%', 'consumer_defensive': '7.38%', 'technology': '23.65%', 'communication_services': '7.43%', 'financial_services': '13.7%', 'utilities': '2.43%', 'industrials': '8.82%', 'energy': '5.11%', 'healthcare': '15.27%'}, 'company_holdings': {'Apple Inc': '5.92%', 'Microsoft Corp': '5.62%', 'Amazon.com Inc': '4.06%', 'Facebook Inc Class A': '2.29%', 'Alphabet Inc Class A': '2.02%', 'Alphabet Inc Class C': '1.97%', 'Berkshire Hathaway Inc Class B': '1.44%', 'Tesla Inc': '1.44%', 'NVIDIA Corp': '1.37%', 'JPMorgan Chase & Co': '1.3%'}, 'annual_returns': {'2022': '-18.15%', '2021': '28.66%', '2020': '18.35%', '2019': '31.46%', '2018': '-4.42%', '2017': '21.78%'}, 'risk_data': {'5y': {'year': '5y', 'alpha': -0.04, 'beta': 1, 'meanAnnualReturn': 0.89, 'rSquared': 100, 'stdDev': 18.69, 'sharpeRatio': -0.19, 'treynorRatio': 8.04}, '3y': {'year': '3y', 'alpha': -0.04, 'beta': 1, 'meanAnnualReturn': 0.8, 'rSquared': 100, 'stdDev': 21.17, 'sharpeRatio': -0.55, 'treynorRatio': 6.76}, '10y': {'year': '10y', 'alpha': -0.04, 'beta': 1, 'meanAnnualReturn': 1.08, 'rSquared': 100, 'stdDev': 14.78, 'sharpeRatio': 0.88, 'treynorRatio': 11.7}}, 'key_characteristics': {'fundInceptionDate': '2010-09-07', 'category': 'Large Blend', 'totalAssets': 744769716224, 'currency': 'USD', 'navPrice': 366.24, 'previousClose': 365.67}}
You also have the option to generate a comparison report as follows:
import thepassiveinvestor as pi
# Collect data from a set of ETFs and compare them
etf_comparison = pi.collect_data(['VOO', 'QQQ', 'ARKG', 'VUG', 'SCHA', 'VWO'], comparison=True)
# Show the comparison
etf_comparisonWhich returns the following:
| VOO | QQQ | ARKG | VUG | SCHA | VWO | |
|---|---|---|---|---|---|---|
| ('sector_holdings', 'realestate') | 2.75% | 0.29% | 0% | 2.55% | 7.16% | 2.95% |
| ('sector_holdings', 'consumer_cyclical') | 10.13% | 14.2% | 0% | 18.09% | 12.75% | 12.92% |
| ('sector_holdings', 'basic_materials') | 2.4% | 0% | 0% | 2.01% | 4.35% | 9.34% |
| ('sector_holdings', 'consumer_defensive') | 7.38% | 6.67% | 0% | 2.92% | 4.12% | 6.23% |
| ('sector_holdings', 'technology') | 23.65% | 47.62% | 3.41% | 41.19% | 14.18% | 15.49% |
| ('sector_holdings', 'communication_services') | 7.43% | 15.99% | 0% | 11.96% | 2.74% | 8.72% |
| ('sector_holdings', 'financial_services') | 13.7% | 0.74% | 0% | 6.95% | 15.68% | 20.63% |
| ('sector_holdings', 'utilities') | 2.43% | 0.88% | 0% | 0% | 1.83% | 3.78% |
| ('sector_holdings', 'industrials') | 8.82% | 4.75% | 0% | 4.64% | 16.16% | 7.26% |
| ('sector_holdings', 'energy') | 5.11% | 0.49% | 0% | 1.35% | 5.85% | 5.36% |
| ('sector_holdings', 'healthcare') | 15.27% | 7.54% | 96.58% | 8.13% | 13.98% | 4.6% |
| ('annual_returns', '2022') | -18.15% | -32.49% | -53.94% | -33.13% | -19.8% | -17.72% |
| ('annual_returns', '2021') | 28.66% | 27.24% | -33.89% | 27.26% | 16.35% | 0.96% |
| ('annual_returns', '2020') | 18.35% | 48.6% | 180.51% | 40.16% | 19.35% | 15.32% |
| ('annual_returns', '2019') | 31.46% | 39.12% | 43.75% | 37.26% | 26.54% | 20.4% |
| ('annual_returns', '2018') | -4.42% | -0.14% | 0.59% | -3.32% | -11.75% | -14.57% |
| ('annual_returns', '2017') | 21.78% | 32.7% | 45.41% | 27.8% | 15.04% | 31.38% |
| ('key_characteristics', 'fundInceptionDate') | 2010-09-07 | 1999-03-10 | 2014-10-31 | 2004-01-26 | 2009-11-03 | 2005-03-04 |
| ('key_characteristics', 'category') | Large Blend | Large Growth | Health | Large Growth | Small Blend | Diversified Emerging Mkts |
| ('key_characteristics', 'totalAssets') | 744769716224 | 145931501568 | 1899108352 | 132303921152 | 13327223808 | 93044613120 |
| ('key_characteristics', 'currency') | USD | USD | USD | USD | USD | USD |
| ('key_characteristics', 'navPrice') | 366.24 | 281.03 | 32.79 | 225.08 | 43.42 | 41.9 |
| ('key_characteristics', 'previousClose') | 365.67 | 281.54 | 33.43 | 225.66 | 43.41 | 41.92 |
| ('risk_data_3y', 'year') | 3y | 3y | 3y | 3y | 3y | 3y |
| ('risk_data_3y', 'alpha') | -0.04 | 0.76 | -4.62 | -1.7 | -3.72 | -1.28 |
| ('risk_data_3y', 'beta') | 1 | 1.08 | 1.32 | 1.11 | 1.15 | 0.9 |
| ('risk_data_3y', 'meanAnnualReturn') | 0.8 | 0.92 | 0.25 | 0.74 | 0.6 | 0.05 |
| ('risk_data_3y', 'rSquared') | 100 | 87.57 | 41.82 | 90.79 | 82.66 | 76.68 |
| ('risk_data_3y', 'stdDev') | 21.17 | 24.49 | 41.28 | 24.6 | 26.8 | 20.04 |
| ('risk_data_3y', 'sharpeRatio') | -0.55 | -0.7 | 0.27 | -0.72 | 1.58 | 2 |
| ('risk_data_3y', 'treynorRatio') | 6.76 | 7.04 | -4.51 | 4.7 | 2.44 | -2.53 |
| ('risk_data_5y', 'year') | 5y | 5y | 5y | 5y | 5y | 5y |
| ('risk_data_5y', 'alpha') | -0.04 | 2.15 | 2.44 | -0.2 | -5.06 | -0.93 |
| ('risk_data_5y', 'beta') | 1 | 1.1 | 1.5 | 1.1 | 1.16 | 0.94 |
| ('risk_data_5y', 'meanAnnualReturn') | 0.89 | 1.16 | 0.98 | 0.96 | 0.6 | 0.11 |
| ('risk_data_5y', 'rSquared') | 100 | 88.49 | 45.66 | 91.7 | 83.48 | 78.97 |
| ('risk_data_5y', 'stdDev') | 18.69 | 21.85 | 39.32 | 21.4 | 23.73 | 18.27 |
| ('risk_data_5y', 'sharpeRatio') | -0.19 | -0.44 | -0.12 | -0.3 | 1.77 | 1.58 |
| ('risk_data_5y', 'treynorRatio') | 8.04 | 9.81 | 1.98 | 7.55 | 2.69 | -1.74 |
| ('risk_data_10y', 'year') | 10y | 10y | 10y | 10y | 10y | 10y |
| ('risk_data_10y', 'alpha') | -0.04 | 2.46 | 0 | -0.51 | -4.08 | -1.79 |
| ('risk_data_10y', 'beta') | 1 | 1.1 | 0 | 1.08 | 1.16 | 0.98 |
| ('risk_data_10y', 'meanAnnualReturn') | 1.08 | 1.39 | 0 | 1.13 | 0.9 | 0.24 |
| ('risk_data_10y', 'rSquared') | 100 | 85.33 | 0 | 91.48 | 80.44 | 75.61 |
| ('risk_data_10y', 'stdDev') | 14.78 | 17.56 | 0 | 16.76 | 19.06 | 16.38 |
| ('risk_data_10y', 'sharpeRatio') | 0.88 | 0.39 | 0 | 0.78 | 2.92 | 1.44 |
| ('risk_data_10y', 'treynorRatio') | 11.7 | 14.01 | 0 | 11.05 | 7.38 | 0.79 |
Lastly, if you wish to export to Excel this is also a possibility generating an Excel file that contains the most relevant information for each ticker.
import thepassiveinvestor as pi
# Create a report from a list of ETFs
etf_list = ['VOO', 'QQQ', 'ARKG', 'VUG', 'SCHA', 'VWO']
pi.create_ETF_report(etf_list, 'Popular ETFs.xlsx')Which returns the following:
The package outputs an overview of each fund on a separate sheet. In this overview the following data is shown:
| Topic | Contains |
|---|---|
| General | The title of the fund and a summary about the fund's purpose and goal. |
| Characteristics | Inception date (the start of the fund), the category, assets under management (AUM), the denominated currency, net asset value (NAV), the latest close price and the Morningstar Style Box (if available). |
| Holdings | Sector holdings (% in each sector) and company holdings (top 10 companies with highest %). |
| Risk Metrics | All metrics are displayed in an interval of 3, 5 and 10 years. This includes Jensen's Alpha, Beta, Mean Annual Return, R-squared, Standard Deviation, Sharpe Ratio and Treynor Ratio. |
| Performance | The last five annual returns of the fund as well as a graph depicting the adjusted close prices over the last 10 years. The actual data for this graph is available on a hidden sheet. |
If you have any questions about the FinanceToolkit or would like to share with me what you have been working on, feel free to reach out to me via:
- Website: https://jeroenbouma.com/
- Twitter: https://twitter.com/JerBouma
- LinkedIn: https://www.linkedin.com/in/boumajeroen/
- Email: [email protected]
- Discord: add me on Discord
JerBouma
If you'd like to support my efforts, either help me out by contributing to the package or Sponsor Me.