Likes Likes:  0
Page 2 of 5 FirstFirst 1234 ... LastLast
Results 13 to 24 of 49

Thread: I fund tracker...

  1. #13

    Default Re: I fund tracker...

    Updated spreadsheet again. Thought of a simple way to compensate for the changes in variable table formats that TSP.gov uses around holidays. Let me know if this works!

  2.  
  3. #14

    Join Date
    Apr 2005
    Posts
    14,685
    Blog Entries
    13

    Default Re: I fund tracker...

    Chem:

    Thanks for the update. I had to go back to page one of this thread to find the updated version. It works well.

    Thanks again.

  4.  
  5. #15

    Default Re: I fund tracker...

    Quote Originally Posted by James48843 View Post
    Chem:

    Thanks for the update. I had to go back to page one of this thread to find the updated version. It works well.

    Thanks again.
    Heres the I fund lookup not on the front page.

    Attachment 1733

  6.  
  7. #16

    Default Re: I fund tracker...

    Updated spreadsheet. Found a way to speed it up if you're like me and use it multiple times a day. Enjoy!

  8.  
  9. #17

    Join Date
    Feb 2006
    Location
    Florida
    Posts
    120

    Default Re: I fund tracker...

    Thank you, I used it all the time. Keep up the good work!!

  10.  
  11. #18

    Default Re: I fund tracker...

    Thanks for all of your hard work. I use this often through the day. Even after noon to check on the $ direction.

    Debbie


  12.  
  13. #19

    Default Re: I fund tracker...

    This latest version works with Excel 2000 (my copy anyway). The older versions (at least the last ones I tried) did not so wanted to let others know in case they thought they wouldn't be able to use this wonderful application. Thanks ChemEng!

  14.  
  15. #20

    Default Re: I fund tracker...

    Updated the spreadsheet to include a cell to enable quick and easy estimates to be posted in the I-fund thread. The process is simple.

    Press Get Data! button.
    Point to cell G36.
    Copy that cell.
    Paste data into message box in 350z's I fund thread.
    Post message.

    One other small update. If there is a FVC for todays markets, then you enter it into cell G34. (It will add itself into the estimate text automatically.)

    Let me know if you have any problems.
    Last edited by ChemEng; 08-24-2007 at 11:20 AM.

  16.  
  17. #21

    Default Re: I fund tracker...

    Updated the composition of the I fund based on new data from TSP website. The latest version of this sheet should have ^FTSE as the first index instead of ^N300.

  18.  
  19. #22

    Default Re: I fund tracker...

    ChemEng:

    Thanks very much for the spreadsheet. I have a favor to ask though. In your macro updating the share prices and I fund current %, can you also pull in the % for the C (^GSPC) and S (^DWCPF)funds? These are the 2 funds I used to track C and S. I can handle the simple spreadsheet, but have no idea how to do macros, especially to pull in real data!

    Thank you mucho!

  20.  
  21. Default Re: I fund tracker...

    I agree. Keeping an Eye on C and S funds all in the same spreadsheet would be helpful.
    Two steps forward, one step back.

  22.  
  23. #24

    Default Re: I fund tracker...

    Quote Originally Posted by catt1 View Post
    I agree. Keeping an Eye on C and S funds all in the same spreadsheet would be helpful.
    Thanks for the comments. Ill add this feature in the next version of the tracker. It will probably be next week before I can get to it though, Im pretty heavily engaged with work and family (wife's due in 4 weeks!!) right now.

  24.  
Page 2 of 5 FirstFirst 1234 ... 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