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