已知1、某股票的增减持日期,2、股票从上市至今的交易数据,求减持后(交易日)1天,5天,15天的收盘价。

import pandas as pd 
import numpy as np
df_day = pd.read_csv('000002_daily.csv',encoding = 'gbk')
df_zjc = pd.read_csv('000002_zjc.csv',encoding = 'gbk')
df_day = df_day[['ts_code', 'trade_date', 'close']]
df_day['date'] = pd.to_datetime(df_day['trade_date'],format='%Y%m%d')
df_day = df_day.set_index('date',drop = True)
df_zjc=df_zjc[['ts_code', 'ann_date']]
df_zjc['date'] = pd.to_datetime(df_zjc['ann_date'],format='%Y%m%d')
df_zjc = df_zjc.set_index('date',drop = True)
for i in range(0,len(df_zjc)):
    df_zjc.loc[df_zjc.index[i],'1day'] = df_day['close'][df_zjc.index[i]:][1]
    df_zjc.loc[df_zjc.index[i],'5day'] = df_day['close'][df_zjc.index[i]:][4]
    df_zjc.loc[df_zjc.index[i],'15day'] = df_day['close'][df_zjc.index[i]:][14]

 

 

 

 

 

posted @ 2021-02-23 10:44  汉江S  阅读(95)  评论(0编辑  收藏  举报