I use macros extensively to automate the data collection and analysis. I could learn python to make the data collection easier but its only 10 min of work on a few websites so, meh...
As far as automating the picks process, I hesitate to build something that will do that. I like to be "close" to the data to make sure I see the trends and don't overlook an obvious play (or no play).