{"id":239,"date":"2012-11-05T16:52:42","date_gmt":"2012-11-05T21:52:42","guid":{"rendered":"http:\/\/konkin.com\/blog\/?p=239"},"modified":"2012-11-06T15:01:15","modified_gmt":"2012-11-06T20:01:15","slug":"russell-2000-membership-list-updated","status":"publish","type":"post","link":"http:\/\/konkin.com\/blog\/russell-2000-membership-list-updated\/","title":{"rendered":"Russell 2000 Membership List in Spreadsheet format (updated)"},"content":{"rendered":"<p><a title=\"Russell 2000 membership list\" href=\"http:\/\/konkin.com\/blog\/?p=207\">My last post<\/a> on the membership list generated some positive feedback, but it appears that it needs an update.<\/p>\n<p>I'm posting the steps I took to convert the index's PDF-only list to an Excel spreadsheet in case anyone else would like to have a go at updating in the future...<\/p>\n<p><!--more--><\/p>\n<p>1. Download and open the <a href=\"http:\/\/www.russell.com\/indexes\/data\/fact_sheets\/us\/Russell_2000_Index.asp\">Rusell 2000 membership list<\/a> in Adobe Acrobat Reader.<\/p>\n<p>2. Do an Edit\/Select-All and Edit\/copy to the clipboard.<\/p>\n<p>3.\u00a0 Open an new Excel (or on my case OpenOffice Calc) spreadsheet, and Edit\/Paste the contents of the clipboard to the blank sheet. You should get a column full of company names and ticker symbols combined into a column of single cells.<\/p>\n<p>4.\u00a0 To extract the symbol (basically the last word of the cell), use the following formula in a new column to the right:<\/p>\n<p style=\"padding-left: 30px;\">=RIGHT(A4,LEN(A4)-FIND(\"*\",SUBSTITUTE(A4,\" \",\"*\",LEN(A4)-LEN(SUBSTITUTE(A4,\" \",\"\")))))<\/p>\n<p>\u00a0 assuming the start of your symbols are in cell A4, post this in colum B4 or C4<\/p>\n<p>5.\u00a0 Copy\/paste this formula all the way down your sheet to get a list of ticker symbols.<\/p>\n<p>The results of the above steps can be seen\/downloaded at this google spreadsheet:<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheet\/ccc?key=0AjjUvzIcIusUdExDTFNOY21pOGNGQTVLcWJKS2lEcGc\">https:\/\/docs.google.com\/spreadsheet\/ccc?key=0AjjUvzIcIusUdExDTFNOY21pOGNGQTVLcWJKS2lEcGc<\/a><\/p>\n<p>I hope this helps all you who commented on the earlier post.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>My last post on the membership list generated some positive feedback, but it appears that it needs an update. I'm posting the steps I took to convert the index's PDF-only list to an Excel spreadsheet in case anyone else would like to have a go at updating in the future...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,12],"tags":[],"class_list":["post-239","post","type-post","status-publish","format-standard","hentry","category-finance","category-investing"],"_links":{"self":[{"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/posts\/239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/comments?post=239"}],"version-history":[{"count":5,"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/posts\/239\/revisions"}],"predecessor-version":[{"id":326,"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/posts\/239\/revisions\/326"}],"wp:attachment":[{"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/media?parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/categories?post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/konkin.com\/blog\/wp-json\/wp\/v2\/tags?post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}