|
#3
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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) |
| | |||
| |||
| 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
| |||
| |||
| 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. |