如何从雅虎获得一套股票？

Question

我有一份股票清单和一家诱人的咨询公司为每个人报价。并创建一个数据框以继续分析

result= [['ABEV3.SA', 'AZUL4.SA', 'B3SA3.SA', 'BBAS3.SA', 'BBDC3.SA', 'BBDC4.SA', 'BBSE3.SA', 'BEEF3.SA', 'BPAC11.SA']

for t in result:
    ticker[t]=wb.DataReader(t, data_source='yahoo', start='2020-10-1')['High','Low','Open','Close','Volume','Adj Close']

KeyError:（“高”、“低”、“打开”、“关闭”、“音量”、“调整关闭”）

Answer 1

DataReader返回一个数据帧，因此您需要相应地访问数据单元

请尝试以下代码：

import pandas_datareader.data as wb

result= ['ABEV3.SA', 'AZUL4.SA', 'B3SA3.SA', 'BBAS3.SA', 'BBDC3.SA', 'BBDC4.SA', 'BBSE3.SA', 'BEEF3.SA', 'BPAC11.SA']

for t in result:
    x = wb.DataReader(t, data_source='yahoo', start='2020-10-1')  # return entire dataset for this stock
    print('\nStock =',t)
    print(x)  # print dataset
    print('First High =', x.iloc[0]['High'])  # get High column from first row
   

输出

Stock = ABEV3.SA
             High    Low   Open  Close    Volume  Adj Close
Date
2020-10-01  12.78  12.48  12.55  12.70  20845400      12.70
2020-10-02  12.83  12.53  12.61  12.53  18790500      12.53
First High = 12.779999732971191

Stock = AZUL4.SA
                 High    Low   Open      Close    Volume  Adj Close
Date
2020-10-01  26.080000  24.83  25.32  25.700001  20951400  25.700001
2020-10-02  25.559999  24.25  25.40  24.270000  14473800  24.270000
First High = 26.079999923706055

........