Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Captool Conversion & Splits

Questions about updating prices or transactions in Fund Manager

Postby ljbc01 » Fri Jan 27, 2017 12:23 pm

I am importing Captools data to Fund Manager using the Excel Template provided.

When the conversion runs against my Captools data SPLIT transactions are translated to:
DATE,SYMB,#N/A,#N/A,#N/A,CNUM,MEMO

i.e the TRAN,ANUM,BNUM fields are not translated. All others are correct.

The TRAN ids for splits in Captools are: SP+ SP-
How can I convert Splits?
Can you update the template to handle splits or do I have to do it manually (ugh!)?

Thanks - Lloyd
ljbc01
 
Posts: 20
Joined: Mon Feb 18, 2013 4:01 pm

Postby Mark » Fri Jan 27, 2017 2:03 pm

Hi Lloyd,

If you want to email us a sample data file you're trying to convert with some split transactions, along with an explanation of the split transactions (are they a 2 for 1, etc), we can update the template.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby ljbc01 » Fri Jan 27, 2017 5:16 pm

I have attached a file with Captools Split transactions including an explanation of each transaction.

- Lloyd
Attachments
Captools Sample Split Xactions.csv
Sample with explanation - hope this is useful
(2.12 KiB) Downloaded 235 times
ljbc01
 
Posts: 20
Joined: Mon Feb 18, 2013 4:01 pm

Postby Mark » Mon Jan 30, 2017 11:31 am

Hi Lloyd,

Thanks for the sample. We've updated this conversion template, and posted the update here.

You should see the split transactions supported. If not, make sure you see the revision 2 item listed under the Revision History section on the "Mappings" sheet.
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 Prices and Transactions

Who is online

Users browsing this forum: No registered users and 20 guests

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