Google Gadget for Tracking your TSP

[Scout333]

Scout how is it different from yours? I haven't updated mine for 2011. My moves have been minimal this year, so I can catch up when I feel the need. I used yours for previous years though. I've been trying to migrate to MAC software for finances. Been a PITA trying to find one that does what I want. Kind of burned out on reentering all the data over and over at the moment.

Lost, Haven't looked at the iGoogle gadget but mine is set up to do most of the math for you. Worked towards minimum input (share prices mostly). Some maintenance when you make IFTs and biweekly contributions. Have been trying to find a way to get the share prices updated automatically. Difficult with an Excel spreadsheet. No success yet. Good luck with the MAC software! I understand it is excellent with graphics, pics, etc. but not so much with financial spreadsheets, etc.

 

[pmcint01]

I think we should develop an app for that.

 

[KevinD]

I think we should develop an app for that.

I wish somebody would. I would if I had a clue how... :embarrest:

 

[Handballer]

Interesting way to use that tool.

I keep a few spreadsheets that show- woulda, coulda, shoulda....but then who can make 45% a year with two IFTs/month.

How many IFTs/month did you need to make 45% a year?

 

[KevinD]

Lost, Haven't looked at the iGoogle gadget but mine is set up to do most of the math for you. Worked towards minimum input (share prices mostly). Some maintenance when you make IFTs and biweekly contributions. Have been trying to find a way to get the share prices updated automatically. Difficult with an Excel spreadsheet. No success yet. Good luck with the MAC software! I understand it is excellent with graphics, pics, etc. but not so much with financial spreadsheets, etc.

No guarantees this will work for you, but . . . I use the attached [TSP weekly update.xls] at least once a week and sometimes more frequently. It can pull TSP fund price from the the TSP website automatically, but you will likely have to enable linking and enable macros--always a risk. I provide this spreadsheet to address the concept of linking/automatic updates.

Originally developed as a macro-enabled Excel 2010 spreadsheet, I converted it back to Excel 97-2003 "compatability" . . . so all the cautions that go along with anything that is converted backwards and is macro-enabled go along with it. Just like lots of other free things, I cannot accept responsibility for data or other problems and I offer no support.

Even though it indicates it is compatible with earlier versions of Excel, it is what it is, and I don't have any plans to improve it. If you are good with spreadsheets, feel free to make improvements. [Although I would appreciate feedback. Just send a PM.]

ANOTHER WARNING: When TSP.gov changes funds (like adding L2050) or otherwise changes their TSP prices website (like for holidays), the spreadsheet will update with erroneous or nonsense info. If you are not comfortable with modifying the spreadsheet to accommodate this, you should not rely on this spreadsheet.

Because I like to "cut and paste" into another file that I import into Quicken, I've used pseudoticker symbols that should be understandable. If not, look at http://www.tsptalk.com/1212/shareprices.html [I haven't bothered with adding L2050 on the left side, although it pulls the most recent few weeks of data into the sheet.]

Hope you find this helpful.

Monty

...

 

[Frixxxx]

How many IFTs/month did you need to make 45% a year?

Same amount of licks it takes to get to the center of a Tootsie Roll Pop!

 

[KevinD]

...then we're one short.

 

[KevinD]

Anybody else sad that igoogle is going away and we're losing this gadget?

 

[PLANO]

I am. I've had igoogle as my home page for many years and now it will go away. I've tried some alternatives but none that i've found are as good and most are glitchy.