!pip install FinanceDataReader

import pandas as pd

import FinanceDataReader as fdr

def make_rate(code):

      df = fdr.DataReader(code,'2017')

      original = df[['Close']].iloc[0]

      df = df[['Close']] / original -1

      return df['Close']

def final_rate(code):

      return make_rate(code).iloc[-1]

def final_rate(code):

  try:

    return make_rate(code).iloc[-1]

  except:

    return (-1000)

df = fdr.StockListing('SP500')

df = df[['Symbol','Name']].head(100)

df['rate'] = df['Symbol'].apply(final_rate)

cond = df['rate'] > -50

df = df[cond]

df = df.sort_values(by='rate',ascending=False).head(10)

df.set_index('Name',inplace=True)

df.plot(kind='bar')

----------------

ERROR: Could not find a version that satisfies the requirement FinanceDataReader (from versions: none)
ERROR: No matching distribution found for FinanceDataReader
---------------------------------------------------------------------------
ModuleNotFoundError                       Traceback (most recent call last)
<ipython-input-4-19dbd03bebf2> in <cell line: 4>()
      2 
      3 import pandas as pd
----> 4 import FinanceDataReader as fdr
      5 
      6 

ModuleNotFoundError: No module named 'FinanceDataReader'
---------------------------------------------------------------------------
NOTE: If your import is failing due to a missing package, you can
manually install dependencies using either !pip or !apt.

To view examples of installing some common dependencies, click the
"Open Examples" button below.

---------------------------------------------------------------------------