NOTE THAT NEW VERSIONS HAVE CALLED ISSUES REMOVED AND NEW ISSUES ADDED
Please NOTE that this will not work with EXCEL only Google Sheets.
- You need a Google Account to use this sheet correctly. Go here to set up an account if you do not have one. While an account gives you gmail and other apps it importantly gives you an account for accessing and using Google Sheets.
- After creating an account with Google make sure you are signed in.
- Go the the sortable spreadsheet which you can find here.
- Once you open the spreadsheet as long as you are logged into your Google account the spreadsheet will automatically be in you spreadsheet list.
- You will see that when you open the spreadsheet it will say ‘view only’.
- Make a copy of the sheet for yourself–go to File, Make a Copy then give it the name you want.
- You will now be able to use own copy to sort etc.
Note that there are 3 sheets to the spreadsheet–I have hidden 2 which are not needed by you unless you wish to make changes. The tab you need is labeled “Filter”.
Unless you are very well versed in Google Sheets I would suggest not modifying the other 2 pages–BUT if you are like me and just can’t help yourself you can always come back here if you ‘break’ the sheet.
What’s up with the Sortable Sheet? Used to just download. Now shows as needing to request access? I requested yesterday, no access yet. I’m OK waiting if that’s how it’s supposed to work, or is this something broke/not working right? Thanks for making the sheet available and updating.
TAP-TAP-TAP…. is this mike on? TAP-TAP-TAP
See #3 line in instructions above. I clicked on it and the spreadsheet simply opened. * You need to be signed into your GOOGLE account. Hope this helps.
Must have been fixed as I was clicking on #3, had a pop-up to request access. Now opens the spreadsheet. Thanks
Not sure the correct place to post this item.
On the page entitled “Floating Rate and Fixed-to-Floating Rate Preferred Stocks”, I was looking at AGNCO. It lists the spread over 3mL as 4.332%. In fact, the spread over 3mL is 4.993%. (I believe the reason for the typo is that AGNCM has a spread of 4.332%, which is listed correctly on the same page).
Thanks
While I’m on nitpicks, I see the potential coupon for NLY-F listed as 8.633%. I’m confident that the dividend determination date is 9/29 at 11am London time. When I look at the history of libor pricing on web pages, I see 3.74286% as the 3mL rate on 9/29. That would suggest a coupon of 8.735%. I think 8.633% is based upon the 9/28 3mL rate. But maybe the popular web based rates shift the date because of the time difference? Just wondering which is correct? Thanks
Hi Tim, May have missed it though not seeing GDV-H on the CEF sheet. Thank you!
Hi Tim, Brightsphere Investment, ticker BSA, should be removed from sheet.
AGNC’s newest preferred should be added. Just tagging along to Mr. C’s comment.
FWIW, AFSIN listed twice in the spreadsheet with differing data and missing AFSIA and AFSIM.
Thanks Theo
Tim,
Just a reminder of calls, effective today/tomorrow of securities on the master list: DRUA, SAF, UZA, TDI.
Thanks!
Got it A4I–Thanks
Tim,
Would you like a list of 40+ big board symbols that are not in the list?
Hello,
great site, thanks for sharing this valuable resource.
The ex-Dividend Calendar file link seems to no longer work.
https://docs.google.com/spreadsheets/d/1aCoOrYNMlNr2z8uMhMn–ENKyQcYA8HZZzuzO-w6TWw/edit#gid=278372155
Is it still available?
Thank you
Tim, do you want suggestions for improvement added on this page, or at https://innovativeincomeinvestor.com/sortable-spreadsheet/ ?
Bur.
Bur–sure I always look for suggestions–but with the caveat that I would 60-70 hours a week right now at my “real job” so my ability to spend great amounts of time ‘renovating’ right now are real limited. Also I paid a google sheets expert to build the original version and I no longer have a ‘sheets’ expert–just my old brain.
Okay, I’ll put comments/corrections to the sheet here (as a new comment) as I have them, for you to address as and when you have the time.
Had no trouble opening it…just reduced it to 90% so all the columns fit on the screen.
Only problem, wanted to save it to my documents…couldn’t do it.
Ron–you should have no problem saving it as long as you have a google account–all the instructions are on the page–https://innovativeincomeinvestor.com/sortable-spreadsheet-new-instuctions/
Where can i find $50-100 master list ? Thank You ?
Nikolas—I keep a sheet here
https://innovativeincomeinvestor.com/50-and-100-preferred-shares/
It is an ongoing ‘project’