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()