Results 1 to 8 of 8

Thread: The Spreadsheet

  1. #1
    lifer is offline Newbie
    Join Date
    Aug 2004
    Location
    , ,
    Posts
    5

    Post imported post

    I'm going to start tracking what I'm doing with the spreadsheet (TSP returns Calculator). It appears very tedious to use. Am I missing something, or do you really need to manually input all the numbers, i.e. share prices/day, percentage, and market indices?

    Thanks,

    Lifer


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

    Post imported post

    It only takes a minute or two to update the daily price changes. It can be a bit tedious when you make a transfer. There is some adjusting needed. If you know how to use a spreadsheet you will see where it needs tweaked. It takes me an extra minute or two when I make an allocation change. If you are not familiar with spreadsheets it may be a little more challenging.

  4.  
  5. #3
    Rolo is offline Club TSP
    Join Date
    Mar 2004
    Location
    , Colorado, USA
    Posts
    1,463

    Post imported post

    hehehe...That was a politician's answer!

    If the spreadsheet's prices are in the same order as the TSP.gov site, you can copy/paste them directly from the site's table into the spreadsheet. You can do this with Frizz B's.

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

    Post imported post

    I'm finding out that I do most things the hard way.

  8.  
  9. #5
    Timer is offline TSP Talker
    Join Date
    Jul 2004
    Location
    , Colorado, USA
    Posts
    166

    Post imported post

    Rolo wrote:
    You can do this with Frizz B's.
    OK, I need to start tracking. How do I get a copy of this thing of wonder by :dude:?

    No offense Tom!

    Also, you spelled your name wrong - it's ROLO

    Kidding!o


  10.  
  11. #6
    Rolo is offline Club TSP
    Join Date
    Mar 2004
    Location
    , Colorado, USA
    Posts
    1,463

    Post imported post

    Timer wrote:
    Also, you spelled your name wrong - it's ROLO
    baaahaahahahaha..LOL!

    I want to design the überspreadsheet, to contain a balance tracker, easy import, FRO, and scalable to add anything to it from the same core data. PM me your ideas. I am far too manic right now to do it; I will begin on the next downswing, soon.

    My FRO spreadsheet is outdated and I stopped tracking it. Tom's...well... "Why you have to go and make things so complicateeed?"*


    *...been on an Avril Lavigne kick

  12.  
  13. #7
    lifer is offline Newbie
    Join Date
    Aug 2004
    Location
    , ,
    Posts
    5

    Post imported post

    Where can I find Frizz B's spreadsheet? Is it still on the forum somewhere?



    Thanks.

  14.  
  15. #8
    Rolo is offline Club TSP
    Join Date
    Mar 2004
    Location
    , Colorado, USA
    Posts
    1,463

    Post imported post

    Ya, an old one is here:

    http://www.tsptalk.com/mb/view_topic...ht=Excel+Frizz

    Find "FRO.zip" on that page. That may or may not be the one with my extra junk on it, heh.

  16.  

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