Subject: Re: Bogle , back to the real world,
Is there a trading platform that would make doing something like this easier and possibly automated?
Well, you'd have to figure out the picks. But once you've done that, sure.
For example, Interactive Brokers has a feature that you can upload a spreadsheet (actually CSV I think) with tickers and it will redo your portfolio to be what's in the list in more or less one step. I think it's used a lot by managed account folk to set client accounts to match model portfolios. Perhaps more common, you can apparently also export the current portfolio allocations, adjust them, then re-import them to get it balanced to the weights you want.
I imagine some other brokers have similar features.
For doing the picks, I've generally used an ancient Excel macro done by someone on the Mechanical Investing board, now sadly passed away. You can import a stock price/fundamentals database from Value Line or Stock Investor Pro (or elsewhere, if you have it in tab delimited format), then stock screens are programmed in a mostly intelligible way as blocks in a different spreadsheet. But if the criteria you want to use are simple enough you can do it "manually" by just pulling, say, stock price + ticker + ROE from some database into an Excel sheet. I've done that a lot too. It depends how complicated your stock selection criteria are.
One tip: do NOT use an up to date list of S&P 500 constituents as your "universe" of eligible stocks. The easiest free money in the world is using the list from 6-12 months earlier, which means you include things that have been ejected and skip those that are new entrants. If you duplicate the whole index with its own weights (but a stale list) you'll outperform the official index by quite a bit.
https://www.researchaffiliates...
"We find that, for the period from October 1989 through December 2017, additions outperformed the market, on average, by 523 bps over the period between announcement date and effective date. In contrast, we find that discretionary deletions (those not related to corporate actions such as a merger or acquisition) underperformed the market by an average of 429 bps over the grace period... From October 1989 through December 2017, the S&P 500 (not the index funds) would have performed 22 bps better a year if additions and deletions were effective immediately at the close preceding the announcement."
Jim