def get_stock_info_a_code_name(self):
'''
code name
0 000001 平安银行
'''
stock_info_a_code_name_df = ak.stock_info_a_code_name()
return stock_info_a_code_name_df
def get_stock_list(self):
# 获取股票列表
stock_info_a_code_name_df = ak.stock_info_a_code_name()
print(stock_info_a_code_name_df)
file_name = self.list_path + "stock_list.csv"
stock_info_a_code_name_df['code'] = stock_info_a_code_name_df[
'code'].astype(str)
#print(stock_info_a_code_name_df['code'])
stock_info_a_code_name_df.to_csv(file_name, encoding="utf_8_sig")
def get_stock_code_info(self):
stock_info_df = ak.stock_info_a_code_name() # 获取所有A股code和name
stock_symbol_code = ak.stock_zh_a_spot().get(["symbol", "code"]) # 获取A股所有股票的symbol和code
for _id in range(stock_info_df.shape[0]):
_symbol = stock_symbol_code[stock_symbol_code.code == stock_info_df.iloc[_id].code].symbol.values
if len(_symbol) != 0:
_dict = {"symbol": _symbol[0]}
_dict.update(stock_info_df.iloc[_id].to_dict())
self.col_basic_info.insert_one(_dict)
return stock_info_df
def get_stock_status():
"""股票状态词典
键：股票代码
值：退市日期。在市交易的股票代码其值为空
"""
df = ak.stock_info_a_code_name()
p1 = set(df['code'].to_list())
p2 = set(get_recent_trading_stocks())
codes = p1 | p2
d1 = {code: None for code in codes}
d2 = get_delist_stock_dates()
# 注意，退市字典要放在次位置
# 如有交叉键，则以次位置的值替代
return merge(d1, d2)
def stock_zh_ah_name_dict():
stock_info_a_code_name_df = ak.stock_info_a_code_name();
stock_list = [];
# 当前股票字典
for row in stock_info_a_code_name_df.iterrows():
dict_item = StockAhNameDict();
dict_item.code = row[1]['code'];
dict_item.name = row[1]['name'];
stock_list.append(dict_item);
# 本地mysql股票字典
# mysql_stock_info = session.query(StockAhNameDict).all();
num_rows_deleted = db.session.query(StockAhNameDict).delete()
print(num_rows_deleted);
session.add_all(stock_list);
session.commit();
response = ReponseBuilder(True, "success");
return json.dumps(response.__dict__);
def main():
outfile = abspath(__file__)[:-2] + "txt"
with open(outfile) as f:
for i in f:
i = i.strip("\n")
if i:
NAME << i
# 港股、美股
for func, attr in (
(ak.stock_us_spot, 'cname'),
(ak.stock_hk_spot, 'name'),
):
li = func()
for index, i in li.iterrows():
name = i[attr].split("-")[0].replace("（", "(").split("(")[0]
if name.isascii():
continue
if name.endswith("公司"):
name = name[:-2]
if name.endswith("类股") or ' ' in name or '&#' in name:
continue
NAME << name
# A股全部
stock_a = StockA()
li = ak.stock_info_a_code_name()
for index, i in li.iterrows():
stock_a(i['code'], i['name'])
li = ak.stock_info_sz_delist(indicator="终止上市公司")
for index, i in li.iterrows():
stock_a(i['证券代码'], i['证券简称'])
with open(outfile, "w") as out:
out.write(str(NAME))
def stock_info_a_code_name():
try:
stock_info_a_code_name_df = ak.stock_info_a_code_name()
return jsonify_dataframe(stock_info_a_code_name_df)
except Exception as e:
jsonify_failure(e)
def get_stock_code_info(self):
stock_info_a_code_name_df = ak.stock_info_a_code_name()
for _id in range(stock_info_a_code_name_df.shape[0]):
_dict = stock_info_a_code_name_df.iloc[_id].to_dict()
self.col.insert_one(_dict)
