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
#9
Stock tickers are returned as a list. So there is no need to use pandas if only requirement is to write tickers into file, vanilla Python is good enough.

Following code creates combined list of tickers and writes list into file so that every ticker is on separate line:

tickers = [*si.tickers_nasdaq(), *si.tickers_other()]

with open('tickers.csv', 'w') as f:
    print(*tickers, sep='\n', file=f)
I'm not 'in'-sane. Indeed, I am so far 'out' of sane that you appear a tiny blip on the distant coast of sanity. Bucky Katt, Get Fuzzy

Da Bishop: There's a dead bishop on the landing. I don't know who keeps bringing them in here. ....but society is to blame.
Reply


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

Possibly Related Threads…
Thread Author Replies Views Last Post
  Exporting Stock Fundamental Data to a CSV file with yahoo_fin DustinKlent 2 4,871 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,240 May-03-2022, 05:46 PM
Last Post: ahmedbarbary
  Yahoo_fin, Pandas: how to convert data table structure in csv file detlefschmitt 14 8,125 Feb-15-2021, 12:58 PM
Last Post: detlefschmitt
  Skeleton file export error Python Code pepapoha 4 3,652 Nov-17-2020, 02:06 AM
Last Post: pepapoha
  Python Export Question Below samlee916 1 1,636 Jul-07-2020, 12:22 PM
Last Post: Larz60+
  export file and display cmd prompt same time jacklee26 1 2,105 Jul-24-2019, 05:15 AM
Last Post: Larz60+
  [PYTHON EXPORT SQL TO .txt file] PYTHONDUDE 9 24,802 Feb-21-2018, 08:54 PM
Last Post: nilamo
  Need help to open PDF file and Export to text file ratna_ain 3 7,171 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