Pull Stock Data & Export It To Excel Using Python

Category: Excel Automation

A quick way to pull stock data using Python

import pandas_datareader as web
from datetime import datetime
import pandas as pd

start = datetime(2020,1,1)
end = datetime(2021,2,28)
ticker = 'TSLA'

df = web.DataReader(ticker,
                    'yahoo',
                    start,
                    end)
df.to_excel('stockdata.xlsx')