Python for Finance 2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Provides ways to work with large multidimensional arrays\n",
    "import numpy as np \n",
    "# Allows for further data manipulation and analysis\n",
    "import pandas as pd\n",
    "from pandas_datareader import data as web # Reads stock data \n",
    "import matplotlib.pyplot as plt # Plotting\n",
    "import matplotlib.dates as mdates # Styling dates\n",
    "%matplotlib inline\n",
    "\n",
    "import datetime as dt # For defining dates\n",
    "import mplfinance as mpf # Matplotlib finance\n",
    "\n",
    "import time\n",
    "\n",
    "# Used to get data from a directory\n",
    "import os\n",
    "from os import listdir\n",
    "from os.path import isfile, join"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Default Values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Define path to files\n",
    "path = \"D:/Python for Finance/Stocks/\"\n",
    "\n",
    "# Start date defaults\n",
    "S_YEAR = 2017\n",
    "S_MONTH = 1\n",
    "S_DAY = 3\n",
    "S_DATE_STR = f\"{S_YEAR}-{S_MONTH}-{S_DAY}\"\n",
    "S_DATE_DATETIME = dt.datetime(S_YEAR, S_MONTH, S_DAY)\n",
    "\n",
    "# End date defaults\n",
    "E_YEAR = 2021\n",
    "E_MONTH = 8\n",
    "E_DAY = 19\n",
    "E_DATE_STR = f\"{E_YEAR}-{E_MONTH}-{E_DAY}\"\n",
    "E_DATE_DATETIME = dt.datetime(E_YEAR, E_MONTH, E_DAY)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get Stock File Names in a List"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['A',\n",
       " 'AA',\n",
       " 'AAL',\n",
       " 'AAME',\n",
       " 'AAN',\n",
       " 'AAOI',\n",
       " 'AAON',\n",
       " 'AAP',\n",
       " 'AAPL',\n",
       " 'AAT',\n",
       " 'AAWW',\n",
       " 'ABBV',\n",
       " 'ABC',\n",
       " 'ABCB',\n",
       " 'ABEO',\n",
       " 'ABG',\n",
       " 'ABIO',\n",
       " 'ABM',\n",
       " 'ABMD',\n",
       " 'ABR',\n",
       " 'ABT',\n",
       " 'ABTX',\n",
       " 'AC',\n",
       " 'ACA',\n",
       " 'ACAD',\n",
       " 'ACBI',\n",
       " 'ACC',\n",
       " 'ACCO',\n",
       " 'ACER',\n",
       " 'ACGL',\n",
       " 'ACHC',\n",
       " 'ACHV',\n",
       " 'ACIW',\n",
       " 'ACLS',\n",
       " 'ACM',\n",
       " 'ACMR',\n",
       " 'ACN',\n",
       " 'ACNB',\n",
       " 'ACOR',\n",
       " 'ACRE',\n",
       " 'ACRS',\n",
       " 'ACRX',\n",
       " 'ACTG',\n",
       " 'ACU',\n",
       " 'ACY',\n",
       " 'ADBE',\n",
       " 'ADC',\n",
       " 'ADES',\n",
       " 'ADI',\n",
       " 'ADM',\n",
       " 'ADMA',\n",
       " 'ADMP',\n",
       " 'ADMS',\n",
       " 'ADNT',\n",
       " 'ADP',\n",
       " 'ADS',\n",
       " 'ADSK',\n",
       " 'ADT',\n",
       " 'ADTN',\n",
       " 'ADUS',\n",
       " 'ADVM',\n",
       " 'ADXS',\n",
       " 'AE',\n",
       " 'AEE',\n",
       " 'AEHR',\n",
       " 'AEIS',\n",
       " 'AEL',\n",
       " 'AEMD',\n",
       " 'AEO',\n",
       " 'AEP',\n",
       " 'AERI',\n",
       " 'AES',\n",
       " 'AEY',\n",
       " 'AFG',\n",
       " 'AFI',\n",
       " 'AFIN',\n",
       " 'AFL',\n",
       " 'AGCO',\n",
       " 'AGE',\n",
       " 'AGEN',\n",
       " 'AGFS',\n",
       " 'AGIO',\n",
       " 'AGLE',\n",
       " 'AGM',\n",
       " 'AGNC',\n",
       " 'AGO',\n",
       " 'AGR',\n",
       " 'AGRX',\n",
       " 'AGS',\n",
       " 'AGTC',\n",
       " 'AGX',\n",
       " 'AGYS',\n",
       " 'AHH',\n",
       " 'AHT',\n",
       " 'AIG',\n",
       " 'AIMC',\n",
       " 'AIN',\n",
       " 'AINC',\n",
       " 'AIR',\n",
       " 'AIRG',\n",
       " 'AIRI',\n",
       " 'AIRT',\n",
       " 'AIT',\n",
       " 'AIV',\n",
       " 'AIZ',\n",
       " 'AJG',\n",
       " 'AJRD',\n",
       " 'AJX',\n",
       " 'AKAM',\n",
       " 'AKBA',\n",
       " 'AKR',\n",
       " 'AKTS',\n",
       " 'AL',\n",
       " 'ALB',\n",
       " 'ALBO',\n",
       " 'ALCO',\n",
       " 'ALDX',\n",
       " 'ALE',\n",
       " 'ALEC',\n",
       " 'ALEX',\n",
       " 'ALG',\n",
       " 'ALGN',\n",
       " 'ALGT',\n",
       " 'ALIM',\n",
       " 'ALJJ',\n",
       " 'ALK',\n",
       " 'ALKS',\n",
       " 'ALL',\n",
       " 'ALLE',\n",
       " 'ALLK',\n",
       " 'ALLO',\n",
       " 'ALLY',\n",
       " 'ALNA',\n",
       " 'ALNY',\n",
       " 'ALOT',\n",
       " 'ALPN',\n",
       " 'ALRM',\n",
       " 'ALSN',\n",
       " 'ALT',\n",
       " 'ALTM',\n",
       " 'ALTR',\n",
       " 'ALV',\n",
       " 'ALX',\n",
       " 'ALXN',\n",
       " 'AM',\n",
       " 'AMAL',\n",
       " 'AMAT',\n",
       " 'AMBC',\n",
       " 'AMC',\n",
       " 'AMCX',\n",
       " 'AMD',\n",
       " 'AME',\n",
       " 'AMED',\n",
       " 'AMG',\n",
       " 'AMGN',\n",
       " 'AMH',\n",
       " 'AMKR',\n",
       " 'AMN',\n",
       " 'AMNB',\n",
       " 'AMOT',\n",
       " 'AMP',\n",
       " 'AMPE',\n",
       " 'AMPH',\n",
       " 'AMRC',\n",
       " 'AMRK',\n",
       " 'AMRS',\n",
       " 'AMRX',\n",
       " 'AMS',\n",
       " 'AMSC',\n",
       " 'AMSF',\n",
       " 'AMSWA',\n",
       " 'AMT',\n",
       " 'AMTX',\n",
       " 'AMWD',\n",
       " 'AMZN',\n",
       " 'AN',\n",
       " 'ANAB',\n",
       " 'ANAT',\n",
       " 'ANDE',\n",
       " 'ANET',\n",
       " 'ANF',\n",
       " 'ANGI',\n",
       " 'ANGO',\n",
       " 'ANIK',\n",
       " 'ANIP',\n",
       " 'ANIX',\n",
       " 'ANSS',\n",
       " 'ANTM',\n",
       " 'AON',\n",
       " 'AOS',\n",
       " 'AOSL',\n",
       " 'AP',\n",
       " 'APA',\n",
       " 'APAM',\n",
       " 'APD',\n",
       " 'APDN',\n",
       " 'APEI',\n",
       " 'APEN',\n",
       " 'APH',\n",
       " 'APLE',\n",
       " 'APLS',\n",
       " 'APOG',\n",
       " 'APPF',\n",
       " 'APPN',\n",
       " 'APPS',\n",
       " 'APRN',\n",
       " 'APT',\n",
       " 'APTS',\n",
       " 'APTV',\n",
       " 'APVO',\n",
       " 'APYX',\n",
       " 'AQB',\n",
       " 'AQMS',\n",
       " 'AQUA',\n",
       " 'AR',\n",
       " 'ARAV',\n",
       " 'ARAY',\n",
       " 'ARC',\n",
       " 'ARCB',\n",
       " 'ARCH',\n",
       " 'ARDX',\n",
       " 'ARE',\n",
       " 'ARES',\n",
       " 'ARGO',\n",
       " 'ARI',\n",
       " 'ARKR',\n",
       " 'ARL',\n",
       " 'ARLO',\n",
       " 'ARMK',\n",
       " 'ARNA',\n",
       " 'ARNC',\n",
       " 'AROC',\n",
       " 'AROW',\n",
       " 'ARPO',\n",
       " 'ARR',\n",
       " 'ARTNA',\n",
       " 'ARTW',\n",
       " 'ARVN',\n",
       " 'ARW',\n",
       " 'ARWR',\n",
       " 'ASB',\n",
       " 'ASGN',\n",
       " 'ASH',\n",
       " 'ASIX',\n",
       " 'ASMB',\n",
       " 'ASPN',\n",
       " 'ASPS',\n",
       " 'ASRT',\n",
       " 'ASRV',\n",
       " 'ASTC',\n",
       " 'ASTE',\n",
       " 'ASUR',\n",
       " 'ASYS',\n",
       " 'ATEC',\n",
       " 'ATEN',\n",
       " 'ATGE',\n",
       " 'ATH',\n",
       " 'ATHX',\n",
       " 'ATI',\n",
       " 'ATKR',\n",
       " 'ATLC',\n",
       " 'ATLO',\n",
       " 'ATNI',\n",
       " 'ATNM',\n",
       " 'ATNX',\n",
       " 'ATO',\n",
       " 'ATOS',\n",
       " 'ATR',\n",
       " 'ATRA',\n",
       " 'ATRC',\n",
       " 'ATRI',\n",
       " 'ATRO',\n",
       " 'ATRS',\n",
       " 'ATSG',\n",
       " 'ATUS',\n",
       " 'ATVI',\n",
       " 'AUBN',\n",
       " 'AUMN',\n",
       " 'AUTO',\n",
       " 'AVA',\n",
       " 'AVAV',\n",
       " 'AVB',\n",
       " 'AVD',\n",
       " 'AVEO',\n",
       " 'AVGO',\n",
       " 'AVGR',\n",
       " 'AVID',\n",
       " 'AVLR',\n",
       " 'AVNS',\n",
       " 'AVNW',\n",
       " 'AVRO',\n",
       " 'AVT',\n",
       " 'AVTR',\n",
       " 'AVXL',\n",
       " 'AVY',\n",
       " 'AVYA',\n",
       " 'AWI',\n",
       " 'AWK',\n",
       " 'AWR',\n",
       " 'AWRE',\n",
       " 'AX',\n",
       " 'AXAS',\n",
       " 'AXDX',\n",
       " 'AXGN',\n",
       " 'AXL',\n",
       " 'AXNX',\n",
       " 'AXP',\n",
       " 'AXR',\n",
       " 'AXS',\n",
       " 'AXSM',\n",
       " 'AXTA',\n",
       " 'AXTI',\n",
       " 'AYI',\n",
       " 'AYX',\n",
       " 'AZO',\n",
       " 'AZPN',\n",
       " 'AZZ',\n",
       " 'B',\n",
       " 'BA',\n",
       " 'BAC',\n",
       " 'BAH',\n",
       " 'BANC',\n",
       " 'BAND',\n",
       " 'BANF',\n",
       " 'BANR',\n",
       " 'BATRA',\n",
       " 'BATRK',\n",
       " 'BAX',\n",
       " 'BBBY',\n",
       " 'BBCP',\n",
       " 'BBGI',\n",
       " 'BBSI',\n",
       " 'BBW',\n",
       " 'BBY',\n",
       " 'BC',\n",
       " 'BCBP',\n",
       " 'BCC',\n",
       " 'BCEI',\n",
       " 'BCLI',\n",
       " 'BCO',\n",
       " 'BCOR',\n",
       " 'BCOV',\n",
       " 'BCPC',\n",
       " 'BCRX',\n",
       " 'BDC',\n",
       " 'BDL',\n",
       " 'BDN',\n",
       " 'BDSI',\n",
       " 'BDX',\n",
       " 'BE',\n",
       " 'BECN',\n",
       " 'BELFA',\n",
       " 'BELFB',\n",
       " 'BEN',\n",
       " 'BERY',\n",
       " 'BFAM',\n",
       " 'BFIN',\n",
       " 'BFS',\n",
       " 'BFST',\n",
       " 'BG',\n",
       " 'BGCP',\n",
       " 'BGFV',\n",
       " 'BGS',\n",
       " 'BGSF',\n",
       " 'BH',\n",
       " 'BHB',\n",
       " 'BHE',\n",
       " 'BHF',\n",
       " 'BHLB',\n",
       " 'BHR',\n",
       " 'BHVN',\n",
       " 'BIG',\n",
       " 'BIIB',\n",
       " 'BIO',\n",
       " 'BIOC',\n",
       " 'BIOL',\n",
       " 'BJ',\n",
       " 'BJRI',\n",
       " 'BK',\n",
       " 'BKD',\n",
       " 'BKE',\n",
       " 'BKH',\n",
       " 'BKI',\n",
       " 'BKNG',\n",
       " 'BKSC',\n",
       " 'BKTI',\n",
       " 'BKU',\n",
       " 'BL',\n",
       " 'BLBD',\n",
       " 'BLCM',\n",
       " 'BLD',\n",
       " 'BLDR',\n",
       " 'BLFS',\n",
       " 'BLK',\n",
       " 'BLKB',\n",
       " 'BLL',\n",
       " 'BLMN',\n",
       " 'BLUE',\n",
       " 'BMI',\n",
       " 'BMRC',\n",
       " 'BMRN',\n",
       " 'BMTC',\n",
       " 'BMY',\n",
       " 'BNED',\n",
       " 'BNFT',\n",
       " 'BOCH',\n",
       " 'BOH',\n",
       " 'BOKF',\n",
       " 'BOMN',\n",
       " 'BOOM',\n",
       " 'BOOT',\n",
       " 'BOTJ',\n",
       " 'BOX',\n",
       " 'BPFH',\n",
       " 'BPMC',\n",
       " 'BPOP',\n",
       " 'BPRN',\n",
       " 'BPTH',\n",
       " 'BR',\n",
       " 'BRC',\n",
       " 'BRG',\n",
       " 'BRID',\n",
       " 'BRKL',\n",
       " 'BRKR',\n",
       " 'BRKS',\n",
       " 'BRN',\n",
       " 'BRO',\n",
       " 'BRT',\n",
       " 'BRX',\n",
       " 'BRY',\n",
       " 'BSET',\n",
       " 'BSGM',\n",
       " 'BSQR',\n",
       " 'BSRR',\n",
       " 'BSX',\n",
       " 'BTN',\n",
       " 'BTU',\n",
       " 'BURL',\n",
       " 'BUSE',\n",
       " 'BV',\n",
       " 'BW',\n",
       " 'BWA',\n",
       " 'BWEN',\n",
       " 'BWFG',\n",
       " 'BWXT',\n",
       " 'BXC',\n",
       " 'BXMT',\n",
       " 'BXP',\n",
       " 'BXS',\n",
       " 'BY',\n",
       " 'BYD',\n",
       " 'BYFC',\n",
       " 'BYND',\n",
       " 'BZH',\n",
       " 'C',\n",
       " 'CABO',\n",
       " 'CAC',\n",
       " 'CACC',\n",
       " 'CACI',\n",
       " 'CADE',\n",
       " 'CAG',\n",
       " 'CAH',\n",
       " 'CAI',\n",
       " 'CAKE',\n",
       " 'CAL',\n",
       " 'CALA',\n",
       " 'CALM',\n",
       " 'CALX',\n",
       " 'CAMP',\n",
       " 'CAPR',\n",
       " 'CAR',\n",
       " 'CARA',\n",
       " 'CARG',\n",
       " 'CARS',\n",
       " 'CASA',\n",
       " 'CASH',\n",
       " 'CASI',\n",
       " 'CASS',\n",
       " 'CASY',\n",
       " 'CAT',\n",
       " 'CATB',\n",
       " 'CATC',\n",
       " 'CATO',\n",
       " 'CATY',\n",
       " 'CB',\n",
       " 'CBAN',\n",
       " 'CBAY',\n",
       " 'CBB',\n",
       " 'CBFV',\n",
       " 'CBIO',\n",
       " 'CBLI',\n",
       " 'CBOE',\n",
       " 'CBRE',\n",
       " 'CBRL',\n",
       " 'CBSH',\n",
       " 'CBT',\n",
       " 'CBTX',\n",
       " 'CBU',\n",
       " 'CBZ',\n",
       " 'CC',\n",
       " 'CCBG',\n",
       " 'CCF',\n",
       " 'CCI',\n",
       " 'CCK',\n",
       " 'CCL',\n",
       " 'CCMP',\n",
       " 'CCNE',\n",
       " 'CCO',\n",
       " 'CCOI',\n",
       " 'CCRN',\n",
       " 'CCS',\n",
       " 'CCXI',\n",
       " 'CDAY',\n",
       " 'CDE',\n",
       " 'CDEV',\n",
       " 'CDK',\n",
       " 'CDLX',\n",
       " 'CDMO',\n",
       " 'CDNA',\n",
       " 'CDNS',\n",
       " 'CDR',\n",
       " 'CDTX',\n",
       " 'CDW',\n",
       " 'CDXC',\n",
       " 'CDXS',\n",
       " 'CDZI',\n",
       " 'CE',\n",
       " 'CECE',\n",
       " 'CEI',\n",
       " 'CEIX',\n",
       " 'CELC',\n",
       " 'CELH',\n",
       " 'CEMI',\n",
       " 'CENT',\n",
       " 'CENTA',\n",
       " 'CENX',\n",
       " 'CERC',\n",
       " 'CERN',\n",
       " 'CERS',\n",
       " 'CETX',\n",
       " 'CEVA',\n",
       " 'CF',\n",
       " 'CFBK',\n",
       " 'CFFI',\n",
       " 'CFFN',\n",
       " 'CFG',\n",
       " 'CFMS',\n",
       " 'CFR',\n",
       " 'CFX',\n",
       " 'CGNX',\n",
       " 'CHCI',\n",
       " 'CHCO',\n",
       " 'CHCT',\n",
       " 'CHD',\n",
       " 'CHDN',\n",
       " 'CHE',\n",
       " 'CHEF',\n",
       " 'CHGG',\n",
       " 'CHH',\n",
       " 'CHK',\n",
       " 'CHMA',\n",
       " 'CHMG',\n",
       " 'CHMI',\n",
       " 'CHRS',\n",
       " 'CHRW',\n",
       " 'CHS',\n",
       " 'CHTR',\n",
       " 'CHUY',\n",
       " 'CI',\n",
       " 'CIA',\n",
       " 'CIDM',\n",
       " 'CIEN',\n",
       " 'CIM',\n",
       " 'CINF',\n",
       " 'CIO',\n",
       " 'CIR',\n",
       " 'CIT',\n",
       " 'CIVB',\n",
       " 'CIX',\n",
       " 'CIZN',\n",
       " 'CKX',\n",
       " 'CL',\n",
       " 'CLAR',\n",
       " 'CLB',\n",
       " 'CLBS',\n",
       " 'CLDR',\n",
       " 'CLDT',\n",
       " 'CLDX',\n",
       " 'CLF',\n",
       " 'CLFD',\n",
       " 'CLH',\n",
       " 'CLI',\n",
       " 'CLIR',\n",
       " 'CLNE',\n",
       " 'CLPR',\n",
       " 'CLR',\n",
       " 'CLRB',\n",
       " 'CLRO',\n",
       " 'CLSN',\n",
       " 'CLVS',\n",
       " 'CLW',\n",
       " 'CLX',\n",
       " 'CLXT',\n",
       " 'CMA',\n",
       " 'CMC',\n",
       " 'CMCO',\n",
       " 'CMCSA',\n",
       " 'CMCT',\n",
       " 'CME',\n",
       " 'CMG',\n",
       " 'CMI',\n",
       " 'CMO',\n",
       " 'CMP',\n",
       " 'CMRX',\n",
       " 'CMS',\n",
       " 'CMT',\n",
       " 'CMTL',\n",
       " 'CNA',\n",
       " 'CNBKA',\n",
       " 'CNC',\n",
       " 'CNCE',\n",
       " 'CNDT',\n",
       " 'CNFR',\n",
       " 'CNK',\n",
       " 'CNMD',\n",
       " 'CNNE',\n",
       " 'CNO',\n",
       " 'CNOB',\n",
       " 'CNP',\n",
       " 'CNS',\n",
       " 'CNSL',\n",
       " 'CNTY',\n",
       " 'CNX',\n",
       " 'CNXN',\n",
       " 'CODA',\n",
       " 'COF',\n",
       " 'COG',\n",
       " 'COHN',\n",
       " 'COHR',\n",
       " 'COHU',\n",
       " 'COKE',\n",
       " 'COLB',\n",
       " 'COLD',\n",
       " 'COLL',\n",
       " 'COLM',\n",
       " 'COMM',\n",
       " 'CONE',\n",
       " 'CONN',\n",
       " 'COO',\n",
       " 'COOP',\n",
       " 'COP',\n",
       " 'COR',\n",
       " 'CORE',\n",
       " 'CORR',\n",
       " 'CORT',\n",
       " 'COST',\n",
       " 'COTY',\n",
       " 'COUP',\n",
       " 'COWN',\n",
       " 'CPB',\n",
       " 'CPE',\n",
       " 'CPF',\n",
       " 'CPHC',\n",
       " 'CPIX',\n",
       " 'CPK',\n",
       " 'CPLG',\n",
       " 'CPRI',\n",
       " 'CPRT',\n",
       " 'CPRX',\n",
       " 'CPS',\n",
       " 'CPSH',\n",
       " 'CPSI',\n",
       " 'CPSS',\n",
       " 'CPT',\n",
       " 'CR',\n",
       " 'CRAI',\n",
       " 'CRBP',\n",
       " 'CRC',\n",
       " 'CREE',\n",
       " 'CRI',\n",
       " 'CRIS',\n",
       " 'CRK',\n",
       " 'CRL',\n",
       " 'CRM',\n",
       " 'CRMD',\n",
       " 'CRMT',\n",
       " 'CRNX',\n",
       " 'CROX',\n",
       " 'CRS',\n",
       " 'CRTX',\n",
       " 'CRUS',\n",
       " 'CRVL',\n",
       " 'CRVS',\n",
       " 'CRWS',\n",
       " 'CRY',\n",
       " 'CSCO',\n",
       " 'CSGP',\n",
       " 'CSGS',\n",
       " 'CSII',\n",
       " 'CSL',\n",
       " 'CSLT',\n",
       " 'CSOD',\n",
       " 'CSPI',\n",
       " 'CSTR',\n",
       " 'CSU',\n",
       " 'CSV',\n",
       " 'CSWI',\n",
       " 'CSX',\n",
       " 'CTAS',\n",
       " 'CTBI',\n",
       " 'CTG',\n",
       " 'CTHR',\n",
       " 'CTIB',\n",
       " 'CTIC',\n",
       " 'CTLT',\n",
       " 'CTMX',\n",
       " 'CTO',\n",
       " 'CTRE',\n",
       " 'CTRN',\n",
       " 'CTS',\n",
       " 'CTSH',\n",
       " 'CTSO',\n",
       " 'CTT',\n",
       " 'CTXS',\n",
       " 'CUBE',\n",
       " 'CUBI',\n",
       " 'CUE',\n",
       " 'CULP',\n",
       " 'CURO',\n",
       " 'CUTR',\n",
       " 'CUZ',\n",
       " 'CVA',\n",
       " 'CVBF',\n",
       " 'CVCO',\n",
       " 'CVCY',\n",
       " 'CVGI',\n",
       " 'CVGW',\n",
       " 'CVI',\n",
       " 'CVLT',\n",
       " 'CVLY',\n",
       " 'CVM',\n",
       " 'CVNA',\n",
       " 'CVR',\n",
       " 'CVS',\n",
       " 'CVU',\n",
       " 'CVV',\n",
       " 'CVX',\n",
       " 'CW',\n",
       " 'CWBC',\n",
       " 'CWBR',\n",
       " 'CWEN',\n",
       " 'CWH',\n",
       " 'CWST',\n",
       " 'CWT',\n",
       " 'CXP',\n",
       " 'CXW',\n",
       " 'CYAN',\n",
       " 'CYBE',\n",
       " 'CYCC',\n",
       " 'CYH',\n",
       " 'CYRX',\n",
       " 'CYTK',\n",
       " 'CYTR',\n",
       " 'CZNC',\n",
       " 'CZR',\n",
       " 'CZWI',\n",
       " 'D',\n",
       " 'DAIO',\n",
       " 'DAKT',\n",
       " 'DAL',\n",
       " 'DAN',\n",
       " 'DAR',\n",
       " 'DARE',\n",
       " 'DBD',\n",
       " 'DBI',\n",
       " 'DBX',\n",
       " 'DCI',\n",
       " 'DCO',\n",
       " 'DCOM',\n",
       " 'DCPH',\n",
       " 'DD',\n",
       " 'DDD',\n",
       " 'DDS',\n",
       " 'DE',\n",
       " 'DEA',\n",
       " 'DECK',\n",
       " 'DEI',\n",
       " 'DELL',\n",
       " 'DENN',\n",
       " 'DFIN',\n",
       " 'DFS',\n",
       " 'DG',\n",
       " 'DGICA',\n",
       " 'DGII',\n",
       " 'DGLY',\n",
       " 'DGX',\n",
       " 'DHI',\n",
       " 'DHIL',\n",
       " 'DHR',\n",
       " 'DHX',\n",
       " 'DIN',\n",
       " 'DIOD',\n",
       " 'DIS',\n",
       " 'DISCA',\n",
       " 'DISCK',\n",
       " 'DISH',\n",
       " 'DIT',\n",
       " 'DJCO',\n",
       " 'DK',\n",
       " 'DKS',\n",
       " 'DLA',\n",
       " 'DLB',\n",
       " 'DLHC',\n",
       " 'DLR',\n",
       " 'DLTH',\n",
       " 'DLTR',\n",
       " 'DLX',\n",
       " 'DMRC',\n",
       " 'DNLI',\n",
       " 'DNOW',\n",
       " 'DOC',\n",
       " 'DOCU',\n",
       " 'DOMO',\n",
       " 'DOOR',\n",
       " 'DORM',\n",
       " 'DOV',\n",
       " 'DOW',\n",
       " 'DPZ',\n",
       " 'DRE',\n",
       " 'DRH',\n",
       " 'DRI',\n",
       " 'DRNA',\n",
       " 'DRQ',\n",
       " 'DRRX',\n",
       " 'DS',\n",
       " 'DSKE',\n",
       " 'DSPG',\n",
       " 'DSS',\n",
       " 'DTE',\n",
       " 'DUK',\n",
       " 'DVA',\n",
       " 'DVAX',\n",
       " 'DVD',\n",
       " 'DVN',\n",
       " 'DWSN',\n",
       " 'DX',\n",
       " 'DXC',\n",
       " 'DXCM',\n",
       " 'DXLG',\n",
       " 'DXPE',\n",
       " 'DXYN',\n",
       " 'DY',\n",
       " 'DZSI',\n",
       " 'EA',\n",
       " 'EAF',\n",
       " 'EARN',\n",
       " 'EAT',\n",
       " 'EB',\n",
       " 'EBAY',\n",
       " 'EBF',\n",
       " 'EBIX',\n",
       " 'EBMT',\n",
       " 'EBS',\n",
       " 'EBSB',\n",
       " 'EBTC',\n",
       " 'ECHO',\n",
       " 'ECL',\n",
       " 'ECOL',\n",
       " 'ECOM',\n",
       " 'ECPG',\n",
       " 'ED',\n",
       " 'EDIT',\n",
       " 'EDUC',\n",
       " 'EEFT',\n",
       " 'EEX',\n",
       " 'EFC',\n",
       " 'EFOI',\n",
       " 'EFSC',\n",
       " 'EFX',\n",
       " 'EGAN',\n",
       " 'EGBN',\n",
       " 'EGHT',\n",
       " 'EGLE',\n",
       " 'EGP',\n",
       " 'EGRX',\n",
       " 'EGY',\n",
       " 'EHC',\n",
       " 'EHTH',\n",
       " 'EIG',\n",
       " 'EIGR',\n",
       " 'EIX',\n",
       " 'EKSO',\n",
       " 'EL',\n",
       " 'ELAN',\n",
       " 'ELF',\n",
       " 'ELMD',\n",
       " 'ELOX',\n",
       " 'ELS',\n",
       " 'ELSE',\n",
       " 'ELVT',\n",
       " 'ELY',\n",
       " 'EMAN',\n",
       " 'EMCF',\n",
       " 'EME',\n",
       " 'EMKR',\n",
       " 'EML',\n",
       " 'EMMS',\n",
       " 'EMN',\n",
       " 'EMR',\n",
       " 'ENDP',\n",
       " 'ENG',\n",
       " 'ENOB',\n",
       " 'ENPH',\n",
       " 'ENR',\n",
       " 'ENS',\n",
       " 'ENSG',\n",
       " 'ENSV',\n",
       " 'ENTA',\n",
       " 'ENTG',\n",
       " 'ENV',\n",
       " 'ENVA',\n",
       " 'ENZ',\n",
       " 'EOG',\n",
       " 'EOLS',\n",
       " 'EPAM',\n",
       " 'EPAY',\n",
       " 'EPC',\n",
       " 'EPM',\n",
       " 'EPR',\n",
       " 'EPRT',\n",
       " 'EPZM',\n",
       " 'EQBK',\n",
       " 'EQC',\n",
       " 'EQH',\n",
       " 'EQIX',\n",
       " 'EQR',\n",
       " 'EQT',\n",
       " 'ERIE',\n",
       " 'ERII',\n",
       " 'ES',\n",
       " 'ESBK',\n",
       " 'ESCA',\n",
       " 'ESE',\n",
       " 'ESGR',\n",
       " 'ESNT',\n",
       " 'ESP',\n",
       " 'ESPR',\n",
       " 'ESRT',\n",
       " 'ESS',\n",
       " 'ESSA',\n",
       " 'ESTC',\n",
       " 'ESTE',\n",
       " 'ESXB',\n",
       " 'ETH',\n",
       " 'ETN',\n",
       " 'ETR',\n",
       " 'ETRN',\n",
       " 'ETSY',\n",
       " 'EVBG',\n",
       " 'EVBN',\n",
       " 'EVC',\n",
       " 'EVER',\n",
       " 'EVFM',\n",
       " 'EVH',\n",
       " 'EVI',\n",
       " 'EVOK',\n",
       " 'EVOL',\n",
       " 'EVOP',\n",
       " 'EVR',\n",
       " 'EVRG',\n",
       " 'EVRI',\n",
       " 'EVTC',\n",
       " 'EW',\n",
       " 'EWBC',\n",
       " 'EXAS',\n",
       " 'EXC',\n",
       " 'EXEL',\n",
       " 'EXLS',\n",
       " 'EXP',\n",
       " 'EXPD',\n",
       " 'EXPE',\n",
       " 'EXPI',\n",
       " 'EXPO',\n",
       " 'EXPR',\n",
       " 'EXR',\n",
       " 'EXTN',\n",
       " 'EXTR',\n",
       " 'EYE',\n",
       " 'EYEG',\n",
       " 'EYES',\n",
       " 'EYPT',\n",
       " 'EZPW',\n",
       " 'F',\n",
       " 'FAF',\n",
       " 'FANG',\n",
       " 'FARM',\n",
       " 'FARO',\n",
       " 'FAST',\n",
       " 'FATE',\n",
       " 'FB',\n",
       " ...]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# listdir returns all files in the directory and isfile will return true\n",
    "# if it is a file and then we store its name in our list named files\n",
    "files = [x for x in listdir(path) if isfile(join(path, x))]\n",
    "\n",
    "# Remove extension from file names\n",
    "# Splitext splits the file name into 2 parts being the name and extension\n",
    "# We say get all file names and then store just the name in our list named files\n",
    "tickers = [os.path.splitext(x)[0] for x in files]\n",
    "tickers"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create a Dataframe from our List"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AAME</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3046</th>\n",
       "      <td>ZUMZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3047</th>\n",
       "      <td>ZUO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3048</th>\n",
       "      <td>ZVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3049</th>\n",
       "      <td>ZYNE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3050</th>\n",
       "      <td>ZYXI</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3051 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Ticker\n",
       "0         A\n",
       "1        AA\n",
       "2       AAL\n",
       "3      AAME\n",
       "4       AAN\n",
       "...     ...\n",
       "3046   ZUMZ\n",
       "3047    ZUO\n",
       "3048    ZVO\n",
       "3049   ZYNE\n",
       "3050   ZYXI\n",
       "\n",
       "[3051 rows x 1 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stock_df = pd.DataFrame(tickers,columns=['Ticker'])\n",
    "stock_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Function that Returns a Dataframe from a CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reads a dataframe from the CSV file, changes index to date and returns it\n",
    "def get_df_from_csv(ticker):\n",
    "    \n",
    "    # Try to get the file and if it doesn't exist issue a warning\n",
    "    try:\n",
    "        df = pd.read_csv(path + ticker + '.csv')\n",
    "    except FileNotFoundError:\n",
    "        print(\"File Doesn't Exist\")\n",
    "    else:\n",
    "        return df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Function that Saves Dataframe to CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "def save_dataframe_to_csv(df, ticker):\n",
    "    df.to_csv(path + ticker + '.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Delete Unnamed Columns in CSV Files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def delete_unnamed_cols(df):\n",
    "    df = df.loc[:, ~df.columns.str.contains('^Unnamed')]\n",
    "    return df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Add Daily Return to Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# We calculate a percentage rate of return for each day to compare investments.\n",
    "# Simple Rate of Return = (End Price - Beginning Price) / Beginning Price OR (EP / BP) - 1\n",
    "\n",
    "# Shift provides the value from the previous day\n",
    "# NaN is displayed because there was no previous day price for the 1st calculation\n",
    "def add_daily_return_to_df(df, ticker):\n",
    "    df['daily_return'] = (df['Adj Close'] / df['Adj Close'].shift(1)) - 1\n",
    "    # Save data to a CSV file\n",
    "    df.to_csv(path + ticker + '.csv')\n",
    "    return df  "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Returns Return on Investment over Time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Return on Investment is the return you received from your investment\n",
    "# This amount does not include your initial investment\n",
    "# If you invest 100 and have 200 after 5 years\n",
    "# ROI = End Value (200) - Initial Value (100) / Inital Value = 1\n",
    "# Your new total is Inital Investment + 1 * Inital Investment = 200\n",
    "\n",
    "def get_roi_defined_time(df):\n",
    "    # Set as a datetime\n",
    "    df['Date'] = pd.to_datetime(df['Date'])\n",
    "    start_val = df[df['Date'] == S_DATE_STR]['Adj Close'][0]\n",
    "    print(\"Initial Price :\", start_val)\n",
    "    \n",
    "    # ----- I CHANGED THIS AFTER THE VIDEO -----\n",
    "    \n",
    "    end_val = df[df['Date'] == E_DATE_STR]['Adj Close']\n",
    "    print(end_val.item())\n",
    "    print(\"Final Price :\", end_val.item())\n",
    "    \n",
    "    # ----- END OF VIDEO CHANGES -----\n",
    "    \n",
    "    # Calculate return on investment\n",
    "    roi = (end_val - start_val) / start_val\n",
    "\n",
    "    # Return the total return between 2 dates\n",
    "    return roi"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get Coefficient of Variation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Receives the dataframe with the Adj Close data and returns the coefficient of variation\n",
    "def get_cov(stock_df):\n",
    "    mean = stock_df['Adj Close'].mean()\n",
    "    sd = stock_df['Adj Close'].std()\n",
    "    cov = sd / mean\n",
    "    return cov"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Test Functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a backup for all original stock data\n",
    "\n",
    "# Get our 1st ticker\n",
    "tickers[0]\n",
    "\n",
    "# Get a dataframe for that ticker\n",
    "stock_a = get_df_from_csv(tickers[0])\n",
    "stock_a\n",
    "\n",
    "# Add daily return to this dataframe\n",
    "add_daily_return_to_df(stock_a, tickers[0])\n",
    "stock_a\n",
    "\n",
    "# Delete unnamed columns in dataframe\n",
    "stock_a = delete_unnamed_cols(stock_a)\n",
    "stock_a\n",
    "\n",
    "# Save cleaned dataframe to csv\n",
    "save_dataframe_to_csv(stock_a, tickers[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Add Daily Returns & Clean Up All Files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Working on : A\n",
      "Working on : AA\n",
      "Working on : AAL\n",
      "Working on : AAME\n",
      "Working on : AAN\n",
      "Working on : AAOI\n",
      "Working on : AAON\n",
      "Working on : AAP\n",
      "Working on : AAPL\n",
      "Working on : AAT\n",
      "Working on : AAWW\n",
      "Working on : ABBV\n",
      "Working on : ABC\n",
      "Working on : ABCB\n",
      "Working on : ABEO\n",
      "Working on : ABG\n",
      "Working on : ABIO\n",
      "Working on : ABM\n",
      "Working on : ABMD\n",
      "Working on : ABR\n",
      "Working on : ABT\n",
      "Working on : ABTX\n",
      "Working on : AC\n",
      "Working on : ACA\n",
      "Working on : ACAD\n",
      "Working on : ACBI\n",
      "Working on : ACC\n",
      "Working on : ACCO\n",
      "Working on : ACER\n",
      "Working on : ACGL\n",
      "Working on : ACHC\n",
      "Working on : ACHV\n",
      "Working on : ACIW\n",
      "Working on : ACLS\n",
      "Working on : ACM\n",
      "Working on : ACMR\n",
      "Working on : ACN\n",
      "Working on : ACNB\n",
      "Working on : ACOR\n",
      "Working on : ACRE\n",
      "Working on : ACRS\n",
      "Working on : ACRX\n",
      "Working on : ACTG\n",
      "Working on : ACU\n",
      "Working on : ACY\n",
      "Working on : ADBE\n",
      "Working on : ADC\n",
      "Working on : ADES\n",
      "Working on : ADI\n",
      "Working on : ADM\n",
      "Working on : ADMA\n",
      "Working on : ADMP\n",
      "Working on : ADMS\n",
      "Working on : ADNT\n",
      "Working on : ADP\n",
      "Working on : ADS\n",
      "Working on : ADSK\n",
      "Working on : ADT\n",
      "Working on : ADTN\n",
      "Working on : ADUS\n",
      "Working on : ADVM\n",
      "Working on : ADXS\n",
      "Working on : AE\n",
      "Working on : AEE\n",
      "Working on : AEHR\n",
      "Working on : AEIS\n",
      "Working on : AEL\n",
      "Working on : AEMD\n",
      "Working on : AEO\n",
      "Working on : AEP\n",
      "Working on : AERI\n",
      "Working on : AES\n",
      "Working on : AEY\n",
      "Working on : AFG\n",
      "Working on : AFI\n",
      "Working on : AFIN\n",
      "Working on : AFL\n",
      "Working on : AGCO\n",
      "Working on : AGE\n",
      "Working on : AGEN\n",
      "Working on : AGFS\n",
      "Working on : AGIO\n",
      "Working on : AGLE\n",
      "Working on : AGM\n",
      "Working on : AGNC\n",
      "Working on : AGO\n",
      "Working on : AGR\n",
      "Working on : AGRX\n",
      "Working on : AGS\n",
      "Working on : AGTC\n",
      "Working on : AGX\n",
      "Working on : AGYS\n",
      "Working on : AHH\n",
      "Working on : AHT\n",
      "Working on : AIG\n",
      "Working on : AIMC\n",
      "Working on : AIN\n",
      "Working on : AINC\n",
      "Working on : AIR\n",
      "Working on : AIRG\n",
      "Working on : AIRI\n",
      "Working on : AIRT\n",
      "Working on : AIT\n",
      "Working on : AIV\n",
      "Working on : AIZ\n",
      "Working on : AJG\n",
      "Working on : AJRD\n",
      "Working on : AJX\n",
      "Working on : AKAM\n",
      "Working on : AKBA\n",
      "Working on : AKR\n",
      "Working on : AKTS\n",
      "Working on : AL\n",
      "Working on : ALB\n",
      "Working on : ALBO\n",
      "Working on : ALCO\n",
      "Working on : ALDX\n",
      "Working on : ALE\n",
      "Working on : ALEC\n",
      "Working on : ALEX\n",
      "Working on : ALG\n",
      "Working on : ALGN\n",
      "Working on : ALGT\n",
      "Working on : ALIM\n",
      "Working on : ALJJ\n",
      "Working on : ALK\n",
      "Working on : ALKS\n",
      "Working on : ALL\n",
      "Working on : ALLE\n",
      "Working on : ALLK\n",
      "Working on : ALLO\n",
      "Working on : ALLY\n",
      "Working on : ALNA\n",
      "Working on : ALNY\n",
      "Working on : ALOT\n",
      "Working on : ALPN\n",
      "Working on : ALRM\n",
      "Working on : ALSN\n",
      "Working on : ALT\n",
      "Working on : ALTM\n",
      "Working on : ALTR\n",
      "Working on : ALV\n",
      "Working on : ALX\n",
      "Working on : ALXN\n",
      "Working on : AM\n",
      "Working on : AMAL\n",
      "Working on : AMAT\n",
      "Working on : AMBC\n",
      "Working on : AMC\n",
      "Working on : AMCX\n",
      "Working on : AMD\n",
      "Working on : AME\n",
      "Working on : AMED\n",
      "Working on : AMG\n",
      "Working on : AMGN\n",
      "Working on : AMH\n",
      "Working on : AMKR\n",
      "Working on : AMN\n",
      "Working on : AMNB\n",
      "Working on : AMOT\n",
      "Working on : AMP\n",
      "Working on : AMPE\n",
      "Working on : AMPH\n",
      "Working on : AMRC\n",
      "Working on : AMRK\n",
      "Working on : AMRS\n",
      "Working on : AMRX\n",
      "Working on : AMS\n",
      "Working on : AMSC\n",
      "Working on : AMSF\n",
      "Working on : AMSWA\n",
      "Working on : AMT\n",
      "Working on : AMTX\n",
      "Working on : AMWD\n",
      "Working on : AMZN\n",
      "Working on : AN\n",
      "Working on : ANAB\n",
      "Working on : ANAT\n",
      "Working on : ANDE\n",
      "Working on : ANET\n",
      "Working on : ANF\n",
      "Working on : ANGI\n",
      "Working on : ANGO\n",
      "Working on : ANIK\n",
      "Working on : ANIP\n",
      "Working on : ANIX\n",
      "Working on : ANSS\n",
      "Working on : ANTM\n",
      "Working on : AON\n",
      "Working on : AOS\n",
      "Working on : AOSL\n",
      "Working on : AP\n",
      "Working on : APA\n",
      "Working on : APAM\n",
      "Working on : APD\n",
      "Working on : APDN\n",
      "Working on : APEI\n",
      "Working on : APEN\n",
      "Working on : APH\n",
      "Working on : APLE\n",
      "Working on : APLS\n",
      "Working on : APOG\n",
      "Working on : APPF\n",
      "Working on : APPN\n",
      "Working on : APPS\n",
      "Working on : APRN\n",
      "Working on : APT\n",
      "Working on : APTS\n",
      "Working on : APTV\n",
      "Working on : APVO\n",
      "Working on : APYX\n",
      "Working on : AQB\n",
      "Working on : AQMS\n",
      "Working on : AQUA\n",
      "Working on : AR\n",
      "Working on : ARAV\n",
      "Working on : ARAY\n",
      "Working on : ARC\n",
      "Working on : ARCB\n",
      "Working on : ARCH\n",
      "Working on : ARDX\n",
      "Working on : ARE\n",
      "Working on : ARES\n",
      "Working on : ARGO\n",
      "Working on : ARI\n",
      "Working on : ARKR\n",
      "Working on : ARL\n",
      "Working on : ARLO\n",
      "Working on : ARMK\n",
      "Working on : ARNA\n",
      "Working on : ARNC\n",
      "Working on : AROC\n",
      "Working on : AROW\n",
      "Working on : ARPO\n",
      "Working on : ARR\n",
      "Working on : ARTNA\n",
      "Working on : ARTW\n",
      "Working on : ARVN\n",
      "Working on : ARW\n",
      "Working on : ARWR\n",
      "Working on : ASB\n",
      "Working on : ASGN\n",
      "Working on : ASH\n",
      "Working on : ASIX\n",
      "Working on : ASMB\n",
      "Working on : ASPN\n",
      "Working on : ASPS\n",
      "Working on : ASRT\n",
      "Working on : ASRV\n",
      "Working on : ASTC\n",
      "Working on : ASTE\n",
      "Working on : ASUR\n",
      "Working on : ASYS\n",
      "Working on : ATEC\n",
      "Working on : ATEN\n",
      "Working on : ATGE\n",
      "Working on : ATH\n",
      "Working on : ATHX\n",
      "Working on : ATI\n",
      "Working on : ATKR\n",
      "Working on : ATLC\n",
      "Working on : ATLO\n",
      "Working on : ATNI\n",
      "Working on : ATNM\n",
      "Working on : ATNX\n",
      "Working on : ATO\n",
      "Working on : ATOS\n",
      "Working on : ATR\n",
      "Working on : ATRA\n",
      "Working on : ATRC\n",
      "Working on : ATRI\n",
      "Working on : ATRO\n",
      "Working on : ATRS\n",
      "Working on : ATSG\n",
      "Working on : ATUS\n",
      "Working on : ATVI\n",
      "Working on : AUBN\n",
      "Working on : AUMN\n",
      "Working on : AUTO\n",
      "Working on : AVA\n",
      "Working on : AVAV\n",
      "Working on : AVB\n",
      "Working on : AVD\n",
      "Working on : AVEO\n",
      "Working on : AVGO\n",
      "Working on : AVGR\n",
      "Working on : AVID\n",
      "Working on : AVLR\n",
      "Working on : AVNS\n",
      "Working on : AVNW\n",
      "Working on : AVRO\n",
      "Working on : AVT\n",
      "Working on : AVTR\n",
      "Working on : AVXL\n",
      "Working on : AVY\n",
      "Working on : AVYA\n",
      "Working on : AWI\n",
      "Working on : AWK\n",
      "Working on : AWR\n",
      "Working on : AWRE\n",
      "Working on : AX\n",
      "Working on : AXAS\n",
      "Working on : AXDX\n",
      "Working on : AXGN\n",
      "Working on : AXL\n",
      "Working on : AXNX\n",
      "Working on : AXP\n",
      "Working on : AXR\n",
      "Working on : AXS\n",
      "Working on : AXSM\n",
      "Working on : AXTA\n",
      "Working on : AXTI\n",
      "Working on : AYI\n",
      "Working on : AYX\n",
      "Working on : AZO\n",
      "Working on : AZPN\n",
      "Working on : AZZ\n",
      "Working on : B\n",
      "Working on : BA\n",
      "Working on : BAC\n",
      "Working on : BAH\n",
      "Working on : BANC\n",
      "Working on : BAND\n",
      "Working on : BANF\n",
      "Working on : BANR\n",
      "Working on : BATRA\n",
      "Working on : BATRK\n",
      "Working on : BAX\n",
      "Working on : BBBY\n",
      "Working on : BBCP\n",
      "Working on : BBGI\n",
      "Working on : BBSI\n",
      "Working on : BBW\n",
      "Working on : BBY\n",
      "Working on : BC\n",
      "Working on : BCBP\n",
      "Working on : BCC\n",
      "Working on : BCEI\n",
      "Working on : BCLI\n",
      "Working on : BCO\n",
      "Working on : BCOR\n",
      "Working on : BCOV\n",
      "Working on : BCPC\n",
      "Working on : BCRX\n",
      "Working on : BDC\n",
      "Working on : BDL\n",
      "Working on : BDN\n",
      "Working on : BDSI\n",
      "Working on : BDX\n",
      "Working on : BE\n",
      "Working on : BECN\n",
      "Working on : BELFA\n",
      "Working on : BELFB\n",
      "Working on : BEN\n",
      "Working on : BERY\n",
      "Working on : BFAM\n",
      "Working on : BFIN\n",
      "Working on : BFS\n",
      "Working on : BFST\n",
      "Working on : BG\n",
      "Working on : BGCP\n",
      "Working on : BGFV\n",
      "Working on : BGS\n",
      "Working on : BGSF\n",
      "Working on : BH\n",
      "Working on : BHB\n",
      "Working on : BHE\n",
      "Working on : BHF\n",
      "Working on : BHLB\n",
      "Working on : BHR\n",
      "Working on : BHVN\n",
      "Working on : BIG\n",
      "Working on : BIIB\n",
      "Working on : BIO\n",
      "Working on : BIOC\n",
      "Working on : BIOL\n",
      "Working on : BJ\n",
      "Working on : BJRI\n",
      "Working on : BK\n",
      "Working on : BKD\n",
      "Working on : BKE\n",
      "Working on : BKH\n",
      "Working on : BKI\n",
      "Working on : BKNG\n",
      "Working on : BKSC\n",
      "Working on : BKTI\n",
      "Working on : BKU\n",
      "Working on : BL\n",
      "Working on : BLBD\n",
      "Working on : BLCM\n",
      "Working on : BLD\n",
      "Working on : BLDR\n",
      "Working on : BLFS\n",
      "Working on : BLK\n",
      "Working on : BLKB\n",
      "Working on : BLL\n",
      "Working on : BLMN\n",
      "Working on : BLUE\n",
      "Working on : BMI\n",
      "Working on : BMRC\n",
      "Working on : BMRN\n",
      "Working on : BMTC\n",
      "Working on : BMY\n",
      "Working on : BNED\n",
      "Working on : BNFT\n",
      "Working on : BOCH\n",
      "Working on : BOH\n",
      "Working on : BOKF\n",
      "Working on : BOMN\n",
      "Working on : BOOM\n",
      "Working on : BOOT\n",
      "Working on : BOTJ\n",
      "Working on : BOX\n",
      "Working on : BPFH\n",
      "Working on : BPMC\n",
      "Working on : BPOP\n",
      "Working on : BPRN\n",
      "Working on : BPTH\n",
      "Working on : BR\n",
      "Working on : BRC\n",
      "Working on : BRG\n",
      "Working on : BRID\n",
      "Working on : BRKL\n",
      "Working on : BRKR\n",
      "Working on : BRKS\n",
      "Working on : BRN\n",
      "Working on : BRO\n",
      "Working on : BRT\n",
      "Working on : BRX\n",
      "Working on : BRY\n",
      "Working on : BSET\n",
      "Working on : BSGM\n",
      "Working on : BSQR\n",
      "Working on : BSRR\n",
      "Working on : BSX\n",
      "Working on : BTN\n",
      "Working on : BTU\n",
      "Working on : BURL\n",
      "Working on : BUSE\n",
      "Working on : BV\n",
      "Working on : BW\n",
      "Working on : BWA\n",
      "Working on : BWEN\n",
      "Working on : BWFG\n",
      "Working on : BWXT\n",
      "Working on : BXC\n",
      "Working on : BXMT\n",
      "Working on : BXP\n",
      "Working on : BXS\n",
      "Working on : BY\n",
      "Working on : BYD\n",
      "Working on : BYFC\n",
      "Working on : BYND\n",
      "Working on : BZH\n",
      "Working on : C\n",
      "Working on : CABO\n",
      "Working on : CAC\n",
      "Working on : CACC\n",
      "Working on : CACI\n",
      "Working on : CADE\n",
      "Working on : CAG\n",
      "Working on : CAH\n",
      "Working on : CAI\n",
      "Working on : CAKE\n",
      "Working on : CAL\n",
      "Working on : CALA\n",
      "Working on : CALM\n",
      "Working on : CALX\n",
      "Working on : CAMP\n",
      "Working on : CAPR\n",
      "Working on : CAR\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Working on : CARA\n",
      "Working on : CARG\n",
      "Working on : CARS\n",
      "Working on : CASA\n",
      "Working on : CASH\n",
      "Working on : CASI\n",
      "Working on : CASS\n",
      "Working on : CASY\n",
      "Working on : CAT\n",
      "Working on : CATB\n",
      "Working on : CATC\n",
      "Working on : CATO\n",
      "Working on : CATY\n",
      "Working on : CB\n",
      "Working on : CBAN\n",
      "Working on : CBAY\n",
      "Working on : CBB\n",
      "Working on : CBFV\n",
      "Working on : CBIO\n",
      "Working on : CBLI\n",
      "Working on : CBOE\n",
      "Working on : CBRE\n",
      "Working on : CBRL\n",
      "Working on : CBSH\n",
      "Working on : CBT\n",
      "Working on : CBTX\n",
      "Working on : CBU\n",
      "Working on : CBZ\n",
      "Working on : CC\n",
      "Working on : CCBG\n",
      "Working on : CCF\n",
      "Working on : CCI\n",
      "Working on : CCK\n",
      "Working on : CCL\n",
      "Working on : CCMP\n",
      "Working on : CCNE\n",
      "Working on : CCO\n",
      "Working on : CCOI\n",
      "Working on : CCRN\n",
      "Working on : CCS\n",
      "Working on : CCXI\n",
      "Working on : CDAY\n",
      "Working on : CDE\n",
      "Working on : CDEV\n",
      "Working on : CDK\n",
      "Working on : CDLX\n",
      "Working on : CDMO\n",
      "Working on : CDNA\n",
      "Working on : CDNS\n",
      "Working on : CDR\n",
      "Working on : CDTX\n",
      "Working on : CDW\n",
      "Working on : CDXC\n",
      "Working on : CDXS\n",
      "Working on : CDZI\n",
      "Working on : CE\n",
      "Working on : CECE\n",
      "Working on : CEI\n",
      "Working on : CEIX\n",
      "Working on : CELC\n",
      "Working on : CELH\n",
      "Working on : CEMI\n",
      "Working on : CENT\n",
      "Working on : CENTA\n",
      "Working on : CENX\n",
      "Working on : CERC\n",
      "Working on : CERN\n",
      "Working on : CERS\n",
      "Working on : CETX\n",
      "Working on : CEVA\n",
      "Working on : CF\n",
      "Working on : CFBK\n",
      "Working on : CFFI\n",
      "Working on : CFFN\n",
      "Working on : CFG\n",
      "Working on : CFMS\n",
      "Working on : CFR\n",
      "Working on : CFX\n",
      "Working on : CGNX\n",
      "Working on : CHCI\n",
      "Working on : CHCO\n",
      "Working on : CHCT\n",
      "Working on : CHD\n",
      "Working on : CHDN\n",
      "Working on : CHE\n",
      "Working on : CHEF\n",
      "Working on : CHGG\n",
      "Working on : CHH\n",
      "Working on : CHK\n",
      "Working on : CHMA\n",
      "Working on : CHMG\n",
      "Working on : CHMI\n",
      "Working on : CHRS\n",
      "Working on : CHRW\n",
      "Working on : CHS\n",
      "Working on : CHTR\n",
      "Working on : CHUY\n",
      "Working on : CI\n",
      "Working on : CIA\n",
      "Working on : CIDM\n",
      "Working on : CIEN\n",
      "Working on : CIM\n",
      "Working on : CINF\n",
      "Working on : CIO\n",
      "Working on : CIR\n",
      "Working on : CIT\n",
      "Working on : CIVB\n",
      "Working on : CIX\n",
      "Working on : CIZN\n",
      "Working on : CKX\n",
      "Working on : CL\n",
      "Working on : CLAR\n",
      "Working on : CLB\n",
      "Working on : CLBS\n",
      "Working on : CLDR\n",
      "Working on : CLDT\n",
      "Working on : CLDX\n",
      "Working on : CLF\n",
      "Working on : CLFD\n",
      "Working on : CLH\n",
      "Working on : CLI\n",
      "Working on : CLIR\n",
      "Working on : CLNE\n",
      "Working on : CLPR\n",
      "Working on : CLR\n",
      "Working on : CLRB\n",
      "Working on : CLRO\n",
      "Working on : CLSN\n",
      "Working on : CLVS\n",
      "Working on : CLW\n",
      "Working on : CLX\n",
      "Working on : CLXT\n",
      "Working on : CMA\n",
      "Working on : CMC\n",
      "Working on : CMCO\n",
      "Working on : CMCSA\n",
      "Working on : CMCT\n",
      "Working on : CME\n",
      "Working on : CMG\n",
      "Working on : CMI\n",
      "Working on : CMO\n",
      "Working on : CMP\n",
      "Working on : CMRX\n",
      "Working on : CMS\n",
      "Working on : CMT\n",
      "Working on : CMTL\n",
      "Working on : CNA\n",
      "Working on : CNBKA\n",
      "Working on : CNC\n",
      "Working on : CNCE\n",
      "Working on : CNDT\n",
      "Working on : CNFR\n",
      "Working on : CNK\n",
      "Working on : CNMD\n",
      "Working on : CNNE\n",
      "Working on : CNO\n",
      "Working on : CNOB\n",
      "Working on : CNP\n",
      "Working on : CNS\n",
      "Working on : CNSL\n",
      "Working on : CNTY\n",
      "Working on : CNX\n",
      "Working on : CNXN\n",
      "Working on : CODA\n",
      "Working on : COF\n",
      "Working on : COG\n",
      "Working on : COHN\n",
      "Working on : COHR\n",
      "Working on : COHU\n",
      "Working on : COKE\n",
      "Working on : COLB\n",
      "Working on : COLD\n",
      "Working on : COLL\n",
      "Working on : COLM\n",
      "Working on : COMM\n",
      "Working on : CONE\n",
      "Working on : CONN\n",
      "Working on : COO\n",
      "Working on : COOP\n",
      "Working on : COP\n",
      "Working on : COR\n",
      "Working on : CORE\n",
      "Working on : CORR\n",
      "Working on : CORT\n",
      "Working on : COST\n",
      "Working on : COTY\n",
      "Working on : COUP\n",
      "Working on : COWN\n",
      "Working on : CPB\n",
      "Working on : CPE\n",
      "Working on : CPF\n",
      "Working on : CPHC\n",
      "Working on : CPIX\n",
      "Working on : CPK\n",
      "Working on : CPLG\n",
      "Working on : CPRI\n",
      "Working on : CPRT\n",
      "Working on : CPRX\n",
      "Working on : CPS\n",
      "Working on : CPSH\n",
      "Working on : CPSI\n",
      "Working on : CPSS\n",
      "Working on : CPT\n",
      "Working on : CR\n",
      "Working on : CRAI\n",
      "Working on : CRBP\n",
      "Working on : CRC\n",
      "Working on : CREE\n",
      "Working on : CRI\n",
      "Working on : CRIS\n",
      "Working on : CRK\n",
      "Working on : CRL\n",
      "Working on : CRM\n",
      "Working on : CRMD\n",
      "Working on : CRMT\n",
      "Working on : CRNX\n",
      "Working on : CROX\n",
      "Working on : CRS\n",
      "Working on : CRTX\n",
      "Working on : CRUS\n",
      "Working on : CRVL\n",
      "Working on : CRVS\n",
      "Working on : CRWS\n",
      "Working on : CRY\n",
      "Working on : CSCO\n",
      "Working on : CSGP\n",
      "Working on : CSGS\n",
      "Working on : CSII\n",
      "Working on : CSL\n",
      "Working on : CSLT\n",
      "Working on : CSOD\n",
      "Working on : CSPI\n",
      "Working on : CSTR\n",
      "Working on : CSU\n",
      "Working on : CSV\n",
      "Working on : CSWI\n",
      "Working on : CSX\n",
      "Working on : CTAS\n",
      "Working on : CTBI\n",
      "Working on : CTG\n",
      "Working on : CTHR\n",
      "Working on : CTIB\n",
      "Working on : CTIC\n",
      "Working on : CTLT\n",
      "Working on : CTMX\n",
      "Working on : CTO\n",
      "Working on : CTRE\n",
      "Working on : CTRN\n",
      "Working on : CTS\n",
      "Working on : CTSH\n",
      "Working on : CTSO\n",
      "Working on : CTT\n",
      "Working on : CTXS\n",
      "Working on : CUBE\n",
      "Working on : CUBI\n",
      "Working on : CUE\n",
      "Working on : CULP\n",
      "Working on : CURO\n",
      "Working on : CUTR\n",
      "Working on : CUZ\n",
      "Working on : CVA\n",
      "Working on : CVBF\n",
      "Working on : CVCO\n",
      "Working on : CVCY\n",
      "Working on : CVGI\n",
      "Working on : CVGW\n",
      "Working on : CVI\n",
      "Working on : CVLT\n",
      "Working on : CVLY\n",
      "Working on : CVM\n",
      "Working on : CVNA\n",
      "Working on : CVR\n",
      "Working on : CVS\n",
      "Working on : CVU\n",
      "Working on : CVV\n",
      "Working on : CVX\n",
      "Working on : CW\n",
      "Working on : CWBC\n",
      "Working on : CWBR\n",
      "Working on : CWEN\n",
      "Working on : CWH\n",
      "Working on : CWST\n",
      "Working on : CWT\n",
      "Working on : CXP\n",
      "Working on : CXW\n",
      "Working on : CYAN\n",
      "Working on : CYBE\n",
      "Working on : CYCC\n",
      "Working on : CYH\n",
      "Working on : CYRX\n",
      "Working on : CYTK\n",
      "Working on : CYTR\n",
      "Working on : CZNC\n",
      "Working on : CZR\n",
      "Working on : CZWI\n",
      "Working on : D\n",
      "Working on : DAIO\n",
      "Working on : DAKT\n",
      "Working on : DAL\n",
      "Working on : DAN\n",
      "Working on : DAR\n",
      "Working on : DARE\n",
      "Working on : DBD\n",
      "Working on : DBI\n",
      "Working on : DBX\n",
      "Working on : DCI\n",
      "Working on : DCO\n",
      "Working on : DCOM\n",
      "Working on : DCPH\n",
      "Working on : DD\n",
      "Working on : DDD\n",
      "Working on : DDS\n",
      "Working on : DE\n",
      "Working on : DEA\n",
      "Working on : DECK\n",
      "Working on : DEI\n",
      "Working on : DELL\n",
      "Working on : DENN\n",
      "Working on : DFIN\n",
      "Working on : DFS\n",
      "Working on : DG\n",
      "Working on : DGICA\n",
      "Working on : DGII\n",
      "Working on : DGLY\n",
      "Working on : DGX\n",
      "Working on : DHI\n",
      "Working on : DHIL\n",
      "Working on : DHR\n",
      "Working on : DHX\n",
      "Working on : DIN\n",
      "Working on : DIOD\n",
      "Working on : DIS\n",
      "Working on : DISCA\n",
      "Working on : DISCK\n",
      "Working on : DISH\n",
      "Working on : DIT\n",
      "Working on : DJCO\n",
      "Working on : DK\n",
      "Working on : DKS\n",
      "Working on : DLA\n",
      "Working on : DLB\n",
      "Working on : DLHC\n",
      "Working on : DLR\n",
      "Working on : DLTH\n",
      "Working on : DLTR\n",
      "Working on : DLX\n",
      "Working on : DMRC\n",
      "Working on : DNLI\n",
      "Working on : DNOW\n",
      "Working on : DOC\n",
      "Working on : DOCU\n",
      "Working on : DOMO\n",
      "Working on : DOOR\n",
      "Working on : DORM\n",
      "Working on : DOV\n",
      "Working on : DOW\n",
      "Working on : DPZ\n",
      "Working on : DRE\n",
      "Working on : DRH\n",
      "Working on : DRI\n",
      "Working on : DRNA\n",
      "Working on : DRQ\n",
      "Working on : DRRX\n",
      "Working on : DS\n",
      "Working on : DSKE\n",
      "Working on : DSPG\n",
      "Working on : DSS\n",
      "Working on : DTE\n",
      "Working on : DUK\n",
      "Working on : DVA\n",
      "Working on : DVAX\n",
      "Working on : DVD\n",
      "Working on : DVN\n",
      "Working on : DWSN\n",
      "Working on : DX\n",
      "Working on : DXC\n",
      "Working on : DXCM\n",
      "Working on : DXLG\n",
      "Working on : DXPE\n",
      "Working on : DXYN\n",
      "Working on : DY\n",
      "Working on : DZSI\n",
      "Working on : EA\n",
      "Working on : EAF\n",
      "Working on : EARN\n",
      "Working on : EAT\n",
      "Working on : EB\n",
      "Working on : EBAY\n",
      "Working on : EBF\n",
      "Working on : EBIX\n",
      "Working on : EBMT\n",
      "Working on : EBS\n",
      "Working on : EBSB\n",
      "Working on : EBTC\n",
      "Working on : ECHO\n",
      "Working on : ECL\n",
      "Working on : ECOL\n",
      "Working on : ECOM\n",
      "Working on : ECPG\n",
      "Working on : ED\n",
      "Working on : EDIT\n",
      "Working on : EDUC\n",
      "Working on : EEFT\n",
      "Working on : EEX\n",
      "Working on : EFC\n",
      "Working on : EFOI\n",
      "Working on : EFSC\n",
      "Working on : EFX\n",
      "Working on : EGAN\n",
      "Working on : EGBN\n",
      "Working on : EGHT\n",
      "Working on : EGLE\n",
      "Working on : EGP\n",
      "Working on : EGRX\n",
      "Working on : EGY\n",
      "Working on : EHC\n",
      "Working on : EHTH\n",
      "Working on : EIG\n",
      "Working on : EIGR\n",
      "Working on : EIX\n",
      "Working on : EKSO\n",
      "Working on : EL\n",
      "Working on : ELAN\n",
      "Working on : ELF\n",
      "Working on : ELMD\n",
      "Working on : ELOX\n",
      "Working on : ELS\n",
      "Working on : ELSE\n",
      "Working on : ELVT\n",
      "Working on : ELY\n",
      "Working on : EMAN\n",
      "Working on : EMCF\n",
      "Working on : EME\n",
      "Working on : EMKR\n",
      "Working on : EML\n",
      "Working on : EMMS\n",
      "Working on : EMN\n",
      "Working on : EMR\n",
      "Working on : ENDP\n",
      "Working on : ENG\n",
      "Working on : ENOB\n",
      "Working on : ENPH\n",
      "Working on : ENR\n",
      "Working on : ENS\n",
      "Working on : ENSG\n",
      "Working on : ENSV\n",
      "Working on : ENTA\n",
      "Working on : ENTG\n",
      "Working on : ENV\n",
      "Working on : ENVA\n",
      "Working on : ENZ\n",
      "Working on : EOG\n",
      "Working on : EOLS\n",
      "Working on : EPAM\n",
      "Working on : EPAY\n",
      "Working on : EPC\n",
      "Working on : EPM\n",
      "Working on : EPR\n",
      "Working on : EPRT\n",
      "Working on : EPZM\n",
      "Working on : EQBK\n",
      "Working on : EQC\n",
      "Working on : EQH\n",
      "Working on : EQIX\n",
      "Working on : EQR\n",
      "Working on : EQT\n",
      "Working on : ERIE\n",
      "Working on : ERII\n",
      "Working on : ES\n",
      "Working on : ESBK\n",
      "Working on : ESCA\n",
      "Working on : ESE\n",
      "Working on : ESGR\n",
      "Working on : ESNT\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Working on : ESP\n",
      "Working on : ESPR\n",
      "Working on : ESRT\n",
      "Working on : ESS\n",
      "Working on : ESSA\n",
      "Working on : ESTC\n",
      "Working on : ESTE\n",
      "Working on : ESXB\n",
      "Working on : ETH\n",
      "Working on : ETN\n",
      "Working on : ETR\n",
      "Working on : ETRN\n",
      "Working on : ETSY\n",
      "Working on : EVBG\n",
      "Working on : EVBN\n",
      "Working on : EVC\n",
      "Working on : EVER\n",
      "Working on : EVFM\n",
      "Working on : EVH\n",
      "Working on : EVI\n",
      "Working on : EVOK\n",
      "Working on : EVOL\n",
      "Working on : EVOP\n",
      "Working on : EVR\n",
      "Working on : EVRG\n",
      "Working on : EVRI\n",
      "Working on : EVTC\n",
      "Working on : EW\n",
      "Working on : EWBC\n",
      "Working on : EXAS\n",
      "Working on : EXC\n",
      "Working on : EXEL\n",
      "Working on : EXLS\n",
      "Working on : EXP\n",
      "Working on : EXPD\n",
      "Working on : EXPE\n",
      "Working on : EXPI\n",
      "Working on : EXPO\n",
      "Working on : EXPR\n",
      "Working on : EXR\n",
      "Working on : EXTN\n",
      "Working on : EXTR\n",
      "Working on : EYE\n",
      "Working on : EYEG\n",
      "Working on : EYES\n",
      "Working on : EYPT\n",
      "Working on : EZPW\n",
      "Working on : F\n",
      "Working on : FAF\n",
      "Working on : FANG\n",
      "Working on : FARM\n",
      "Working on : FARO\n",
      "Working on : FAST\n",
      "Working on : FATE\n",
      "Working on : FB\n",
      "Working on : FBC\n",
      "Working on : FBHS\n",
      "Working on : FBIO\n",
      "Working on : FBIZ\n",
      "Working on : FBK\n",
      "Working on : FBMS\n",
      "Working on : FBNC\n",
      "Working on : FBP\n",
      "Working on : FC\n",
      "Working on : FCAP\n",
      "Working on : FCBC\n",
      "Working on : FCBP\n",
      "Working on : FCCO\n",
      "Working on : FCCY\n",
      "Working on : FCEL\n",
      "Working on : FCF\n",
      "Working on : FCFS\n",
      "Working on : FCN\n",
      "Working on : FCNCA\n",
      "Working on : FCPT\n",
      "Working on : FCX\n",
      "Working on : FDBC\n",
      "Working on : FDP\n",
      "Working on : FDS\n",
      "Working on : FDX\n",
      "Working on : FE\n",
      "Working on : FEIM\n",
      "Working on : FELE\n",
      "Working on : FET\n",
      "Working on : FEYE\n",
      "Working on : FF\n",
      "Working on : FFBC\n",
      "Working on : FFIC\n",
      "Working on : FFIN\n",
      "Working on : FFIV\n",
      "Working on : FFNW\n",
      "Working on : FFWM\n",
      "Working on : FGBI\n",
      "Working on : FGEN\n",
      "Working on : FHB\n",
      "Working on : FHN\n",
      "Working on : FI\n",
      "Working on : FIBK\n",
      "Working on : FICO\n",
      "Working on : FIS\n",
      "Working on : FISI\n",
      "Working on : FISV\n",
      "Working on : FITB\n",
      "Working on : FIVE\n",
      "Working on : FIVN\n",
      "Working on : FIX\n",
      "Working on : FIXX\n",
      "Working on : FIZZ\n",
      "Working on : FL\n",
      "Working on : FLDM\n",
      "Working on : FLIC\n",
      "Working on : FLL\n",
      "Working on : FLMN\n",
      "Working on : FLNT\n",
      "Working on : FLO\n",
      "Working on : FLOW\n",
      "Working on : FLR\n",
      "Working on : FLS\n",
      "Working on : FLT\n",
      "Working on : FLWS\n",
      "Working on : FLXN\n",
      "Working on : FLXS\n",
      "Working on : FMAO\n",
      "Working on : FMBH\n",
      "Working on : FMBI\n",
      "Working on : FMC\n",
      "Working on : FMNB\n",
      "Working on : FN\n",
      "Working on : FNB\n",
      "Working on : FNCB\n",
      "Working on : FND\n",
      "Working on : FNF\n",
      "Working on : FNHC\n",
      "Working on : FNKO\n",
      "Working on : FNLC\n",
      "Working on : FNWB\n",
      "Working on : FOCS\n",
      "Working on : FOE\n",
      "Working on : FOLD\n",
      "Working on : FONR\n",
      "Working on : FOR\n",
      "Working on : FORD\n",
      "Working on : FORM\n",
      "Working on : FORR\n",
      "Working on : FOSL\n",
      "Working on : FOX\n",
      "Working on : FOXA\n",
      "Working on : FOXF\n",
      "Working on : FPI\n",
      "Working on : FR\n",
      "Working on : FRBA\n",
      "Working on : FRBK\n",
      "Working on : FRC\n",
      "Working on : FRD\n",
      "Working on : FRGI\n",
      "Working on : FRME\n",
      "Working on : FRPH\n",
      "Working on : FRPT\n",
      "Working on : FRT\n",
      "Working on : FRTA\n",
      "Working on : FSBW\n",
      "Working on : FSFG\n",
      "Working on : FSLR\n",
      "Working on : FSLY\n",
      "Working on : FSP\n",
      "Working on : FSS\n",
      "Working on : FSTR\n",
      "Working on : FTDR\n",
      "Working on : FTEK\n",
      "Working on : FTI\n",
      "Working on : FTK\n",
      "Working on : FTNT\n",
      "Working on : FTSI\n",
      "Working on : FTV\n",
      "Working on : FUL\n",
      "Working on : FULT\n",
      "Working on : FUNC\n",
      "Working on : FUSB\n",
      "Working on : FVE\n",
      "Working on : FWONA\n",
      "Working on : FWONK\n",
      "Working on : FWRD\n",
      "Working on : G\n",
      "Working on : GABC\n",
      "Working on : GAIA\n",
      "Working on : GALT\n",
      "Working on : GATX\n",
      "Working on : GBCI\n",
      "Working on : GBL\n",
      "Working on : GBLI\n",
      "Working on : GBT\n",
      "Working on : GBX\n",
      "Working on : GCBC\n",
      "Working on : GCI\n",
      "Working on : GCO\n",
      "Working on : GCP\n",
      "Working on : GD\n",
      "Working on : GDDY\n",
      "Working on : GDEN\n",
      "Working on : GDOT\n",
      "Working on : GDP\n",
      "Working on : GE\n",
      "Working on : GEF\n",
      "Working on : GENC\n",
      "Working on : GEO\n",
      "Working on : GEOS\n",
      "Working on : GERN\n",
      "Working on : GES\n",
      "Working on : GEVO\n",
      "Working on : GFED\n",
      "Working on : GFF\n",
      "Working on : GGG\n",
      "Working on : GH\n",
      "Working on : GHC\n",
      "Working on : GHL\n",
      "Working on : GHM\n",
      "Working on : GIFI\n",
      "Working on : GIII\n",
      "Working on : GILD\n",
      "Working on : GIS\n",
      "Working on : GKOS\n",
      "Working on : GLBZ\n",
      "Working on : GLDD\n",
      "Working on : GLPI\n",
      "Working on : GLRE\n",
      "Working on : GLT\n",
      "Working on : GLW\n",
      "Working on : GLYC\n",
      "Working on : GM\n",
      "Working on : GME\n",
      "Working on : GMED\n",
      "Working on : GMRE\n",
      "Working on : GMS\n",
      "Working on : GNCA\n",
      "Working on : GNE\n",
      "Working on : GNK\n",
      "Working on : GNL\n",
      "Working on : GNRC\n",
      "Working on : GNTX\n",
      "Working on : GNTY\n",
      "Working on : GNW\n",
      "Working on : GOGO\n",
      "Working on : GOLF\n",
      "Working on : GOOD\n",
      "Working on : GOOG\n",
      "Working on : GOOGL\n",
      "Working on : GORO\n",
      "Working on : GOSS\n",
      "Working on : GPC\n",
      "Working on : GPI\n",
      "Working on : GPK\n",
      "Working on : GPMT\n",
      "Working on : GPN\n",
      "Working on : GPOR\n",
      "Working on : GPRE\n",
      "Working on : GPRO\n",
      "Working on : GPS\n",
      "Working on : GPX\n",
      "Working on : GRA\n",
      "Working on : GRBK\n",
      "Working on : GRC\n",
      "Working on : GRMN\n",
      "Working on : GROW\n",
      "Working on : GRPN\n",
      "Working on : GRTS\n",
      "Working on : GRUB\n",
      "Working on : GS\n",
      "Working on : GSAT\n",
      "Working on : GSBC\n",
      "Working on : GSHD\n",
      "Working on : GSIT\n",
      "Working on : GSKY\n",
      "Working on : GT\n",
      "Working on : GTES\n",
      "Working on : GTHX\n",
      "Working on : GTIM\n",
      "Working on : GTLS\n",
      "Working on : GTN\n",
      "Working on : GTS\n",
      "Working on : GTT\n",
      "Working on : GTX\n",
      "Working on : GTY\n",
      "Working on : GTYH\n",
      "Working on : GVA\n",
      "Working on : GVP\n",
      "Working on : GWB\n",
      "Working on : GWGH\n",
      "Working on : GWRE\n",
      "Working on : GWRS\n",
      "Working on : GWW\n",
      "Working on : H\n",
      "Working on : HA\n",
      "Working on : HAE\n",
      "Working on : HAFC\n",
      "Working on : HAIN\n",
      "Working on : HAL\n",
      "Working on : HALL\n",
      "Working on : HALO\n",
      "Working on : HAS\n",
      "Working on : HASI\n",
      "Working on : HAYN\n",
      "Working on : HBAN\n",
      "Working on : HBB\n",
      "Working on : HBCP\n",
      "Working on : HBI\n",
      "Working on : HBIO\n",
      "Working on : HBMD\n",
      "Working on : HBNC\n",
      "Working on : HBP\n",
      "Working on : HCA\n",
      "Working on : HCC\n",
      "Working on : HCCI\n",
      "Working on : HCHC\n",
      "Working on : HCI\n",
      "Working on : HCKT\n",
      "Working on : HCSG\n",
      "Working on : HD\n",
      "Working on : HDSN\n",
      "Working on : HE\n",
      "Working on : HEAR\n",
      "Working on : HEES\n",
      "Working on : HEI\n",
      "Working on : HELE\n",
      "Working on : HES\n",
      "Working on : HFBL\n",
      "Working on : HFC\n",
      "Working on : HFWA\n",
      "Working on : HGV\n",
      "Working on : HHC\n",
      "Working on : HI\n",
      "Working on : HIBB\n",
      "Working on : HIFS\n",
      "Working on : HIG\n",
      "Working on : HII\n",
      "Working on : HIL\n",
      "Working on : HIW\n",
      "Working on : HL\n",
      "Working on : HLF\n",
      "Working on : HLI\n",
      "Working on : HLIT\n",
      "Working on : HLNE\n",
      "Working on : HLT\n",
      "Working on : HLX\n",
      "Working on : HMHC\n",
      "Working on : HMN\n",
      "Working on : HMNF\n",
      "Working on : HMST\n",
      "Working on : HMTV\n",
      "Working on : HNI\n",
      "Working on : HNRG\n",
      "Working on : HOFT\n",
      "Working on : HOG\n",
      "Working on : HOLX\n",
      "Working on : HOMB\n",
      "Working on : HOME\n",
      "Working on : HON\n",
      "Working on : HONE\n",
      "Working on : HOPE\n",
      "Working on : HOV\n",
      "Working on : HP\n",
      "Working on : HPE\n",
      "Working on : HPP\n",
      "Working on : HPQ\n",
      "Working on : HQY\n",
      "Working on : HR\n",
      "Working on : HRB\n",
      "Working on : HRC\n",
      "Working on : HRI\n",
      "Working on : HRL\n",
      "Working on : HROW\n",
      "Working on : HRTG\n",
      "Working on : HRTX\n",
      "Working on : HSC\n",
      "Working on : HSIC\n",
      "Working on : HSII\n",
      "Working on : HSKA\n",
      "Working on : HSON\n",
      "Working on : HST\n",
      "Working on : HSTM\n",
      "Working on : HSY\n",
      "Working on : HT\n",
      "Working on : HTA\n",
      "Working on : HTBI\n",
      "Working on : HTBK\n",
      "Working on : HTBX\n",
      "Working on : HTGM\n",
      "Working on : HTH\n",
      "Working on : HTLD\n",
      "Working on : HTLF\n",
      "Working on : HUBB\n",
      "Working on : HUBG\n",
      "Working on : HUBS\n",
      "Working on : HUM\n",
      "Working on : HUN\n",
      "Working on : HURC\n",
      "Working on : HURN\n",
      "Working on : HUSA\n",
      "Working on : HVT\n",
      "Working on : HWBK\n",
      "Working on : HWC\n",
      "Working on : HWKN\n",
      "Working on : HXL\n",
      "Working on : HY\n",
      "Working on : HZN\n",
      "Working on : HZNP\n",
      "Working on : HZO\n",
      "Working on : IAC\n",
      "Working on : IART\n",
      "Working on : IBCP\n",
      "Working on : IBIO\n",
      "Working on : IBKR\n",
      "Working on : IBM\n",
      "Working on : IBOC\n",
      "Working on : IBP\n",
      "Working on : IBTX\n",
      "Working on : ICAD\n",
      "Working on : ICBK\n",
      "Working on : ICCC\n",
      "Working on : ICD\n",
      "Working on : ICE\n",
      "Working on : ICFI\n",
      "Working on : ICHR\n",
      "Working on : ICON\n",
      "Working on : ICPT\n",
      "Working on : ICUI\n",
      "Working on : IDA\n",
      "Working on : IDCC\n",
      "Working on : IDN\n",
      "Working on : IDRA\n",
      "Working on : IDT\n",
      "Working on : IDXG\n",
      "Working on : IDXX\n",
      "Working on : IEC\n",
      "Working on : IESC\n",
      "Working on : IEX\n",
      "Working on : IFF\n",
      "Working on : IHC\n",
      "Working on : III\n",
      "Working on : IIIN\n",
      "Working on : IIIV\n",
      "Working on : IIN\n",
      "Working on : IIPR\n",
      "Working on : IIVI\n",
      "Working on : IKNX\n",
      "Working on : ILMN\n",
      "Working on : ILPT\n",
      "Working on : IMGN\n",
      "Working on : IMH\n",
      "Working on : IMKTA\n",
      "Working on : IMMR\n",
      "Working on : IMXI\n",
      "Working on : INBK\n",
      "Working on : INCY\n",
      "Working on : INDB\n",
      "Working on : INFI\n",
      "Working on : INFN\n",
      "Working on : INFO\n",
      "Working on : INFU\n",
      "Working on : INGN\n",
      "Working on : INGR\n",
      "Working on : INN\n",
      "Working on : INO\n",
      "Working on : INOD\n",
      "Working on : INOV\n",
      "Working on : INPX\n",
      "Working on : INS\n",
      "Working on : INSE\n",
      "Working on : INSG\n",
      "Working on : INSM\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Working on : INSP\n",
      "Working on : INSW\n",
      "Working on : INT\n",
      "Working on : INTC\n",
      "Working on : INTG\n",
      "Working on : INTT\n",
      "Working on : INTU\n",
      "Working on : INUV\n",
      "Working on : INVA\n",
      "Working on : INVE\n",
      "Working on : INVH\n",
      "Working on : IO\n",
      "Working on : IONS\n",
      "Working on : IOR\n",
      "Working on : IOSP\n",
      "Working on : IOVA\n",
      "Working on : IP\n",
      "Working on : IPAR\n",
      "Working on : IPG\n",
      "Working on : IPGP\n",
      "Working on : IPI\n",
      "Working on : IPWR\n",
      "Working on : IQV\n",
      "Working on : IR\n",
      "Working on : IRBT\n",
      "Working on : IRDM\n",
      "Working on : IRIX\n",
      "Working on : IRM\n",
      "Working on : IRMD\n",
      "Working on : IROQ\n",
      "Working on : IRT\n",
      "Working on : IRTC\n",
      "Working on : IRWD\n",
      "Working on : ISBC\n",
      "Working on : ISDR\n",
      "Working on : ISIG\n",
      "Working on : ISNS\n",
      "Working on : ISR\n",
      "Working on : ISRG\n",
      "Working on : ISSC\n",
      "Working on : ISTR\n",
      "Working on : IT\n",
      "Working on : ITCI\n",
      "Working on : ITGR\n",
      "Working on : ITI\n",
      "Working on : ITIC\n",
      "Working on : ITRI\n",
      "Working on : ITT\n",
      "Working on : ITW\n",
      "Working on : IVAC\n",
      "Working on : IVC\n",
      "Working on : IVR\n",
      "Working on : IVZ\n",
      "Working on : IZEA\n",
      "Working on : JACK\n",
      "Working on : JAGX\n",
      "Working on : JAKK\n",
      "Working on : JAX\n",
      "Working on : JAZZ\n",
      "Working on : JBGS\n",
      "Working on : JBHT\n",
      "Working on : JBL\n",
      "Working on : JBLU\n",
      "Working on : JBSS\n",
      "Working on : JBT\n",
      "Working on : JCI\n",
      "Working on : JCOM\n",
      "Working on : JCS\n",
      "Working on : JCTCF\n",
      "Working on : JEF\n",
      "Working on : JELD\n",
      "Working on : JHG\n",
      "Working on : JILL\n",
      "Working on : JJSF\n",
      "Working on : JKHY\n",
      "Working on : JLL\n",
      "Working on : JNCE\n",
      "Working on : JNJ\n",
      "Working on : JNPR\n",
      "Working on : JOB\n",
      "Working on : JOE\n",
      "Working on : JOUT\n",
      "Working on : JPM\n",
      "Working on : JRVR\n",
      "Working on : JVA\n",
      "Working on : JWN\n",
      "Working on : JYNT\n",
      "Working on : K\n",
      "Working on : KAI\n",
      "Working on : KALA\n",
      "Working on : KALU\n",
      "Working on : KALV\n",
      "Working on : KAMN\n",
      "Working on : KAR\n",
      "Working on : KBAL\n",
      "Working on : KBH\n",
      "Working on : KBR\n",
      "Working on : KDMN\n",
      "Working on : KDP\n",
      "Working on : KE\n",
      "Working on : KELYA\n",
      "Working on : KEQU\n",
      "Working on : KEX\n",
      "Working on : KEY\n",
      "Working on : KEYS\n",
      "Working on : KFFB\n",
      "Working on : KFRC\n",
      "Working on : KFY\n",
      "Working on : KHC\n",
      "Working on : KIDS\n",
      "Working on : KIM\n",
      "Working on : KIN\n",
      "Working on : KINS\n",
      "Working on : KIRK\n",
      "Working on : KKR\n",
      "Working on : KLAC\n",
      "Working on : KLIC\n",
      "Working on : KLXE\n",
      "Working on : KMB\n",
      "Working on : KMI\n",
      "Working on : KMPH\n",
      "Working on : KMPR\n",
      "Working on : KMT\n",
      "Working on : KMX\n",
      "Working on : KN\n",
      "Working on : KNL\n",
      "Working on : KNSA\n",
      "Working on : KNSL\n",
      "Working on : KNX\n",
      "Working on : KO\n",
      "Working on : KOD\n",
      "Working on : KODK\n",
      "Working on : KOP\n",
      "Working on : KOPN\n",
      "Working on : KOS\n",
      "Working on : KPTI\n",
      "Working on : KR\n",
      "Working on : KRA\n",
      "Working on : KRC\n",
      "Working on : KREF\n",
      "Working on : KRG\n",
      "Working on : KRNY\n",
      "Working on : KRO\n",
      "Working on : KRYS\n",
      "Working on : KSS\n",
      "Working on : KSU\n",
      "Working on : KTCC\n",
      "Working on : KTOS\n",
      "Working on : KURA\n",
      "Working on : KVHI\n",
      "Working on : KW\n",
      "Working on : KWR\n",
      "Working on : KZR\n",
      "Working on : L\n",
      "Working on : LAD\n",
      "Working on : LADR\n",
      "Working on : LAKE\n",
      "Working on : LAMR\n",
      "Working on : LANC\n",
      "Working on : LAND\n",
      "Working on : LARK\n",
      "Working on : LASR\n",
      "Working on : LAUR\n",
      "Working on : LAWS\n",
      "Working on : LAZ\n",
      "Working on : LB\n",
      "Working on : LBAI\n",
      "Working on : LBC\n",
      "Working on : LBRDA\n",
      "Working on : LBRDK\n",
      "Working on : LBRT\n",
      "Working on : LBTYA\n",
      "Working on : LBTYK\n",
      "Working on : LC\n",
      "Working on : LCI\n",
      "Working on : LCII\n",
      "Working on : LCNB\n",
      "Working on : LCUT\n",
      "Working on : LDL\n",
      "Working on : LDOS\n",
      "Working on : LE\n",
      "Working on : LEA\n",
      "Working on : LECO\n",
      "Working on : LEE\n",
      "Working on : LEG\n",
      "Working on : LEGH\n",
      "Working on : LEN\n",
      "Working on : LEU\n",
      "Working on : LEVI\n",
      "Working on : LFUS\n",
      "Working on : LFVN\n",
      "Working on : LGIH\n",
      "Working on : LGL\n",
      "Working on : LGND\n",
      "Working on : LH\n",
      "Working on : LHCG\n",
      "Working on : LIFE\n",
      "Working on : LII\n",
      "Working on : LILA\n",
      "Working on : LILAK\n",
      "Working on : LIN\n",
      "Working on : LINC\n",
      "Working on : LIND\n",
      "Working on : LIQT\n",
      "Working on : LITE\n",
      "Working on : LIVE\n",
      "Working on : LIVN\n",
      "Working on : LIVX\n",
      "Working on : LJPC\n",
      "Working on : LKFN\n",
      "Working on : LKQ\n",
      "Working on : LL\n",
      "Working on : LLNW\n",
      "Working on : LLY\n",
      "Working on : LMAT\n",
      "Working on : LMFA\n",
      "Working on : LMNR\n",
      "Working on : LMNX\n",
      "Working on : LMT\n",
      "Working on : LNC\n",
      "Working on : LNDC\n",
      "Working on : LNG\n",
      "Working on : LNN\n",
      "Working on : LNT\n",
      "Working on : LNTH\n",
      "Working on : LOAN\n",
      "Working on : LOB\n",
      "Working on : LOCO\n",
      "Working on : LODE\n",
      "Working on : LONE\n",
      "Working on : LOOP\n",
      "Working on : LOPE\n",
      "Working on : LORL\n",
      "Working on : LOVE\n",
      "Working on : LOW\n",
      "Working on : LPCN\n",
      "Working on : LPG\n",
      "Working on : LPI\n",
      "Working on : LPLA\n",
      "Working on : LPSN\n",
      "Working on : LPTH\n",
      "Working on : LPX\n",
      "Working on : LQDA\n",
      "Working on : LQDT\n",
      "Working on : LRCX\n",
      "Working on : LRN\n",
      "Working on : LSBK\n",
      "Working on : LSCC\n",
      "Working on : LSI\n",
      "Working on : LSTR\n",
      "Working on : LSXMA\n",
      "Working on : LSXMK\n",
      "Working on : LTBR\n",
      "Working on : LTC\n",
      "Working on : LTHM\n",
      "Working on : LTRPA\n",
      "Working on : LTRX\n",
      "Working on : LUB\n",
      "Working on : LULU\n",
      "Working on : LUNA\n",
      "Working on : LUV\n",
      "Working on : LVS\n",
      "Working on : LW\n",
      "Working on : LWAY\n",
      "Working on : LXP\n",
      "Working on : LXRX\n",
      "Working on : LXU\n",
      "Working on : LYB\n",
      "Working on : LYFT\n",
      "Working on : LYTS\n",
      "Working on : LYV\n",
      "Working on : LZB\n",
      "Working on : M\n",
      "Working on : MA\n",
      "Working on : MAA\n",
      "Working on : MAC\n",
      "Working on : MACK\n",
      "Working on : MAN\n",
      "Working on : MANH\n",
      "Working on : MANT\n",
      "Working on : MAR\n",
      "Working on : MARA\n",
      "Working on : MARK\n",
      "Working on : MAS\n",
      "Working on : MASI\n",
      "Working on : MAT\n",
      "Working on : MATW\n",
      "Working on : MATX\n",
      "Working on : MAYS\n",
      "Working on : MBCN\n",
      "Working on : MBI\n",
      "Working on : MBII\n",
      "Working on : MBIN\n",
      "Working on : MBIO\n",
      "Working on : MBOT\n",
      "Working on : MBUU\n",
      "Working on : MBWM\n",
      "Working on : MC\n",
      "Working on : MCB\n",
      "Working on : MCBC\n",
      "Working on : MCD\n",
      "Working on : MCF\n",
      "Working on : MCFT\n",
      "Working on : MCHP\n",
      "Working on : MCHX\n",
      "Working on : MCK\n",
      "Working on : MCO\n",
      "Working on : MCRB\n",
      "Working on : MCRI\n",
      "Working on : MCS\n",
      "Working on : MCY\n",
      "Working on : MD\n",
      "Working on : MDB\n",
      "Working on : MDC\n",
      "Working on : MDGL\n",
      "Working on : MDLY\n",
      "Working on : MDLZ\n",
      "Working on : MDP\n",
      "Working on : MDRX\n",
      "Working on : MDT\n",
      "Working on : MDU\n",
      "Working on : MED\n",
      "Working on : MEDP\n",
      "Working on : MEI\n",
      "Working on : MEIP\n",
      "Working on : MERC\n",
      "Working on : MESA\n",
      "Working on : MET\n",
      "Working on : MFA\n",
      "Working on : MFNC\n",
      "Working on : MG\n",
      "Working on : MGEE\n",
      "Working on : MGI\n",
      "Working on : MGLN\n",
      "Working on : MGM\n",
      "Working on : MGNX\n",
      "Working on : MGPI\n",
      "Working on : MGRC\n",
      "Working on : MGTA\n",
      "Working on : MGY\n",
      "Working on : MGYR\n",
      "Working on : MHH\n",
      "Working on : MHK\n",
      "Working on : MHLD\n",
      "Working on : MHO\n",
      "Working on : MIC\n",
      "Working on : MICR\n",
      "Working on : MICT\n",
      "Working on : MIDD\n",
      "Working on : MIND\n",
      "Working on : MITK\n",
      "Working on : MITT\n",
      "Working on : MKC\n",
      "Working on : MKL\n",
      "Working on : MKSI\n",
      "Working on : MKTX\n",
      "Working on : MLAB\n",
      "Working on : MLHR\n",
      "Working on : MLI\n",
      "Working on : MLM\n",
      "Working on : MLND\n",
      "Working on : MLP\n",
      "Working on : MLR\n",
      "Working on : MLSS\n",
      "Working on : MLVF\n",
      "Working on : MMAC\n",
      "Working on : MMC\n",
      "Working on : MMI\n",
      "Working on : MMM\n",
      "Working on : MMS\n",
      "Working on : MMSI\n",
      "Working on : MN\n",
      "Working on : MNKD\n",
      "Working on : MNOV\n",
      "Working on : MNR\n",
      "Working on : MNRL\n",
      "Working on : MNRO\n",
      "Working on : MNST\n",
      "Working on : MNTX\n",
      "Working on : MO\n",
      "Working on : MOBL\n",
      "Working on : MOD\n",
      "Working on : MODN\n",
      "Working on : MOFG\n",
      "Working on : MOH\n",
      "Working on : MORN\n",
      "Working on : MOS\n",
      "Working on : MOSY\n",
      "Working on : MOTS\n",
      "Working on : MOV\n",
      "Working on : MPAA\n",
      "Working on : MPB\n",
      "Working on : MPC\n",
      "Working on : MPW\n",
      "Working on : MPWR\n",
      "Working on : MPX\n",
      "Working on : MRAM\n",
      "Working on : MRC\n",
      "Working on : MRCY\n",
      "Working on : MRIN\n",
      "Working on : MRK\n",
      "Working on : MRKR\n",
      "Working on : MRLN\n",
      "Working on : MRNS\n",
      "Working on : MRO\n",
      "Working on : MRSN\n",
      "Working on : MRTN\n",
      "Working on : MRTX\n",
      "Working on : MRVL\n",
      "Working on : MS\n",
      "Working on : MSA\n",
      "Working on : MSBI\n",
      "Working on : MSCI\n",
      "Working on : MSEX\n",
      "Working on : MSFT\n",
      "Working on : MSGN\n",
      "Working on : MSI\n",
      "Working on : MSM\n",
      "Working on : MSN\n",
      "Working on : MSON\n",
      "Working on : MSTR\n",
      "Working on : MTB\n",
      "Working on : MTCH\n",
      "Working on : MTD\n",
      "Working on : MTDR\n",
      "Working on : MTEM\n",
      "Working on : MTEX\n",
      "Working on : MTG\n",
      "Working on : MTH\n",
      "Working on : MTN\n",
      "Working on : MTNB\n",
      "Working on : MTOR\n",
      "Working on : MTRN\n",
      "Working on : MTRX\n",
      "Working on : MTSI\n",
      "Working on : MTW\n",
      "Working on : MTX\n",
      "Working on : MTZ\n",
      "Working on : MU\n",
      "Working on : MUR\n",
      "Working on : MUSA\n",
      "Working on : MUX\n",
      "Working on : MVBF\n",
      "Working on : MVIS\n",
      "Working on : MWA\n",
      "Working on : MXIM\n",
      "Working on : MXL\n",
      "Working on : MYE\n",
      "Working on : MYGN\n",
      "Working on : MYRG\n",
      "Working on : NAII\n",
      "Working on : NATH\n",
      "Working on : NATI\n",
      "Working on : NATR\n",
      "Working on : NAV\n",
      "Working on : NAVB\n",
      "Working on : NAVI\n",
      "Working on : NBEV\n",
      "Working on : NBHC\n",
      "Working on : NBIX\n",
      "Working on : NBN\n",
      "Working on : NBR\n",
      "Working on : NBTB\n",
      "Working on : NBY\n",
      "Working on : NC\n",
      "Working on : NCBS\n",
      "Working on : NCLH\n",
      "Working on : NCMI\n",
      "Working on : NCR\n",
      "Working on : NCSM\n",
      "Working on : NDAQ\n",
      "Working on : NDLS\n",
      "Working on : NDSN\n",
      "Working on : NE\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Working on : NEE\n",
      "Working on : NEM\n",
      "Working on : NEO\n",
      "Working on : NEOG\n",
      "Working on : NEON\n",
      "Working on : NERV\n",
      "Working on : NETE\n",
      "Working on : NEU\n",
      "Working on : NEWR\n",
      "Working on : NFBK\n",
      "Working on : NFG\n",
      "Working on : NFLX\n",
      "Working on : NGS\n",
      "Working on : NGVC\n",
      "Working on : NGVT\n",
      "Working on : NHC\n",
      "Working on : NHI\n",
      "Working on : NHTC\n",
      "Working on : NI\n",
      "Working on : NICK\n",
      "Working on : NINE\n",
      "Working on : NJR\n",
      "Working on : NKE\n",
      "Working on : NKSH\n",
      "Working on : NKTR\n",
      "Working on : NL\n",
      "Working on : NLS\n",
      "Working on : NLSN\n",
      "Working on : NLY\n",
      "Working on : NMIH\n",
      "Working on : NMRK\n",
      "Working on : NNBR\n",
      "Working on : NNI\n",
      "Working on : NNN\n",
      "Working on : NNVC\n",
      "Working on : NOC\n",
      "Working on : NODK\n",
      "Working on : NOG\n",
      "Working on : NOV\n",
      "Working on : NOVT\n",
      "Working on : NOW\n",
      "Working on : NP\n",
      "Working on : NPK\n",
      "Working on : NPO\n",
      "Working on : NPTN\n",
      "Working on : NR\n",
      "Working on : NRC\n",
      "Working on : NRG\n",
      "Working on : NRIM\n",
      "Working on : NRZ\n",
      "Working on : NSA\n",
      "Working on : NSC\n",
      "Working on : NSEC\n",
      "Working on : NSIT\n",
      "Working on : NSP\n",
      "Working on : NSSC\n",
      "Working on : NSTG\n",
      "Working on : NTAP\n",
      "Working on : NTCT\n",
      "Working on : NTGR\n",
      "Working on : NTIC\n",
      "Working on : NTIP\n",
      "Working on : NTLA\n",
      "Working on : NTNX\n",
      "Working on : NTRA\n",
      "Working on : NTRS\n",
      "Working on : NTWK\n",
      "Working on : NUAN\n",
      "Working on : NUE\n",
      "Working on : NURO\n",
      "Working on : NUS\n",
      "Working on : NUVA\n",
      "Working on : NVAX\n",
      "Working on : NVDA\n",
      "Working on : NVEC\n",
      "Working on : NVEE\n",
      "Working on : NVFY\n",
      "Working on : NVIV\n",
      "Working on : NVR\n",
      "Working on : NVRO\n",
      "Working on : NVT\n",
      "Working on : NVTA\n",
      "Working on : NWBI\n",
      "Working on : NWE\n",
      "Working on : NWFL\n",
      "Working on : NWHM\n",
      "Working on : NWL\n",
      "Working on : NWLI\n",
      "Working on : NWN\n",
      "Working on : NWPX\n",
      "Working on : NWS\n",
      "Working on : NWSA\n",
      "Working on : NX\n",
      "Working on : NXGN\n",
      "Working on : NXRT\n",
      "Working on : NXST\n",
      "Working on : NXTD\n",
      "Working on : NYCB\n",
      "Working on : NYMT\n",
      "Working on : NYT\n",
      "Working on : O\n",
      "Working on : OAS\n",
      "Working on : OBCI\n",
      "Working on : OBNK\n",
      "Working on : OC\n",
      "Working on : OCC\n",
      "Working on : OCFC\n",
      "Working on : OCN\n",
      "Working on : OCUL\n",
      "Working on : OCX\n",
      "Working on : ODC\n",
      "Working on : ODFL\n",
      "Working on : ODP\n",
      "Working on : ODT\n",
      "Working on : OESX\n",
      "Working on : OFC\n",
      "Working on : OFED\n",
      "Working on : OFG\n",
      "Working on : OFIX\n",
      "Working on : OFLX\n",
      "Working on : OGE\n",
      "Working on : OGEN\n",
      "Working on : OGS\n",
      "Working on : OHI\n",
      "Working on : OI\n",
      "Working on : OII\n",
      "Working on : OIS\n",
      "Working on : OKE\n",
      "Working on : OKTA\n",
      "Working on : OLED\n",
      "Working on : OLLI\n",
      "Working on : OLN\n",
      "Working on : OLP\n",
      "Working on : OMC\n",
      "Working on : OMCL\n",
      "Working on : OMER\n",
      "Working on : OMEX\n",
      "Working on : OMF\n",
      "Working on : OMI\n",
      "Working on : ON\n",
      "Working on : ONB\n",
      "Working on : ONCS\n",
      "Working on : ONTX\n",
      "Working on : ONVO\n",
      "Working on : OOMA\n",
      "Working on : OPGN\n",
      "Working on : OPI\n",
      "Working on : OPK\n",
      "Working on : OPOF\n",
      "Working on : OPRX\n",
      "Working on : OPTN\n",
      "Working on : OPTT\n",
      "Working on : OPY\n",
      "Working on : ORA\n",
      "Working on : ORBC\n",
      "Working on : ORC\n",
      "Working on : ORCL\n",
      "Working on : ORGO\n",
      "Working on : ORI\n",
      "Working on : ORLY\n",
      "Working on : ORN\n",
      "Working on : ORRF\n",
      "Working on : OSBC\n",
      "Working on : OSG\n",
      "Working on : OSIS\n",
      "Working on : OSK\n",
      "Working on : OSPN\n",
      "Working on : OSTK\n",
      "Working on : OSUR\n",
      "Working on : OTIC\n",
      "Working on : OTTR\n",
      "Working on : OUT\n",
      "Working on : OVBC\n",
      "Working on : OVLY\n",
      "Working on : OXM\n",
      "Working on : OXY\n",
      "Working on : OZK\n",
      "Working on : PACB\n",
      "Working on : PACW\n",
      "Working on : PAG\n",
      "Working on : PAHC\n",
      "Working on : PANL\n",
      "Working on : PANW\n",
      "Working on : PAR\n",
      "Working on : PARR\n",
      "Working on : PATI\n",
      "Working on : PATK\n",
      "Working on : PAYC\n",
      "Working on : PAYX\n",
      "Working on : PB\n",
      "Working on : PBCT\n",
      "Working on : PBF\n",
      "Working on : PBH\n",
      "Working on : PBHC\n",
      "Working on : PBI\n",
      "Working on : PBIP\n",
      "Working on : PBPB\n",
      "Working on : PBYI\n",
      "Working on : PCAR\n",
      "Working on : PCH\n",
      "Working on : PCRX\n",
      "Working on : PCSB\n",
      "Working on : PCTI\n",
      "Working on : PCTY\n",
      "Working on : PCYG\n",
      "Working on : PCYO\n",
      "Working on : PD\n",
      "Working on : PDCE\n",
      "Working on : PDCO\n",
      "Working on : PDEX\n",
      "Working on : PDFS\n",
      "Working on : PDLB\n",
      "Working on : PDM\n",
      "Working on : PEB\n",
      "Working on : PEBK\n",
      "Working on : PEBO\n",
      "Working on : PED\n",
      "Working on : PEG\n",
      "Working on : PEGA\n",
      "Working on : PEI\n",
      "Working on : PEN\n",
      "Working on : PENN\n",
      "Working on : PEP\n",
      "Working on : PESI\n",
      "Working on : PETQ\n",
      "Working on : PETS\n",
      "Working on : PFBC\n",
      "Working on : PFBI\n",
      "Working on : PFE\n",
      "Working on : PFG\n",
      "Working on : PFGC\n",
      "Working on : PFIE\n",
      "Working on : PFIN\n",
      "Working on : PFIS\n",
      "Working on : PFMT\n",
      "Working on : PFPT\n",
      "Working on : PFS\n",
      "Working on : PFSW\n",
      "Working on : PG\n",
      "Working on : PGC\n",
      "Working on : PGR\n",
      "Working on : PGRE\n",
      "Working on : PGTI\n",
      "Working on : PH\n",
      "Working on : PHAS\n",
      "Working on : PHIO\n",
      "Working on : PHM\n",
      "Working on : PHX\n",
      "Working on : PI\n",
      "Working on : PII\n",
      "Working on : PINC\n",
      "Working on : PINS\n",
      "Working on : PJT\n",
      "Working on : PK\n",
      "Working on : PKBK\n",
      "Working on : PKE\n",
      "Working on : PKG\n",
      "Working on : PKI\n",
      "Working on : PKOH\n",
      "Working on : PLAB\n",
      "Working on : PLAN\n",
      "Working on : PLAY\n",
      "Working on : PLBC\n",
      "Working on : PLCE\n",
      "Working on : PLD\n",
      "Working on : PLNT\n",
      "Working on : PLOW\n",
      "Working on : PLPC\n",
      "Working on : PLSE\n",
      "Working on : PLUG\n",
      "Working on : PLUS\n",
      "Working on : PLXP\n",
      "Working on : PLXS\n",
      "Working on : PLYA\n",
      "Working on : PLYM\n",
      "Working on : PM\n",
      "Working on : PMBC\n",
      "Working on : PMD\n",
      "Working on : PMT\n",
      "Working on : PMTS\n",
      "Working on : PNBK\n",
      "Working on : PNC\n",
      "Working on : PNFP\n",
      "Working on : PNM\n",
      "Working on : PNR\n",
      "Working on : PNRG\n",
      "Working on : PNW\n",
      "Working on : PODD\n",
      "Working on : POOL\n",
      "Working on : POR\n",
      "Working on : POST\n",
      "Working on : POWI\n",
      "Working on : POWL\n",
      "Working on : PPBI\n",
      "Working on : PPC\n",
      "Working on : PPG\n",
      "Working on : PPIH\n",
      "Working on : PPL\n",
      "Working on : PPSI\n",
      "Working on : PQG\n",
      "Working on : PRA\n",
      "Working on : PRAA\n",
      "Working on : PRAH\n",
      "Working on : PRFT\n",
      "Working on : PRGO\n",
      "Working on : PRGS\n",
      "Working on : PRI\n",
      "Working on : PRIM\n",
      "Working on : PRK\n",
      "Working on : PRLB\n",
      "Working on : PRMW\n",
      "Working on : PRO\n",
      "Working on : PROV\n",
      "Working on : PRPH\n",
      "Working on : PRTA\n",
      "Working on : PRTK\n",
      "Working on : PRTS\n",
      "Working on : PRTY\n",
      "Working on : PRU\n",
      "Working on : PRVB\n",
      "Working on : PSA\n",
      "Working on : PSB\n",
      "Working on : PSMT\n",
      "Working on : PSN\n",
      "Working on : PSTG\n",
      "Working on : PSX\n",
      "Working on : PTC\n",
      "Working on : PTCT\n",
      "Working on : PTE\n",
      "Working on : PTEN\n",
      "Working on : PTGX\n",
      "Working on : PTN\n",
      "Working on : PTSI\n",
      "Working on : PULM\n",
      "Working on : PUMP\n",
      "Working on : PVAC\n",
      "Working on : PVBC\n",
      "Working on : PVH\n",
      "Working on : PW\n",
      "Working on : PWOD\n",
      "Working on : PWR\n",
      "Working on : PXD\n",
      "Working on : PXLW\n",
      "Working on : PYPL\n",
      "Working on : PZG\n",
      "Working on : PZN\n",
      "Working on : PZZA\n",
      "Working on : QADA\n",
      "Working on : QADB\n",
      "Working on : QCOM\n",
      "Working on : QCRH\n",
      "Working on : QDEL\n",
      "Working on : QLYS\n",
      "Working on : QNST\n",
      "Working on : QRHC\n",
      "Working on : QRTEA\n",
      "Working on : QRVO\n",
      "Working on : QTRX\n",
      "Working on : QTS\n",
      "Working on : QTWO\n",
      "Working on : QUAD\n",
      "Working on : QUIK\n",
      "Working on : QUMU\n",
      "Working on : QUOT\n",
      "Working on : R\n",
      "Working on : RAD\n",
      "Working on : RAIL\n",
      "Working on : RAMP\n",
      "Working on : RARE\n",
      "Working on : RAVE\n",
      "Working on : RAVN\n",
      "Working on : RBB\n",
      "Working on : RBBN\n",
      "Working on : RBC\n",
      "Working on : RBCAA\n",
      "Working on : RBCN\n",
      "Working on : RBNC\n",
      "Working on : RC\n",
      "Working on : RCII\n",
      "Working on : RCKT\n",
      "Working on : RCKY\n",
      "Working on : RCL\n",
      "Working on : RCM\n",
      "Working on : RCMT\n",
      "Working on : RCUS\n",
      "Working on : RDFN\n",
      "Working on : RDI\n",
      "Working on : RDN\n",
      "Working on : RDNT\n",
      "Working on : RDUS\n",
      "Working on : RDVT\n",
      "Working on : RE\n",
      "Working on : REED\n",
      "Working on : REFR\n",
      "Working on : REG\n",
      "Working on : REGI\n",
      "Working on : REGN\n",
      "Working on : REI\n",
      "Working on : RELL\n",
      "Working on : RELV\n",
      "Working on : REPH\n",
      "Working on : REPL\n",
      "Working on : RES\n",
      "Working on : RESN\n",
      "Working on : RETA\n",
      "Working on : REV\n",
      "Working on : REVG\n",
      "Working on : REX\n",
      "Working on : REXR\n",
      "Working on : REZI\n",
      "Working on : RF\n",
      "Working on : RFIL\n",
      "Working on : RFL\n",
      "Working on : RFP\n",
      "Working on : RGA\n",
      "Working on : RGCO\n",
      "Working on : RGEN\n",
      "Working on : RGLD\n",
      "Working on : RGLS\n",
      "Working on : RGNX\n",
      "Working on : RGR\n",
      "Working on : RGS\n",
      "Working on : RH\n",
      "Working on : RHE\n",
      "Working on : RHI\n",
      "Working on : RHP\n",
      "Working on : RIBT\n",
      "Working on : RICK\n",
      "Working on : RIG\n",
      "Working on : RIGL\n",
      "Working on : RILY\n",
      "Working on : RIOT\n",
      "Working on : RJF\n",
      "Working on : RKDA\n",
      "Working on : RL\n",
      "Working on : RLGT\n",
      "Working on : RLGY\n",
      "Working on : RLI\n",
      "Working on : RLJ\n",
      "Working on : RM\n",
      "Working on : RMAX\n",
      "Working on : RMBS\n",
      "Working on : RMCF\n",
      "Working on : RMD\n",
      "Working on : RMR\n",
      "Working on : RMTI\n",
      "Working on : RNDB\n",
      "Working on : RNG\n",
      "Working on : RNR\n",
      "Working on : RNST\n",
      "Working on : RNWK\n",
      "Working on : ROCK\n",
      "Working on : ROG\n",
      "Working on : ROIC\n",
      "Working on : ROK\n",
      "Working on : ROKU\n",
      "Working on : ROL\n",
      "Working on : ROLL\n",
      "Working on : ROP\n",
      "Working on : ROST\n",
      "Working on : RPAI\n",
      "Working on : RPD\n",
      "Working on : RPM\n",
      "Working on : RPT\n",
      "Working on : RRC\n",
      "Working on : RRD\n",
      "Working on : RRGB\n",
      "Working on : RRR\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Working on : RRTS\n",
      "Working on : RS\n",
      "Working on : RSG\n",
      "Working on : RUBY\n",
      "Working on : RUN\n",
      "Working on : RUSHA\n",
      "Working on : RUSHB\n",
      "Working on : RUTH\n",
      "Working on : RVI\n",
      "Working on : RVNC\n",
      "Working on : RVP\n",
      "Working on : RVSB\n",
      "Working on : RWT\n",
      "Working on : RXN\n",
      "Working on : RYAM\n",
      "Working on : RYI\n",
      "Working on : RYN\n",
      "Working on : RYTM\n",
      "Working on : SABR\n",
      "Working on : SACH\n",
      "Working on : SAFE\n",
      "Working on : SAFM\n",
      "Working on : SAFT\n",
      "Working on : SAGE\n",
      "Working on : SAH\n",
      "Working on : SAIA\n",
      "Working on : SAIC\n",
      "Working on : SAIL\n",
      "Working on : SAL\n",
      "Working on : SALM\n",
      "Working on : SAM\n",
      "Working on : SAMG\n",
      "Working on : SANM\n",
      "Working on : SANW\n",
      "Working on : SASR\n",
      "Working on : SATS\n",
      "Working on : SAVE\n",
      "Working on : SBAC\n",
      "Working on : SBCF\n",
      "Working on : SBFG\n",
      "Working on : SBGI\n",
      "Working on : SBH\n",
      "Working on : SBNY\n",
      "Working on : SBOW\n",
      "Working on : SBRA\n",
      "Working on : SBSI\n",
      "Working on : SBT\n",
      "Working on : SBUX\n",
      "Working on : SC\n",
      "Working on : SCHL\n",
      "Working on : SCHN\n",
      "Working on : SCHW\n",
      "Working on : SCI\n",
      "Working on : SCL\n",
      "Working on : SCON\n",
      "Working on : SCOR\n",
      "Working on : SCPL\n",
      "Working on : SCS\n",
      "Working on : SCSC\n",
      "Working on : SCVL\n",
      "Working on : SCWX\n",
      "Working on : SCX\n",
      "Working on : SCYX\n",
      "Working on : SD\n",
      "Working on : SDPI\n",
      "Working on : SEAC\n",
      "Working on : SEAS\n",
      "Working on : SEB\n",
      "Working on : SEDG\n",
      "Working on : SEE\n",
      "Working on : SEIC\n",
      "Working on : SELB\n",
      "Working on : SELF\n",
      "Working on : SEM\n",
      "Working on : SENEA\n",
      "Working on : SENEB\n",
      "Working on : SENS\n",
      "Working on : SESN\n",
      "Working on : SF\n",
      "Working on : SFBC\n",
      "Working on : SFBS\n",
      "Working on : SFE\n",
      "Working on : SFIX\n",
      "Working on : SFM\n",
      "Working on : SFNC\n",
      "Working on : SFST\n",
      "Working on : SGA\n",
      "Working on : SGC\n",
      "Working on : SGEN\n",
      "Working on : SGH\n",
      "Working on : SGMA\n",
      "Working on : SGMO\n",
      "Working on : SGMS\n",
      "Working on : SGRP\n",
      "Working on : SGRY\n",
      "Working on : SHAK\n",
      "Working on : SHBI\n",
      "Working on : SHEN\n",
      "Working on : SHO\n",
      "Working on : SHOO\n",
      "Working on : SHSP\n",
      "Working on : SHW\n",
      "Working on : SIBN\n",
      "Working on : SIEB\n",
      "Working on : SIEN\n",
      "Working on : SIF\n",
      "Working on : SIG\n",
      "Working on : SIGA\n",
      "Working on : SIGI\n",
      "Working on : SILK\n",
      "Working on : SINT\n",
      "Working on : SIRI\n",
      "Working on : SITC\n",
      "Working on : SITE\n",
      "Working on : SIVB\n",
      "Working on : SIX\n",
      "Working on : SJI\n",
      "Working on : SJM\n",
      "Working on : SJW\n",
      "Working on : SKT\n",
      "Working on : SKX\n",
      "Working on : SKY\n",
      "Working on : SKYW\n",
      "Working on : SLAB\n",
      "Working on : SLB\n",
      "Working on : SLCA\n",
      "Working on : SLCT\n",
      "Working on : SLDB\n",
      "Working on : SLG\n",
      "Working on : SLGN\n",
      "Working on : SLM\n",
      "Working on : SLNO\n",
      "Working on : SLP\n",
      "Working on : SLS\n",
      "Working on : SM\n",
      "Working on : SMAR\n",
      "Working on : SMBC\n",
      "Working on : SMBK\n",
      "Working on : SMED\n",
      "Working on : SMG\n",
      "Working on : SMIT\n",
      "Working on : SMMF\n",
      "Working on : SMP\n",
      "Working on : SMPL\n",
      "Working on : SMSI\n",
      "Working on : SMTC\n",
      "Working on : SNA\n",
      "Working on : SNAP\n",
      "Working on : SNBR\n",
      "Working on : SNCR\n",
      "Working on : SND\n",
      "Working on : SNDR\n",
      "Working on : SNDX\n",
      "Working on : SNFCA\n",
      "Working on : SNOA\n",
      "Working on : SNPS\n",
      "Working on : SNR\n",
      "Working on : SNV\n",
      "Working on : SNX\n",
      "Working on : SO\n",
      "Working on : SOHO\n",
      "Working on : SOI\n",
      "Working on : SOLY\n",
      "Working on : SON\n",
      "Working on : SONO\n",
      "Working on : SP\n",
      "Working on : SPB\n",
      "Working on : SPG\n",
      "Working on : SPGI\n",
      "Working on : SPKE\n",
      "Working on : SPLK\n",
      "Working on : SPNE\n",
      "Working on : SPOK\n",
      "Working on : SPPI\n",
      "Working on : SPR\n",
      "Working on : SPRO\n",
      "Working on : SPRT\n",
      "Working on : SPSC\n",
      "Working on : SPTN\n",
      "Working on : SPWH\n",
      "Working on : SPWR\n",
      "Working on : SPXC\n",
      "Working on : SQ\n",
      "Working on : SQBG\n",
      "Working on : SR\n",
      "Working on : SRC\n",
      "Working on : SRCE\n",
      "Working on : SRCL\n",
      "Working on : SRDX\n",
      "Working on : SRE\n",
      "Working on : SREV\n",
      "Working on : SRG\n",
      "Working on : SRI\n",
      "Working on : SRNE\n",
      "Working on : SRPT\n",
      "Working on : SRRK\n",
      "Working on : SRT\n",
      "Working on : SRTS\n",
      "Working on : SSB\n",
      "Working on : SSBI\n",
      "Working on : SSD\n",
      "Working on : SSKN\n",
      "Working on : SSNC\n",
      "Working on : SSP\n",
      "Working on : SSTI\n",
      "Working on : SSTK\n",
      "Working on : ST\n",
      "Working on : STAA\n",
      "Working on : STAG\n",
      "Working on : STAR\n",
      "Working on : STBA\n",
      "Working on : STC\n",
      "Working on : STCN\n",
      "Working on : STE\n",
      "Working on : STFC\n",
      "Working on : STIM\n",
      "Working on : STKS\n",
      "Working on : STL\n",
      "Working on : STLD\n",
      "Working on : STMP\n",
      "Working on : STOR\n",
      "Working on : STRA\n",
      "Working on : STRL\n",
      "Working on : STRM\n",
      "Working on : STRS\n",
      "Working on : STRT\n",
      "Working on : STT\n",
      "Working on : STWD\n",
      "Working on : STX\n",
      "Working on : STXB\n",
      "Working on : STZ\n",
      "Working on : SUI\n",
      "Working on : SUM\n",
      "Working on : SUMR\n",
      "Working on : SUNW\n",
      "Working on : SUP\n",
      "Working on : SUPN\n",
      "Working on : SVBI\n",
      "Working on : SVRA\n",
      "Working on : SVT\n",
      "Working on : SWAV\n",
      "Working on : SWCH\n",
      "Working on : SWK\n",
      "Working on : SWKS\n",
      "Working on : SWM\n",
      "Working on : SWN\n",
      "Working on : SWX\n",
      "Working on : SXC\n",
      "Working on : SXI\n",
      "Working on : SXT\n",
      "Working on : SYBT\n",
      "Working on : SYBX\n",
      "Working on : SYF\n",
      "Working on : SYK\n",
      "Working on : SYKE\n",
      "Working on : SYN\n",
      "Working on : SYNA\n",
      "Working on : SYNH\n",
      "Working on : SYNL\n",
      "Working on : SYPR\n",
      "Working on : SYRS\n",
      "Working on : SYX\n",
      "Working on : SYY\n",
      "Working on : T\n",
      "Working on : TACO\n",
      "Working on : TACT\n",
      "Working on : TAIT\n",
      "Working on : TALO\n",
      "Working on : TAP\n",
      "Working on : TAST\n",
      "Working on : TAYD\n",
      "Working on : TBBK\n",
      "Working on : TBI\n",
      "Working on : TBIO\n",
      "Working on : TBK\n",
      "Working on : TBNK\n",
      "Working on : TBPH\n",
      "Working on : TCBI\n",
      "Working on : TCBK\n",
      "Working on : TCDA\n",
      "Working on : TCFC\n",
      "Working on : TCI\n",
      "Working on : TCMD\n",
      "Working on : TCON\n",
      "Working on : TCS\n",
      "Working on : TDC\n",
      "Working on : TDG\n",
      "Working on : TDOC\n",
      "Working on : TDS\n",
      "Working on : TDW\n",
      "Working on : TDY\n",
      "Working on : TECH\n",
      "Working on : TEL\n",
      "Working on : TELL\n",
      "Working on : TEN\n",
      "Working on : TENB\n",
      "Working on : TENX\n",
      "Working on : TER\n",
      "Working on : TESS\n",
      "Working on : TEUM\n",
      "Working on : TEX\n",
      "Working on : TFSL\n",
      "Working on : TFX\n",
      "Working on : TG\n",
      "Working on : TGEN\n",
      "Working on : TGI\n",
      "Working on : TGLS\n",
      "Working on : TGNA\n",
      "Working on : TGT\n",
      "Working on : TGTX\n",
      "Working on : THC\n",
      "Working on : THFF\n",
      "Working on : THG\n",
      "Working on : THO\n",
      "Working on : THR\n",
      "Working on : THRM\n",
      "Working on : THS\n",
      "Working on : TILE\n",
      "Working on : TIPT\n",
      "Working on : TISI\n",
      "Working on : TITN\n",
      "Working on : TJX\n",
      "Working on : TKR\n",
      "Working on : TLGT\n",
      "Working on : TLYS\n",
      "Working on : TMDX\n",
      "Working on : TMHC\n",
      "Working on : TMO\n",
      "Working on : TMP\n",
      "Working on : TMST\n",
      "Working on : TMUS\n",
      "Working on : TNC\n",
      "Working on : TNDM\n",
      "Working on : TNET\n",
      "Working on : TNXP\n",
      "Working on : TOL\n",
      "Working on : TOWN\n",
      "Working on : TPB\n",
      "Working on : TPC\n",
      "Working on : TPH\n",
      "Working on : TPHS\n",
      "Working on : TPIC\n",
      "Working on : TPR\n",
      "Working on : TPTX\n",
      "Working on : TPX\n",
      "Working on : TR\n",
      "Working on : TRC\n",
      "Working on : TRCH\n",
      "Working on : TREC\n",
      "Working on : TREE\n",
      "Working on : TREX\n",
      "Working on : TRGP\n",
      "Working on : TRHC\n",
      "Working on : TRIP\n",
      "Working on : TRMB\n",
      "Working on : TRMK\n",
      "Working on : TRN\n",
      "Working on : TRNO\n",
      "Working on : TRNS\n",
      "Working on : TROW\n",
      "Working on : TROX\n",
      "Working on : TRS\n",
      "Working on : TRST\n",
      "Working on : TRT\n",
      "Working on : TRTN\n",
      "Working on : TRTX\n",
      "Working on : TRU\n",
      "Working on : TRUP\n",
      "Working on : TRV\n",
      "Working on : TRVN\n",
      "Working on : TSBK\n",
      "Working on : TSC\n",
      "Working on : TSCO\n",
      "Working on : TSE\n",
      "Working on : TSLA\n",
      "Working on : TSN\n",
      "Working on : TSQ\n",
      "Working on : TTC\n",
      "Working on : TTD\n",
      "Working on : TTEC\n",
      "Working on : TTEK\n",
      "Working on : TTGT\n",
      "Working on : TTI\n",
      "Working on : TTMI\n",
      "Working on : TTNP\n",
      "Working on : TTOO\n",
      "Working on : TTWO\n",
      "Working on : TUP\n",
      "Working on : TUSK\n",
      "Working on : TVTY\n",
      "Working on : TW\n",
      "Working on : TWI\n",
      "Working on : TWIN\n",
      "Working on : TWLO\n",
      "Working on : TWNK\n",
      "Working on : TWO\n",
      "Working on : TWOU\n",
      "Working on : TWST\n",
      "Working on : TWTR\n",
      "Working on : TXMD\n",
      "Working on : TXN\n",
      "Working on : TXRH\n",
      "Working on : TXT\n",
      "Working on : TYL\n",
      "Working on : TYME\n",
      "Working on : TZOO\n",
      "Working on : UA\n",
      "Working on : UAA\n",
      "Working on : UAL\n",
      "Working on : UAMY\n",
      "Working on : UBA\n",
      "Working on : UBCP\n",
      "Working on : UBER\n",
      "Working on : UBFO\n",
      "Working on : UBOH\n",
      "Working on : UBSI\n",
      "Working on : UCBI\n",
      "Working on : UCTT\n",
      "Working on : UDR\n",
      "Working on : UE\n",
      "Working on : UEC\n",
      "Working on : UEIC\n",
      "Working on : UFAB\n",
      "Working on : UFCS\n",
      "Working on : UFI\n",
      "Working on : UFPI\n",
      "Working on : UFPT\n",
      "Working on : UFS\n",
      "Working on : UG\n",
      "Working on : UGI\n",
      "Working on : UHAL\n",
      "Working on : UHS\n",
      "Working on : UHT\n",
      "Working on : UIHC\n",
      "Working on : UIS\n",
      "Working on : ULBI\n",
      "Working on : ULH\n",
      "Working on : ULTA\n",
      "Working on : UMBF\n",
      "Working on : UMH\n",
      "Working on : UMPQ\n",
      "Working on : UNAM\n",
      "Working on : UNB\n",
      "Working on : UNF\n",
      "Working on : UNFI\n",
      "Working on : UNH\n",
      "Working on : UNIT\n",
      "Working on : UNM\n",
      "Working on : UNP\n",
      "Working on : UNTY\n",
      "Working on : UNVR\n",
      "Working on : UONE\n",
      "Working on : UONEK\n",
      "Working on : UPLD\n",
      "Working on : UPS\n",
      "Working on : UPWK\n",
      "Working on : URBN\n",
      "Working on : URI\n",
      "Working on : USAK\n",
      "Working on : USAP\n",
      "Working on : USB\n",
      "Working on : USCR\n",
      "Working on : USEG\n",
      "Working on : USFD\n",
      "Working on : USIO\n",
      "Working on : USLM\n",
      "Working on : USM\n",
      "Working on : USNA\n",
      "Working on : USPH\n",
      "Working on : USWS\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Working on : USX\n",
      "Working on : UTHR\n",
      "Working on : UTI\n",
      "Working on : UTL\n",
      "Working on : UTMD\n",
      "Working on : UUU\n",
      "Working on : UVE\n",
      "Working on : UVSP\n",
      "Working on : UVV\n",
      "Working on : V\n",
      "Working on : VAC\n",
      "Working on : VAL\n",
      "Working on : VALU\n",
      "Working on : VAPO\n",
      "Working on : VBFC\n",
      "Working on : VBIV\n",
      "Working on : VBTX\n",
      "Working on : VC\n",
      "Working on : VCEL\n",
      "Working on : VCRA\n",
      "Working on : VCTR\n",
      "Working on : VCYT\n",
      "Working on : VEC\n",
      "Working on : VECO\n",
      "Working on : VEEV\n",
      "Working on : VER\n",
      "Working on : VERI\n",
      "Working on : VERU\n",
      "Working on : VFC\n",
      "Working on : VG\n",
      "Working on : VGR\n",
      "Working on : VHC\n",
      "Working on : VIAV\n",
      "Working on : VICI\n",
      "Working on : VICR\n",
      "Working on : VIRC\n",
      "Working on : VIRT\n",
      "Working on : VISL\n",
      "Working on : VIVO\n",
      "Working on : VKTX\n",
      "Working on : VLGEA\n",
      "Working on : VLO\n",
      "Working on : VLY\n",
      "Working on : VMC\n",
      "Working on : VMI\n",
      "Working on : VMW\n",
      "Working on : VNCE\n",
      "Working on : VNDA\n",
      "Working on : VNE\n",
      "Working on : VNO\n",
      "Working on : VNRX\n",
      "Working on : VNTR\n",
      "Working on : VOXX\n",
      "Working on : VOYA\n",
      "Working on : VPG\n",
      "Working on : VRA\n",
      "Working on : VRAY\n",
      "Working on : VREX\n",
      "Working on : VRNS\n",
      "Working on : VRNT\n",
      "Working on : VRRM\n",
      "Working on : VRS\n",
      "Working on : VRSK\n",
      "Working on : VRSN\n",
      "Working on : VRTS\n",
      "Working on : VRTV\n",
      "Working on : VRTX\n",
      "Working on : VSAT\n",
      "Working on : VSEC\n",
      "Working on : VSH\n",
      "Working on : VST\n",
      "Working on : VSTM\n",
      "Working on : VSTO\n",
      "Working on : VTNR\n",
      "Working on : VTR\n",
      "Working on : VTVT\n",
      "Working on : VUZI\n",
      "Working on : VVI\n",
      "Working on : VVV\n",
      "Working on : VXRT\n",
      "Working on : VYGR\n",
      "Working on : VZ\n",
      "Working on : W\n",
      "Working on : WAB\n",
      "Working on : WABC\n",
      "Working on : WAFD\n",
      "Working on : WAL\n",
      "Working on : WASH\n",
      "Working on : WAT\n",
      "Working on : WATT\n",
      "Working on : WBA\n",
      "Working on : WBS\n",
      "Working on : WBT\n",
      "Working on : WCC\n",
      "Working on : WD\n",
      "Working on : WDAY\n",
      "Working on : WDC\n",
      "Working on : WDFC\n",
      "Working on : WEC\n",
      "Working on : WELL\n",
      "Working on : WEN\n",
      "Working on : WERN\n",
      "Working on : WETF\n",
      "Working on : WEX\n",
      "Working on : WEYS\n",
      "Working on : WFC\n",
      "Working on : WGO\n",
      "Working on : WH\n",
      "Working on : WHD\n",
      "Working on : WHG\n",
      "Working on : WHLM\n",
      "Working on : WHLR\n",
      "Working on : WHR\n",
      "Working on : WINA\n",
      "Working on : WING\n",
      "Working on : WIRE\n",
      "Working on : WK\n",
      "Working on : WKHS\n",
      "Working on : WLDN\n",
      "Working on : WLFC\n",
      "Working on : WLK\n",
      "Working on : WLL\n",
      "Working on : WLTW\n",
      "Working on : WM\n",
      "Working on : WMB\n",
      "Working on : WMC\n",
      "Working on : WMK\n",
      "Working on : WMS\n",
      "Working on : WMT\n",
      "Working on : WNC\n",
      "Working on : WNEB\n",
      "Working on : WOR\n",
      "Working on : WOW\n",
      "Working on : WPC\n",
      "Working on : WPG\n",
      "Working on : WRB\n",
      "Working on : WRE\n",
      "Working on : WRI\n",
      "Working on : WRK\n",
      "Working on : WRLD\n",
      "Working on : WSBC\n",
      "Working on : WSBF\n",
      "Working on : WSC\n",
      "Working on : WSFS\n",
      "Working on : WSM\n",
      "Working on : WSO\n",
      "Working on : WSR\n",
      "Working on : WST\n",
      "Working on : WSTG\n",
      "Working on : WSTL\n",
      "Working on : WTBA\n",
      "Working on : WTFC\n",
      "Working on : WTI\n",
      "Working on : WTM\n",
      "Working on : WTRH\n",
      "Working on : WTS\n",
      "Working on : WTT\n",
      "Working on : WTTR\n",
      "Working on : WU\n",
      "Working on : WVE\n",
      "Working on : WVFC\n",
      "Working on : WVVI\n",
      "Working on : WW\n",
      "Working on : WWD\n",
      "Working on : WWE\n",
      "Working on : WWR\n",
      "Working on : WWW\n",
      "Working on : WY\n",
      "Working on : WYNN\n",
      "Working on : WYY\n",
      "Working on : X\n",
      "Working on : XBIT\n",
      "Working on : XEC\n",
      "Working on : XEL\n",
      "Working on : XELA\n",
      "Working on : XELB\n",
      "Working on : XENT\n",
      "Working on : XERS\n",
      "Working on : XFOR\n",
      "Working on : XHR\n",
      "Working on : XLNX\n",
      "Working on : XLRN\n",
      "Working on : XNCR\n",
      "Working on : XOG\n",
      "Working on : XOM\n",
      "Working on : XOMA\n",
      "Working on : XONE\n",
      "Working on : XPER\n",
      "Working on : XPL\n",
      "Working on : XPO\n",
      "Working on : XRAY\n",
      "Working on : XRX\n",
      "Working on : XSPA\n",
      "Working on : XTNT\n",
      "Working on : XXII\n",
      "Working on : XYL\n",
      "Working on : Y\n",
      "Working on : YELP\n",
      "Working on : YETI\n",
      "Working on : YEXT\n",
      "Working on : YMAB\n",
      "Working on : YORW\n",
      "Working on : YTEN\n",
      "Working on : YUM\n",
      "Working on : Z\n",
      "Working on : ZBH\n",
      "Working on : ZBRA\n",
      "Working on : ZDGE\n",
      "Working on : ZEN\n",
      "Working on : ZEUS\n",
      "Working on : ZG\n",
      "Working on : ZGNX\n",
      "Working on : ZION\n",
      "Working on : ZIOP\n",
      "Working on : ZIXI\n",
      "Working on : ZM\n",
      "Working on : ZNGA\n",
      "Working on : ZS\n",
      "Working on : ZSAN\n",
      "Working on : ZTS\n",
      "Working on : ZUMZ\n",
      "Working on : ZUO\n",
      "Working on : ZVO\n",
      "Working on : ZYNE\n",
      "Working on : ZYXI\n"
     ]
    }
   ],
   "source": [
    "# Create a backup for all original stock data\n",
    "\n",
    "# Cycle through all tickers\n",
    "for ticker in tickers:\n",
    "    print(\"Working on :\", ticker)\n",
    "    \n",
    "    # Get a dataframe for that ticker\n",
    "    stock_df = get_df_from_csv(ticker)\n",
    "    \n",
    "    # Add daily return to this dataframe\n",
    "    add_daily_return_to_df(stock_df, ticker)\n",
    "    \n",
    "    # Delete unnamed columns in dataframe\n",
    "    stock_df = delete_unnamed_cols(stock_df)\n",
    "    \n",
    "    # Save cleaned dataframe to csv\n",
    "    save_dataframe_to_csv(stock_df, ticker)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get Stock Return over Time Period & Coefficient of Variation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Initial Price : 44.77385330200195\n",
      "167.6699981689453\n",
      "Final Price : 167.6699981689453\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "1165    2.744819\n",
       "Name: Adj Close, dtype: float64"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stock_a\n",
    "\n",
    "# Get total return since 2017\n",
    "# Final Price 167.67 = (44.77 * 2.745) + 44.77\n",
    "get_roi_defined_time(stock_a)\n",
    "\n",
    "# Get coefficient of variation \n",
    "# This is higher than normal because I'm using many years instead of one\n",
    "# get_cov(stock_a)"
   ]
  },
  {
   "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}