Python Forum
Yahoo_fin question: how does one export all stock tickers to a csv file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Yahoo_fin question: how does one export all stock tickers to a csv file
#6
I found the solution. The below yahoo_fin script will export all ticker symbols in the NASDAQ to a csv file.

import pandas as pd
from yahoo_fin import stock_info as si
 
data = si.tickers_nasdaq()

df = pd.DataFrame(data)
df2 = df.drop_duplicates(subset=None, keep="first", inplace=False)
df2.to_csv(r'stats.csv')
Reply


Messages In This Thread
RE: Yahoo_fin question: how does one export all stock tickers to a csv file - by detlefschmitt - Feb-12-2021, 06:11 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Exporting Stock Fundamental Data to a CSV file with yahoo_fin DustinKlent 2 4,794 Aug-01-2022, 06:08 PM
Last Post: paulyan
  How to keep columns header on excel without change after export data to excel file? ahmedbarbary 0 1,201 May-03-2022, 05:46 PM
Last Post: ahmedbarbary
  Yahoo_fin, Pandas: how to convert data table structure in csv file detlefschmitt 14 7,935 Feb-15-2021, 12:58 PM
Last Post: detlefschmitt
  Skeleton file export error Python Code pepapoha 4 3,576 Nov-17-2020, 02:06 AM
Last Post: pepapoha
  Python Export Question Below samlee916 1 1,602 Jul-07-2020, 12:22 PM
Last Post: Larz60+
  export file and display cmd prompt same time jacklee26 1 2,072 Jul-24-2019, 05:15 AM
Last Post: Larz60+
  [PYTHON EXPORT SQL TO .txt file] PYTHONDUDE 9 24,470 Feb-21-2018, 08:54 PM
Last Post: nilamo
  Need help to open PDF file and Export to text file ratna_ain 3 7,114 Oct-10-2017, 01:44 AM
Last Post: ratna_ain

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020