Likes Likes:  0
Page 1 of 5 123 ... LastLast
Results 1 to 12 of 49

Thread: I fund tracker...

  1. #1

    Default I fund tracker...

    Here is the spreadsheet I talked about on Friday. It tracks the real-time % changes of the component EAFE funds and then using their EAFE weightings, calculates an overall % change. I found the macro coding online while trying to find a list of the different Yahoo tags and thought I could put it to good use tracking I fund changes.

    1. This is done in MS Excel and uses a macro. That means you need to enable the macro when you start up the spreadsheet.
    2. It works on Excel versions 2002 or later. If you have trouble loading it, please check your version of Excel to see if this is the problem.

    --------------------------------------------------------------------------------------------------------------------
    17JAN07--Corrected spreadsheet to track Nikkei 300, instead of Nikkei 225.
    02MAR07--Updated spreadsheet given new data about DX.
    09APR07--Updated new tsp.gov import bug I found.
    02JUL07--Dynamic coded the spreadsheet to fix TSP.gov's table format changing. (This should permanently fix the bug I found on 09APR07.)
    12JUL07--Found opportunity to speed up coding.
    24AUG07--Added cell to allow for copy+paste of timed updates.
    24AUG07--Updated the composition of the I fund based on new data from TSP website.
    23DEC07--Changed CAC 40 symbol from ^FCHI to ^CAC.
    16FEB08--Changed Ireland symbol to ^I:IEDOW and Portugal symbol to ^I:PTDOW.
    22APR08--Updated symbols for Japan, Greece, and Ireland.
    20OCT08--Updated program to reflect the new location of the Index data.
    27JAN09--Addressed TSP.gov redirect issue.
    03FEB09--Corrected sort method to work with earlier Excel versions.

    I fund lookup
    Last edited by ChemEng; 02-03-2009 at 07:18 PM.


  2.  
  3. #2

    Default Re: I fund tracker...

    Thanks, Chem! This is a nice little program.

  4.  
  5. #3

    Default Re: I fund tracker...

    Thanks ChemEng! I've been trying to get something going on this and was not able to.

  6.  
  7. #4

    Default Re: I fund tracker...

    Im glad that you found this utility useful! Although Im still not certain that Im tracking the right symbols on the spreadsheet. (Note I did update it this morning to track the Nikkei 300 instead of the Nikkei 225.)

    Is there anyone out there that could double check the listing to make sure its tracking the right ones?

  8.  
  9. #5

    Default Re: I fund tracker...

    ChemEng, I track these major world indices:

    ^N300,^FTSE,^FCHI,^SSMI,^GDAXI^,AORD,^MIBTEL,^IBEX ,^AEX,^OMXSPI,^HSI,^FIDOW,^BFX,^IEDOW,^STI,OMXC20. CO,^OSEAX,^GRDOW,^ATX,^PTDOW,^NZ50

    You may have to check if you got FINLAND (^FIDOW 1.40&#37 included. The above link lists the indices from top to bottom according to its countries' weight.
    Last edited by ebbnflow; 01-17-2007 at 09:39 PM.

  10.  
  11. #6

    Join Date
    Jun 2004
    Location
    In Your Imagination...
    Posts
    4,385

    Arrow Re: I fund tracker...

    Great spreadsheet! Thanx for sharing.

    Perhaps with your excel expertise, you could come up with a spreadsheet that calculates/estimates the (I) Fund price increase/decrease for the day?
    "Treat your wife with honor, respect, and understanding as you live together so that you can pray effectively as husband and wife." 1 Peter 3:7

  12.  
  13. #7

    Default Re: I fund tracker...

    Updated I fund lookup spreadsheet today. Will post here any updates that get made to it.

  14.  
  15. #8

    Join Date
    Jun 2004
    Location
    In Your Imagination...
    Posts
    4,385

    Arrow Re: I fund tracker...

    This is a good place for a sticky!
    "Treat your wife with honor, respect, and understanding as you live together so that you can pray effectively as husband and wife." 1 Peter 3:7

  16.  
  17. #9

    Default Re: I fund tracker...

    Updated new tracker to fix a new tsp.gov import bug I found.


  18.  
  19. #10

    Default Re: I fund tracker...

    Quote Originally Posted by ChemEng View Post
    Updated new tracker to fix a new tsp.gov import bug I found.
    ChemEng,

    I re-downloaded the tracker but still only shows to April 3rd. Did I miss something.

    Thx for all your hard work.


  20.  
  21. #11

    Default Re: I fund tracker...

    Quote Originally Posted by wv-girl View Post
    ChemEng,

    I re-downloaded the tracker but still only shows to April 3rd. Did I miss something.

    Thx for all your hard work.

    Give it a try again. I uploaded the latest copy of the tracker again.

  22.  
  23. #12

    Default Re: I fund tracker...

    Thanks that worked.

    Happy trading.

  24.  
Page 1 of 5 123 ... LastLast

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)
I fund tracker...
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
I fund tracker...
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
I fund tracker...
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
I fund tracker...
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes