Pilgrim
11-17-2005, 02:20 PM
If you want to play with numbers and need closing data for the Wilshire 4500 all the way back to its beginning, you can get it this way:
Go to http://www.wilshire.com
near the top of the page click on "indexes"
in the colored area to the right click on "index return calculator"
in the box labeled "Broad/style" select: "DJ Wilshire 4500 (Full Cap) Price"
in the box right under that select "since inception returns"
click the button off to the right (not the one down below) that says: "download csv files"
Prepare to be swamped with a single column of numbers.
I had trouble getting this into a spreadsheet and separating into three separate columns for date, change, and closing value. I finally pasted it into word, used the change text to table feature, then copying the table into excel. If there is a better way to get a comma delimited file into excel and directly separating the columns, let me know
Pilgrim
Go to http://www.wilshire.com
near the top of the page click on "indexes"
in the colored area to the right click on "index return calculator"
in the box labeled "Broad/style" select: "DJ Wilshire 4500 (Full Cap) Price"
in the box right under that select "since inception returns"
click the button off to the right (not the one down below) that says: "download csv files"
Prepare to be swamped with a single column of numbers.
I had trouble getting this into a spreadsheet and separating into three separate columns for date, change, and closing value. I finally pasted it into word, used the change text to table feature, then copying the table into excel. If there is a better way to get a comma delimited file into excel and directly separating the columns, let me know
Pilgrim