make simple watchlist from a running list of tickers with python?

admin

How to make simple watchlist from a running list of tickers with python?

I am trying to gather tickers that close above the previous day close from a small list of tickers during a specific time period using python?

I am coming up with No data based on my conditions written below but when I look manual I know the conditions are true for ABML on 12-7-21.

I can't seem to figure out what I am missing.

1. import datetime as dt
   
2. import pandas as pd
   
3. from pandas_datareader import data as pdr
   
4. import yfinance as yf
   
5. from tkinter import Tk
   
6. from tkinter.filedialog import askopenfilename
   
7. import os
   
8. from pandas import ExcelWriter
   
9. 
   
10. yf.pdr_override()
    
11. start = dt.datetime(2021, 11, 30)
    
12. now = dt.datetime(2021, 12, 15) # dt.datetime.now()
    
13. 
    
14. filePath = ('your file path')
    
15. 
    
16. stocklist = pd.read_excel(filePath)
    
17. stocklist = stocklist.head()
    
18. 
    
19. #*************************************************************************
    
20. 
    
21. exportList = pd.DataFrame(columns=['Stock', "Date", "Open"])
    
22. 
    
23. for i in stocklist.index:
    
24.     stock = str(stocklist["Symbol"][i])
    
25.     #RS_Rating = stocklist["RS Rating"][i]
    
26. 
    
27. try:
    
28.         df = pdr.get_data_yahoo(stock, start, now)
    
29. 
    
30.         PreviousClose = df["Close"][-1]
    
31.         CurrentClose = df["Close"][0]
    
32.         CurrentDate = df["Date"][0]
    
33.         CurrentOpen = df["Open"][0]
    
34. 
    
35.         # Condition 1: Explain your criteria
    
36.         if (PreviousClose < CurrentClose):
    
37.             cond_1 = True
    
38.         else:
    
39.             cond_1 = False
    
40.         # Condition 2: Explain your criteria
    
41.         if (PreviousClose < CurrentClose):
    
42.             cond_2 = True
    
43.         else:
    
44.             cond_2 = False
    
45. 
    
46.         if (cond_1 and cond_2):
    
47.             exportList = exportList.append({'Stock': stock, "Date": CurrentDate, "Open": CurrentOpen}, ignore_index=True)
    
48. 
    
49. except Exception:
    
50.     print("No data on " + stock)
    
51. 
    
52. 
    
53. print(exportList)
    
54. 
    
55. newFile = os.path.dirname(filePath) + "/ScreenOutput.xlsx"
    
56. 
    
57. writer = ExcelWriter(newFile)
    
58. exportList.to_excel(writer, "Sheet1")
    
59. writer.save()

複製代碼