Historical Data for Wilshire 4500

**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

**The_Technician** · 01-10-2006, 03:13 PM

Found out that Business week has a nice site...see this for a historical quote for alot of symbols....

http://host.businessweek.com/busines...rt&Symbol=DWCP

**jeffp** · 01-11-2006, 02:59 AM

You can also get share data at the DJ Indexes website: http://djindexes.com/mdsidx/download.../dwcp_hist.xls

Does anyone know where to get historical earnings data?

**Chaser** · 01-14-2006, 10:58 AM

"If there is a better way to get a comma delimited file into excel and directly separating the columns, let me know."

Pilgrim: clicking on the csv file should open the file in Excel in tabular format, if it does not, try right-clicking on the file, and use "Open with" Excel. Once the file is open in Excel with rows and columns you can use "Save as" under the Excel Edit menu to save it as a .xls regular spreadsheet file if you want to add formatting.

Good luck.

**Mike1999** · 11-22-2006, 03:48 AM

Where can I find historical data on earnings for the Wilshire 4500? I'm really looking for a chart of the Historical PE ratio.

**jeffp** · 04-07-2007, 07:00 PM

http://djindexes.com/mdsidx/download.../dwcp_hist.xls
and use column D for DWCPF

**jeffp** · 04-07-2007, 07:03 PM

Originally Posted by Mike1999

Where can I find historical data on earnings for the Wilshire 4500? I'm really looking for a chart of the Historical PE ratio.

This is all I have. Majority are real end-of-month data. Some are interpolated. Use at your own risk:
Aug-04 27.9
Sep-04 29.3
Oct-04 30.6
Nov-04 30.9
Dec-04 32.2
Jan-05 31.2
Feb-05 30.1
Mar-05 29.1
Apr-05 29.1
May-05 30.0
Jun-05 30.1
Jul-05 30.2
Aug-05 30.3
Sep-05 30.4
Oct-05 30.5
Nov-05 30.6
Dec-05 30.6
Jan-06 31.5
Feb-06 31.5
Mar-06 34.6
Apr-06 34.6
May-06 30.8
Jun-06 30.8
Jul-06 30.3
Aug-06 29.9
Sep-06 29.4
Oct-06 28.9
Nov-06 28.5
Dec-06 28.0
Jan-07 28.3
Feb-07 29.4?
Mar-07 27.4

Have fun.