Articles
Dividing a database
Eventually your PortfolioCenter database will grow too large. It’s a data graveyard: Data goes in but never comes out. At some point you may want to create a database to archive dropped clients and keep it separate from your production database. Here’s how to do it.
When NET framework breaks PortfolioCenter
Have you seen this error (or one like it) when using PortfolioCenter? I got this error when trying to use the Trade Lot Reconciliation Tool after Windows upgraded itself. Not only would the Trade Lot Reconciliation Tool fail, PortfolioCenter would crash instead of...
How to use the PortfolioCenter Account Transfer bulk upload
PortfolioCenter 5.17.100.1 brought us the ability to upload a CSV to select multiple accounts in the Transfer Wizard. Here’s how to use the new feature.
How to run the Realized Gain report for all taxable accounts
The easiest way to run the realized gain/loss report for all taxable accounts is to create a batch print job. After that you only need to update your settings each year.
2020 Stock Market Holidays
In 2020 The New York Stock Exchange will be closed for the following holidays: NYSE Holidays2020 DateDay of WeekNew Year’s DayJanuary 1WednesdayMartin Luther King, Jr. DayJanuary 20MondayWashington’s BirthdayFebruary 17MondayGood FridayApril 10FridayMemorial DayMay...
Resolving PortfolioCenter “insufficient memory error”
Have you seen this error when running a batch job in PortfolioCenter? It sometimes happens when batch printing Presentation Studio reports. Here's how to solve it. Restart your computer and then run the job again. This often solves the problem.If that fails, try...
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...
2019 Stock Market Holidays
In 2019 The New York Stock Exchange will be closed for the following holidays:
Adjust PortfolioCenter for National Day of Mourning
The US Stock Markets closed Wednesday December 5, 2018 as a national day of mourning for President George H.W. Bush. You need to adjust PortfolioCenter for unexpected market "holiday." For the most accurate Time-Weighted Rate of Return (TWR) and Internal Rate of...
How to handle the Scottrade conversion to Ameritrade in PortfolioCenter
With the marriage of TD Ameritrade and Scottrade, if you are have accounts at Scottrade, you need to update PortfolioCenter to the new Ameritrade account numbers February 26, 2018. You can do this quickly through the Data Manager using the update from CSV feature and the account map Scottrade provides.
2018 Stock Market Holidays
In 2018 The New York Stock Exchange will be closed for the following Holidays: NYSE Holidays 2018 Date Day of Week New Year’s Day January 1 Monday Martin Luther King, Jr. Day January 15 Monday Washington’s Birthday February 19 Monday Good Friday March 30 Friday...
How to handle a double income reclassification
If you keep cost basis in PortfolioCenter reconciled to your broker, February means income reclassifications. But what do you do when a fund issues an income reclassification and then issues another one a week later?
Get Started