Bond portfolio ATR calculator

To calculate the annualized total return for each bond in a portfolio, and for the total portfolio,
paste spreadsheet data in the following format, one record per line, with tab-separated fields.
Or enter data manually (the Tab key works).  Date format, any separator: 

IDpurchase datematurity datecoupon ratecoupons per yearpar valuepurchase price

secondary rate: %
coupon reinvestment:

Please visit | blog