Generic bond transaction import

[BradN]

Hi Mark,

I am trying a generic import of a bond transaction and would like to capture the accrued interest. I am breaking the SELL into 2 transactions...the first for the clean (w/o acc'd int) sale, the second for the acc int.


ACCT CUSIP SYMB ED BNUM TRAN ANUM CNUM MEMO
7013 373298BE7 CB98BE7 20100511 100 SELL 106.5 10 BLAH
7013 CASH CASH 20100511 DIST_I 430.14 0 0 AccInt

The CASH acct then only reflects the $10,640 (sale less comm) and not the acc'd int. Am I taking the right approach to this? How would I tie the acc'd int to the bond sale?

Thanks in advance,

Brad

PS... sorry for the lousy formatting, please find attached csv

[Mark]

Hi Brad,

Instead of recording the DIST_I transaction directly into CASH, record it for the bond itself. The bond is the investment that paid the accrued interest (not the CASH account), so that is where the transaction should be recorded. If you have a default cash account assigned the interest received will automatically be recorded as a purchase of cash. The bond had the interest payment, and the proceeds were deposited into cash. For example, use:

ACCT,CUSIP,SYMB,ED,BNUM,TRAN,ANUM,CNUM,MEMO
7013****,373298BE7,CB98BE7,20100511,100,SELL,106.5,10,UNSOLICITED ORDER
7013****,373298BE7,CB98BE7,20100511,0,DIST_I,430.14,0,Accrued Int

[BradN]

Worked great. Thanks, Mark.

In your dealings with Scottrade, have you come across a list of their transaction descriptions? I would love to know the exact difference between "RED17" and "RED."

Brad

[Mark]

Hi Brad,

Are you importing their institutional file formats (*.TR1)? If so, you can do this in the Advisor version under "File / Import / Transactions / Scottrade...". It will be a lot easier than trying to convert to the generic format.

The "RED17" is a "system generated redemption", where "RED" is just a "redemption".

[BradN]

Yes, using TR1. I would much rather import your way, unchecking the Bond transactions (I have to accrue the int for GIPS), however, I ran into about 100 transactions that FM didn't like. So I thought I would invest the time to macro-ize the process.

Some examples are option assignments, bonds called and partially called, NWX22's and NWMRG's (whatever these are). I could get you a complete list if you like.

[Mark]

Hi BradN,

If you want to email us some sample .TR1 files that have non-supported transactions we can see about getting them supported. If you can also describe the transactions that may help us. You can just change the account number in the .TR1 file before emailing.

[atrooper0005]

I'd like to use the generic import function to add a list of bond purchases. I'm looking for the symbols to add the data found in the income properties tab --> Maturity Date; Coupon Rate; Payment Frequency and Day Count Basis. (As well as the other symbols already defined in the FM Generic Transaction Import Dialog page for the bond purchase information)

In an attempt to find the fields that FM uses for this data, I tried to export a sample that I hand entered to FM with the following attribute list:
NAME,SYMB,CUSIP,ED,ITYPE,TRAN,ANUM,BNUM,CNUM,CIP01,CIP02,CIP03,CIP04,CIP05,CIP06,CIP07,CIP08,CIP09,CIP10,MEMO,PORT,ACCT,IAMETH,IDESC,IACCT,ASSET

No joy on this approach. Can you tell me how to accomplish this import operation?
Thanks!
Ted

[Mark]

Hi Ted,

Unfortunately, the bond info like maturity date and coupon rate are not importable with the generic transaction import. These would be good to add, but they're not available today. The online help shows the documentation on all the available keys:

http://www.fundmanagersoftware.com/help ... neric.html