The Mechanical Investor

It is possible to import weekly rankings from this site into Excel. First, you need the Great Radish’s ImportRanginks.xls spreadsheet. This can be obtained at: http://www.mechinv.org/files/TheGreatRadish/Exports_And_Imports/ .

Download  ImportRankings.xls

This spreadsheet was originally designed to get rankings from TMF. It can work with this site also.

Directions from the spreadsheet itself:

First, bring up the desired rankings post using Internet Explorer or Netscape. Next, in IE or Netscape, type ctrl-A ctrl-C (that is, hold down the Ctrl key and type A then C; this will select the entire page and copy it to the Windows clipboard). Finally, click the button above. The rankings will be loaded into a new workbook. Close the ImportRankings workbook once the macro finishes running.

Related Reading:

Exploring Microsoft Office Excel 2007 Comprehensive (2nd Edition)

Succeeding in Business with Microsoft Office Excel 2007: A Problem-Solving Approach

Top 20 segment brands, super premium & import and IRI Data, U.S. Food 4-week and 13-week periods ending October 5, 2008.: An article from: Modern Brewery Age

Calculating a Value for Dominant Battlespace Awareness

Ranking, Spicer and Pegler's executorship law and accounts

This content is published under the Attribution-Noncommercial-Share Alike 3.0 Unported license.