Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 11-27-2003, 03:59 AM
Jeff
Guest
 
Posts: n/a
Default Money and the gov TSP

Not exactly ... I use Excel to calculate the transactions
though.

Part I --- transactions

Copy the Account Balance table as a base.
Next pay period, copy the Account balance below the base.

Now create a table to the side with these columns:
A) the net difference in shares (G Fund [today] less G
Fund [base], .... )
B) % distribution per fund
C) % distribution times contribution - Total $/Fund
D) Share price (Column C divided by Column A)

(Excel's relative addresses allow formula reuse and
testing for division by zero {=IF(J26=0,,L26/J26)}will
keep the spreadsheet pretty.)

Now the lazy part --- Comparing share prices in column D
to TSP's "Share Prices" in the "Rates of Return", guess
the transaction day. Then cut and paste transactions into
your TSP account. With practice it becomes easier than it
sounds. With knowledge of how to set up a .QFX file, a
macro could load the data (I suppose). I looked at one
from an investment account and it had almost 100 lines for
2 tranasctions.

Part II --- daily prices

I've not found any way to enter prices without symbols
other than Money's "update prices manually" feature. From
the "Share Prices" table, I cut and paste my prices. I've
gotten real good with Ctrl-C/Ctrl-V









- quote -

> -----Original Message-----
> Has anyone figured out an easy way to import data from

the U.S. Government
> TSP retirement plan? Maybe a cut and past into Excel and

then import into
> Money. It also be great if there were a daily download

of the value of each
> share.
> .

  #2  
Old 11-26-2003, 01:19 PM
FrankV
Guest
 
Posts: n/a
Default Re: Money and the gov TSP

The only thing you can get from that huge waste of money new web is the
current value. There is no way to get previous data as far as I could find.

Frank
"Robert Futscher" <rfutscher[at]pbs.org> wrote in message
news:O284dL8sDHA.3140[at]TK2MSFTNGP11.phx.gbl...
- quote -

> I was hoping to do the TSP "cut" and "paste" from the WEB site. If I
> have to do the mail paper thing I am in big trouble, just because of my
> typing abilities.
> "FrankV" <FrankV[at]anonymous.address> wrote in message
> news:ehTwb.4797$nP3.366[at]nwrdny03.gnilink.net...
> > I've been using the TSP "cut" and "paste" (from quarterly statements

> mailed
> > to us) for years. Getting the government to do something like daily
> > download is about the best joke I've heard in years. They just wasted
> > multi-millions of dollars in the new system that is another joke.
> > > Frank (Retired)



  #1  
Old 11-26-2003, 01:13 AM
Robert Futscher
Guest
 
Posts: n/a
Default Re: Money and the gov TSP

I was hoping to do the TSP "cut" and "paste" from the WEB site. If I
have to do the mail paper thing I am in big trouble, just because of my
typing abilities.

"FrankV" <FrankV[at]anonymous.address> wrote in message
news:ehTwb.4797$nP3.366[at]nwrdny03.gnilink.net...
- quote -

> I've been using the TSP "cut" and "paste" (from quarterly statements
mailed
> to us) for years. Getting the government to do something like daily
> download is about the best joke I've heard in years. They just wasted
> multi-millions of dollars in the new system that is another joke.
> Frank (Retired)



 
Old 11-26-2003, 12:24 AM
FrankV
Guest
 
Posts: n/a
Default Re: Money and the gov TSP

I've been using the TSP "cut" and "paste" (from quarterly statements mailed
to us) for years. Getting the government to do something like daily
download is about the best joke I've heard in years. They just wasted
multi-millions of dollars in the new system that is another joke.

Frank (Retired)

"Robert Futscher" <rfutscher[at]pbs.org> wrote in message
news:ONpwRy4sDHA.4060[at]TK2MSFTNGP11.phx.gbl...
- quote -

> Has anyone figured out an easy way to import data from the U.S. Government
> TSP retirement plan? Maybe a cut and past into Excel and then import into
> Money. It also be great if there were a daily download of the value of

each
> share.



  #-1  
Old 11-25-2003, 06:44 PM
Robert Futscher
Guest
 
Posts: n/a
Default Money and the gov TSP

Has anyone figured out an easy way to import data from the U.S. Government
TSP retirement plan? Maybe a cut and past into Excel and then import into
Money. It also be great if there were a daily download of the value of each
share.


 

Tags
gov, money, tsp


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 04:15 AM.