All Time Most Popular
How do I find a stock’s date of death value? When a client passes away, most likely you’ll be asked for the valuation of the estate on the date of death. Can you retrieve this information from PortfolioCenter?
Why is there a positive Dollar Gain and a negative Time Weighted Return? Or vice versa? A positive Dollar Gain and a negative Time Weighted Return (or vice versa) occur more frequently than you might expect. Here's how it happens.
What’s the difference between Time Weighted Return and Internal Rate of Return? PortfolioCenter provides two main performance calculations: Internal Rate of Return (IRR) and Time-Weighted Rate of Return (TWR). What's the difference?
Time Warner Cable merger with Charter Communication Inc On May 18, 2016, Charter Communications, Inc. (CHTR) merged with Time Warner Cable Inc (TWR). If you have clients that held CHTR prior to the merger you need to handle this stock split a little differently.
SEC Audit: Producing a trade blotter When the SEC Auditor knocks on your door, one item he will request is a spreadsheet containing a trade blotter for the time period under review. The easiest way to retrieve this information is using the Export Wizard.
Switching to Schwab Tax Lot Optimizer With the new matching method called "Tax Lot Optimizer", you can produce the smallest capital gain or largest capital loss when selling positions. Here's how to switch.
Aloca (AA) spinoff Arconic (ARNC) On November 1, 2016, Alcoa Inc became two companies. The original Arcon shares (AA) became Arconic Inc (ARNC). Then ARNC spunoff a new Alcoa Corp (AA). Great news for investors, but a headache for PortfolioCenter users.
How much does Schwab’s PortfolioCenter cost? PortfolioCenter is worth the cost, especially considering what it does for you. But if you truly can't afford the cost yet, you still have options.
Cost basis adjusted, now what? Broker says: "Cost Basis Adjusted. No Action Required." But the cost basis in PortfolioCenter no longer reconciles with the broker. Now what?
Google Name Change and C Shares spinoff The Google stock dividend changed the historic symbol, creating a problem for PortfolioCenter users. Here's help.
Trending Now
- How do I find a stock’s date of death value? When a client passes away, most likely you’ll be asked for the valuation of the estate on the date of death. Can you retrieve this information from PortfolioCenter?
Schwab Account Type Codes Confused about what the codes mean in the Schwab account type field? Here's the list.- Switching to Schwab Tax Lot Optimizer With the new matching method called "Tax Lot Optimizer", you can produce the smallest capital gain or largest capital loss when selling positions. Here's how to switch.
- SEC Audit: Producing a trade blotter When the SEC Auditor knocks on your door, one item he will request is a spreadsheet containing a trade blotter for the time period under review. The easiest way to retrieve this information is using the Export Wizard.
How does Schwab process Tax Lot Optimizer? Need some help understanding how Schwab processes trade lots when using the Tax Lot Optimizer? The method takes losses before and gains.- Why is there a positive Dollar Gain and a negative Time Weighted Return? Or vice versa? A positive Dollar Gain and a negative Time Weighted Return (or vice versa) occur more frequently than you might expect. Here's how it happens.
Understanding the 5 Matching Methods in PortfolioCenter The matching method you select for closing transactions greatly influences cost basis and your clients' taxes. Make sure you understand the 5 options available in PortfolioCenter.
Explain the Contributions and Withdrawals on my PortfolioCenter performance report The client insists he didn't withdraw that much money from his accounts. How do you verify net contributions on your PortfolioCenter performance reports?
Importing a Generic index file into PortfolioCenter Since the demise of InvestmentView on 3/31/2019), you may be scrambling to import index figures into PortfolioCenter. If you can find the numbers, you can use the generic import to get the numbers into your PortfolioCenter database. Here's how to do it. Create a Import File You will need a source for the numbers Excel or a spreadsheet program that can export to a TXT file format The file format is Column A - Symbol Column B - Description Column C - Beginning Date Column D - Ending Date Column E - Return (in decimal format) The first line of the file is a header row. PortfolioCenter will ignore it, so you can use it for column headers. The returns should be in decimal, not percentages. If your source says the return is 2.5, divide by 100 and enter 0.025 in your data column. That will import as 2.50%. If you're using Excel, save this spreadsheet as Text (MS DOS) .TXT Import the file into PortfolioCenter Open PortfolioCenter and go to the Securities Tab From the menu bar, select Tools, Import Index Returns, Generic File format. In the window that opens, enter the dates and browse to your TXT file. Import Check your data to make sure it imported properly. Photo by Everton Vila on Unsplash - Time Warner Cable merger with Charter Communication Inc On May 18, 2016, Charter Communications, Inc. (CHTR) merged with Time Warner Cable Inc (TWR). If you have clients that held CHTR prior to the merger you need to handle this stock split a little differently.
