I've been thinking to build an excel based trade watchlist using S&P 500 pairs. But, don't know where to start in Python.
Below is what I'm looking at to build
1. Once I have my view at a macro level, industry level then identify stocks in cyclical and defensive sectors.
2. Then, identify the pair stocks (as many as) and generate the price actions over a 1 week to a 3-week time frame.
The excel trade watchlist should be automated in such a way that the prices are updated on a weekly basis whenever I a. either run the python program b. open the excel.
Can anyone help me with this?
Thanks
Joe from Singapore