Results 1 to 5 of 5

Thread: Returns Calculator Instructions

  1. #1
    bubbaman is offline Newbie
    Join Date
    Apr 2005
    Location
    LaVista, ,
    Posts
    2

    Post imported post

    How does it work now with with the L funds?


  2.  
  3. #2
    tsptalk's Avatar
    tsptalk is online now Moderator
    Join Date
    Feb 2004
    Posts
    11,173
    Blog Entries
    734

    Post imported post

    Welcome bubba! Since the spreadsheet / calculator is quite the eyeful already, I was thinking the L funds would be too much to add.

    The L funds are for buy and hold investors and if someone chooses one, it should be easy enough to track the results. If someone wants to actively trade the L funds, good luck. That would be an interesting task.

    If you plan to only use the L funds, try this spreadsheet... http://www.tsptalk.com/utilities/tsp_Lfund.xls

    I haven't created one that mixes both the L and the old funds. Like I said, it would be way too tough to read.

    Tom



  4.  
  5. #3
    bubbaman is offline Newbie
    Join Date
    Apr 2005
    Location
    LaVista, ,
    Posts
    2

    Post imported post

    Thanks for your responce. I don't use the L funds right now but I have been using the spreadsheet since the first of the year. I just loveit. Just copy and paste.

  6.  
  7. #4
    tsptalk's Avatar
    tsptalk is online now Moderator
    Join Date
    Feb 2004
    Posts
    11,173
    Blog Entries
    734

    Post imported post

    I wish they stuck those L fund prices on the right. Having them on the left did mess up the quick cut and paste we had with the date.

  8.  
  9. #5
    tsptalk's Avatar
    tsptalk is online now Moderator
    Join Date
    Feb 2004
    Posts
    11,173
    Blog Entries
    734

    Post imported post

    If you still want to cut and paste the share prices from the tsp.gov site to your spreadsheet, you can try what I did. Add 5 culumns between the date and the G fund price, then squeeze them down until you can't see them. It will paste without showing the L fund prices...

    http://www.tsptalk.com/utilities/test.xls

  10.  

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&P 500 (C fund)
[Chart]
1d  5d  3m  6m  1y  2y
Dow Completion (S fund)
[Chart]
1d  5d  3m  6m 
EFA (I fund)
[Chart]
1d  5d  3m  6m  1y  2y
Bonds (F fund)
[Chart]
1d  5d  3m  6m  1y  2y