TRACKING RETURNS

04-13-2005, 12:03 PM

Since the subject came up again can I ask for some assistance in finally getting my confusions cleared up on how to enter one's allocations and which excel template to use? I would really like to be able to track my own returns but can''t because I was never able to get my confusions clarified. If I could get some input from our 3 gurus here, Tom, Fundsurfer and Pyriel I would greatly appreciate it. Below are my confusions:

A while back there seemed to be a debate whether to enter data into the excel template on the day one sold shares of a fund or on the day one's new allocations actually became effective. My understanding was that Tom entered data the day he sold shares and that his excel template is desiigned for this method. Now I could never decipher the logic of Tom's method but given my limited training in this area this is not saying much.

Then Fundsurfer said he does it differently. That is, he enters the allocation percentages for the days one actually earns or looses money based on the share prices for those days, (i.e. hypothetically I went to 100% G and this allocation begins on 4/10 so data is entered in the worksheet for 4/10. Then after changing allocation to 100% C whcih begins on 4/13 then data is entered into the worksheet for 4/13). Fundsurfer has a different template than Tom's designed to handle data entry for this method. Fundsurger tried to help me out with this in the past and sent me this other version of the worksheet. However, I think when I went to use it and saw the creator was Tom, I figured it was the wrong version.

Now Pyriel has been doing many tracking reports. I believe he started out entering data the way Tom does and using Tom's excel template but later switched to Fundsurfer's method and template. I may be wrong here but when I examine Pyriel's reports it appears this way to me.

Could one or all of you, Tom, Fundsurfer, Pyriel set me straight for once and for all. I would love to track my own funds but I haven't been able to because of the above confusions. If one or all of you could assist me, here on the board or through PMs or email, I would greatly appreciate it.
Thank you .......

**cowboy** · 04-13-2005, 01:26 PM

This may help you some WW (Wild Woman). The TSP has the quarterly reports on the site and the quarterly statement for 2005 just came out. It will show all your transactions and what you made for the quarter. Maybe you can use that to help you track on the spread sheet and compare. I have never run their spreadsheets but I believe their is nothing wrong with Tom's. I am going to run my yearly thruTSP Talks (Tom's) exceland maybe I'll post the results.

04-13-2005, 02:05 PM

Thank you for your suggestion, cowboy.....

**cowboy** · 04-13-2005, 05:16 PM

As I said I decided to try Tom's calculator. I went fine with the calculator until the date of 1/25/05. Then this is what happened on 1/25/05 I moved 50% that I had in the C fund and put it to I fund. TSP gave me the closing $12.46 price but did not update the I fund at close and updated on 1/26/05. I'm thinking TSP errored! If they gave me the closing price on 1/25/ shouldn't they put in the I fund on that day. The difference in the I fund from close of 1/25/ to 1/26close was $.17 share.

I called TSP and they are checking out what occured that I got the close on 1/25/ but not updated until the 1/26. I must say the person on the line was very concerned and very cooperative. He noticed that I make a lot of moves and watch my TSP account. He stated that they would need 48 hours to get the facts to what happened on that transaction and if there is an error they have to correct everything. Please look at your quarterly statements. I may even review back further.

Now this could play out, where they could say I didn't make the move until after 12;00 and they had a typo error on the date but now I have to wait and see. I usually make my moves prior to the noon deadline so I am thinking the move was prior to that but there was times I had problems getting through the system.

**cowboy** · 04-13-2005, 05:32 PM

cowboy wrote:

As I said I decided to try Tom's calculator. I went fine with the calculator until the date of 1/25/05. Then this is what happened on 1/25/05 I moved 50% that I had in the C fund and put it to I fund. TSP gave me the closing $12.46 price but did not update the I fund at close and updated on 1/26/05. I'm thinking TSP errored! If they gave me the closing price on 1/25/ shouldn't they put in the I fund on that day. The difference in the I fund from close of 1/25/ to 1/26close was $.17 share.

I called TSP and they are checking out what occured that I got the close on 1/25/ but not updated until the 1/26. I must say the person on the line was very concerned and very cooperative. He noticed that I make a lot of moves and watch my TSP account. He stated that they would need 48 hours to get the facts to what happened on that transaction and if there is an error they have to correct everything. Please look at your quarterly statements. I may even review back further.

Now this could play out, where they could say I didn't make the move until after 12;00 and they had a typo error on the date but now I have to wait and see. I usually make my moves prior to the noon deadline so I am thinking the move was prior to that but there was times I had problems getting through the system.

I have since rechecked and found that making the transaction Imade an error when reading my statement andcalled TSP and they are stopping the research. This I can see is going to be very tricky.

**MR CARLO** · 04-13-2005, 09:32 PM

I don't know if this will help. What I have been doing daily is Going to my TSP account Balance, by dragging the mouse and selecting the statement I copy(Ctrl C) and paste to excel(Ctrl V) . I made a funtion box that Subtracts the last total balance from the new balance. That tells me in Dollars and cents how I do each day. I have to type in the date for day. Thats it. There is a lot of different ways to track. I find my way as simple as I am.:dah: Good luck

**cowboy** · 04-14-2005, 03:40 AM

A function box? Give us your idea Carloc? I love simple although I have not problem with Tom's spread sheet. Change and improvement helps everyone.

**tsptalk** · 04-14-2005, 04:54 AM

I could show someone in 5 minutes but telling them is another story. Were the instructions of any help?... http://www.tsptalk.com/utilities/instructions.html

**pyriel** · 04-14-2005, 05:36 AM

tsptalk wrote:

I could show someone in 5 minutes but telling them is another story. Were the instructions of any help?... http://www.tsptalk.com/utilities/instructions.html

Tom, Your instructions are great.

**cowboy** · 04-14-2005, 12:52 PM

There is nothing wrong with the spreadsheet. I just have more trades then lines to imput them and have to copy the formulas and adjust them.

**grandma** · 04-14-2005, 06:26 PM

cowboy wrote:

and have to copy the formulas and adjust them.

...and let me tell you - THAT is a bugger !! :s My excell keeps changing its mind on whether it is going to leave off the first numbers, or the last!!:@

**MR CARLO** · 04-14-2005, 10:04 PM

OK. Here we go. Icall it a function box. In exel go to Box A1, type in =A2-A3

The value in A1 will show A2 (A2 =5) & (A3 = 5) A1should show 0. Type (=A2+A3) addition. The box with the funtion will show the value. Also you can add or subtract multiply, divide as many boxes as you want. Excel can do many funtions. Under Menu insert - function, read the list, according to your level of math will determine whatyou can do.