def tii_symbols():
client = c()
symbols = client.list_stock_tickers()
e = get_exchange('')
for symbol in symbols:
try:
meta = client.get_ticker_metadata(symbol['ticker'])
except HTTPError as err:
print(colored.red(err))
except Exception as err:
print(colored.red(err))
if symbol['assetType'] == 'Stock':
market_type = 'cs'
else:
print(symbol['assetType'])
try:
Market.create(symbol=symbol['ticker'],
name=meta['name'],
exchange=e,
market_type=market_type,
description=meta['description'])
print(colored.green(symbol['ticker']))
except IntegrityError:
DB.rollback()
except Exception as err:
print(colored.red(err))
DB.rollback()
def insert_market(exchange, name):
for market in exchange.load_markets():
print(market)
try:
CryptoMarket.create(market=market, exchange=CryptoExchange.get(title=name).id)
except IntegrityError:
DB.rollback()
except Exception as err:
print(colored.red(err))
def put_exchanges():
for e in ccxt.exchaanges:
print(e)
try:
if e is not None:
CryptoExchange.create(title=e)
except IntegrityError:
DB.rollback()
except Exception as err:
print(colored.red(err))
def iex_symbols():
markets = get_available_symbols(output_format='pandas')
e = get_exchange('IEX')
for m in markets:
try:
Market.create(symbol=m['symbol'], name=m['name'],
market_type=m['type'],
exchange=e, enabled=m['isEnabled'])
print(colored.green(m))
except IntegrityError:
DB.rollback()
except Exception as err:
print(colored.red(err))
DB.rollback()
def eod_symbols(e='US'):
df = get_exchange_symbols(exchange_code=e)
for i in range(len(df)):
try:
symbol = df.ix[i].name
name = df.ix[i]['Name']
exchange = df.ix[i]['Exchange']
if exchange != 'NaN':
e = ge(exchange)
else:
e = ge('')
Market.create(symbol=symbol, name=name, exchange=e)
print(colored.green(symbol))
except IntegrityError:
DB.rollback()
except Exception as err:
print(colored.red(err))
DB.rollback()