How do I sort the Stocks in The DJIA by Price?
Zak R asked:
When I go to the list of stocks in the Dow Jones Industrial Average at YAHOO! Finance, the list is alphbetical by ticker symbol.
When I go to the list of stocks in the Dow Jones Industrial Average at YAHOO! Finance, the list is alphbetical by ticker symbol.
I want to make my own version based on share price.
I want the most expensive share at the top and the least expensive share at the bottom.
At the end of this page =%5EDJI
is given the link Download to Spreadsheet. This will download a file quotes.csv. Open the file with Excel and sort the data using the second column. Here is the result.
INTC20.69
PFE23.10
GM27.46
C27.8799
HD29.38
DIS29.41
MSFT32.2
AA32.7
GE34.9358
T37.35
VZ38.24
HPQ43.54
DD44.56
MRK46.69
AXP47.34
JPM47.35
WMT49.16
MCD51.01
AIG54.37
KO57.77
HON58.163
JNJ62.1799
PG65.09
CAT68.44
UTX72.75
MO76.503
MMM78.22
BA82.8699
XOM85.28
IBM105.65