如何计算Alphabet股票的高低百分比?
import pandas as pdimport quandldf = quandl.get('WIKI/GOOGL')df = df[['Adj. Open','Adj. High','Adj. Low','Adj. Close','Adj. Volume']]df['HL_PCT'] = (df['Adj. High'] - df['Adj. Close']) / df['Adj. Close']*100.00df['PCT_change'] = (df['Adj. Close'] - df['Adj. Open']) / df['Adj. Open ']*100.00df = df[['Adj. Close','HL_PCT','HL_PCT','PCT_change','Adj. Volume']]print(df.head())
回答:
这个问题有点草率,但我认为这就是你想要的。不过下次请先阅读如何正确提问的指南。
import quandldf = quandl.get('WIKI/GOOGL')df['HL_PCT'] = (df['Adj. High'] - df['Adj. Close']) / df['Adj. Close'] * 100.00df['PCT_change'] = (df['Adj. Close'] - df['Adj. Open']) / df['Adj. Open'] * 100.00print(df.head())