Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Import Multiple SubFolio Accounts

General questions about using Fund Manager that do not fit into any other forum.

Postby csulbaran » Mon Aug 24, 2020 1:38 pm

Is there a way to import, from a CSV, multiple accounts with different portfolio hierarchies?
For example I'd like to import something like this:


Portfolio Hierarchy_________________Account Number________Portfolio Name
Top Level/Client 1/Client Account 1_____A12301 _________________Portfolio 1
Top Level/Client 2/Client Account 1_____A45601 _________________Portfolio 1
Top Level/Client 2/Client Account 1_____A45602 _________________Portfolio 2
Top Level/Client 2/Client Account 1_____A45603 _________________ Portfolio 3

If not what's the best way to do this for over 350+ new portfolio/sub-folios?
csulbaran
 
Posts: 1
Joined: Tue Aug 04, 2020 7:50 am

Postby Mark » Mon Aug 24, 2020 2:32 pm

Hi csulbaran,

You can't import only sub-portfolios. However, if you import transactions or positions assigned to non-existent sub-portfolios (based on account number), these sub-portfolio will be created for you (along with the investments and the transactions). Usually this is how you get started. Import the actual transactions/positions, and all the sub-portfolios will be created automatically. The sub-portfolios won't have any hierarchy, but you can arrange them manually after the import.

If you want to do this with a CSV file, I've attached a sample to this post. Use the "File / Import / Transactions / Generic..." command with the format string:

ACCT,TRAN,SYMB,ANUM,BNUM,CNUM,MM/DD/YY

for the attached sample.
Attachments
imptest.csv
Sample Generic Transaction Import CSV
(72 Bytes) Downloaded 183 times
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to General

Who is online

Users browsing this forum: No registered users and 17 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.