Glassdoor Scraper from jsonlines file.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "flexible-grade",
   "metadata": {},
   "source": [
    "# Professor Fedyk URAP Interview Task: Glassdoor Scraper"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "educational-color",
   "metadata": {},
   "source": [
    "## Step 1: Build GlassDoor Seed URL list."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "meaning-nicaragua",
   "metadata": {},
   "outputs": [],
   "source": [
    "import time\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import nltk\n",
    "\n",
    "import jsonlines\n",
    "import json\n",
    "import csv\n",
    "\n",
    "wait=.05"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "contained-heart",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get all data we need to search the company from files\n",
    "\n",
    "name = []\n",
    "longName = []\n",
    "ticker = []\n",
    "\n",
    "with open('gvkey_salary_company_seeds.jsonl') as reader:\n",
    "    for line in reader:\n",
    "        company = json.loads(line)\n",
    "        \n",
    "        name.append(company['name'])\n",
    "        longName.append(company['longname'])\n",
    "        ticker.append(company['capiq-ticker'])       \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "frank-mission",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0                                AAR\n",
      "1                  American Airlines\n",
      "2                 CECO Environmental\n",
      "3       ASA Gold and Precious Metals\n",
      "4                                AVX\n",
      "                    ...             \n",
      "5805                  nVent Electric\n",
      "5806               Grindrod Shipping\n",
      "5807      Navios Maritime Containers\n",
      "5808                          Arcosa\n",
      "5809                 Castor Maritime\n",
      "Length: 5810, dtype: object\n"
     ]
    }
   ],
   "source": [
    "# Process out the legal words from the 'long name' to get common names\n",
    "\n",
    "common = pd.Series(longName)\n",
    "\n",
    "with open('legal.csv', newline='') as legal:\n",
    "    reader = csv.reader(legal)\n",
    "    legalTerms = list(reader)[0][1:]\n",
    "    \n",
    "    \n",
    "    #Special case for words with '(The)'\n",
    "    common = common.apply(lambda x: 'The ' + x.replace('(The)', '') if '(The)' in x else x)\n",
    "    \n",
    "    for term in legalTerms:\n",
    "        common = common.apply(lambda x: x.replace(term, '') if (type(x)==str and x.endswith(term)) else x)\n",
    "\n",
    "        \n",
    "print(common)\n",
    "    \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "satellite-craps",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Now we begin the search for seeds. below are helper functions to help divide up the task.\n",
    "\n",
    "def sign_in(args):\n",
    "    url = 'https://www.glassdoor.com/profile/login_input.htm'\n",
    "    browser.get(url)\n",
    "    time.sleep(wait)\n",
    "    \n",
    "    email_field = browser.find_element_by_name('username')\n",
    "    password_field = browser.find_element_by_name('password')\n",
    "    submit_btn = browser.find_element_by_xpath('//button[@type=\"submit\"]')\n",
    "\n",
    "    email_field.send_keys(args['username'])\n",
    "    password_field.send_keys(args['password'])\n",
    "    submit_btn.click()\n",
    "\n",
    "    time.sleep(wait)\n",
    "    browser.get(args['url'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "stretch-champion",
   "metadata": {},
   "outputs": [],
   "source": [
    "def search_word(c):\n",
    "    '''Accesses the search bar and inputs all information\n",
    "    and submits the search.\n",
    "    '''\n",
    "    keyword = browser.find_element(By.XPATH, '//*[@id=\"sc.keyword\"]')\n",
    "    keyword.clear()\n",
    "    keyword.send_keys(c)\n",
    "    time.sleep(wait)\n",
    "\n",
    "    dropdown = browser.find_element(By.XPATH, '//*[@id=\"scBar\"]/div/div[2]/div')\n",
    "    dropdown.click()\n",
    "    time.sleep(wait)\n",
    "\n",
    "    selectCompany = browser.find_element(By.XPATH, '//*[@id=\"option_1\"]')\n",
    "    selectCompany.click()\n",
    "    time.sleep(wait)\n",
    "\n",
    "    #.clear() doesnt work so harcoded backspace\n",
    "    location = browser.find_element(By.XPATH,'//*[@id=\"sc.location\"]')\n",
    "    for i in range(50):\n",
    "        location.send_keys(Keys.BACK_SPACE)\n",
    "\n",
    "    searchBtn = browser.find_element(By.XPATH,'//*[@id=\"scBar\"]/div/button/span')\n",
    "    searchBtn.click()\n",
    "    time.sleep(wait)\n",
    "    \n",
    "    #Some times random pop ups come to block the scraper if the scraper goes too fast.\n",
    "    #optionally uncomment below if this happens.\n",
    "    # try:\n",
    "    #     browser.find_element_by_class_name(\"selected\").click()\n",
    "    # except ElementClickInterceptedException:\n",
    "    #     pass\n",
    "\n",
    "    # time.sleep(wait)\n",
    "\n",
    "    # try:\n",
    "    #     browser.find_element_by_class_name(\"ModalStyle__xBtn___29PT9\").click()  #clicking to the X.\n",
    "    # except NoSuchElementException:\n",
    "    #     pass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "joined-injection",
   "metadata": {},
   "outputs": [],
   "source": [
    "def find_match(i, c):\n",
    "    ''' finds company with name 'c' and returns link to most likely website of company 'c'\n",
    "        \n",
    "        Detail:\n",
    "        searches through each result and checks how many times each result word matches\n",
    "        with the ticker, longname, and company name. We choose the best candidates\n",
    "        that match the most of these three, and determine the most likely legetimate\n",
    "        site via heuristic getStat(<possible result>) and clicks on link. \n",
    "    '''\n",
    "    results = browser.find_elements(By.CLASS_NAME,'single-company-result.module')\n",
    "\n",
    "    similarNames = []\n",
    "    similarStat = []\n",
    "    matches = []\n",
    "    \n",
    "    # count matches\n",
    "    for oneResult in results:\n",
    "        resultName = oneResult.find_element(By.CLASS_NAME, 'col-9.pr-0')\n",
    "        textLink = resultName.find_element(By.TAG_NAME, 'a')\n",
    "        matchNum = checkAnyInLowerStrip(i, textLink.text)\n",
    "        matches.append(matchNum)  \n",
    "        \n",
    "    matches = np.array(matches)\n",
    "    if matches.size == 0:\n",
    "        return ''\n",
    "    maxMatch = max(matches)\n",
    "    if maxMatch == 0:\n",
    "        return ''\n",
    "    else:\n",
    "        # choose best stat out of best matches\n",
    "        bestCandidates = np.where(matches == maxMatch)[0]\n",
    "        for i in bestCandidates:\n",
    "            candidate = results[i]\n",
    "            oneOfBestName = candidate.find_element(By.CLASS_NAME, 'col-9.pr-0')\n",
    "            textLink = oneOfBestName.find_element(By.TAG_NAME, 'a')\n",
    "            similarNames.append(textLink)\n",
    "            similarStat.append(getStat(candidate))\n",
    "        similarNames[np.argmax(similarStat)].click()\n",
    "        \n",
    "        direct_name = browser.find_element(By.XPATH, '//*[@id=\"DivisionsDropdownComponent\"]').text\n",
    "        if check_public(direct_name):\n",
    "            time.sleep(wait)\n",
    "            return browser.current_url\n",
    "        else:\n",
    "            return ''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "weighted-timber",
   "metadata": {},
   "outputs": [],
   "source": [
    "def getStat(oneResult):\n",
    "    '''gets a the mean of reviews, salaries, and interviews to determine how legitimite the company profile is.\n",
    "    \n",
    "    the mean is used since if there is only one metric that is strong (possibly due to spamming) then this is \n",
    "    discounted by taking the mean of all three values.\n",
    "    '''\n",
    "    \n",
    "    stats = oneResult.find_elements(By.CLASS_NAME, 'num.h2')\n",
    "    nums = []\n",
    "    k = 1\n",
    "    for s in stats:\n",
    "        s = s.text.strip().replace('--', '0')\n",
    "        if 'k' in s:\n",
    "            s = s.replace('k', '')\n",
    "            k = 1000 # we need to multiply by 1k = 1000\n",
    "        numStat = float(s) * k\n",
    "        nums.append(numStat)\n",
    "        \n",
    "    return np.mean(nums)\n",
    "            \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "hispanic-utilization",
   "metadata": {},
   "outputs": [],
   "source": [
    "def check_redirect(i, c):\n",
    "    '''Occasioanlly the exact name of the comapany is entered, and we are taken to their page.\n",
    "    In this case the company name may be different so we just check if either the display name\n",
    "    is in what we're searching and vice versa.\n",
    "    \n",
    "    returns TRUE if there was a redirect\n",
    "    '''\n",
    "    try:\n",
    "        direct_name = browser.find_element(By.XPATH, '//*[@id=\"DivisionsDropdownComponent\"]').text\n",
    "    except:\n",
    "        return 'not redirect'\n",
    "    print('redirected to: ', direct_name, ' when searching: ', c)\n",
    "    if direct_name and direct_name != ' ':\n",
    "        if checkAnyInLowerStrip(i, direct_name):\n",
    "            if check_public(direct_name):\n",
    "                return browser.current_url\n",
    "    return 'fail'\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "latest-truth",
   "metadata": {},
   "source": [
    "Logic for private words:\n",
    "- Non-profits may issue stock publicly in some states\n",
    "- Some franchises are publicly traded\n",
    "- Hospitals can be publicly traded\n",
    "- Contracting firms may be publicly traded\n",
    "- Subsidaries may be publicly traded\n",
    "- Other is ambiguous\n",
    "    \n",
    "    Thus everything else in the list must be private\n",
    "\n",
    "https://www.glassdoor.com/mz-survey/start_input.htm?cr=&c=&showSurvey=Reviews"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "controlling-north",
   "metadata": {},
   "outputs": [],
   "source": [
    "def check_public(direct_name):\n",
    "    '''all entries in JSONL files should be publicly traded.\n",
    "    If any company is not publicly traded, return false\n",
    "    else return true\n",
    "    \n",
    "    might need to adjust private words later.\n",
    "    '''\n",
    "    return True #many public companies are listed as private so turn off\n",
    "    \n",
    "    \n",
    "    typeText = browser.find_element(By.XPATH, \"//*[@data-test='employer-type']\").text\n",
    "    privateWords = ['Private', 'Government', 'College', 'School', 'Self']\n",
    "    if any([p for p in privateWords if p in typeText]):\n",
    "        print('Private Company found and ignored: ', direct_name)\n",
    "        return ''\n",
    "    else:\n",
    "        return True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "advised-hardwood",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_seed_link(i, c):\n",
    "    '''gets the seed link of the 'i'th word, 'c'.\n",
    "    if the link is found, appends it to seeds.\n",
    "    otherwise appends ''.\n",
    "    '''\n",
    "    link_found = find_match(i, c)\n",
    "    if not link_found:\n",
    "        return ''\n",
    "    else:\n",
    "        return link_found"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "primary-closure",
   "metadata": {},
   "outputs": [],
   "source": [
    "def search(i, c):\n",
    "    '''searches the word in the search bar via search_word(c)\n",
    "    then checks if there was a redirect via check_redirect\n",
    "    finally gets seed link via get_seed_link\n",
    "    '''\n",
    "    try:\n",
    "        search_word(c)\n",
    "        result = check_redirect(i, c)\n",
    "        if (result == 'not redirect'):\n",
    "            return get_seed_link(i, c)\n",
    "        elif (result == 'fail'):\n",
    "            return ''\n",
    "        else:\n",
    "            return result\n",
    "        \n",
    "    except Exception as e:\n",
    "        return ''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "welsh-adrian",
   "metadata": {},
   "outputs": [],
   "source": [
    "def gather_seeds(limit):\n",
    "    '''iterates from entries at index start to end to search for the seed link\n",
    "    adds '' to gd-url in taskOne if not found.\n",
    "    adds the link to gd-url in taskOne if found\n",
    "    \n",
    "    if the link is found, we go ahead and collect the \n",
    "    '''\n",
    "    \n",
    "    \n",
    "    reader = jsonlines.open('gvkey_salary_company_seeds.jsonl', mode='r')\n",
    "    \n",
    "    seed = ''\n",
    "    taskOne = []\n",
    "    taskTwo = []\n",
    "    \n",
    "    for index, company in enumerate(reader):\n",
    "        #if index < limit:\n",
    "        #    continue\n",
    "        seed = search(index, longName[index])\n",
    "        if not seed:\n",
    "            seed = search(index, common[index])\n",
    "            #give up only after common name and long name does not work.\n",
    "        company['gd-url'] = seed\n",
    "        taskOne.append(company)\n",
    "        \n",
    "        if (seed != ''):\n",
    "            collectTaskTwo(taskTwo, company.copy())\n",
    "            \n",
    "        limit -= 1\n",
    "        \n",
    "    reader.close() \n",
    "    \n",
    "    return taskOne, taskTwo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "organizational-extraction",
   "metadata": {},
   "outputs": [],
   "source": [
    "def checkAnyInLowerStrip(i, word):\n",
    "    ''' checks if a the common name, long name, or ticker is in word, or vise versa when stripped \n",
    "    of spaces and punctuations and lower cased are contained in eachother.\n",
    "    \n",
    "    Note:\n",
    "    After the first successfull pass, there were many instances where one search led to another\n",
    "    version of the name popping up, but it was not caught as valid. This happened as redirects and\n",
    "    normal searches.\n",
    "    \n",
    "    Additionally the cases of the words were messing with the accuracy so everything is in lower case.\n",
    "    However, the search itself is in the original case because that tends to bring the most relavent to \n",
    "    the top. The punctuations are also removed.\n",
    "    \n",
    "    finally we get rid of spaces since some comapnies concatinate their company names on glass door.\n",
    "    '''\n",
    "    \n",
    "    #strip all punctuation\n",
    "    tokenizer = nltk.RegexpTokenizer(r\"\\w+\")\n",
    "    word = ''.join(tokenizer.tokenize(word)).lower()\n",
    "\n",
    "    def normalizeAndCompare(c):\n",
    "        c = ''.join(tokenizer.tokenize(c)).lower()\n",
    "        return c in word or word in c\n",
    "    \n",
    "    check = [ticker[i], common[i], longName[i]]\n",
    "    result = []\n",
    "    \n",
    "    for item in check:\n",
    "        result.append(normalizeAndCompare(item))\n",
    "        \n",
    "    return sum(result)\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "alleged-actress",
   "metadata": {},
   "outputs": [],
   "source": [
    "### Now we input the URLs into the jsonl file\n",
    "def writeToJson(writeList, dest):\n",
    "    ''' Write writeList into dest.json as json object\n",
    "    '''\n",
    "    jsonObject = json.dumps(writeList, indent = 4)\n",
    "    with open(dest + \".json\", \"w\") as outfile: \n",
    "        outfile.write(jsonObject) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "european-station",
   "metadata": {},
   "outputs": [],
   "source": [
    "def collectTaskTwo(taskTwo, company):\n",
    "    ''' Given output list taskTwo and a dict company\n",
    "    to input information, collect Overview and Top bar \n",
    "    data into the comapny dict, then append to\n",
    "    taskTwo list\n",
    "    '''\n",
    "    collectOverview(company)\n",
    "    collectTopBar(company)\n",
    "    taskTwo.append(company)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "explicit-domestic",
   "metadata": {},
   "outputs": [],
   "source": [
    "def collectOverview(company):\n",
    "    ''' Collect all information from the Overview pane on glassdoor.com\n",
    "    '''\n",
    "    infoSquare = browser.find_element(By.CLASS_NAME, 'css-155za0w.row.px-0.m-0')\n",
    "    rows = infoSquare.find_elements(By.TAG_NAME, 'li')\n",
    "    overview = {}\n",
    "    \n",
    "    # link formatted differently\n",
    "    overview['website'] = rows[0].find_element(By.TAG_NAME, 'a').text \n",
    "    \n",
    "    for info in rows[1:]:\n",
    "        label = info.find_element(By.TAG_NAME, 'label').text \n",
    "        data = info.find_element(By.TAG_NAME, 'div').text \n",
    "        overview[label] = data\n",
    "        \n",
    "    company['Overview Data'] = overview"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "satellite-employment",
   "metadata": {},
   "outputs": [],
   "source": [
    "def collectTopBar(company):\n",
    "    ''' Collect all information on the top bar pane of glassdoor.com\n",
    "    then , enter information into company dict\n",
    "    '''\n",
    "    name =''\n",
    "    topBarData = {}\n",
    "    \n",
    "    infoBar = browser.find_element(By.ID, 'EIProductHeaders')\n",
    "    links = infoBar.find_elements(By.TAG_NAME, 'a')\n",
    "    \n",
    "    # skip first link = overview page\n",
    "    overview = links[0].get_attribute(\"href\")\n",
    "    for data in links[1:]:\n",
    "        link = data.get_attribute(\"href\")\n",
    "        \n",
    "        if 'Reviews' in link:\n",
    "            review = link\n",
    "        \n",
    "        if 'FAQ' in link:\n",
    "            name = 'FAQ'\n",
    "        elif 'Location' in link:\n",
    "            name = 'Location'\n",
    "        elif 'Affiliated' in link:\n",
    "            name = 'Affiliated'\n",
    "        else:\n",
    "            textData = data.find_elements(By.TAG_NAME, 'span')\n",
    "            value = textData[0].text\n",
    "            name = textData[1].text\n",
    "            topBarData['Number of ' +name+ ' Posted'] = value\n",
    "            \n",
    "        topBarData[name + ' Link'] = link\n",
    "        \n",
    "    reviewCase(company, review)\n",
    "\n",
    "    company['Top bar Data'] = topBarData"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "cardiovascular-procurement",
   "metadata": {},
   "outputs": [],
   "source": [
    "def reviewCase(company, link):\n",
    "    ''' Go to the reviews page at link, and collect some simple statistics.\n",
    "    Add this information into company\n",
    "    '''\n",
    "    reviews = {'Star score':'', 'Ceo Approval Rate':'', 'Recommend to Friend Rate':'', 'CEO Name':''}\n",
    "    browser.get(link)\n",
    "    try:\n",
    "        starScore = browser.find_element(By.XPATH, '//*[@id=\"EmpStats\"]/div/div[1]/div/div/div').text\n",
    "\n",
    "        reviews['Star score'] = starScore\n",
    "    except Exception as e:\n",
    "        print(company['name'], ' does not have star score')\n",
    "    try:\n",
    "        ceo = browser.find_element(By.XPATH, '//*[@id=\"EmpStats\"]/div/div[2]/div[3]/div/div[2]/div[1]').text\n",
    "        reviews['CEO Name'] = ceo\n",
    "\n",
    "        ratings = browser.find_elements(By.CLASS_NAME, 'donut__DonutStyle__donutchart_text_val')\n",
    "\n",
    "        recommendToFriend = ratings[0].text\n",
    "        reviews['Recommend to Friend Rate'] = recommendToFriend\n",
    "\n",
    "        approveOfCeo = ratings[1].text\n",
    "        reviews['Ceo Approval Rate'] = approveOfCeo\n",
    "    except Exception as e:\n",
    "        print(company['name'], ' does not have donut values')\n",
    "        \n",
    "    company['Review Section Details'] = reviews"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "tough-chamber",
   "metadata": {},
   "source": [
    "### And now we get the seeds!!!!\n",
    "\n",
    "Some searches seem to tend towards the same result. \n",
    "\n",
    "For example:\n",
    "\n",
    "\"BANK OF NEW YORK MELLON CORP\" on line 76 and \n",
    "\n",
    "\"BNY Mellon Municipal Bond Infrastructure Fund Inc\" on line 1258\n",
    "\n",
    "both go to the same \"BNY Mellon\" page.In this case these both have the same link."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "developed-debate",
   "metadata": {},
   "source": [
    "Created for Mac OS Chrome Ver. 88.0.4324.96\n",
    "chromedriver.exe \n",
    "\n",
    "\n",
    "Downloaded from here:\n",
    "https://chromedriver.storage.googleapis.com/index.html?path=88.0.4324.96/\n",
    "\n",
    "Follow this tutorial to put chromedriver.exe into PATH:\n",
    "https://www.edureka.co/community/52315/how-to-setup-chrome-driver-with-selenium-on-macos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "athletic-gauge",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "redirected to:  Monster Worldwide  when searching:  Monster Worldwide Inc.\n",
      "DPW HOLDINGS INC  does not have donut values\n",
      "redirected to:  Quest Diagnostics  when searching:  Quest Diagnostics Inc\n",
      "redirected to:  Emclaire Financial  when searching:  Emclaire Financial Corp\n",
      "EMCLAIRE FINANCIAL CORP  does not have donut values\n",
      "redirected to:  DXP Enterprises  when searching:  DXP Enterprises Inc\n",
      "redirected to:  Cal-Maine Foods  when searching:  Cal Maine Foods Inc\n",
      "redirected to:  Eltek (Israel)  when searching:  Eltek Ltd\n",
      "ELTEK LTD  does not have donut values\n",
      "redirected to:  Insperity  when searching:  Insperity Inc.\n",
      "redirected to:  Kilroy Realty  when searching:  Kilroy Realty Corp\n",
      "redirected to:  Cerus Corporation  when searching:  Cerus Corp\n",
      "redirected to:  Vericel Corporation  when searching:  Vericel Corp\n",
      "redirected to:  China Eastern Airlines  when searching:  China Eastern Airlines Corp Ltd\n",
      "redirected to:  Vail Resorts  when searching:  Vail Resorts Inc.\n",
      "redirected to:  Epiq  when searching:  EPIQ Systems Inc\n",
      "GOLDEN OCEAN GROUP  does not have donut values\n",
      "redirected to:  Ciena  when searching:  Ciena Corp\n",
      "redirected to:  Silgan  when searching:  Silgan Holdings Inc\n",
      "redirected to:  CarMax  when searching:  CarMax Inc\n",
      "redirected to:  TiVo  when searching:  TiVo Corp\n",
      "redirected to:  Euro Tech  when searching:  Euro Tech Holdings Co Ltd\n",
      "EURO TECH HOLDINGS CO LTD  does not have donut values\n",
      "redirected to:  Cell Therapeutics  when searching:  CTI BioPharma Corp\n",
      "redirected to:  Cell Therapeutics  when searching:  CTI BioPharma\n",
      "redirected to:  Asia Pacific Wire & Cable  when searching:  Asia Pacific Wire & Cable Corp\n",
      "ASIA PACIFIC WIRE&CABLE CORP  does not have donut values\n",
      "redirected to:  Euronet  when searching:  Euronet Worldwide Inc\n",
      "redirected to:  McDermott  when searching:  Chicago Bridge & Iron Co. NV\n",
      "redirected to:  McDermott  when searching:  Chicago Bridge & Iron\n",
      "redirected to:  TD Ameritrade  when searching:  TD AMERITRADE Holding Corp\n",
      "redirected to:  Gulf Island Fabrication  when searching:  Gulf Island Fabrication Inc\n",
      "redirected to:  COPEL  when searching:  Companhia Paranaense De Energia - Copel\n",
      "redirected to:  Take-Two  when searching:  Take-Two Interactive Software Inc\n",
      "redirected to:  BIO-key  when searching:  Bio-Key International Inc\n",
      "redirected to:  Xplore  when searching:  Xplore Technologies Corp\n",
      "redirected to:  Autoliv  when searching:  Autoliv Inc\n",
      "redirected to:  Flagstar Bank  when searching:  Flagstar Bancorp Inc\n",
      "redirected to:  Rambus  when searching:  Rambus Inc\n",
      "redirected to:  Amazon  when searching:  Amazon.com Inc\n",
      "redirected to:  Denison Mines  when searching:  Denison Mines Corp\n",
      "DENISON MINES CORP  does not have donut values\n",
      "redirected to:  G. Willi-Food  when searching:  G. Willi Food International  Ltd\n",
      "G WILLI-FOOD INTL LTD  does not have donut values\n",
      "redirected to:  MER Telemanagement Solutions  when searching:  MER Telemanagement Solutions Ltd\n",
      "redirected to:  Alexandria Real Estate Equities  when searching:  Alexandria Real Estate Equities Inc.\n",
      "redirected to:  Ryanair  when searching:  Ryanair Holdings PLC\n",
      "redirected to:  Qorvo  when searching:  Qorvo Inc\n",
      "redirected to:  Sarepta Therapeutics  when searching:  Sarepta Therapeutics Inc\n",
      "redirected to:  Ralph Lauren  when searching:  Ralph Lauren Corp\n",
      "redirected to:  inTEST  when searching:  inTest Corp\n",
      "redirected to:  Nortel Inversora  when searching:  Nortel Inversora Sa\n",
      "NORTEL INVERSORA SA  does not have donut values\n",
      "redirected to:  Boston Properties  when searching:  Boston Properties Inc\n",
      "redirected to:  Simulations Plus  when searching:  Simulations Plus Inc\n",
      "SIMULATIONS PLUS INC  does not have donut values\n",
      "redirected to:  Pacific Premier  when searching:  Pacific Premier Bancorp Inc\n",
      "redirected to:  Comfort Systems USA  when searching:  Comfort Systems USA Inc.\n",
      "redirected to:  Helix Energy Solutions  when searching:  Helix Energy Solutions Group Inc\n",
      "redirected to:  Archrock  when searching:  Archrock Inc\n",
      "redirected to:  Heska  when searching:  Heska Corp\n",
      "redirected to:  8x8  when searching:  8x8 Inc\n",
      "redirected to:  Meritor  when searching:  Meritor Inc\n",
      "redirected to:  1800PetMeds  when searching:  PetMed Express Inc\n",
      "redirected to:  1800PetMeds  when searching:  PetMed Express\n",
      "redirected to:  Yum!  when searching:  YUM! Brands Inc.\n",
      "redirected to:  FARO Technologies  when searching:  FARO Technologies\n",
      "redirected to:  Stewardship Financial  when searching:  Stewardship Financial Corp\n",
      "redirected to:  RADCOM  when searching:  Radcom Ltd\n",
      "redirected to:  1st Constitution  when searching:  1st Constitution Bancorp\n",
      "redirected to:  Pacific Continental  when searching:  Pacific Continental Corp\n",
      "redirected to:  Net 1 UEPS  when searching:  Net 1 Ueps Technologies Inc\n",
      "redirected to:  Camden National  when searching:  Camden National Corp\n",
      "redirected to:  Identiv  when searching:  Identiv Inc\n",
      "redirected to:  Annaly Capital Management  when searching:  Annaly Capital Management Inc\n",
      "NATIONAL RESEARCH CORP  does not have donut values\n",
      "redirected to:  Ritchie Bros.  when searching:  Ritchie Bros Auctioneers Inc\n",
      "redirected to:  OSI Systems  when searching:  OSI Systems Inc\n",
      "redirected to:  C.H. Robinson  when searching:  C.H. Robinson Worldwide Inc.\n",
      "redirected to:  Middleburg Financial  when searching:  Middleburg Financial Corp\n",
      "redirected to:  Choice Hotels  when searching:  Choice Hotels International Inc.\n",
      "redirected to:  Centerspace  when searching:  Investors Real Estate Trust\n",
      "redirected to:  Fairchild Semiconductor  when searching:  Fairchild Semiconductor International Inc.\n",
      "redirected to:  China Mobile  when searching:  China Mobile Ltd\n",
      "redirected to:  Dril-Quip  when searching:  Dril-Quip Inc.\n",
      "redirected to:  CUI Global  when searching:  CUI Global Inc\n",
      "redirected to:  Carolina Bank  when searching:  Carolina Bank Holdings Inc\n",
      "redirected to:  Ladenburg Thalmann  when searching:  Ladenburg Thalmann Financial Services Inc.\n",
      "redirected to:  Group 1 Automotive  when searching:  Group 1 Automotive Inc.\n",
      "redirected to:  Capital Senior Living  when searching:  Capital Senior Living Corp\n",
      "redirected to:  CTI Industries  when searching:  CTI Industries Corp\n",
      "CTI INDUSTRIES CORP  does not have donut values\n",
      "redirected to:  Mettler-Toledo  when searching:  Mettler-Toledo International Inc\n",
      "redirected to:  MidWestOne Bank  when searching:  MidWestOne Financial Group Inc\n",
      "redirected to:  MidWestOne Bank  when searching:  MidWestOne Financial\n",
      "redirected to:  Charles & Colvard  when searching:  Charles & Colvard Ltd\n",
      "CHARLES & COLVARD LTD  does not have donut values\n",
      "redirected to:  Progenics Pharmaceuticals  when searching:  Progenics Pharmaceuticals Inc\n",
      "redirected to:  SB One Bank  when searching:  SB One Bancorp\n",
      "SB ONE BANCORP  does not have donut values\n",
      "redirected to:  GeoSpace Technologies  when searching:  Geospace Technologies Corp\n",
      "redirected to:  RealNetworks  when searching:  RealNetworks Inc\n",
      "redirected to:  MACOM  when searching:  Applied Micro Circuits Corp\n",
      "redirected to:  MACOM  when searching:  Applied Micro Circuits\n",
      "redirected to:  BASi  when searching:  Bioanalytical Systems Inc\n",
      "redirected to:  Apex Silver Mines  when searching:  Golden Minerals Co\n",
      "redirected to:  Apex Silver Mines  when searching:  Golden Minerals\n",
      "redirected to:  Assertio  when searching:  Assertio Therapeutics Inc\n",
      "ASSERTIO THERAPEUTICS INC  does not have donut values\n",
      "redirected to:  C&F Financial  when searching:  C&F Financial Corp\n",
      "redirected to:  Envision Healthcare  when searching:  Envision Healthcare Corp\n",
      "redirected to:  Ingredion  when searching:  Ingredion Inc\n",
      "redirected to:  Power Integrations  when searching:  Power Integrations Inc\n",
      "redirected to:  Arlington Asset Investment  when searching:  Arlington Asset Investment Corp\n",
      "redirected to:  Sonabank  when searching:  Eastern Virginia Bankshares Inc\n",
      "redirected to:  Norwood Financial  when searching:  Norwood Financial Corp.\n",
      "NORWOOD FINANCIAL CORP  does not have donut values\n",
      "redirected to:  Oak Valley Community Bank  when searching:  Oak Valley Bancorp\n",
      "redirected to:  Old Line Bancshares  when searching:  Old Line Bancshares Inc\n",
      "redirected to:  LCNB  when searching:  LCNB Corp\n",
      "redirected to:  Bank Of Hope  when searching:  Hope Bancorp Inc\n",
      "LIVE VENTURES INC  does not have donut values\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "redirected to:  NICE inContact  when searching:  inContact Inc\n",
      "redirected to:  Heritage Financial (MD)  when searching:  Heritage Financial Corp\n",
      "HERITAGE FINANCIAL CORP  does not have donut values\n",
      "redirected to:  Timberland Bancorp  when searching:  Timberland Bancorp Inc\n",
      "redirected to:  Mid Penn Bancorp  when searching:  Mid Penn Bancorp Inc\n",
      "redirected to:  Steelcase  when searching:  Steelcase Inc.\n",
      "redirected to:  AeroCentury  when searching:  AeroCentury Corp\n",
      "AEROCENTURY CORP  does not have donut values\n",
      "redirected to:  Old Point Financial  when searching:  Old Point Financial Corp\n",
      "redirected to:  Descartes Systems  when searching:  Descartes Systems Group Inc (The)\n",
      "redirected to:  W. P. Carey  when searching:  W. P. Carey Inc\n",
      "redirected to:  First National  when searching:  First National Corp\n",
      "FIRST NATIONAL CORP  does not have donut values\n",
      "redirected to:  Rockwell Medical  when searching:  Rockwell Medical Inc\n",
      "redirected to:  Verisign  when searching:  Verisign Inc\n",
      "redirected to:  IES Holdings (TX)  when searching:  IES Holdings Inc\n",
      "IES HOLDINGS INC  does not have donut values\n",
      "redirected to:  Correvio  when searching:  Correvio Pharma Corp\n",
      "redirected to:  Penseco Financial Services  when searching:  Penseco Financial Services Corp\n",
      "PEOPLES FINANCIAL SERVICES  does not have donut values\n",
      "redirected to:  Quanta Services  when searching:  Quanta Services Inc.\n",
      "redirected to:  Nutraceutical  when searching:  Nutraceutical International Corp\n",
      "redirected to:  Colony Bankcorp  when searching:  Colony Bankcorp Inc\n",
      "redirected to:  Connection  when searching:  PC Connection Inc\n",
      "redirected to:  SurModics  when searching:  Surmodics Inc\n",
      "FIRST US BANCSHARES INC  does not have donut values\n",
      "redirected to:  CompX International  when searching:  CompX International Inc.\n",
      "redirected to:  Anworth Mortgage Asset  when searching:  Anworth Mortgage Asset Corp\n",
      "redirected to:  OneSpan  when searching:  OneSpan Inc\n",
      "redirected to:  Inovio Biomedical  when searching:  Inovio Pharmaceuticals Inc\n",
      "redirected to:  Federated Investors  when searching:  Federated Investors Inc.\n",
      "redirected to:  Turning Point Brands  when searching:  Turning Point Brands Inc\n",
      "TURNING POINT BRANDS INC  does not have donut values\n",
      "redirected to:  RELX  when searching:  RELX NV\n",
      "redirected to:  RELX  when searching:  RELX PLC\n",
      "redirected to:  Sasol  when searching:  Sasol Ltd\n",
      "redirected to:  James Hardie  when searching:  James Hardie Industries Plc\n",
      "redirected to:  Pearson  when searching:  Pearson PLC\n",
      "redirected to:  Nielsen  when searching:  Nielsen Holdings plc\n",
      "redirected to:  Sanofi  when searching:  Sanofi\n",
      "redirected to:  Novartis  when searching:  Novartis AG\n",
      "redirected to:  Smith & Nephew  when searching:  Smith & Nephew PLC\n",
      "redirected to:  Harmony Gold  when searching:  Harmony Gold Mining Co Ltd\n",
      "redirected to:  SAP  when searching:  SAP SE\n",
      "redirected to:  Norwegian Cruise Line  when searching:  Norwegian Cruise Line Holdings Ltd\n",
      "redirected to:  CEMEX  when searching:  Cemex SAB de CV\n",
      "redirected to:  American Tower  when searching:  American Tower Corp\n",
      "redirected to:  Paysign  when searching:  Paysign Inc\n",
      "PAYSIGN INC  does not have donut values\n",
      "SIERRA BANCORP  does not have donut values\n",
      "redirected to:  Kirkland Lake Gold  when searching:  Kirkland Lake Gold Ltd\n",
      "redirected to:  Brookline Bancorp  when searching:  Brookline Bancorp Inc\n",
      "redirected to:  Columbia Sportswear  when searching:  Columbia Sportswear Co\n",
      "redirected to:  New Gold  when searching:  New Gold Inc\n",
      "redirected to:  Applied DNA Sciences  when searching:  Applied DNA Sciences Inc\n",
      "redirected to:  Fauquier Bankshares  when searching:  Fauquier Bankshares Inc\n",
      "FAUQUIER BANKSHARES INC  does not have donut values\n",
      "redirected to:  PolyMet Mining  when searching:  PolyMet Mining Corp\n",
      "POLYMET MINING CORP  does not have donut values\n",
      "redirected to:  HopFed Bancorp  when searching:  HopFed Bancorp Inc\n",
      "HOPFED BANCORP INC  does not have donut values\n",
      "redirected to:  HudBay Minerals  when searching:  Hudbay Minerals Inc\n",
      "redirected to:  Peapack-Gladstone Bank  when searching:  Peapack-Gladstone Financial Corp\n",
      "redirected to:  Peapack-Gladstone Bank  when searching:  Peapack-Gladstone Financial\n",
      "redirected to:  Marker Therapeutics  when searching:  Marker Therapeutics Inc\n",
      "MARKER THERAPEUTICS INC  does not have donut values\n",
      "redirected to:  Silvercorp Metals  when searching:  Silvercorp Metals Inc\n",
      "SILVERCORP METALS INC  does not have donut values\n",
      "redirected to:  Pareteum  when searching:  Pareteum Corp\n",
      "redirected to:  Ultra Petroleum  when searching:  Ultra Petroleum Corp.\n",
      "redirected to:  United Bancshares  when searching:  United Bancshares Inc\n",
      "UNITED BANCSHARES INC  does not have donut values\n",
      "redirected to:  First Majestic Silver  when searching:  First Majestic Silver Corp\n",
      "redirected to:  Westport Fuel Systems  when searching:  Westport Fuel Systems Inc\n",
      "WESTPORT FUEL SYSTEMS INC  does not have donut values\n",
      "redirected to:  Omega Protein  when searching:  Omega Protein Corp\n",
      "redirected to:  Arm  when searching:  Arm Holdings PLC\n",
      "redirected to:  Heritage Commerce  when searching:  Heritage Commerce Corp\n",
      "HERITAGE COMMERCE CORP  does not have donut values\n",
      "redirected to:  First Niagara Financial  when searching:  First Niagara Financial Group Inc\n",
      "redirected to:  BNC Bancorp  when searching:  BNC Bancorp\n",
      "redirected to:  Manhattan Associates  when searching:  Manhattan Associates Inc\n",
      "redirected to:  LaSalle Hotel Properties  when searching:  LaSalle Hotel Properties\n",
      "redirected to:  Amkor  when searching:  Amkor Technology Inc\n",
      "redirected to:  Infinity Property & Casualty  when searching:  Infinity Property and Casualty Corp\n",
      "redirected to:  Southcoast Financial  when searching:  Southcoast Financial Corp\n",
      "SOUTHCOAST FINANCIAL CORP  does not have donut values\n",
      "redirected to:  Evolving Systems  when searching:  Evolving Systems Inc\n",
      "redirected to:  Innospec  when searching:  Innospec Inc\n",
      "redirected to:  ICON  when searching:  Icon PLC\n",
      "redirected to:  Interpace Dignostics  when searching:  Interpace Diagnostics Group Inc\n",
      "redirected to:  Interpace Dignostics  when searching:  Interpace Diagnostics\n",
      "redirected to:  Waste Connections  when searching:  Waste Connections Inc.\n",
      "redirected to:  AXT  when searching:  AXT Inc\n",
      "AXT INC  does not have donut values\n",
      "redirected to:  Avalon Holdings  when searching:  Avalon Holdings Corp\n",
      "AVALON HOLDINGS CORP  does not have donut values\n",
      "NEFF CORP  does not have donut values\n",
      "redirected to:  The Hackett Group  when searching:  Hackett Group Inc (The)\n",
      "redirected to:  MarineMax  when searching:  MarineMax Inc\n",
      "redirected to:  Hawthorn Bancshares  when searching:  Hawthorn Bancshares Inc\n",
      "redirected to:  Gildan Activewear  when searching:  Gildan Activewear Inc\n",
      "redirected to:  MicroStrategy  when searching:  MicroStrategy Inc\n",
      "redirected to:  Union Bank (Vermont)  when searching:  Union Bankshares Inc\n",
      "UNION BANKSHARES INC  does not have donut values\n",
      "redirected to:  CoBiz Financial  when searching:  CoBiz Financial Inc\n",
      "redirected to:  Orrstown Bank  when searching:  Orrstown Financial Services Inc\n",
      "redirected to:  Orrstown Bank  when searching:  Orrstown Financial Services\n",
      "redirected to:  Cognizant Technology Solutions  when searching:  Cognizant Technology Solutions Corp\n",
      "redirected to:  Amdocs  when searching:  Amdocs Ltd\n",
      "FIRST BANCORP INC  does not have donut values\n",
      "redirected to:  Gerdau  when searching:  Gerdau SA\n",
      "redirected to:  GenVec  when searching:  GenVec Inc\n",
      "redirected to:  CUMULUS MEDIA  when searching:  Cumulus Media Inc\n",
      "redirected to:  LMI Aerospace  when searching:  LMI Aerospace Inc\n",
      "redirected to:  CoStar Group  when searching:  CoStar Group Inc\n",
      "redirected to:  Bank of Commerce  when searching:  Bank of Commerce Holdings\n",
      "redirected to:  Celestica  when searching:  Celestica Inc\n",
      "redirected to:  Centrus Energy  when searching:  Centrus Energy Corp\n",
      "redirected to:  Sharps Compliance  when searching:  Sharps Compliance Corp\n",
      "redirected to:  Mannatech  when searching:  Mannatech Inc\n",
      "redirected to:  Salisbury Bancorp  when searching:  Salisbury Bancorp Inc\n",
      "redirected to:  Convergys  when searching:  Convergys Corp\n",
      "redirected to:  Crown Castle  when searching:  Crown Castle International Corp\n",
      "redirected to:  First National Community Bancorp  when searching:  FNCB\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "redirected to:  Cemtrex  when searching:  Cemtrex Inc\n",
      "redirected to:  IXYS  when searching:  IXYS Corp\n",
      "redirected to:  RiceBran Technologies  when searching:  RiceBran Technologies\n",
      "RICEBRAN TECHNOLOGIES  does not have donut values\n",
      "redirected to:  eBay  when searching:  eBay Inc.\n",
      "redirected to:  Goldman Sachs  when searching:  Goldman Sachs Group Inc (The)\n",
      "redirected to:  eMagin  when searching:  eMagin Corp\n",
      "EMAGIN CORP  does not have donut values\n",
      "redirected to:  Mackinac Financial  when searching:  MacKinac Financial Corp\n",
      "redirected to:  Xenith Bankshares  when searching:  Xenith Bankshares Inc\n",
      "redirected to:  Algonquin Power & Utilities  when searching:  Algonquin Power & Utilities Corp\n",
      "redirected to:  WebMD Health  when searching:  Webmd Health Corp\n",
      "redirected to:  Eaton Vance  when searching:  Eaton Vance Senior Income\n",
      "redirected to:  American Outdoor Brands  when searching:  American Outdoor Brands Corp\n",
      "redirected to:  FedNat  when searching:  FedNat Holding Co\n",
      "NETWORK-1 TECHNOLOGIES INC  does not have donut values\n",
      "redirected to:  NVIDIA  when searching:  NVIDIA Corp\n",
      "NVIDIA CORP  does not have donut values\n",
      "redirected to:  American Axle & Manufacturing  when searching:  American Axle & Manufacturing Holdings Inc\n",
      "CITIZENS FIRST CORP  does not have donut values\n",
      "redirected to:  East West Bank  when searching:  East West Bancorp Inc\n",
      "redirected to:  AMRI  when searching:  Albany Molecular Research Inc\n",
      "redirected to:  Aptiv  when searching:  Aptiv Plc\n",
      "redirected to:  Bottomline Technologies  when searching:  Bottomline Technologies Inc\n",
      "redirected to:  GAMCO Investors  when searching:  Gamco Investors Inc\n",
      "redirected to:  Korn Ferry  when searching:  Korn Ferry\n",
      "CEB INC  does not have donut values\n",
      "redirected to:  AutoWeb (formerly Autobytel)  when searching:  AutoWeb Inc\n",
      "redirected to:  MKS Instruments  when searching:  MKS Instruments Inc\n",
      "redirected to:  Booking Holdings  when searching:  Booking Holdings Inc\n",
      "redirected to:  Trex Company  when searching:  Trex Co Inc\n",
      "redirected to:  Capitol Federal® Savings Bank  when searching:  Capitol Federal Financial Inc\n",
      "redirected to:  Capitol Federal® Savings Bank  when searching:  Capitol Federal Financial\n",
      "redirected to:  Optibase  when searching:  Optibase Ltd\n",
      "OPTIBASE LTD  does not have donut values\n",
      "redirected to:  Extreme Networks  when searching:  Extreme Networks Inc\n",
      "redirected to:  Atlanticus Holdings  when searching:  Atlanticus Holdings Corp\n",
      "ATLANTICUS HOLDINGS CORP  does not have donut values\n",
      "redirected to:  Heidrick & Struggles  when searching:  Heidrick & Struggles International Inc\n",
      "redirected to:  CNX Resources  when searching:  CNX Resources Corp\n",
      "redirected to:  LifePoint Health  when searching:  LifePoint Health Inc\n",
      "redirected to:  TowneBank  when searching:  Townebank\n",
      "redirected to:  Sierra Wireless  when searching:  Sierra Wireless Inc\n",
      "redirected to:  TheStreet  when searching:  TheStreet Inc\n",
      "redirected to:  Manhattan Bridge Capital  when searching:  Manhattan Bridge Capital\n",
      "MANHATTAN BRIDGE CAPITAL INC  does not have donut values\n",
      "redirected to:  Bankrate  when searching:  Bankrate Inc\n",
      "redirected to:  TC PipeLines  when searching:  TC PipeLines LP\n",
      "TC PIPELINES LP  does not have donut values\n",
      "redirected to:  U.S. Concrete  when searching:  US Concrete Inc\n",
      "redirected to:  AudioCodes  when searching:  Audiocodes Ltd\n",
      "redirected to:  Reynolds American  when searching:  Reynolds American Inc\n",
      "redirected to:  F5  when searching:  F5 Networks Inc\n",
      "redirected to:  Skechers U.S.A.  when searching:  Skechers U.S.A. Inc\n",
      "redirected to:  Pacific Mercantile Bank  when searching:  Pacific Mercantile Bancorp\n",
      "PACIFIC MERCANTILE BANCORP  does not have donut values\n",
      "redirected to:  United Therapeutics  when searching:  United Therapeutics Corp\n",
      "redirected to:  The Meet Group  when searching:  Meet Group Inc (The)\n",
      "redirected to:  Stamps.com  when searching:  Stamps.com Inc\n",
      "redirected to:  Financial Institutions  when searching:  Financial Institutions\n",
      "redirected to:  Juniper Networks  when searching:  Juniper Networks Inc\n",
      "redirected to:  I.D. Systems  when searching:  I.D. Systems Inc\n",
      "redirected to:  CYREN  when searching:  CYREN Ltd\n",
      "redirected to:  Encore Capital Group  when searching:  Encore Capital Group Inc\n",
      "redirected to:  The PrivateBank  when searching:  PrivateBancorp Inc\n",
      "redirected to:  The PrivateBank  when searching:  PrivateBancorp\n",
      "redirected to:  Salem Media Group  when searching:  Salem Media Group Inc\n",
      "redirected to:  j2 Global  when searching:  j2 Global Inc\n",
      "redirected to:  Hooker Furniture  when searching:  Hooker Furniture Corp\n",
      "redirected to:  General Moly  when searching:  General Moly Inc\n",
      "redirected to:  BioMarin Pharmaceutical  when searching:  Biomarin Pharmaceutical Inc\n",
      "redirected to:  Lennox  when searching:  Lennox International Inc.\n",
      "redirected to:  Perficient  when searching:  Perficient Inc\n",
      "redirected to:  1-800-Flowers.com  when searching:  1-800-FLOWERS.COM Inc\n",
      "redirected to:  Points International  when searching:  Points International Ltd\n",
      "redirected to:  Red Hat  when searching:  Red Hat Inc\n",
      "redirected to:  Internet Gold  when searching:  Internet Gold-Golden Lines Ltd\n",
      "INTERNET GOLD-GOLDEN LINES  does not have donut values\n",
      "redirected to:  NETSCOUT  when searching:  NetScout Systems Inc\n",
      "redirected to:  PolarityTE  when searching:  PolarityTE Inc\n",
      "redirected to:  Lionbridge  when searching:  Lionbridge Technologies Inc\n",
      "redirected to:  Alamos Gold  when searching:  Alamos Gold Inc\n",
      "redirected to:  eGain  when searching:  eGain Corp\n",
      "redirected to:  Senior Housing Properties  when searching:  Senior Housing Properties Trust\n",
      "SENIOR HOUSING PPTYS TRUST  does not have donut values\n",
      "redirected to:  United Online  when searching:  United Online Inc\n",
      "redirected to:  OMNOVA Solutions  when searching:  OMNOVA Solutions Inc.\n",
      "redirected to:  Internap Corporation  when searching:  Internap Corp\n",
      "redirected to:  Ultrapar  when searching:  Ultrapar Participacoes SA\n",
      "redirected to:  CIRCOR International  when searching:  CIRCOR International Inc\n",
      "redirected to:  Vascular Solutions  when searching:  Vascular Solutions Inc\n",
      "redirected to:  PCTEL  when searching:  PCTEL Inc\n",
      "redirected to:  Radware  when searching:  Radware Ltd\n",
      "redirected to:  Citizens Holding  when searching:  Citizens Holding Co\n",
      "CITIZENS HOLDING CO  does not have donut values\n",
      "redirected to:  WWE  when searching:  World Wrestling Entertainment Inc.\n",
      "redirected to:  Bsquare  when searching:  BSQUARE Corp\n",
      "redirected to:  Opexa  when searching:  Opexa Therapeutics Inc\n",
      "redirected to:  Akamai  when searching:  Akamai Technologies Inc\n",
      "redirected to:  Plug Power  when searching:  Plug Power Inc\n",
      "redirected to:  NeoGenomics  when searching:  Neogenomics Inc\n",
      "redirected to:  Collectors Universe  when searching:  Collectors Universe Inc\n",
      "redirected to:  Flexible Solutions  when searching:  Flexible Solutions International\n",
      "FLEXIBLE SOLUTIONS INTL INC  does not have donut values\n",
      "redirected to:  Intellicheck  when searching:  Intellicheck Inc\n",
      "redirected to:  Kratos Defense & Security Solutions  when searching:  Kratos Defense & Security Solutions Inc\n",
      "redirected to:  Expedia Group  when searching:  Expedia Group Inc\n",
      "redirected to:  Finisar  when searching:  Finisar Corp\n",
      "redirected to:  Rudolph Technologies  when searching:  Rudolph Technologies Inc.\n",
      "redirected to:  Agilent Technologies  when searching:  Agilent Technologies Inc\n",
      "redirected to:  Upside Software  when searching:  SciQuest Inc\n",
      "redirected to:  Upside Software  when searching:  SciQuest\n",
      "redirected to:  PFSweb  when searching:  PFSweb Inc\n",
      "redirected to:  Teledyne Technologies  when searching:  Teledyne Technologies Inc.\n",
      "redirected to:  BGC Partners  when searching:  BGC Partners Inc\n",
      "redirected to:  WPCS International  when searching:  Wpcs International Inc\n",
      "redirected to:  MutualBank  when searching:  MutualFirst Financial Inc\n",
      "redirected to:  MutualBank  when searching:  MutualFirst Financial\n",
      "redirected to:  PCA  when searching:  Packaging Corp Of America\n",
      "redirected to:  PCA  when searching:  Packaging Corp Of America\n",
      "redirected to:  Zynex Medical  when searching:  Zynex Inc\n",
      "redirected to:  Beasley Broadcast Group  when searching:  Beasley Broadcast Group Inc\n",
      "redirected to:  Mattersight  when searching:  Mattersight Corp\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "redirected to:  GigaMedia  when searching:  GigaMedia Ltd\n",
      "GIGAMEDIA LTD  does not have donut values\n",
      "AMERICAS SILVER CORP  does not have donut values\n",
      "redirected to:  Onvia  when searching:  Onvia Inc\n",
      "redirected to:  UTStarcom  when searching:  Utstarcom Holdings Corp\n",
      "redirected to:  Silicon Labs  when searching:  Silicon Laboratories Inc\n",
      "redirected to:  Silicon Labs  when searching:  Silicon Laboratories\n",
      "redirected to:  Edwards Lifesciences  when searching:  Edwards Lifesciences Corp\n",
      "redirected to:  Edgewell Personal Care  when searching:  Edgewell Personal Care Co\n",
      "redirected to:  Rigel Pharmaceuticals  when searching:  Rigel Pharmaceuticals Inc\n",
      "redirected to:  Global Sources  when searching:  Global Sources Ltd\n",
      "redirected to:  Camtek  when searching:  Camtek Ltd\n",
      "redirected to:  CMC Materials  when searching:  Cabot Microelectronics Corp\n",
      "redirected to:  CMC Materials  when searching:  Cabot Microelectronics\n",
      "redirected to:  HealthStream  when searching:  HealthStream Inc\n",
      "redirected to:  Krispy Kreme  when searching:  Krispy Kreme Doughnuts Inc.\n",
      "redirected to:  MetLife  when searching:  Metlife Inc.\n",
      "redirected to:  Lexicon Pharmaceuticals  when searching:  Lexicon Pharmaceuticals Inc\n",
      "redirected to:  LivePerson  when searching:  LivePerson Inc\n",
      "redirected to:  PetroChina  when searching:  Petrochina Co Ltd\n",
      "redirected to:  Sangamo Therapeutics  when searching:  Sangamo Therapeutics Inc\n",
      "redirected to:  Exelixis  when searching:  Exelixis Inc\n",
      "redirected to:  Nova Measuring  when searching:  Nova Measuring Instruments Ltd\n",
      "redirected to:  Oclaro  when searching:  Oclaro Inc\n",
      "redirected to:  Qualstar  when searching:  Qualstar Corp\n",
      "redirected to:  Crown Media  when searching:  Crown Media Holdings Inc\n",
      "redirected to:  ON Semiconductor  when searching:  ON Semiconductor Corp\n",
      "redirected to:  Pixelworks  when searching:  Pixelworks Inc\n",
      "redirected to:  Two River Community Bank  when searching:  Two River Bancorp\n",
      "redirected to:  CEVA  when searching:  Ceva Inc\n",
      "redirected to:  Innovative Solutions & Support  when searching:  Innovative Solutions and Support Inc\n",
      "redirected to:  Innovative Solutions & Support  when searching:  Innovative Solutions and Support\n",
      "redirected to:  NRG Energy  when searching:  NRG Energy Inc\n",
      "redirected to:  Insmed  when searching:  Insmed Inc\n",
      "redirected to:  PacWest Bancorp  when searching:  PacWest Bancorp\n",
      "redirected to:  Visteon  when searching:  Visteon Corp.\n",
      "redirected to:  Brookfield Renewable  when searching:  Brookfield Renewable Partners LP\n",
      "redirected to:  Intuitive (Intuitive Surgical)  when searching:  Intuitive Surgical Inc\n",
      "INTUITIVE SURGICAL INC  does not have donut values\n",
      "redirected to:  Cepheid  when searching:  Cepheid Inc\n",
      "redirected to:  Bank of the James  when searching:  Bank of the James Financial Group Inc\n",
      "redirected to:  Basic Energy Services  when searching:  Basic Energy Services Inc\n",
      "redirected to:  China Unicom  when searching:  China Unicom (Hong Kong) Ltd\n",
      "redirected to:  Charles River Laboratories  when searching:  Charles River Laboratories International Inc\n",
      "redirected to:  MVC Capital  when searching:  MVC Capital Inc\n",
      "MVC CAPITAL INC  does not have donut values\n",
      "redirected to:  Janus Capital  when searching:  Janus Capital Group Inc\n",
      "redirected to:  Marvell Semiconductor  when searching:  Marvell Technology Group Ltd\n",
      "MARVELL TECHNOLOGY GROUP LTD  does not have donut values\n",
      "redirected to:  Berkshire Bank  when searching:  Berkshire Hills Bancorp Inc\n",
      "BERKSHIRE HILLS BANCORP INC  does not have donut values\n",
      "redirected to:  Shanxi YIDA Special Steel Group  when searching:  China Yida Holding Co\n",
      "redirected to:  Shanxi YIDA Special Steel Group  when searching:  China Yida\n",
      "redirected to:  Capstone Turbine  when searching:  Capstone Turbine Corp\n",
      "redirected to:  EXFO  when searching:  EXFO Inc\n",
      "redirected to:  Delta Apparel  when searching:  Delta Apparel Inc\n",
      "redirected to:  NetEase.com  when searching:  Netease Inc\n",
      "redirected to:  Entegris  when searching:  Entegris Inc\n",
      "redirected to:  Maxar Technologies  when searching:  Maxar Technologies Inc\n",
      "redirected to:  SMTC  when searching:  SMTC Corp\n",
      "redirected to:  Arena Pharmaceuticals  when searching:  Arena Pharmaceuticals Inc\n",
      "redirected to:  Keryx Biopharmaceuticals  when searching:  Keryx Biopharmaceuticals Inc\n",
      "redirected to:  Illumina  when searching:  Illumina Inc\n",
      "ILLUMINA INC  does not have donut values\n",
      "redirected to:  Curis  when searching:  Curis Inc\n",
      "CURIS INC  does not have donut values\n",
      "redirected to:  Lantronix  when searching:  Lantronix Inc\n",
      "redirected to:  Bruker  when searching:  Bruker Corp\n",
      "redirected to:  Ceragon Networks  when searching:  Ceragon Networks Ltd\n",
      "redirected to:  MIND CTI  when searching:  Mind Cti Ltd\n",
      "redirected to:  The Medicines Company  when searching:  Medicines Co (The)\n",
      "redirected to:  RTI Surgical  when searching:  RTI Surgical Holdings Inc\n",
      "redirected to:  Equinix  when searching:  Equinix Inc\n",
      "redirected to:  Compugen (isreal)  when searching:  Compugen Ltd\n",
      "BELMOND LTD  does not have donut values\n",
      "redirected to:  O2Micro  when searching:  O2Micro International Ltd\n",
      "redirected to:  Pinnacle Financial Partners  when searching:  Pinnacle Financial Partners Inc\n",
      "redirected to:  180 Degree Capital  when searching:  180 Degree Capital Corp\n",
      "180 DEGREE CPTL CORP  does not have donut values\n",
      "redirected to:  Middlefield Banc  when searching:  Middlefield Banc Corp\n",
      "redirected to:  TTM Technologies  when searching:  TTM Technologies Inc\n",
      "redirected to:  DURECT  when searching:  Durect Corp\n",
      "redirected to:  Asur  when searching:  Grupo Aeroportuario del Sureste SAB de CV\n",
      "redirected to:  Asur  when searching:  Grupo Aeroportuario del Sureste SAB de\n",
      "redirected to:  Integer  when searching:  Integer Holdings Corp\n",
      "redirected to:  Banro  when searching:  Banro Corp\n",
      "redirected to:  Select Bank  when searching:  Select Bancorp Inc\n",
      "redirected to:  Sinopec  when searching:  China Petroleum & Chemical Corp Sinopec\n",
      "MONSANTO CO  does not have donut values\n",
      "redirected to:  Carnival  when searching:  Carnival PLC\n",
      "redirected to:  NII Holdings  when searching:  NII Holdings Inc\n",
      "redirected to:  Hydrogenics  when searching:  Hydrogenics Corp\n",
      "redirected to:  Village Bank & Trust  when searching:  Village Bank and Trust Financial Corp\n",
      "redirected to:  Village Bank & Trust  when searching:  Village Bank and Trust Financial\n",
      "redirected to:  DZS Inc.  when searching:  Zhone Technologies Inc.\n",
      "redirected to:  DZS Inc.  when searching:  Zhone Technologies\n",
      "redirected to:  Mutual Bank  when searching:  Bank Mutual Corp\n",
      "redirected to:  Mutual Bank  when searching:  Bank Mutual\n",
      "redirected to:  TriNet  when searching:  Trinet Group Inc\n",
      "redirected to:  IRSA Propiedades Comerciales  when searching:  IRSA Propiedades Comerciales SA\n",
      "IRSA PROPIEDADES COMERCIALES  does not have donut values\n",
      "redirected to:  Inseego  when searching:  Inseego Corp\n",
      "redirected to:  Alliance Fiber Optic Products  when searching:  Alliance Fiber Optic Products Inc\n",
      "redirected to:  Exact Sciences  when searching:  EXACT Sciences Corp\n",
      "redirected to:  MoSys  when searching:  MoSys Inc\n",
      "MOSYS INC  does not have donut values\n",
      "redirected to:  NuStar Energy  when searching:  NuStar Energy LP\n",
      "redirected to:  FormFactor  when searching:  Cascade Microtech Inc\n",
      "redirected to:  FormFactor  when searching:  Cascade Microtech\n",
      "redirected to:  Garmin  when searching:  Garmin Ltd\n",
      "redirected to:  Seagen  when searching:  Seattle Genetics Inc\n",
      "redirected to:  Seagen  when searching:  Seattle Genetics\n",
      "redirected to:  Euronav N.V.  when searching:  Gener8 Maritime Inc\n",
      "redirected to:  Euronav N.V.  when searching:  Gener8 Maritime\n",
      "redirected to:  Harvard Bioscience  when searching:  Harvard Bioscience Inc\n",
      "redirected to:  Dynavax Technologies  when searching:  Dynavax Technologies Corp\n",
      "redirected to:  Acadia Pharmaceuticals  when searching:  Acadia Pharmaceuticals Inc\n",
      "redirected to:  Global Payments  when searching:  Global Payments Inc.\n",
      "redirected to:  CenterState Banks  when searching:  CenterState Bank Corp\n",
      "redirected to:  Magellan Midstream  when searching:  Magellan Midstream Partners LP\n",
      "redirected to:  Oil States International  when searching:  Oil States International Inc.\n",
      "redirected to:  ProShares  when searching:  iShares Nasdaq Biotechnology\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "redirected to:  Northern Oil and Gas  when searching:  Northern Oil and Gas Inc\n",
      "NORTHERN OIL & GAS INC  does not have donut values\n",
      "redirected to:  TransAtlantic Petroleum  when searching:  TransAtlantic Petroleum Ltd\n",
      "redirected to:  Peabody  when searching:  Peabody Energy Corp\n",
      "redirected to:  CNOOC  when searching:  Cnooc Ltd\n",
      "MARINE PRODUCTS CORP  does not have donut values\n",
      "redirected to:  PGMC  when searching:  Platinum Group Metals Ltd\n",
      "redirected to:  PGMC  when searching:  Platinum Group Metals\n",
      "redirected to:  Senomyx  when searching:  Senomyx Inc\n",
      "redirected to:  Synaptics  when searching:  Synaptics Inc\n",
      "redirected to:  Omnicell  when searching:  Omnicell Inc\n",
      "redirected to:  Shore United Bank  when searching:  Shore Bancshares Inc\n",
      "redirected to:  Prudential  when searching:  Prudential Financial Inc\n",
      "redirected to:  Accenture  when searching:  Accenture PLC\n",
      "redirected to:  Wright Medical  when searching:  Wright Medical Group NV\n",
      "redirected to:  Retractable Technologies  when searching:  Retractable Technologies Inc\n",
      "redirected to:  Neovasc  when searching:  Neovasc Inc\n",
      "NEOVASC INC  does not have donut values\n",
      "redirected to:  Axon  when searching:  Axon Enterprise Inc\n",
      "redirected to:  Alliance Data  when searching:  Alliance Data Systems Corp\n",
      "redirected to:  Willis Towers Watson  when searching:  Willis Towers Watson plc\n",
      "redirected to:  Rockwell Collins  when searching:  Rockwell Collins Inc\n",
      "redirected to:  MAN  when searching:  MVB Financial Corp\n",
      "redirected to:  MAN  when searching:  MVB Financial\n",
      "redirected to:  Asanko Gold  when searching:  Asanko Gold Inc\n",
      "ASANKO GOLD INC  does not have donut values\n",
      "redirected to:  Cross Country Healthcare  when searching:  Cross Country Healthcare Inc\n",
      "redirected to:  Bunge Limited  when searching:  Bunge Ltd\n",
      "redirected to:  Natus Medical  when searching:  Natus Medical Inc\n",
      "redirected to:  PDF Solutions  when searching:  PDF Solutions Inc\n",
      "redirected to:  AMN Healthcare  when searching:  AMN Healthcare Services Inc.\n",
      "redirected to:  HDFC Bank  when searching:  H D F C Bank Ltd\n",
      "redirected to:  Zimmer Biomet  when searching:  Zimmer Biomet Holdings Inc\n",
      "redirected to:  Asbury Automotive  when searching:  Asbury Automotive Group Inc\n",
      "redirected to:  XPO Logistics  when searching:  XPO Logistics Inc\n",
      "redirected to:  Gladstone Capital  when searching:  Gladstone Capital Corp\n",
      "redirected to:  Big 5 Sporting Goods  when searching:  Big 5 Sporting Goods Corp\n",
      "redirected to:  Advisory Board  when searching:  Advisory Board Company (The)\n",
      "redirected to:  GameStop  when searching:  GameStop Corp.\n",
      "redirected to:  Digirad  when searching:  Digirad Corp\n",
      "redirected to:  WW  when searching:  Weight Watchers International Inc.\n",
      "redirected to:  Charter Financial  when searching:  Charter Financial Corp\n",
      "CHARTER FINANCIAL CORP  does not have donut values\n",
      "redirected to:  Principal Financial Group  when searching:  Principal Financial Group Inc.\n",
      "redirected to:  Advance Auto Parts  when searching:  Advance Auto Parts Inc.\n",
      "redirected to:  Accuride  when searching:  Accuride Corp\n",
      "redirected to:  Acuity Brands  when searching:  Acuity Brands Inc.\n",
      "redirected to:  Piedmont Office Realty Trust  when searching:  Piedmont Office Realty Trust Inc\n",
      "PIEDMONT OFFICE REALTY TRUST  does not have donut values\n",
      "redirected to:  ManTech  when searching:  ManTech International Corp\n",
      "redirected to:  Aluminum Corporation of China  when searching:  Aluminum Corp of China Ltd\n",
      "redirected to:  Aluminum Corporation of China  when searching:  Aluminum Corp of China\n",
      "redirected to:  Five Star Senior Living  when searching:  Five Star Senior Living Inc\n",
      "redirected to:  Corcept Therapeutics  when searching:  Corcept Therapeutics Inc\n",
      "redirected to:  Cutera  when searching:  Cutera Inc\n",
      "redirected to:  Houston American Energy  when searching:  Houston American Energy Corp\n",
      "redirected to:  Comstock Mining  when searching:  Comstock Mining Inc\n",
      "COMSTOCK MINING INC  does not have donut values\n",
      "redirected to:  Energy Transfer  when searching:  Sunoco Logistics Partners LP\n",
      "redirected to:  Energy Transfer  when searching:  Sunoco Logistics\n",
      "redirected to:  Verint Systems  when searching:  Verint Systems Inc\n",
      "redirected to:  Drive Shack  when searching:  DRIVE SHACK INC\n",
      "redirected to:  JetBlue  when searching:  JetBlue Airways Corp\n",
      "redirected to:  BCB Bank  when searching:  BCB Bancorp Inc\n",
      "redirected to:  HelpSystems  when searching:  GlobalSCAPE Inc\n",
      "redirected to:  HelpSystems  when searching:  GlobalSCAPE\n",
      "redirected to:  Tsakos Energy Navigation  when searching:  Tsakos Energy Navigation Ltd\n",
      "TSAKOS ENERGY NAVIGATION LTD  does not have donut values\n",
      "redirected to:  Cohen & Steers  when searching:  Cohen & Steers Quality Income Realty\n",
      "redirected to:  Netflix  when searching:  Netflix Inc\n",
      "redirected to:  Regal  when searching:  Regal Entertainment Group\n",
      "redirected to:  Dover Downs Gaming  when searching:  Dover Downs Gaming & Entertainment Inc.\n",
      "redirected to:  Calavo Growers  when searching:  Calavo Growers Inc\n",
      "redirected to:  Severn Bancorp  when searching:  Severn Bancorp Inc\n",
      "SEVERN BANCORP INC  does not have donut values\n",
      "redirected to:  Overstock.com  when searching:  Overstock.com Inc\n",
      "redirected to:  InterOil  when searching:  Interoil Corp\n",
      "redirected to:  BioDelivery Sciences International  when searching:  BioDelivery Sciences International Inc\n",
      "BIODELIVERY SCIENCES INTL  does not have donut values\n",
      "redirected to:  Great Lakes Dredge & Dock  when searching:  Great Lakes Dredge & Dock Corp\n",
      "redirected to:  China Pioneer Pharma Holdings  when searching:  China Pharma Holdings Inc\n",
      "redirected to:  TransDigm  when searching:  TransDigm Group Inc\n",
      "redirected to:  TravelCenters of America  when searching:  TravelCenters of America LLC\n",
      "redirected to:  FormFactor  when searching:  FormFactor Inc\n",
      "redirected to:  Progressive Waste  when searching:  Progressive Waste Solutions Ltd\n",
      "redirected to:  Inpixon  when searching:  Inpixon\n",
      "redirected to:  Safety Insurance  when searching:  Safety Insurance Group Inc\n",
      "redirected to:  Red Robin  when searching:  Red Robin Gourmet Burgers Inc\n",
      "redirected to:  Westwood Holdings Group  when searching:  Westwood Holdings Group Inc.\n",
      "redirected to:  Nexstar Media Group  when searching:  Nexstar Media Group Inc.\n",
      "redirected to:  Wynn Resorts  when searching:  Wynn Resorts Ltd\n",
      "redirected to:  Nasdaq  when searching:  Nasdaq Inc\n",
      "redirected to:  SITO Mobile  when searching:  SITO Mobile Ltd\n",
      "redirected to:  Future Fintech  when searching:  Future FinTech Group Inc\n",
      "FUTURE FINTECH GROUP INC  does not have donut values\n",
      "redirected to:  Banc of California  when searching:  Banc of California Inc\n",
      "redirected to:  China Automotive Systems  when searching:  China Automotive Systems Inc\n",
      "redirected to:  Travelzoo  when searching:  Travelzoo\n",
      "redirected to:  CIT  when searching:  CIT Group Inc\n",
      "redirected to:  DICK'S Sporting Goods  when searching:  Dick's Sporting Goods Inc.\n",
      "redirected to:  Martin Midstream Partners  when searching:  Martin Midstream Partners LP\n",
      "redirected to:  Galectin Therapeutics  when searching:  Galectin Therapeutics Inc\n",
      "GALECTIN THERAPEUTICS INC  does not have donut values\n",
      "redirected to:  Sinovac Biotech  when searching:  Sinovac Biotech Ltd\n",
      "SINOVAC BIOTECH LTD  does not have donut values\n",
      "redirected to:  Hornbeck Offshore  when searching:  Hornbeck Offshore Services Inc.\n",
      "redirected to:  EnLink Midstream  when searching:  EnLink Midstream Partners LP\n",
      "redirected to:  Provident Financial Services  when searching:  Provident Financial Services Inc.\n",
      "PROVIDENT FINANCIAL SVCS INC  does not have donut values\n",
      "redirected to:  Texas Capital Bank  when searching:  Texas Capital Bancshares Inc\n",
      "redirected to:  Natural Gas Services  when searching:  Natural Gas Services Group Inc.\n",
      "redirected to:  Cimarex Energy  when searching:  Cimarex Energy Co.\n",
      "redirected to:  Ontrak  when searching:  Catasys Inc\n",
      "redirected to:  Ontrak  when searching:  Catasys\n",
      "BANK FIRST NATIONAL CORP  does not have donut values\n",
      "redirected to:  Natural Resource Partners  when searching:  Natural Resource Partners LP\n",
      "NATURAL RESOURCE PARTNERS LP  does not have donut values\n",
      "redirected to:  Enbridge  when searching:  Enbridge Energy Management LLC\n",
      "redirected to:  Parke Bancorp  when searching:  Parke Bancorp Inc\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "PARKE BANCORP INC  does not have donut values\n",
      "redirected to:  Halozyme  when searching:  Halozyme Therapeutics Inc\n",
      "redirected to:  CombiMatrix  when searching:  CombiMatrix Corp\n",
      "COMBIMATRIX CORP  does not have donut values\n",
      "redirected to:  Tenaris  when searching:  Tenaris SA, Luxembourg\n",
      "redirected to:  Pluristem Life Systems  when searching:  Pluristem Therapeutics Inc\n",
      "redirected to:  Pluristem Life Systems  when searching:  Pluristem Therapeutics\n",
      "NF ENERGY SAVING CORP  does not have donut values\n",
      "redirected to:  Molina Healthcare  when searching:  Molina Healthcare Inc.\n",
      "redirected to:  AXIS Capital  when searching:  AXIS Capital Holdings Ltd\n",
      "redirected to:  OptimumBank  when searching:  OptimumBank Holdings Inc\n",
      "OPTIMUMBANK HOLDINGS INC  does not have donut values\n",
      "redirected to:  NETGEAR  when searching:  NETGEAR Inc\n",
      "redirected to:  QEP Resources  when searching:  QEP Resources Inc\n",
      "redirected to:  Monarch Financial Holdings Inc  when searching:  Monarch Financial Holdings Inc\n",
      "MONARCH FINANCIAL HLDGS INC  does not have donut values\n",
      "redirected to:  Oragenics  when searching:  Oragenics Inc\n",
      "ORAGENICS INC  does not have donut values\n",
      "redirected to:  Gladstone Commercial  when searching:  Gladstone Commercial Corp\n",
      "GLADSTONE COMMERCIAL CORP  does not have donut values\n",
      "redirected to:  Clifton Savings  when searching:  Clifton Bancorp Inc\n",
      "CLIFTON BANCORP INC  does not have donut values\n",
      "redirected to:  Providence Service  when searching:  Providence Service Corp (The)\n",
      "redirected to:  Cheviot Financial  when searching:  Cheviot Financial Corp\n",
      "CHEVIOT FINANCIAL CORP  does not have donut values\n",
      "redirected to:  Government Properties Income Trust  when searching:  First Potomac Realty Trust\n",
      "redirected to:  Government Properties Income Trust  when searching:  First Potomac Realty\n",
      "redirected to:  Air Transport Services Group  when searching:  Air Transport Services Group Inc\n",
      "AIR TRANSPORT SERVICES GROUP  does not have donut values\n",
      "redirected to:  Trovagene  when searching:  TrovaGene Inc\n",
      "TROVAGENE INC  does not have donut values\n",
      "redirected to:  Whiting Petroleum  when searching:  Whiting Petroleum Corp\n",
      "redirected to:  LKQ  when searching:  LKQ Corp\n",
      "redirected to:  Cinedigm  when searching:  Cinedigm Corp\n",
      "redirected to:  Nelnet  when searching:  Nelnet Inc.\n",
      "redirected to:  Ashford, Inc.  when searching:  Ashford Hospitality Trust Inc\n",
      "redirected to:  Ashford, Inc.  when searching:  Ashford Hospitality\n",
      "redirected to:  Xperi  when searching:  Xperi Corp\n",
      "redirected to:  SYNNEX  when searching:  SYNNEX Corp\n",
      "redirected to:  First Marblehead  when searching:  First Marblehead Corp (The)\n",
      "redirected to:  Marlin Capital Solutions  when searching:  Marlin Business Services Corp\n",
      "redirected to:  Marlin Capital Solutions  when searching:  Marlin Business Services\n",
      "redirected to:  American Equity  when searching:  American Equity Investment Life Holding Co\n",
      "PARAGON COMMERCIAL CORP  does not have donut values\n",
      "redirected to:  Eaton Vance  when searching:  Eaton Vance Tax-Advantaged Dividend Income\n",
      "redirected to:  CallidusCloud  when searching:  Callidus Software Inc\n",
      "redirected to:  CallidusCloud  when searching:  Callidus Software\n",
      "redirected to:  Acorda Therapeutics  when searching:  Acorda Therapeutics Inc\n",
      "redirected to:  Universal Technical Institute  when searching:  Universal Technical Institute Inc.\n",
      "redirected to:  Talen Energy  when searching:  Talen Energy Corp\n",
      "redirected to:  Tempur Sealy International  when searching:  Tempur Sealy International Inc\n",
      "redirected to:  Hilltop Holdings  when searching:  Hilltop Holdings Inc\n",
      "redirected to:  Assurant  when searching:  Assurant Inc.\n",
      "redirected to:  Compass Minerals  when searching:  Compass Minerals International Inc.\n",
      "redirected to:  Buffalo Wild Wings  when searching:  Buffalo Wild Wings Inc\n",
      "redirected to:  Aspen  when searching:  Aspen Insurance Holdings Ltd\n",
      "redirected to:  Kronos Worldwide, Inc.  when searching:  Kronos Worldwide Inc\n",
      "redirected to:  Vistra Energy  when searching:  Vistra Energy Corp\n",
      "CTRIP.COM INTL LTD  does not have donut values\n",
      "redirected to:  Pacific City Financial  when searching:  Pacific City Financial Corp\n",
      "PACIFIC CITY FINANCIAL CORP  does not have donut values\n",
      "redirected to:  Spirit Realty Capital  when searching:  Spirit Realty Capital Inc\n",
      "SPIRIT REALTY CAPITAL INC  does not have donut values\n",
      "redirected to:  Marchex  when searching:  Marchex Inc\n",
      "SALESFORCE.COM INC  does not have donut values\n",
      "redirected to:  MEI Pharma  when searching:  MEI Pharma Inc\n",
      "MEI PHARMA INC  does not have donut values\n",
      "redirected to:  US Geothermal  when searching:  U S Geothermal Inc\n",
      "U S GEOTHERMAL INC  does not have donut values\n",
      "redirected to:  Assured Guaranty  when searching:  Assured Guaranty Ltd\n",
      "redirected to:  New York Mortgage Trust  when searching:  New York Mortgage Trust Inc\n",
      "redirected to:  Dyadic  when searching:  Dyadic International Inc\n",
      "redirected to:  Genworth  when searching:  Genworth Financial Inc\n",
      "redirected to:  Cytokinetics  when searching:  Cytokinetics Inc\n",
      "redirected to:  SP+  when searching:  SP Plus Corp\n",
      "redirected to:  MarketAxess  when searching:  MarketAxess Holdings Inc\n",
      "redirected to:  B&G Foods  when searching:  B&G Foods Inc.\n",
      "redirected to:  Arbor Realty Trust  when searching:  Arbor Realty Trust Inc.\n",
      "THRESHOLD PHARMACEUTICALS  does not have donut values\n",
      "redirected to:  GSI Technology  when searching:  GSI Technology Inc\n",
      "redirected to:  Multi-Fineline Electronix  when searching:  Multi-Fineline Electronix Inc\n",
      "redirected to:  Mastercard  when searching:  Mastercard Inc\n",
      "redirected to:  Prospect Capital  when searching:  Prospect Capital Corp\n",
      "redirected to:  Colony Capital  when searching:  NorthStar Realty Finance Corp\n",
      "redirected to:  Colony Capital  when searching:  NorthStar Realty Finance\n",
      "redirected to:  The Alphabet  when searching:  Alphabet Inc\n",
      "ALPHABET INC  does not have donut values\n",
      "redirected to:  MannKind Corporation  when searching:  MannKind Corp\n",
      "redirected to:  W&T Offshore  when searching:  W&T Offshore Inc\n",
      "redirected to:  Texas Roadhouse  when searching:  Texas Roadhouse Inc\n",
      "redirected to:  Gramercy Property Trust  when searching:  Gramercy Property Trust\n",
      "GRAMERCY PROPERTY TRUST  does not have donut values\n",
      "redirected to:  Extra Space Storage  when searching:  Extra Space Storage Inc\n",
      "EXTRA SPACE STORAGE INC  does not have donut values\n",
      "redirected to:  NeuroMetrix  when searching:  NeuroMetrix Inc\n",
      "redirected to:  Hercules Capital  when searching:  Hercules Capital Inc\n",
      "redirected to:  WashingtonFirst Bank  when searching:  WashingtonFirst\n",
      "redirected to:  Liberty Global  when searching:  Liberty Global Plc\n",
      "redirected to:  Media in Cooperation and Transition  when searching:  MICT Inc\n",
      "redirected to:  Commercial Vehicle  when searching:  Commercial Vehicle Group Inc\n",
      "redirected to:  Ohr Pharmaceutical  when searching:  Ohr Pharmaceutical Inc\n",
      "OHR PHARMACEUTICAL INC  does not have donut values\n",
      "redirected to:  Synthesis Energy Systems  when searching:  Synthesis Energy Systems Inc\n",
      "SYNTHESIS ENERGY SYSTEMS INC  does not have donut values\n",
      "redirected to:  Beacon Roofing  when searching:  Beacon Roofing Supply Inc\n",
      "redirected to:  Ship Finance International  when searching:  Ship Finance International LTD\n",
      "SHIP FINANCE INTL LTD  does not have donut values\n",
      "redirected to:  GOL Linhas Aéreas  when searching:  Gol Linhas Aereas Inteligentes SA\n",
      "redirected to:  SI Financial  when searching:  SI Financial Group Inc\n",
      "SI FINANCIAL GROUP INC  does not have donut values\n",
      "redirected to:  Hyster-Yale Materials Handling  when searching:  Hyster-Yale Materials Handling\n",
      "HYSTER-YALE MATERIALS HNDLNG  does not have donut values\n",
      "redirected to:  Westlake Chemical  when searching:  Westlake Chemical Corp\n",
      "redirected to:  DiamondRock Hospitality  when searching:  DiamondRock Hospitality Co\n",
      "redirected to:  LG Display  when searching:  LG Display Co Ltd\n",
      "redirected to:  Coffee Holding Co.  when searching:  Coffee Holding Co Inc\n",
      "redirected to:  Eaton Vance  when searching:  Eaton Vance Floating-Rate Income\n",
      "redirected to:  Mirati Therapeutics  when searching:  Mirati Therapeutics Inc\n",
      "MIRATI THERAPEUTICS INC  does not have donut values\n",
      "redirected to:  First Clover Leaf Financial  when searching:  First Clover Leaf Financial Corp\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "redirected to:  Viad  when searching:  Viad Corp\n",
      "redirected to:  Cyclacel Pharmaceuticals  when searching:  Cyclacel Pharmaceuticals Inc\n",
      "redirected to:  TOP Ships  when searching:  Top Ships Inc\n",
      "redirected to:  Monolithic Power Systems  when searching:  Monolithic Power Systems Inc\n",
      "redirected to:  Syneron Candela  when searching:  Syneron Medical Ltd\n",
      "redirected to:  Syneron Candela  when searching:  Syneron Medical\n",
      "redirected to:  Ormat  when searching:  Ormat Technologies Inc\n",
      "redirected to:  Calamos Investments  when searching:  Calamos Asset Management Inc\n",
      "redirected to:  Calamos Investments  when searching:  Calamos Asset Management\n",
      "redirected to:  CubeSmart  when searching:  CubeSmart\n",
      "redirected to:  Digital Realty  when searching:  Digital Realty Trust Inc\n",
      "redirected to:  NanoViricides  when searching:  NanoViricides Inc\n",
      "NANOVIRICIDES INC  does not have donut values\n",
      "redirected to:  BAYCOM  when searching:  BayCom Corp\n",
      "redirected to:  Mattress Firm  when searching:  Mattress Firm Holding Corp\n",
      "redirected to:  Build-A-Bear  when searching:  Build-A-Bear Workshop Inc\n",
      "redirected to:  Comstock Companies  when searching:  Comstock Holding Cos Inc\n",
      "OCEAN SHORE HOLDING CO  does not have donut values\n",
      "redirected to:  BlueLinx  when searching:  BlueLinx Holdings Inc\n",
      "redirected to:  Manitex International  when searching:  Manitex International Inc\n",
      "redirected to:  Las Vegas Sands  when searching:  Las Vegas Sands Corp\n",
      "redirected to:  Kearny Bank  when searching:  Kearny Financial Corp\n",
      "redirected to:  Kearny Bank  when searching:  Kearny Financial\n",
      "redirected to:  Prudential Bank  when searching:  Prudential Bancorp Inc\n",
      "PRUDENTIAL BANCORP INC  does not have donut values\n",
      "redirected to:  BankFinancial  when searching:  BankFinancial Corp\n",
      "redirected to:  National Interstate  when searching:  National Interstate Corp\n",
      "redirected to:  Ares Capital  when searching:  Ares Capital Corp\n",
      "redirected to:  Pueblo Bank and Trust Bank  when searching:  PB Bancorp Inc\n",
      "redirected to:  Huron Consulting Group  when searching:  Huron Consulting Group Inc\n",
      "redirected to:  ARC Document Solutions  when searching:  ARC Document Solutions Inc\n",
      "redirected to:  Consolidated Communications  when searching:  Consolidated Communications Holdings Inc\n",
      "redirected to:  Cryoport  when searching:  Cryoport Inc\n",
      "CRYOPORT INC  does not have donut values\n",
      "redirected to:  Medical Properties Trust  when searching:  Medical Properties Trust Inc\n",
      "MEDICAL PROPERTIES TRUST  does not have donut values\n",
      "CORDIA BANCORP INC  does not have donut values\n",
      "redirected to:  Digital Ally  when searching:  Digital Ally Inc\n",
      "redirected to:  Celanese  when searching:  Celanese Corp\n",
      "redirected to:  Neenah  when searching:  Neenah Paper Inc\n",
      "redirected to:  First Internet Bank  when searching:  First Internet Bancorp\n",
      "redirected to:  Prestige Brands  when searching:  Prestige Consumer Healthcare Inc\n",
      "redirected to:  Prestige Brands  when searching:  Prestige Consumer Healthcare\n",
      "redirected to:  Universal Logistics Holdings  when searching:  Universal Logistics Holdings Inc\n",
      "redirected to:  Atlantic Power  when searching:  Atlantic Power Corp\n",
      "redirected to:  Dolby  when searching:  Dolby Laboratories Inc\n",
      "redirected to:  Teekay  when searching:  Teekay LNG Partners LP\n",
      "redirected to:  Huntsman Corp  when searching:  Huntsman Corp\n",
      "redirected to:  LHC Group  when searching:  LHC Group Inc\n",
      "redirected to:  EXL Service  when searching:  ExlService Holdings Inc\n",
      "redirected to:  Aemetis  when searching:  Aemetis Inc\n",
      "AEMETIS INC  does not have donut values\n",
      "redirected to:  HighPoint Resources  when searching:  HighPoint Resources Corp\n",
      "HIGHPOINT RESOURCES CORP  does not have donut values\n",
      "redirected to:  Guaranty Bank  when searching:  Guaranty Bancorp\n",
      "redirected to:  Otelco  when searching:  Otelco Inc\n",
      "redirected to:  United Bank  when searching:  United Financial Bancorp Inc\n",
      "redirected to:  Lazard  when searching:  Lazard Ltd\n",
      "redirected to:  Axos Bank  when searching:  Axos Financial Inc\n",
      "redirected to:  Sunesis Pharmaceuticals  when searching:  Sunesis Pharmaceuticals Inc\n",
      "redirected to:  Navios Maritime  when searching:  Navios Maritime Holdings Inc\n",
      "redirected to:  Verifone  when searching:  Verifone Systems Inc\n",
      "redirected to:  FreightCar America  when searching:  FreightCar America Inc\n",
      "redirected to:  DryShips  when searching:  DryShips Inc\n",
      "DRYSHIPS INC  does not have donut values\n",
      "redirected to:  Synta Pharmaceuticals  when searching:  Synta Pharmaceuticals Corp\n",
      "redirected to:  XenoPort  when searching:  XenoPort Inc\n",
      "redirected to:  Home Federal Bancorp  when searching:  Home Federal Bancorp\n",
      "HOME FEDERAL BANCORP INC  does not have donut values\n",
      "redirected to:  Core-Mark  when searching:  Core Mark Holding Co Inc\n",
      "redirected to:  Dexcom  when searching:  DexCom Inc\n",
      "redirected to:  MediciNova  when searching:  Medicinova Inc\n",
      "MEDICINOVA INC  does not have donut values\n",
      "redirected to:  Crestwood Equity Partners  when searching:  Crestwood Equity Partners LP\n",
      "redirected to:  IHS Markit  when searching:  IHS Markit Ltd\n",
      "SILICON GRAPHICS INTL CORP  does not have donut values\n",
      "redirected to:  Radiant Logistics  when searching:  Radiant Logistics Inc\n",
      "redirected to:  Exantas Automotive  when searching:  Exantas Capital Corp\n",
      "EXANTAS CAPITAL CORP  does not have donut values\n",
      "redirected to:  Zumiez  when searching:  Zumiez Inc\n",
      "redirected to:  Builders FirstSource  when searching:  Builders FirstSource Inc\n",
      "redirected to:  Citi Trends  when searching:  Citi Trends Inc\n",
      "redirected to:  Diana Shipping  when searching:  Diana Shipping Inc\n",
      "redirected to:  First Federal Savings Bank of Frankfort  when searching:  Kentucky First Federal Bancorp\n",
      "redirected to:  First Federal Savings Bank of Frankfort  when searching:  Kentucky First Federal\n",
      "redirected to:  Koppers  when searching:  Koppers Holdings Inc\n",
      "redirected to:  TransMontaigne  when searching:  TransMontaigne Partners LP\n",
      "redirected to:  Pacific Ethanol  when searching:  Pacific Ethanol Inc\n",
      "redirected to:  Intercontinental Exchange  when searching:  Intercontinental Exchange Inc\n",
      "redirected to:  Ottawa Food Bank  when searching:  Ottawa Bancorp Inc\n",
      "OTTAWA BANCORP INC  does not have donut values\n",
      "redirected to:  Lincoln Tech  when searching:  Lincoln Educational Services Corp\n",
      "redirected to:  Everi  when searching:  Everi Holdings Inc\n",
      "redirected to:  Deerfield Capital  when searching:  CIFC LLC\n",
      "redirected to:  Deerfield Capital  when searching:  CIFC\n",
      "redirected to:  Eagle Bulk Shipping  when searching:  Eagle Bulk Shipping Inc\n",
      "STUDENT TRANSPORTATION INC  does not have donut values\n",
      "redirected to:  Cooper Standard  when searching:  Cooper-Standard Holdings Inc\n",
      "redirected to:  China Techfaith  when searching:  China Techfaith Wireless Communication Technology Ltd\n",
      "CHINA TECHFAITH WIRELESS-ADR  does not have donut values\n",
      "redirected to:  Eaton Vance  when searching:  Eaton Vance Tax-Managed Buy-Write Income\n",
      "redirected to:  Zion Oil  when searching:  Zion Oil & Gas Inc\n",
      "ZION OIL & GAS INC  does not have donut values\n",
      "redirected to:  Life Care Centers of America  when searching:  Stonegate Bank\n",
      "redirected to:  Life Care Centers of America  when searching:  Stonegate Bank\n",
      "redirected to:  Strategic Education, Inc  when searching:  Capella Education Co\n",
      "redirected to:  Strategic Education, Inc  when searching:  Capella Education\n",
      "redirected to:  Franklin Street Properties  when searching:  Franklin Street Properties Corp\n",
      "redirected to:  AtriCure  when searching:  AtriCure Inc\n",
      "RUTHS HOSPITALITY GROUP INC  does not have donut values\n",
      "WILLIAMS PARTNERS LP  does not have donut values\n",
      "redirected to:  James River Group  when searching:  James River Group Holdings Ltd\n",
      "redirected to:  Genco Shipping And Trading  when searching:  Genco Shipping & Trading Ltd\n",
      "redirected to:  Genco Shipping And Trading  when searching:  Genco Shipping & Trading\n",
      "redirected to:  REXAHN Pharmaceuticals  when searching:  Rexahn Pharmaceuticals Inc\n",
      "REXAHN PHARMACEUTICALS INC  does not have donut values\n",
      "redirected to:  Global Partners  when searching:  Global Partners LP\n",
      "redirected to:  Alon USA Energy  when searching:  Alon USA Energy Inc\n",
      "redirected to:  CF Industries  when searching:  CF Industries Holdings Inc\n",
      "redirected to:  Columbia Property Trust  when searching:  Columbia Property Trust Inc\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "redirected to:  CytoSorbents  when searching:  Cytosorbents Corp\n",
      "redirected to:  TreeHouse Foods  when searching:  TreeHouse Foods Inc\n",
      "redirected to:  Gran Tierra Energy  when searching:  Gran Tierra Energy Inc\n",
      "redirected to:  Toyota Motor Corporation  when searching:  CU Bancorp\n",
      "redirected to:  Cimpress  when searching:  Cimpress NV\n",
      "redirected to:  API Technologies  when searching:  API Technologies Corp\n",
      "redirected to:  Omega Flex  when searching:  Omega Flex Inc\n",
      "redirected to:  Retail Properties of America  when searching:  Retail Properties of America Inc\n",
      "redirected to:  Gladstone Investment  when searching:  Gladstone Investment Corp\n",
      "GLADSTONE INVESTMENT CORP  does not have donut values\n",
      "redirected to:  Jamba  when searching:  Jamba Inc\n",
      "redirected to:  Medivation  when searching:  Medivation Inc\n",
      "redirected to:  Chanticleer Holdings  when searching:  Chanticleer Holdings Inc\n",
      "CHANTICLEER HOLDINGS INC  does not have donut values\n",
      "redirected to:  STRATA Skin Sciences  when searching:  STRATA Skin Sciences Inc\n",
      "STRATA SKIN SCIENCES INC  does not have donut values\n",
      "redirected to:  Tronox  when searching:  Tronox Ltd\n",
      "redirected to:  Investors Bank  when searching:  Investors Bancorp Inc\n",
      "redirected to:  Waterstone Financial  when searching:  Waterstone Financial Inc\n",
      "WATERSTONE FINANCIAL INC  does not have donut values\n",
      "OP BANCORP  does not have donut values\n",
      "redirected to:  BioTelemetry  when searching:  VirtualScopics Inc\n",
      "redirected to:  BioTelemetry  when searching:  VirtualScopics\n",
      "redirected to:  iRobot  when searching:  iRobot Corp\n",
      "redirected to:  Spirit AeroSystems  when searching:  Spirit Aerosystems Holdings Inc\n",
      "redirected to:  ACCO Brands  when searching:  ACCO Brands Corp\n",
      "redirected to:  PharmAthene  when searching:  PharmAthene Inc\n",
      "redirected to:  Advaxis  when searching:  Advaxis Inc\n",
      "ADVAXIS INC  does not have donut values\n",
      "redirected to:  Baidu  when searching:  Baidu Inc\n",
      "redirected to:  Seaspan Corporation  when searching:  Seaspan Corp\n",
      "redirected to:  RBC Bearings  when searching:  RBC Bearings Inc\n",
      "redirected to:  AMERISAFE  when searching:  AMERISAFE Inc\n",
      "redirected to:  eFuture (NL)  when searching:  eFuture Holding Inc\n",
      "EFUTURE HOLDING INC  does not have donut values\n",
      "redirected to:  Town Sports International Holdings  when searching:  Town Sports International Holdings Inc\n",
      "redirected to:  Genomic Health  when searching:  Genomic Health Inc\n",
      "redirected to:  NxStage  when searching:  NxStage Medical Inc\n",
      "redirected to:  Home BancShares  when searching:  Home Bancshares Inc\n",
      "redirected to:  Brookdale Senior Living  when searching:  Brookdale Senior Living Inc\n",
      "redirected to:  Clear Channel Outdoor  when searching:  Clear Channel Outdoor Holdings Inc\n",
      "redirected to:  WestRock  when searching:  KapStone Paper & Packaging Corp\n",
      "redirected to:  WestRock  when searching:  KapStone Paper & Packaging\n",
      "redirected to:  HollySys Group  when searching:  Hollysys Automation Technologies Ltd\n",
      "redirected to:  HollySys Group  when searching:  Hollysys Automation Technologies\n",
      "redirected to:  Ameriprise  when searching:  Ameriprise Financial Inc\n",
      "MAINSTREET BANCSHARES INC  does not have donut values\n",
      "redirected to:  CounterPath Corporation  when searching:  Counterpath Corp\n",
      "redirected to:  Crocs  when searching:  Crocs Inc\n",
      "redirected to:  Boardwalk Pipelines  when searching:  Boardwalk Pipeline Partners LP\n",
      "redirected to:  SunPower  when searching:  SunPower Corp\n",
      "redirected to:  Under Armour  when searching:  Under Armour Inc\n",
      "redirected to:  StealthGas  when searching:  StealthGas Inc\n",
      "STEALTHGAS INC  does not have donut values\n",
      "redirected to:  Leidos  when searching:  Leidos Holdings Inc\n",
      "redirected to:  Synutra  when searching:  Synutra International Inc\n",
      "SYNUTRA INTERNATIONAL INC  does not have donut values\n",
      "CORENERGY INFRASTRUCTURE TR  does not have donut values\n",
      "redirected to:  ZIOPHARM  when searching:  ZIOPHARM Oncology Inc\n",
      "redirected to:  Double Hull Tankers  when searching:  DHT Holdings Inc\n",
      "DHT HOLDINGS INC  does not have donut values\n",
      "redirected to:  Fidelity National Financial  when searching:  Fidelity National Financial Inc FNF Group\n",
      "redirected to:  First Business Bank  when searching:  First Business Financial Services Inc\n",
      "redirected to:  First Business Bank  when searching:  First Business Financial Services\n",
      "redirected to:  American Railcar Industries  when searching:  American Railcar Industries Inc\n",
      "AMERICAN RAILCAR INDS INC  does not have donut values\n",
      "redirected to:  Magyar Bancorp  when searching:  Magyar Bancorp Inc\n",
      "MAGYAR BANCORP INC  does not have donut values\n",
      "redirected to:  DCP Midstream LP  when searching:  DCP Midstream LP\n",
      "redirected to:  Origin Agritech  when searching:  Origin Agritech Ltd\n",
      "ORIGIN AGRITECH LTD  does not have donut values\n",
      "redirected to:  Chaparral Energy  when searching:  Chaparral Energy Inc\n",
      "redirected to:  Birks  when searching:  Birks Group Inc\n",
      "redirected to:  Summit State  when searching:  Summit State Bank\n",
      "redirected to:  Ur-Energy  when searching:  Ur-Energy Inc\n",
      "UR ENERGY INC  does not have donut values\n",
      "redirected to:  Energy Transfer  when searching:  Energy Transfer LP\n",
      "redirected to:  Andeavor  when searching:  Western Refining Inc\n",
      "redirected to:  Andeavor  when searching:  Western Refining\n",
      "redirected to:  ViacomCBS  when searching:  Viacom Inc\n",
      "redirected to:  Copa Airlines  when searching:  Copa Holdings SA\n",
      "redirected to:  Castle Brands  when searching:  Castle Brands Inc\n",
      "redirected to:  Shanghai Ever Glory  when searching:  Ever-Glory International Group Inc\n",
      "redirected to:  Shanghai Ever Glory  when searching:  Ever-Glory International\n",
      "redirected to:  Star Bulk  when searching:  Star Bulk Carriers Corp\n",
      "redirected to:  Lpath  when searching:  Lpath Inc\n",
      "LPATH INC  does not have donut values\n",
      "URANIUM ENERGY CORP  does not have donut values\n",
      "redirected to:  nTelos  when searching:  NTELOS Holdings Corp\n",
      "redirected to:  H&E Equipment Services  when searching:  H&E Equipment Services Inc\n",
      "redirected to:  Euroseas  when searching:  Euroseas Ltd\n",
      "EUROSEAS LTD  does not have donut values\n",
      "redirected to:  Chipotle  when searching:  Chipotle Mexican Grill Inc\n",
      "redirected to:  Perion Network  when searching:  Perion Network Ltd\n",
      "SUNWORKS INC  does not have donut values\n",
      "redirected to:  FIS  when searching:  Fidelity National Information Services Inc\n",
      "redirected to:  AmTrust Financial  when searching:  AmTrust Financial Services Inc\n",
      "redirected to:  Air Industries Group  when searching:  Air Industries Group Inc\n",
      "redirected to:  Lake Shore Bancorp  when searching:  Lake Shore Bancorp Inc\n",
      "redirected to:  Liquidity Services  when searching:  Liquidity Services Inc\n",
      "redirected to:  Novadaq  when searching:  Novadaq Technologies Inc\n",
      "redirected to:  Kraton  when searching:  Kraton Corp\n",
      "redirected to:  Alliance Holdings GP  when searching:  Alliance Holdings GP LP\n",
      "ALLIANCE HOLDINGS GP LP  does not have donut values\n",
      "redirected to:  Compass Diversified Holdings  when searching:  Compass Diversified Holdings\n",
      "redirected to:  Pacific Airport Group  when searching:  Grupo Aeroportuario Del Pacifico SA\n",
      "redirected to:  Vanda Pharmaceuticals  when searching:  Vanda Pharmaceuticals Inc\n",
      "redirected to:  Anavex Life Sciences  when searching:  Anavex Life Sciences Corp\n",
      "ANAVEX LIFE SCIENCES CORP  does not have donut values\n",
      "redirected to:  Mueller Water Products  when searching:  Mueller Water Products Inc\n",
      "redirected to:  Coldwell Banker  when searching:  Regional Health Properties Inc\n",
      "redirected to:  India Globalization Capital  when searching:  India Globalization Capital Inc\n",
      "INDIA GLOBALIZATION CAPITAL  does not have donut values\n",
      "redirected to:  Alphatec Spine  when searching:  Alphatec Holdings Inc\n"
     ]
    }
   ],
   "source": [
    "browser = webdriver.Chrome(executable_path=\"/usr/local/bin/chromedriver\")\n",
    "\n",
    "#enter username and password \n",
    "args = {'username':'', \n",
    "        'password':'', \n",
    "        'url':'https://www.glassdoor.com/member/home/index.htm'}\n",
    "\n",
    "sign_in(args)\n",
    "taskOne, taskTwo = gather_seeds(635) #blocked from 635 so start from here\n",
    "#started at deltic timber after entering captcha info\n",
    "writeToJson(taskOne, 'taskOne')\n",
    "writeToJson(taskTwo, 'taskTwo')\n",
    "browser.quit()\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "federal-newfoundland",
   "metadata": {},
   "source": [
    "#### Notes from full drive #1\n",
    "\n",
    "###### Main points:\n",
    "- may need to compare all companies with same name, and choose whatever company has the most reviews. Ask research ppl\n",
    "- If I dont have a sure answer as to what companuy I am looking for and im not sure of my link, should I omit? i.e. how certain do I have to be about the company I select?\n",
    "- searching with the ticker is too unreliable so its better to not use\n",
    "- Perhaps I could train a model of moving words around in different ways but at this point I feel like I should continue building manually\n",
    "\n",
    "### Key Limitation:\n",
    "- sometimes the company, job, salary, interview dropdown menu disappears. This means we have to create an entirely new scraper as the results page is completely different. Thus, continually refreshing will probably be the only option, if that doesnt trigger the website to think we are a bot."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "pregnant-morning",
   "metadata": {},
   "source": [
    "<details>\n",
    "<summary>Detailed Points (too many so in drop down mode)</summary>\n",
    "<br>\n",
    "\n",
    "asa - ticker misleading\n",
    "    \n",
    "UHL u-haul?\n",
    "    \n",
    "aep\n",
    "\n",
    "aflac afl ?\n",
    "\n",
    "aig - ticker?\n",
    "\n",
    "ametek - ticker?\n",
    "\n",
    "amrep - ticker?\n",
    "\n",
    "trec\n",
    "\n",
    "adm - archer daniels (ADM)\n",
    "\n",
    "ash\n",
    "\n",
    "rex stores redirect bc lower case\n",
    "\n",
    "automatic data processing\n",
    "\n",
    "compare lower to lower\n",
    "\n",
    "avon\n",
    "\n",
    "azz\n",
    "\n",
    "british american tobacco\n",
    "\n",
    "brt aaparetments - brt - ticker cant see images and detect related words... could use ML to choose related words...\n",
    "\n",
    "Ball corp\n",
    "\n",
    "popular\n",
    "\n",
    "\n",
    "bank of mellon BK \n",
    "\n",
    "Bard (C.R) B Barnes\n",
    "\n",
    "Barnes group\n",
    "\n",
    "Beckton dickinson and Co\n",
    "\n",
    "bemis bms\n",
    "\n",
    "bkh black hills\n",
    "\n",
    "block H&R reverse order listed\n",
    "\n",
    "!@ensco rowasn is now ....\n",
    "\n",
    "robert half international include in in search, not equality.\n",
    "\n",
    "Bristol Myers Squibb\n",
    "\n",
    "BP\n",
    "\n",
    "liveramp - lower all and take away spaces\n",
    "\n",
    "CDI \n",
    "\n",
    "cna\n",
    "\n",
    "csp\n",
    "\n",
    "csx\n",
    "\n",
    "cts\n",
    "\n",
    "campbell sroup - lower strip combine search\n",
    "\n",
    "Carisle v Carisle IT - CSL\n",
    "\n",
    "Caterpillar or CAT?\n",
    "\n",
    "CENTURY LINK ctl TOO DIFFERENT. lowercase and strip would be same\n",
    "\n",
    "what do we do when there are only iffy otions? better to not select data?\n",
    "\n",
    "i e multiple similar name but ?\n",
    "\n",
    "JP Morgan (Chase & is un necessary) also same name company but dif bc logo exists\n",
    "\n",
    "Coca Cola Consolidated\n",
    "\n",
    "cohu\n",
    "\n",
    "use number of views to choose most legit company\n",
    "\n",
    "commerce bank in in serarch\n",
    "\n",
    "citi long v name?\n",
    "\n",
    "Avis in in search - CAR\n",
    "\n",
    "ca CA ?? CA INC? LOWER AND IN IN SEARCH\n",
    "\n",
    "COMPUTER TASK CTG TASK?\n",
    "\n",
    "rave restaurant rave totally wrong ;(\n",
    "\n",
    "consolidated editonm ed \n",
    "\n",
    "Biglari steak and shake?\n",
    "\n",
    "consolodated tomoka\n",
    "\n",
    "cooper cos inc The cooper company?\n",
    "\n",
    "TAP\n",
    "\n",
    "CRANE\n",
    "\n",
    "ONEMAIN FIN IN IN SEARCH\n",
    "\n",
    "CROWN HOLDINGS IN IN SEARCH\n",
    "\n",
    "DST\n",
    "\n",
    "DATAO DAIO DATA I in in search for data i/o\n",
    "\n",
    "deere in in search de to get john deere\n",
    "\n",
    "deluxe in in searchDLX delux corp works best but thuis may not be the case forfr american airlines\n",
    "\n",
    "Nortech systems\n",
    "\n",
    "dover v dover crop - user review numbers to compare\n",
    "\n",
    "Dupont de noumers\n",
    "\n",
    "</details>\n",
    "\n",
    "56 possible errors"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "filled-sherman",
   "metadata": {},
   "source": [
    "#### Notes from full drive #2\n",
    "\n",
    "- it seems like no longer using the ticker to search, the use of nltk to normalize text and do a greedy comparison against longname, commonname, and ticker, and having a heuristic to predict which link will be the most legetimate seems to have done well. Testing on rows 11 to 111, we only had 8 sketchy search results.\n",
    "\n",
    "- I was thinking of using whether a company has an image or not as some sort of bonus point to the heuristic, but this may mess up some of the results. if I want to be safe, I could make the image a requirement. what kind of company would be so lazy to not upload their logo?\n",
    "\n",
    "- there seems to be a lot of parameters i can adjust to make the search better. Sounds like a machine learning model...\n",
    "\n",
    "- looks like I need to somehow predict acronyms. But at this point predicting acronyms really depends on the context of the company name. for example, if I search up A V Homes and get Avatar Holdings, I would guess its similar enough. But is it even right? I'm not a professional at determing companies.\n",
    "\n",
    "- seems like there are some companies that exist and probably have an account on glassdoor but there are exact replicas with sketchy names and dangerous links. It looks like I'm going to have to set a SAFETY FACTOR to cut out some weird redirects.\n",
    "\n",
    "- looks like long names are usually a better bet than the common name.\n",
    "\n",
    "- when one of the searches go through, I redirected to a completely unrelated company. How do I prevent this while allowing for acronym changes?\n",
    "\n",
    "- some names just seem off compared to the ticker. There are [API solutions to this](https://www.marketplace.spglobal.com/en/solutions/api-solutions-(61953ac7-ea64-4fac-926a-feb7f846c2be)) and there seems to have been python wrappers, but they cost money. Another method I could take is [download the capiq SPREAD SHEETS AND CONVERT THE CAPIQ to names there. ](https://nickderobertis.github.io/capiq-excel-downloader-py/) However this would be very memory intensive and would take long. [this seems to be common issue within the last year as well.](https://www.reddit.com/r/investing/comments/bjqlf7/capital_iq_api/) There also seems to be [academic resources](https://www.library.hbs.edu/Find/Databases/Capital-IQ-Identifiers) as well  but this also requires special permission.\n",
    "\n",
    "<details>\n",
    "<summary>Detailed Points</summary>\n",
    "<br>\n",
    "j ALEXANDER ACTUALLY CORRECT!\n",
    "\n",
    "american vanguard - legitimate but looks sketchy. Maybe have no safety filter\n",
    "\n",
    "amrep - longname better\n",
    "\n",
    "apogee? - longname works better\n",
    "\n",
    "A V Homes Avatar holdings redirected but too different\n",
    "\n",
    "Brt Apartments - probably british apartments? - >redirects to apartments.com but different from brtapartments.com. not listed?\n",
    "\n",
    "Barnes - Barnes and nobles or barns education? - barns group inc exists. longname first is better\n",
    "\n",
    "</details>\n",
    "    \n",
    "8/100 errors"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "decimal-youth",
   "metadata": {},
   "source": [
    "BRITISH AMERICAN TOBACCO - ticker not BAT, is BTE - too risky to allow head concat automatically\n",
    "\n",
    "BNY Mellon skipped? - could tokenize to match just words, but then becomes sketchy. add more to legal? added Municipal,Bond,Infrastructure,Fund to legal list\n",
    "\n",
    "AV Homes - AV Holdings add Homes to legal list\n",
    "\n",
    "Perhaps having a minimal list to compare to might be advantageous, but sometimes misleading\n",
    "\n",
    "Blocked after DIGITAL TURBINE 615\n",
    "\n",
    "also much faster when task 2 not needed.\n",
    "\n",
    "for tomorrow, just make python executable file and turn in"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "partial-reynolds",
   "metadata": {},
   "source": [
    "### Now we input the URLs into the jsonl file"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}