UnThreaded | Threaded | Whole Thread (3) | Ignore Thread Prev Thread | Prev | Next | Next Thread
Author: joelcorley Big gold star, 5000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 35506  
Subject: Exchange-Traded Debt Spreadsheets Date: 11/24/2009 5:08 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 2
Fools,

If anyone is interested, I've created a few additional spreadsheets based on the QuantumOnline data and the template I put together earlier. I thought that it might be past-time to post them.

They list security issues for a given issuer. You might find them interesting in part because the symbols are fixed and so Google Docs will let you sort them based on Yield or YTM.

Ford: http://spreadsheets.google.com/ccc?key=0ArC7PlrDoTbpdHFzTGh6...
Wells Fargo: http://spreadsheets.google.com/ccc?key=0ArC7PlrDoTbpdHFpTDFP...
Bank of America: http://spreadsheets.google.com/ccc?key=0ArC7PlrDoTbpdEdCa2xZ...
Motorola: http://spreadsheets.google.com/ccc?key=0ArC7PlrDoTbpdGk3VzRT...
CBS: http://spreadsheets.google.com/ccc?key=0ArC7PlrDoTbpdDlDMmpR...
ING: http://spreadsheets.google.com/ccc?key=0ArC7PlrDoTbpdFZleEYw...
Fifth Third Bancorp: http://spreadsheets.google.com/ccc?key=0ArC7PlrDoTbpdExxWUg0...

Obviously others are possible; but these are some of the issuers I hold, so I had an interest in constructing these sheets to compare my holdings against alternatives and to examine the price of alternative obligations from the same issuer.

I've frozen the titles and the columns to make it easier to browse the content. Also, if you hover the cursor over row split, you'll notice that there is a "Sort" feature that will let you sort the table by that field - either ascending or descending.

I still haven't worked up the YTW calculation ... which would be nice. There are other things that need doing here too.

- Joel
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (3) | Ignore Thread Prev Thread | Prev | Next | Next Thread

Announcements

Post of the Day:
Macro Economics

Middle East Friends?
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.
Advertisement