Humm, don't look like it worked for me. A bunch of junk opened up in my notepad.
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.
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
Rod wrote:Rolo had already written:Humm, don't look like it worked for me. A bunch of junk opened up in my notepad.
heh...RTFM before contacting technical support! :XDownload and delete the ".txt" extension from the filename.
Tom added xls to theallowed attachements--just download the file attached to the next message below.
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.
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
MUCH BETTER!!!!!!!
"You rise. You fall. You're down then you rise again. What don't kill ya make ya more strong."
- Metallica
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
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...
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
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.
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:
Frizz B. wrote: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.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:
Also, I still have to figure out that part of your spreadsheet.
|
S&P 500 (C fund) 1d 5d 3m 6m 1y 2y | Dow Completion (S fund)
| EFA (I fund) 1d 5d 3m 6m 1y 2y | Bonds (F fund)
|
Bookmarks