Hello Guys,
I am looking for help with my homework, as the code I have, I am not able to get 'Adj Close' price from yahoo finance, I am looking to add a new sheet to my excel with data of all the 'adj close' prices for my stock from yahoo finance. any help is appreciated
1) This works just for close price
2) This doesn't work just for adj price of the stock
I am looking for help with my homework, as the code I have, I am not able to get 'Adj Close' price from yahoo finance, I am looking to add a new sheet to my excel with data of all the 'adj close' prices for my stock from yahoo finance. any help is appreciated
1) This works just for close price
import pandas_datareader.data as pdr #company i am looking into Tickers = ['AAPL'] #the dates for my data start_date = '2003-01-01' end_date = '2018-12-31' panel_data = pdr.DataReader(Tickers,'yahoo', start_date, end_date) #the data i am looking for Close_Price = panel_data['Close'] Close_Price_monthly = Close_Price.resample("1m").ffill() Close_Price_monthly.to_excel('data_Close_Price.xlsx')I even tried a code just to extra 'adj close price' but it didn't work
2) This doesn't work just for adj price of the stock
import pandas_datareader.data as pdr Tickers = ['AAPL'] start_date = '2003-01-01' end_date = '2018-12-31' panel_data = pdr.DataReader(Tickers,'yahoo', start_date, end_date) Adj_Close = panel_data['Adj_Close'] Adj_Close_monthly = Adj_Close.resample("1m").ffill() Close_Price_monthly.to_excel('data_adj_close.xlsx')Picture of the data column i am trying to get for my stock