We were asked to try to present a new spreadsheet based on the ‘Master List‘ that would present the data in a format similar to our “preferred stock by near new lows’. Thus we would have a listing of over 600 issues sorted in a real time fashion that are either at or within 1% of a new 52 week low.
Our challenges are that in order to do that we need to have the 52 week low and 52 week high data and as everyone who has messed around trying to get decent data knows when dealing with the baby bonds it can be a real challenge.
So with the exception of 5 issues (5 won’t work–out of 633 right now) we have posted the new page under the “All Preferreds” tab up on the menu.
We have created a spreadsheet that opens in the Google sheets fashion–thus anyone who wants a copy can copy and it will update as I make changes. Just be aware that if I make a name or file change your copy will STOP updating as issues are added. I would suggest simply ‘bookmarking’ the spreadsheet if you want to access on a regular basis.
Here is the link for the spreadsheet. 1 or 2 seconds of patience may be required depending on your internet speed–there is a lot of data on these pages.