def get_data(stock, start, end):
data = Share(stock)
try:
data = pd.DataFrame(data.get_historical(start_date=start,
end_date=end))
except Exception as e:
f = open('log.txt', mode='a')
f.write(stock + '\n')
f.write(str(e) + '\n')
return pd.DataFrame()
try:
data.index = data.Date
except Exception as e:
f = open('log.txt', mode='a')
f.write(stock + '\n')
f.write(str(e) + '\n')
return pd.DataFrame()
data = data.drop(['Date', 'Symbol'], axis=1)
data = data.sort_index()
for i in data.columns:
data[i] = data[i].astype(np.float)
#data['Adj_Open'] = 0
#data['Adj_High'] = 0
#data['Adj_Low'] = 0
#for i in range(len(data)):
# k = data['Adj_Close'][i] / data['Close'][i]
# data.loc[i:i+1,'Adj_Open'] = k*data['Open'][i]
# data.loc[i:i + 1, 'Adj_High'] = k * data['High'][i]
# data.loc[i:i + 1, 'Adj_Low'] = k * data['Low'][i]
data['Symbol'] = stock
return data
def get_data(stock,start,end):
data = Share(stock)
try:
data = pd.DataFrame(data.get_historical(start_date=start,end_date=end))
except Exception as e:
f = open('log.txt',mode='a')
f.write(stock+'\n')
f.write(str(e)+'\n')
return pd.DataFrame()
try:
data.index = data.Date
except Exception as e:
f = open('log.txt', mode='a')
f.write(stock+'\n')
f.write(str(e)+'\n')
return pd.DataFrame()
data = data.drop(['Date','Symbol'],axis=1)
data = data.sort_index()
for i in data.columns:
data[i] = data[i].astype(np.float)
#data['Adj_Open'] = 0
#data['Adj_High'] = 0
#data['Adj_Low'] = 0
#for i in range(len(data)):
# k = data['Adj_Close'][i] / data['Close'][i]
# data.loc[i:i+1,'Adj_Open'] = k*data['Open'][i]
# data.loc[i:i + 1, 'Adj_High'] = k * data['High'][i]
# data.loc[i:i + 1, 'Adj_Low'] = k * data['Low'][i]
data['Symbol'] = stock
return data
