for ticker in tickers:
if ticker not in temp:
temp2.append(ticker)
temp.append(ticker)
tickers = temp2
for ticker in tickers:
print(ticker)
s = Sentiment(ticker)
news = s.get_news()
stocktwits = s.get_stocktwits()
press_releases = s.get_press_releases()
analyst_ratings = s.get_analyst_ratings()
insider_trading = s.get_insider_trading()
quiver_data = s.get_quiver_data()
# ticker_sentiment = sentiment.calculate_sentiment(f'{ticker}')
# print(ticker_sentiment)
cursor.execute(
'insert into premarket_sentiment (ticker, articles, sentiment, \
today_sentiment, messages, today_sentiment_st, sentiment_st, \
press_releases, contracts, lobbying, congress_buys, \
congress_sells, senate_buys, senate_sells, house_buys, \
house_sells, insider_trades, upgrades, downgrades) \
values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, \
%s, %s, %s, %s, %s, %s, %s)',
(ticker, news['articles_today'], news['total_sentiment'],
news['today_total_sentiment'], stocktwits['articles_today'],
from sentiment import Sentiment
s = Sentiment('AAPL')
print(dir(s))
results = s.get_stocktwits()
print('\n\n LAST LINE:', results)
results = s.get_insider_trading()
print('\n\n LAST LINE:', results)
results = s.get_news()
print('\n\n LAST LINE:', results)
results = s.get_press_releases()
print('\n\n LAST LINE:', results)
results = s.get_quiver_data()
print('\n\n LAST LINE:', results)
results = s.get_analyst_ratings()
print('\n\n LAST LINE:', results)
