Rhino7
2 posts
msg #54825
- Ignore Rhino7 |
9/15/2007 7:01:36 PM
Does anyone know where to find a list of the Russell 2000 stocks including price that you can cut and paste into excel?
|
ladytrader
10 posts
msg #54838
- Ignore ladytrader |
9/16/2007 3:53:40 PM
http://www.russell.com/Indexes/membership/default.asp
Click on the membership list link and a PDF file will load.
|
rharmelink
81 posts
msg #54841
- Ignore rharmelink |
9/16/2007 7:01:50 PM
Here's a location for a number of index components lists that can be downloaded as CSV files:
http://www.masterdata.com/Downloads/ConstituentLists/index.htm
No prices, just company name and ticker symbol. But there are plenty of ways to get the prices into EXCEL easily, once you have the ticker symbols.
|
CSharpY
7 posts
msg #54865
- Ignore CSharpY
modified |
9/17/2007 8:19:01 AM
"there are plenty of ways to get the prices into EXCEL easily, once you have the ticker symbols"
Well, if there's anybody who knows a thing or two about using Excel to get stock info, my hat goes off to Randy Harmelink aka rharmelink =)
Randy wrote one heck of a Excel add-in called "smf_addin". You can find it in the Yahoo group of the same name.
Nice to see you here, Randy!
c#
|