Open Excel, Click on the “Report” icon. Scroll down the dropdown menu and select “Ratio Reports”, within this folder select “Annual Ratio Report”.
The above screen will appear. On the right side the “Select Companies” screen will scroll to list nearly all industries. Hint: Use the “Find Text” blank to type in a keyword/s of industry you are looking for (i.e. “Electric Utilities”) After which, you will click on “Find Next” and double click on the correct industry. A ticker symbol for that industry will be automatically placed it into the smaller “Enter Ticker” box. Now click “OK”.
RIWeb? will now spend a minute or so accessing it’s databases to collect the data you requested. The data will be placed into an Excel Spreadsheet consisting of You MUST now click on the “unlink” button (or sometimes called “Copy Report as Values”) and Save.