INNER CODE UNIT · Python

_df_DAILY_REF_RATE

adminho/trading-stock-thailand · BOT_API_example.py:134

def _df_DAILY_REF_RATE(data_detail):
	date_list, rate_list = [], []
	for value in data_detail:			
		date_list.append(value["period"])
		rate_list.append(value["rate"])
		
	# convert string to date
	date_list = [ datetime.datetime.strptime(ts, "%Y-%m-%d") for ts in date_list]
	# convert string to float
	rate_list = [float(i.strip()) for i in rate_list]
	# create dataframe for collecting all detail
	df = pd.DataFrame(data = rate_list, index=date_list, columns =["DAILY_RATE"] )	
	return df

def _df_DAILY_AVG_EXG_RATE(data_detail):
	date_list, rate_list, currencyname_list = [], [], []
	for value in data_detail:		
		date_list.append(value["period"])

View source record →