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.

FrankV
Tue Nov 25 19:24:26 CST 2003

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@pbs.org> wrote in message
news:ONpwRy4sDHA.4060@TK2MSFTNGP11.phx.gbl...
> 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.
>
>

Robert
Tue Nov 25 20:13:15 CST 2003

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@anonymous.address> wrote in message
news:ehTwb.4797$nP3.366@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)

FrankV
Wed Nov 26 08:19:02 CST 2003

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@pbs.org> wrote in message
news:O284dL8sDHA.3140@TK2MSFTNGP11.phx.gbl...
> 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@anonymous.address> wrote in message
> news:ehTwb.4797$nP3.366@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)
>
>

Jeff
Wed Nov 26 22:59:36 CST 2003

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









>-----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.
>
>
>.
>