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
#3
Thanks for the reply. I ran your program and understand the output. That is not what I was asking for.

In the Yahoo_fin script I posted above the script line below imports stock_info. The subsequent script then extracts various information from the imported stock_info and exports them. More specifically it exports for each ticker the values of 59 stat types to csv.

from yahoo_fin import stock_info as si
So far so good. That is working fine and is very useful.

What I am looking for is a script that exports the ticker symbols only from the imported stock_info. Exports all tickers symbols in Stock_info, without having to enter the ticker names in the script. I would like to have a script that results in the below csv output. I only list a few tickers to illustrate. Presumably the output will contain several hundred tickers. So, I want to dump all tickers symbols in stock_info to csv.

Output:
AACG AACQU AACQW AAL AAME AAOI AAON AAPL AAWW AAXJ
On the Yahoo_fin documentation page, see link below, I found links to the websites that have the ticker symbols.
http://theautomatic.net/yahoo_fin-documentation/
Look at explanation for tickers_nasdaq(), tickers_dow(), tickers_nifty50(), tickers_other(), tickers_sp500()

I manually extracted the ticker symbols from these websites, compiled them to one list in Excel and compared them to my own ticker list. That way I was able to find the tickers that are no longer listed and not contained in stock_info. Tickers that are not in stock_info cause the above yahoo_fin script to return an error message. I ran into this problem when I ran the above yahoo_fin script with my several hundred tickers. After I had the unlisted tickers removed from my my ticker list I did not get an error message any longer and was able to export the stats for several hundred tickers at once.

Exporting the ticker symbols manually from several websites is a workaround to solve my problem. However, easier would be if I could just dump the ticker symbols from stock_info. I don't know if that can be done.

Maybe the tickers can be exported using tickers_nasdaq(), tickers_dow(), tickers_nifty50(), tickers_other(), tickers_sp500(). I don't know. I am a newbie to yahoo_fin.
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, 01:20 AM

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