Results 1 to 10 of 10

Thread: Historical Data for Wilshire 4500

  1. #1

    Join Date
    Jul 2004
    Location
    Cleveland, Ohio
    Posts
    514

    Post imported post

    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
    Trading, in its simplest form, is the process of capturing the disconnect between perception and reality.


  2.  
  3. #2

    Default Other Historical quotes

    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
    The Technician (escapades at times as Carnac)

  4.  
  5. #3

    Default

    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?

  6.  
  7. #4

    Join Date
    Dec 2005
    Location
    Billings, Montana
    Posts
    86

    Default

    "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.

  8.  
  9. Default Re: Historical Data for Wilshire 4500

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

  10.  
  11. #6

    Default Re: Historical Data for Wilshire 4500


  12.  
  13. #7

    Default Re: Historical Data for Wilshire 4500

    Quote Originally Posted by Mike1999 View Post
    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.

  14.  
  15. #8

    Join Date
    Jun 2004
    Location
    Boiled Peanut, Georgia, USA
    Posts
    76,393

    Default Re: Historical Data for Wilshire 4500

    Try the link they have all you will ever need!!
    http://www.djindexes.com/wilshire/us...?go=index-data



  16.  
  17. #9

    Default Updating Historical Data for Wilshire 4500

    Well most of the links no longer work, and the Wilshire 4500 (Full Cap) appears to have ceased in 2008, so it looks like it's time to update this thread.

    To get to the data download page try going here. If that no longer works try this:
    1. Go to the Wishire home page: www.wilshire.com
    2. Near the top of the page click on "INDEXES"
    3. In the orange colored area to the right click on "Index Calculator"

    That should get you there.

    Since the Wilshire 4500 (Full Cap) doesn't have any data past mid 2008 Im going to continue these instructions with the Wilshire 4500. It looks like they only differ from 2004 onward. To understand the difference check out this thread: http://www.tsptalk.com/mb/s-fund/341...html#post59976

    To get a list of daily or monthly returns since inception try this:
    1. In the menu selector under the "Broad/Style" selection list, change the menu entry from "Cumulative Returns" to "Since Inception Returns".
    2. In the "Broad/Style" selection list select "Wilshire 4500". If you already did this before step 1, you will have to do it again because step 1 blanks existing selections in that list.
    3. In the menu selector under the "Target" selection list, change the menu entry to "Monthly Returns" if you want that instead of the default "Daily Returns".
    4. Press the orange "Download csv files" button. A new tab should pop up containing a comma seperated list of your data.
    5. Select the entire list of data with your mouse and paste it into a text editer like Notepad in Windows.
    6. Save this off with a ".csv" filename extention.
    7. Import this file into your spreadsheet as a CSV file. In Windows you should be able to double click the file icon with your mouse to have Excel automatically open it as a spreadsheet as long as the file has a ".csv" extension.

    To get 8-10 years worth of annual returns at a time try this:
    1. In the menu selector under the "Broad/Style" selection list, change the menu entry from "Cumulative Returns" to "Periodic Returns".
    2. In the "Broad/Style" selection list select "Wilshire 4500". If you already did this before step 1, you will have to do it again because step 1 blanks existing selections in that list.
    3. Set the "From" and "To" dates.
    4. In the menu selector under the "From:" date, change the menu entry from "Simple Returns" to "Yearly Returns".
    5. Press the orange "Submit" button. A new tab should pop up containing your requested data.
    Allocations as of COB Dec 28 : 100% S. | Retirement Date:Dec 2025
    Past Returns:
    2020 31.85%,2019 27.97%,2018 -3.36%,2017 13.10%, 2016 -1.79%, 5Yr Avg 12.61%


  18.  
  19. #10

    Join Date
    Jul 2007
    Location
    Europe
    Posts
    8,430
    Blog Entries
    297

    Default Re: Updating Historical Data for Wilshire 4500

    Quote Originally Posted by Cactus View Post
    Well most of the links no longer work, and the Wilshire 4500 (Full Cap) appears to have ceased in 2008, so it looks like it's time to update this thread.

    To get to the data download page try going here. If that no longer works try this:
    1. Go to the Wishire home page: www.wilshire.com
    2. Near the top of the page click on "INDEXES"
    3. In the orange colored area to the right click on "Index Calculator"

    That should get you there.

    Since the Wilshire 4500 (Full Cap) doesn't have any data past mid 2008 Im going to continue these instructions with the Wilshire 4500. It looks like they only differ from 2004 onward. To understand the difference check out this thread: http://www.tsptalk.com/mb/s-fund/341...html#post59976

    To get a list of daily or monthly returns since inception try this:
    1. In the menu selector under the "Broad/Style" selection list, change the menu entry from "Cumulative Returns" to "Since Inception Returns".
    2. In the "Broad/Style" selection list select "Wilshire 4500". If you already did this before step 1, you will have to do it again because step 1 blanks existing selections in that list.
    3. In the menu selector under the "Target" selection list, change the menu entry to "Monthly Returns" if you want that instead of the default "Daily Returns".
    4. Press the orange "Download csv files" button. A new tab should pop up containing a comma seperated list of your data.
    5. Select the entire list of data with your mouse and paste it into a text editer like Notepad in Windows.
    6. Save this off with a ".csv" filename extention.
    7. Import this file into your spreadsheet as a CSV file. In Windows you should be able to double click the file icon with your mouse to have Excel automatically open it as a spreadsheet as long as the file has a ".csv" extension.

    To get 8-10 years worth of annual returns at a time try this:
    1. In the menu selector under the "Broad/Style" selection list, change the menu entry from "Cumulative Returns" to "Periodic Returns".
    2. In the "Broad/Style" selection list select "Wilshire 4500". If you already did this before step 1, you will have to do it again because step 1 blanks existing selections in that list.
    3. Set the "From" and "To" dates.
    4. In the menu selector under the "From:" date, change the menu entry from "Simple Returns" to "Yearly Returns".
    5. Press the orange "Submit" button. A new tab should pop up containing your requested data.
    Thanks Cactus, I was needing to rebuild those stats and your thread came up #2 under a google search for "wilshire 4500 historical data"
    Retired, 55G/15C/15S/15I (Paper Trading)_ BLOG: Stats for March, Stats for Q1, 2024 Stats

  20.  

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
S&P500 (C Fund) (delayed)
Historical Data for Wilshire 4500
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Historical Data for Wilshire 4500
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Historical Data for Wilshire 4500
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
Historical Data for Wilshire 4500
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes