Below you will find a link to a Google Sheet.
We have added cumulative/non cumulative as well as qualified/non-qualified to the sheet since we last gave you a peek at this sheet.
We are calling this sheet Version 12132019–obviously because that is todays date. There are 672 issues on the sheet and should include most all $25/share preferreds and baby bonds as well as some miscellaneous. There are some convertibles not here, nor illiquids as we can’t get reliable quotes on some of these issues.
TO USE THIS SHEET YOU NEED TO HAVE A GOOGLE ACCOUNT SO THAT WHEN YOU OPEN THE LINK BELOW IT WILL TRANSFER TO YOUR ACCOUNT.
YOU MUST THEN RENAME THE SHEET.
IF YOU DO NOT COPY AND RENAME YOU WILL BE USING THE MAIN MASTER SHEET. UNFORTUNATELY IF A BUNCH OF FOLKS DO THIS YOU WILL FIGHTING EACH OTHER (I.E. YOU DO A SORT–THEN SOMEONE ELSE DOES A DIFFERENT SORT–THEN A 3RD PERSON DOES ANOTHER–ALL AT THE SAME TIME–YOU WILL BE SEEING RESULTS OF OTHER FOLKS).
I am already working on the next VERSION, which I should have in a month. This means that a few new issues will be missing as I add a number of them every week (and I delete called issues).
Be aware that this spreadsheet has 3 separate sheets. I have ‘hidden’ 2 of them. The one showing is where you do the filtering parameters. If you want to make your own changes, after you copy the sheet, you can do so by going to View, Hidden Sheets, Alpha. The Alpha page is where you can make changes. I would strongly suggest not changing the sheet titled ‘list’.
If you try to make changes on the filter sheet it will break–just ‘undo’ to fix it.
Unless you are familiar with scripting etc and you fool around and break it bad–no problem, just come back and get a new copy.