René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Why my python (Spyder) got stuck (i.e. did not return result) when I was trying to run the code of retrieving stock data from yahoo finance","articleBody":"I have a list of US stocks ( around 3000 stocks) in excel and I want to get the stock price and other related daily stock info on each stock in certain time period. So I wrote a for loop to get all related stock info on each stock ( and I have tried both yahoo_fin.stock_info and yfinance packages). But then it just got stuck at certain stock and never return the result. I am using spyder for my python coding. below is the code:\r\n```\r\nimport pandas as pd\r\nimport numpy as np\r\nimport yahoo_fin.stock_info as si\r\n\r\nticker_list = pd.read_excel(r'C:\\Users\\user\\Desktop\\ticker_list.xlsx',engine=\"openpyxl\")\r\n\r\nn=[]\r\net=[] \r\ndf_empty=[]\r\nfor i in range(len(ticker_list)): \r\n    try:\r\n        df = df_empty[0:0]\r\n        df=si.get_data(ticker_list.iloc[i]['ticker'], start_date='2021-09-30', end_date='2022-04-25') \r\n# I used yf.download for using yfinance package\r\n        mkt_cap=si.get_quote_table(ticker_list.iloc[i]['ticker'])[\"Market Cap\"]\r\n        df.insert (7,\"mkt_cap\",mkt_cap) \r\n        print(ticker_list.iloc[i]['ticker'])\r\n        df.replace(np.inf, np.nan)        \r\n        df = df.dropna()\r\n        df.reset_index(inplace=True)   \r\n        n.append(df)   \r\n    except:\r\n        et.append(ticker_list.iloc[i]['ticker'])\r\n        print('error: ' + ticker_list.iloc[i]['ticker'])\r\n        pass\r\nprint(n)\r\n```\r\nwhen I run the code below what it shows in my console:\r\n\r\n```\r\nPython 3.8.13 (default, Mar 28 2022, 06:59:08) [MSC v.1916 64 bit (AMD64)]\r\nType \"copyright\", \"credits\" or \"license\" for more information.\r\n\r\nIPython 7.31.1 -- An enhanced Interactive Python.\r\n\r\nrunfile('C:/Users/USER/get_all_stock_data.py', wdir='C:/Users/USER')\r\nBYDDY\r\nCHTR\r\nJD\r\nKYCCF\r\nRY-PT\r\nGE\r\nBP\r\nMO\r\nVLKPF\r\nSMAWF\r\nAMAT\r\n```\r\n\r\nI tired many times already , everytime it just stuck on different ticker everytime. Also I have also tried to leave the code running for a day but it just stop it right there and never give me return. when I tried to debug, it also stop running at either the si.get.data line or si.get_quote_table line. I actually use this code since last year and it work fine, it just start not working when I run this code again last week. I also tried several other packages ( e.g. pandas_datareader.data) still not able to get the stock info. Appreciate if anyone can let me know what is the problem.\r\n","author":{"url":"https://github.com/kk0186","@type":"Person","name":"kk0186"},"datePublished":"2022-04-29T09:49:27.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/1/SimpleStockAnalysisPython/issues/1"}