Error when trying to import stock exchange data (yahoo)

Asked Jan 19 '21 at 00:52

Active Jan 19 '21 at 17:22

Viewed 39 times

I have a problem when I try to import the historical data of each company in python. Here is my code :

import pandas as pd
import numpy as np
import requests
import pandas_datareader as web

import pandas_datareader as web
ticker = pd.read_csv("nasdaq_screener_1611015840705.csv")['Symbol']
df = pd.DataFrame

for symbol in ticker:
  df[symbol] = web.DataReader(symbol, data_source = 'yahoo', start = '2013-01-01', end = '2020-12-29')['Adj Close']

However, on the last line of code, I got an error :

picture of the error

My goal is to make something which looks like this :

picture here

edited Jan 19 '21 at 17:22

Trenton McKinney

56,955
33
144
158

asked Jan 19 '21 at 00:52

Santosh Passoubady

1

You can just do `df = web.DataReader(ticker.unique(), data_source='yahoo', start='2013-01-01', end='2020-12-29')['Adj Close']`. – Trenton McKinney Jan 19 '21 at 01:04
@TrentonMcKinneyThanks, should I keep the `for symbol in ticker: `? – Santosh Passoubady Jan 19 '21 at 06:46
No, you don’t need the loop. – Trenton McKinney Jan 19 '21 at 07:12
1

Thanks it helped me lot! – Santosh Passoubady Jan 26 '21 at 21:46

Error when trying to import stock exchange data (yahoo)

0 Answers0