Working with Direct Interfaces or Data Aggregators
Data can be entered into PortfolioCenter manually, or it can be downloaded from a brokerage firm, custodian, or mutual fund company. In this section, you can learn how to work with various custodial interfaces to download and post data into PortfolioCenter.
Converting and Posting Interface Files
Posting data from the interface files is the quickest and easiest way to get data into your database. Each data provider gives you data in their own format, and then you convert the data into a format that PortfolioCenter can read. From there, you post the data into the PortfolioCenter database and then you can reconcile your data.
- File Status Codes
- Convert and Post Security Files
- Convert and Post Price Files
- Convert and Post Portfolio Files
- Converting and Posting Portfolio File Updates
- Handling Position Files
- Deciding How to Handle Initial Positions
- Convert and Post Transaction Files
- Using the Interface Error Report
- Identifying Corporate Action Transactions in Your Interface
- Interface file conversion troubleshooting
Reconcile Your Data
Reconciliation is one of the most important steps in your day-to-day interface operation. The reconciliation process verifies that the data you have just posted into the database is correct and complete. Reconciliation compares cash and share quantities in PortfolioCenter with the quantities on record at the custodian.
Share Reconciliation
- What Is Share Reconciliation, and Why Is It Important?
- Running the Share and Cost Basis Reconciliation Reports
- Understanding the Share Reconciliation Report
- Share Reconciliation Tips and Best Practices
- Customizing the Share Reconciliation Report
- Working with Missing Portfolios on the Interface Share Reconciliation Report
- Understanding the Shares Reconciled Field
- Interface Reconciliation Troubleshooting
Cost Basis Reconciliation
Morningstar ByAllAccounts Interface Files
DST FAN Mail Interface Files
Fidelity Interface Files
Pershing Interface Files
Interface Files
- Downloading Files Using SchwabLink
- Scheduling the Daily Download using Schwablink
- Downloading Files Using Schwab Data Delivery
- Scheduling the Daily Download using Delivery
- Working with Interface Files
- Archiving Interface Files
- Charles Portfolio File Fields
- Best Practices to Reconcile to 5 Decimal Places after Converting to the Enhanced Files
TD Ameritrade (Former TD Waterhouse accounts) Interface Files
- Working with Interface Mapping Tables
- DST FAN Mail Interface Settings
- Fidelity Interface Settings
- Pershing Interface Settings
- Working with Morningstar ByAllAccounts Interface Files
- Working with Interface Files
- TD Ameritrade (Former TD Waterhouse accounts) Interface Settings
- Adding a Second TD Ameritrade File Path