Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Bond Amortization and the Generic Transaction Interface

Questions about updating prices or transactions in Fund Manager

Postby dlevy » Fri May 16, 2014 5:36 pm

I'm trying to import bond amortizations through the Generic Transaction Interface.

To verify the how to code it, I did a bond amortization through the FM UI and did a generic file export. The amortization created two transactions:

[symbol] [date] DIST-4 -100.00 0 0 # records as amortization
[symbol] [date] DIST-R 100.00 0 0 # records as return of capital

So, I followed these as models in formatting data exported from another portfolio management package. The DIST-R transaction imported correctly. The DIST-4 did not import at all.

My format string is SYMB,ED,TRAN,ANUM,BNUM,CNUM

Sample data:

544644QL4,20090701,DIST_4,-46.63,0,0
544644QL4,20090701,DIST_R,46.63,0,0

I note that the documentation for the generic file import (http://www.fundmanagersoftware.com/help ... neric.html)
does not document the DIST-4 transaction, but mentions only user-defined DIST-1 and DIST-2.

Should I be able to import a DIST-4 transaction?

Am I doing something else wrong?

With thanks,

David
dlevy
 
Posts: 72
Joined: Tue May 13, 2014 4:42 pm

Postby Mark » Fri May 16, 2014 6:12 pm

Hi David,

That looks like a bug in the generic export. We used to have 4 user-defined distribution types, but the last 2 were changed to be used for accretion and amortization. Change DIST_4 to DIST_T, and then that should import properly. (DIST_3 should be DIST_A for accretion)
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby dlevy » Fri May 16, 2014 6:22 pm

Yes!

That works perfectly.

Thanks, Mark!

David
dlevy
 
Posts: 72
Joined: Tue May 13, 2014 4:42 pm


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 13 guests

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