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
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Ra