Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Trade Watchlist using Python

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