Created
May 11, 2020 04:40
-
-
Save snippsat/049de21e3117f52684982bd5b14d6449 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"cells": [ | |
{ | |
"cell_type": "code", | |
"execution_count": 3, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"import pandas\n", | |
"\n", | |
"df = pandas.read_excel('Ticker List.xlsx')" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 4, | |
"metadata": {}, | |
"outputs": [ | |
{ | |
"data": { | |
"text/html": [ | |
"<div>\n", | |
"<style scoped>\n", | |
" .dataframe tbody tr th:only-of-type {\n", | |
" vertical-align: middle;\n", | |
" }\n", | |
"\n", | |
" .dataframe tbody tr th {\n", | |
" vertical-align: top;\n", | |
" }\n", | |
"\n", | |
" .dataframe thead th {\n", | |
" text-align: right;\n", | |
" }\n", | |
"</style>\n", | |
"<table border=\"1\" class=\"dataframe\">\n", | |
" <thead>\n", | |
" <tr style=\"text-align: right;\">\n", | |
" <th></th>\n", | |
" <th>Ticker</th>\n", | |
" <th>Description</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>0</th>\n", | |
" <td>GC=F</td>\n", | |
" <td>Gold</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>1</th>\n", | |
" <td>SI=F</td>\n", | |
" <td>Silver</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2</th>\n", | |
" <td>CL=F</td>\n", | |
" <td>Crude Oil</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>3</th>\n", | |
" <td>^GSPC</td>\n", | |
" <td>S&P500</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>4</th>\n", | |
" <td>^RUT</td>\n", | |
" <td>Russel 2000 Index</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>5</th>\n", | |
" <td>ZN=F</td>\n", | |
" <td>10 Yr US T-Note futures</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>6</th>\n", | |
" <td>ZT=F</td>\n", | |
" <td>2 Yr US T-Note Futures</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>7</th>\n", | |
" <td>PL=F</td>\n", | |
" <td>Platinum</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>8</th>\n", | |
" <td>HG=F</td>\n", | |
" <td>Copper</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>9</th>\n", | |
" <td>DX=F</td>\n", | |
" <td>Dollar Index</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>10</th>\n", | |
" <td>^VIX</td>\n", | |
" <td>Volatility Index</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>11</th>\n", | |
" <td>S=F</td>\n", | |
" <td>Soybean</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>12</th>\n", | |
" <td>EEM</td>\n", | |
" <td>MSCI EM ETF</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>13</th>\n", | |
" <td>EURUSD=X</td>\n", | |
" <td>Euro USD</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>14</th>\n", | |
" <td>^N100</td>\n", | |
" <td>Euronext100</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>15</th>\n", | |
" <td>^IXIC</td>\n", | |
" <td>Nasdaq</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" Ticker Description\n", | |
"0 GC=F Gold\n", | |
"1 SI=F Silver\n", | |
"2 CL=F Crude Oil\n", | |
"3 ^GSPC S&P500\n", | |
"4 ^RUT Russel 2000 Index\n", | |
"5 ZN=F 10 Yr US T-Note futures\n", | |
"6 ZT=F 2 Yr US T-Note Futures\n", | |
"7 PL=F Platinum\n", | |
"8 HG=F Copper\n", | |
"9 DX=F Dollar Index\n", | |
"10 ^VIX Volatility Index\n", | |
"11 S=F Soybean\n", | |
"12 EEM MSCI EM ETF\n", | |
"13 EURUSD=X Euro USD\n", | |
"14 ^N100 Euronext100\n", | |
"15 ^IXIC Nasdaq" | |
] | |
}, | |
"execution_count": 4, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
], | |
"source": [ | |
"df" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 5, | |
"metadata": {}, | |
"outputs": [ | |
{ | |
"data": { | |
"text/plain": [ | |
"['GC=F',\n", | |
" 'SI=F',\n", | |
" 'CL=F',\n", | |
" '^GSPC',\n", | |
" '^RUT',\n", | |
" 'ZN=F',\n", | |
" 'ZT=F',\n", | |
" 'PL=F',\n", | |
" 'HG=F',\n", | |
" 'DX=F',\n", | |
" '^VIX',\n", | |
" 'S=F',\n", | |
" 'EEM',\n", | |
" 'EURUSD=X',\n", | |
" '^N100',\n", | |
" '^IXIC']" | |
] | |
}, | |
"execution_count": 5, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
], | |
"source": [ | |
"df['Ticker'].to_list()" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": null, | |
"metadata": {}, | |
"outputs": [], | |
"source": [] | |
} | |
], | |
"metadata": { | |
"kernelspec": { | |
"display_name": "Python 3", | |
"language": "python", | |
"name": "python3" | |
}, | |
"language_info": { | |
"codemirror_mode": { | |
"name": "ipython", | |
"version": 3 | |
}, | |
"file_extension": ".py", | |
"mimetype": "text/x-python", | |
"name": "python", | |
"nbconvert_exporter": "python", | |
"pygments_lexer": "ipython3", | |
"version": "3.7.3" | |
} | |
}, | |
"nbformat": 4, | |
"nbformat_minor": 4 | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment