Page 1 of 2 12 LastLast
Results 1 to 12 of 19

Thread: TSP Interfund Transfer Decoder Wheel

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

    Post imported post

    The biggest headache in tracking TSP transfers is that the IFT notifications show you your account before and after the transaction, and you have to figure out the actual transaction itself. The TSP Interfund Transfer Decoder Wheel makes entering your transactions into Quicken (or any financial program) a snap. Rather thandoing multipletedious calculations with a calculator, just paste the table from your IFT e-mail notification into the attached spreadsheet, then copy and paste the values (share price and totalamount)into your Quicken transactions and you are good to go!

    Download and delete the ".txt" extension from the filename.
    Attached Files Attached Files


  2.  
  3. #2
    Rod's Avatar
    Rod
    Rod is offline Moderator
    Join Date
    Jun 2004
    Location
    In Your Imagination...
    Posts
    3,477

    Post imported post

    Humm, don't look like it worked for me. A bunch of junk opened up in my notepad.


    "You rise. You fall. You're down then you rise again. What don't kill ya make ya more strong."
    - Metallica

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

    Post imported post

    Rod wrote:
    Humm, don't look like it worked for me. A bunch of junk opened up in my notepad.


    Rolo had already written:
    Download and delete the ".txt" extension from the filename.
    heh...RTFM before contacting technical support! :X

    Tom added xls to theallowed attachements--just download the file attached to the next message below.

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

    Post imported post

    The biggest headache in tracking TSP transfers is that the IFT notifications show you your account before and after the transaction, and you have to figure out the actual transaction itself. The TSP Interfund Transfer Decoder Wheel makes entering your transactions into Quicken (or any financial program) a snap. Rather thandoing multipletedious calculations with a calculator, just paste the table from your IFT e-mail notification into the attached spreadsheet, then copy and paste the values (share price and totalamount)into your Quicken transactions and you are good to go!

    Attached is the xls (Excel) file.
    Attached Files Attached Files

  8.  
  9. #5
    Rod's Avatar
    Rod
    Rod is offline Moderator
    Join Date
    Jun 2004
    Location
    In Your Imagination...
    Posts
    3,477

    Post imported post

    Don't get yer panties in a twist!:P

    Humm, still having problems. Don't see .txt in the extention to delete.


    "You rise. You fall. You're down then you rise again. What don't kill ya make ya more strong."
    - Metallica

  10.  
  11. #6
    Rod's Avatar
    Rod
    Rod is offline Moderator
    Join Date
    Jun 2004
    Location
    In Your Imagination...
    Posts
    3,477

    Post imported post

    MUCH BETTER!!!!!!!




    "You rise. You fall. You're down then you rise again. What don't kill ya make ya more strong."
    - Metallica

  12.  
  13. #7
    Rod's Avatar
    Rod
    Rod is offline Moderator
    Join Date
    Jun 2004
    Location
    In Your Imagination...
    Posts
    3,477

    Post imported post

    Thank you, Tom.

    and YOU TOO, Rolo!:^


    "You rise. You fall. You're down then you rise again. What don't kill ya make ya more strong."
    - Metallica

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

    Post imported post

    Rod wrote:
    Don't get yer panties in a twist!:P

    Humm, still having problems. Don't see .txt in the extention to delete.


    hehehe...ever see Office Space? "I deal with the people so the engineers don't have to! I have PEOPLE SKILLS! WHAT'S WRONG WITH YOU PEOPLE!?" :X :dude:


    You do not see the .txt extension because Windoze Explorer is hiding it. Togge the option "Hide extensions of known file types" in Tools | Options...

  16.  
  17. #9
    Rod's Avatar
    Rod
    Rod is offline Moderator
    Join Date
    Jun 2004
    Location
    In Your Imagination...
    Posts
    3,477

    Post imported post



    Yeah, I finally got it downloaded with what Tom did.

    Thanx for putting it together!:^




    "You rise. You fall. You're down then you rise again. What don't kill ya make ya more strong."
    - Metallica


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

    Post imported post

    Yes, entering IFT's into Quicken was a real PITA. As I was doing the calculator thing again, I thought, "This is stupid. Duh! Excel..."

    Also, I was less likely to trade in the TSP because of the Hassle Factor; now, that is not the case.

  20.  
  21. #11
    Frizz B. is offline TSP Talker
    Join Date
    Mar 2004
    Location
    , ,
    Posts
    374

    Post imported post

    I still like my excell spreadsheet, quick and easy to track and make changes, and Rolo the :dude:is mine, it shows my Frizz. :dude:

  22.  
  23. #12
    Rolo is offline Club TSP
    Join Date
    Mar 2004
    Location
    , Colorado, USA
    Posts
    1,463

    Post imported post

    Frizz B. wrote:
    I still like my excell spreadsheet, quick and easy to track and make changes, and Rolo the :dude:is mine, it shows my Frizz. :dude:
    Apples and oranges...this spreadsheet has an entirely different purpose, only to paste IFT confirmation, automatically do the calculations, and paste the figures into Quicken--a one-shot deal, no tracking.

    Also, I still have to figure out that part of your spreadsheet.

  24.  
Page 1 of 2 12 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&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