
los = []
url = 'https://stocktwits.com/symbol/'
workbook = openpyxl.load_workbook('Spreadsheet.xlsx')
worksheet = workbook.get_sheet_by_name(name = 'Sheet1') 
for col in worksheet['A']:
    los.append(col.value)
los2 = []
print(los)


for i in los:
   stocksite = url +i + '?q=' +i 
   print(stocksite)
   with contextlib.closing(webdriver.PhantomJS(Phantom_Path)) as driver:
   #with contextlib.closing(webdriver.Phantom_Path)) as driver:    
       driver.get(stocksite) 
       driver.find_element_by_id('sentiment-tab').click()
       Bullish = driver.find_elements_by_css_selector('span.bullish:nth-child(1)')
       Sentiment =  [x.text for x in Bullish]
       los2.append(Sentiment[0])
       


los = []
url = 'https://stocktwits.com/symbol/'
workbook = openpyxl.load_workbook('NYQ.xlsx')
worksheet = workbook.get_sheet_by_name(name = 'Sheet1') 
for col in worksheet['A']:
    los.append(col.value)
los2 = []
print(los)


for i in los:
   stocksite = url +i + '?q=' +i 
   print(stocksite)
   with contextlib.closing(webdriver.PhantomJS(Phantom_Path)) as driver:
   #with contextlib.closing(webdriver.Phantom_Path)) as driver:    
       driver.get(stocksite) 
       driver.find_element_by_id('sentiment-tab').click()
       Bullish = driver.find_elements_by_css_selector('span.bullish:nth-child(1)')
       Sentiment =  [x.text for x in Bullish]
       los2.append(Sentiment[0])
       

Update Watchers.py