This article aims to provide a comprehensive understanding of the CSV upload process for adding portfolio holdings and save time when creating portfolios.
Adding Portfolio Holdings to the Template
When preparing your CSV file for upload, ensure you follow these guidelines for accurate data incorporation.
1. Utilize the Market Identifier Code (MIC) corresponding to the exchange. Here are some common examples:
- NASDAQ: XNAS
- NYSE: XNYS
- TSX: XTSE
**Provide the correct MIC for the respective exchange where your holdings are traded. Remember, ETFs and stocks require an exchange (MIC), while funds do not. **
2. Identifier:
- Use Ticker for Stocks (e.g., AAPL)
- Use code for Funds (e.g., MAW120)
3. Units:
Specify the number of units as a numerical value. Be attentive to this requirement for proper portfolio calculation. Bonds are not accepted in the template. If you have bond holdings, search and add them manually, or use a proxy.
Saving the Portfolio Upload File
Ensure the file is saved in CSV format to maintain compatibility with the upload process.
Uploading Your CSV File
Return to the CapIntel interface and proceed to upload your CSV file. This can be done by either dragging the file into the modal or selecting 'Upload' and locating the CSV file. Once added, click on 'Import.
Verification: The system will alert you if column headers are mismatched or if any issues are detected within the file.
Confirmation: Upon successful validation, the Portfolio Builder modal will appear, allowing you to confirm details or make necessary updates.
Successful File Upload
Upon a successful upload, the Portfolio Builder modal will appear. Here, you can confirm or make updates to your portfolio.
Unsuccessful File Upload
If there are issues with the file, such as incorrect column headers, the system will provide notifications.
Mapping Unfound Holdings
Holdings that cannot be found will be highlighted in red.
Utilize the Quick Search or Fund Screener to locate the fund or add a proxy.
Example Scenario One
Adding an ETF (e.g., VGRO) without a corresponding Market Identifier Code will trigger an error message. Utilize Quick Search to locate the holding efficiently. If you encounter an error due to missing Market Identifier Code, follow the instructions on the error message prompt.
Example Scenario Two
In case a holding is not found, the system will highlight the issue. Use the Quick Search to locate any missing holding.
By following the steps above, portfolio creation can be simplified for efficiency, particularly for portfolios containing many holdings. Our team will be happy to help with any further questions you may have on this feature.