{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "Find ETF Bond funds that move counter to SPY" ] }, { "cell_type": "code", "execution_count": 359, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import pandas as pd\n", "import matplotlib.pyplot as pyplot\n", "import seaborn as sns" ] }, { "cell_type": "code", "execution_count": 360, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | ETF Name | \n", "Tracks This Index | \n", "Index Description | \n", "Category | \n", "Provider | \n", "Expense Ratio | \n", "Dividend | \n", "Div Yield | \n", "Market Cap (millions) | \n", "Shares (millions) | \n", "... | \n", "Beta | \n", "Asset Class | \n", "Asset Class Size | \n", "Asset Class Style | \n", "Region | \n", "Sector | \n", "Leveraged | \n", "Inverse | \n", "Top Holdings | \n", "Chart | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Symbol | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
AAXJ | \n", "iShares MSCI All Country Asia ex Japan Index Fund | \n", "MSCI All Country Asia ex Japan Index | \n", "The index measures the performance of 11 devel... | \n", "Asia Pacific Equities | \n", "iShares | \n", "0.7400% | \n", "$0.36 | \n", "1.8400% | \n", "$1,687.89 | \n", "31 | \n", "... | \n", "1 | \n", "Equity | \n", "NaN | \n", "NaN | \n", "Pacific ex-Japan | \n", "NaN | \n", "NaN | \n", "NaN | \n", "click | \n", "click | \n", "
ACWI | \n", "MSCI All Country World Index Fund | \n", "MSCI All Country World Index | \n", "The Index is designed to measure the performan... | \n", "Global Equities | \n", "iShares | \n", "0.3500% | \n", "$0.36 | \n", "1.4100% | \n", "$1,176.64 | \n", "30 | \n", "... | \n", "1 | \n", "Equity | \n", "Large-Cap | \n", "Blend | \n", "Global/Multi-Region | \n", "NaN | \n", "NaN | \n", "NaN | \n", "click | \n", "click | \n", "
2 rows × 21 columns
\n", "\n", " | ETF Name | \n", "Tracks This Index | \n", "Index Description | \n", "Category | \n", "Provider | \n", "Expense Ratio | \n", "Dividend | \n", "Div Yield | \n", "Market Cap (millions) | \n", "Shares (millions) | \n", "... | \n", "Beta | \n", "Asset Class | \n", "Asset Class Size | \n", "Asset Class Style | \n", "Region | \n", "Sector | \n", "Leveraged | \n", "Inverse | \n", "Top Holdings | \n", "Chart | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Symbol | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
AGG | \n", "iShares Barclays Aggregate Bond Fund | \n", "Barclays Capital U.S. Aggregate Bond Index | \n", "The index measures the performance of the U.S.... | \n", "Total Bond Market | \n", "iShares | \n", "0.2400% | \n", "$0.31 | \n", "3.8500% | \n", "$11,688.03 | \n", "110 | \n", "... | \n", "0 | \n", "Bond | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "click | \n", "click | \n", "
AGZ | \n", "iShares Barclays Agency Bond | \n", "Barclays Capital U.S. Agency Bond Index | \n", "The index measures the performance of the agen... | \n", "Government Bonds | \n", "iShares | \n", "0.200% | \n", "$0.17 | \n", "0.2400% | \n", "$318.54 | \n", "3 | \n", "... | \n", "0 | \n", "Bond | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "click | \n", "click | \n", "
2 rows × 21 columns
\n", "