Why Move
Two reasons, one I’ve outgrown Fidelity and I’ve become tired of not having access to data that I want to analyze my portfolio. Specifically PEG ratio. The other was Fidelity added a $100 transaction fee for buying and selling Roudhill Investment Trust ETFs like YBTC because Roundhill wouldn’t revenue share with them. Fidelity also has poor Excell integration and no realtime integration so there is no way around it. You can export your portfolio to csv but that is about it.
Migration
Creating the account took over a week as the automated systems found some issue with me having a prior account decades ago (we think that was the issue). So I had to go to the Schwab office in person and drop off the forms in addition to letting them photo copy my licenses as proof of Id.
After about 3 days my account was supposedly created but I had to call customer support to get it activated which they needed to get approval from a higher level manager. That took an hour and I was able to login.
Once logged in, it was easy to create IRA and Roth IRA as well as submitting the forms online to move my Fidelity to Schwab. The process took 4 or 5 business days and my positions were inaccessible during the move for 2-3 business days. It was over a holiday period so your mileage may vary.
The positions did transfer with cost basis and lot details which is great for tax purposes.
Portfolio Analysis
In addition to the YBTC issue where Fidelity is charging $100 transaction fee for Roundhill ETFs the other reason was to have access to better tools for portfolio analysis. Fidelity and Schwab have great tools for figuring out what to buy but they don’t have great tools for determining when or what to sell.
That being said Schwab does have real time integration with Excel that Fidelity does not. You can do a fair bit of cool things with this but it’s still far from what I what I expected. For example you can compute in Excel % of account that a given holding is. Fidelity has this out of the box, Schwab does not. % of account is useful to know when to sell if you follow the rule to never own more than 5% of any given individual stock.
Also Schwab has a billion (yes I’m exaggerating) more column options both in their website and tooling (think or swim) app. However I’m not smart enough to know why I would use over 65% of them.
Schwab’s integration with Excel is via the RTD function for example if you wanted the PE ration for a given position you would use =RTD(“tos.rtd”, , “PE”, $A30), the third parameter is the column you want “LAST” would give you the current price for the position.
The list of exportable columns in the documentation do not have a description on the web page so it’s hard to know what some of them are if you are not in the know. The list also doesn’t have EPS (earnings per anything actually) that I can find. I tried “EPR Lower” and “EPR Upper” but they returned nothing.
All in all its still very hard to analyze my portfolio without paying for another service to pull data from.
Also another drawback – with Excel I would have to update the spreadsheet every time I add new positions or remove positions.
Bottom Line
Bottom line it’s very hard in Schwab to evaluate my portfolio so I know what and we to sell. Complex formulas like RSI (Relative Strength Index), Debt to Equity Ratio I haven’t even tried yet as basic things like PEG are too difficult.
However at least they have some Real time integration and support via Excel.
Recent Comments