New Spreadsheet for 2005

[tsptalk]

If anyone wants to check out the new returns calculator, I have it posted on the Financial Utilities Page. Here are the links...

http://www.tsptalk.com/utilities.html (http://www.tsptalk.com/utilities.html)

http://www.tsptalk.com/utilities/instructions.html (http://www.tsptalk.com/utilities/instructions.html)

Feedback on both the spreadsheet and the instructions appreciated. Please let me know if you find any problems.

Thanks,
Tom

Thank you

[Show-me]

U da Man Tom! Thankyou!:^

[smedlap]

Good morning Tom. Good program and I will use it even though I trade in 100% blocks and make rare moves. C Fund column width needs to be expanded to 6.57.

Waiting for your valued assessment at TSPTALK on 2nd week of December.

Thanks

[Rod]

I'm trying to "save as" under "file", but nothing is happening...:%

Is anyone else experiencing?

[smedlap]

I copied and pasted it to a master file where I cross share personal data. No problems. Nice worksheet:^

[Rod]

Rod wrote:
I'm trying to "save as" under "file", but nothing is happening...:%

Is anyone else experiencing?

I figured it out... I had to right click on the LINK itself and click on "save target as".

So if anyone else experiences problems, try it that way.

Thanx Tom!:^

[tsptalk]

Thanks for the feedback! I made some minor changes to the instructions to make it more clear. Keep it coming.

Tom, how do you continue the spread sheet after 25 transactions? Or can you?

Thanks,

M_M

mlk_man wrote:
Tom, how do you continue the spread sheet after 25 transactions? Or can you?

Thanks,

M_M
Also, if you look at the spreadsheet I posted, the "My returns versus the other funds" doesn't appear to be working properly.

[tsptalk]

A little cut and paste editing should work for over 25 transactions. If you need help with that let me know. I'll check out the "My Return" comparison.

Thanks!

tsptalk wrote:
A little cut and paste editing should work for over 25 transactions. If you need help with that let me know. I'll check out the "My Return" comparison.

Thanks!
Did you find out anything with the "my return" part or is just me?

Thanks,

M_M

[tsptalk]

mlk_man wrote:
Did you find out anything with the "my return" part or is just me?

I made a change if you want to download it again. http://www.tsptalk.com/utilities.html

Thanks again for helping out.

tsptalk wrote:
mlk_man wrote:
Did you find out anything with the "my return" part or is just me?

I made a change if you want to download it again. http://www.tsptalk.com/utilities.html

Thanks again for helping out.
Will do, thanks!!

M_M

Close Tom, :P It has me trailing the S fund, but I should be slightly ahead.............

[FundSurfer]

Looks good on the instructions. I'll download and check your numbers. I had planned on re-arranging the columns as you had done to make it easier. On thing from the instuctions that was confusing was do you have to enter the fund prices for the day before and actual day of fund movement? Your example used Feb 9 & Feb 10. I do know that you don't need both sets of numbers for the math or you will get an error (unless you made a move the day before as well).

Thanks Tom, I know how much work can go into this kind of thing.

Sorry I haven't been active for a week, I'm in mid-move. Not much net access.

[FundSurfer]

Thanks Tom, I appreciate the amount of work that goes into updating a spreadsheet like this.



The instructions look good on paper. I’ll download and check your math. (I’ve been in mid-move for the last couple weeks with little access to the net.) I did have one question. Do you have to enter the transaction fund prices for the day before and the actual day of your trade? Your example shows Feb9 and feb 10. I know that from the math standpoint, you don’t use both sets of numbers (unless you had consecutive trading days). To me that was confusing. The cleanest way to do it is to put in the data for the day your trade was effective. Anyway, I’ll look at the spreadsheet and give you some feedback.

[FundSurfer]

I've found an error. I'll e-mail a correction to Tom as soon as I can but perhaps he can also fix the error. Basically the current spreadsheet multiplies gains from the previous trade by the percentages of the next trade.

Tom: example cell S7 should be (copy to bottom of column)

=((H6*M7)+(I6*N7)+(J6*O7)+(K6*P7)+(L6*Q7))

I'm not quite sure to do with cell s6 since you don't have previous percentages. Could add starting percentages on 12/31 as you did for the starting fund prices?

Also, the way you sum your annual return appears to not account for compounding properly. That may be too complicated for this spreadsheet but it does make a couple tenths of a percent difference over a year. I'll look at this a little further. (Tom - look at my spreadsheet to see how I handled this.)I think theerror will show up when you compare someone's calculated hypothetical $100,000 versus this spreadsheet. I have to think on this a little more to be sure. I seem to remember I needed to make the correction when I was checking Namors hypothetical numbers.

[FundSurfer]

Wierd. Sorry for the almost duplicated post above. I posted and thought it was lost cause it wasn't showing up, so I recreated. Now it looks like I'm repeating myself.

[tsptalk]

Thanks again guys! I made another update.

http://www.tsptalk.com/utilities.html

tsptalk wrote:
Thanks again guys! I made another update.

http://www.tsptalk.com/utilities.html

Looks good Tom, thanks.........

M_M

[FundSurfer]

The error I mentioned above is still there Tom. By putting in the instructions that you enter the last day of a trade and then the following actual day the trade takes place, you are limiting the error to cover just one days move, but the error is still there. You will see this error if you have a really big move on that day.

My opinion is that it is much cleaner to make the change I suggested and then only enter the information for the day of actual trade. The numbers are correct and you only enter once for each trade not twice.

[tsptalk]

I'm not sure I get it FundSurfer. Is it also wrong on my current 2003 spreadsheet (http://www.tsptalk.com/returns/returns.html)? If so, tell me which line so I know what you are referring to.

Does anyone else see this problem?

Thanks!
Tom

[FundSurfer]

FundSurfer wrote:
I've found an error. I'll e-mail a correction to Tom as soon as I can but perhaps he can also fix the error. Basically the current spreadsheet multiplies gains from the previous trade by the percentages of the next trade.

Tom: example cell S7 should be (copy to bottom of column)

=((H6*M7)+(I6*N7)+(J6*O7)+(K6*P7)+(L6*Q7))




I never did like the 2003 spreadsheet and the method for entering always messed me up, which is why I created the modified version. I think it has the same error. It is only off for 1 day for each trade because you enter day before trade and day of trade. I'll e-mail you the spreadsheet as I have it tommorrow. I don't have it at home. (Yep, finally plugged back in.) Above is the change I suggest.

Just try it. For input only enter the day of actual trade and corresponding values and the new fund percentages. No double entering and no error.

Want to find out if your works well? Enter in a couple months of Namors trades and compare to his monthly summary. You will see a big difference because he day trades a bunch.

[FundSurfer]

cell s7 currently =((H7*M7)+(I7*N7)+(J7*O7)+(K7*P7)+(L7*Q7))

H7 is the current fund allocation for row 7 - current trade. M7 is the percentage increase from C6 to C7 (increase for prior trade). Therefore you are multplying the current fund percentage times the percent increase for the prior trade. It continues across for each of the five funds.

[tsptalk]

I'll have to wait and see your version because I can't visualize the problem you are describing, unless we are just entering the data differently.

Thanks. I'll let you know what I discover once I get your email.
Tom

[FundSurfer]

OK. I sent the spreadsheet. I also downloaded your returns and put it into my spreadsheet to see what the difference is. It fluctuated through the year and got as high a 1/4%. I now understand better how you enter data and the error was not as bad as I thought. Your input line is different than mine. Each transaction date you enter the actual date, fund prices on that date, and fund percentages that you just changed from. I enter the actual date, fund prices for that day, and the new fund percentages. I see know why you were confused by my post.

As to entering method, that is just personal preference. There is still error between the spreadsheets which concerns me. I'll look closer when I get a chance.

[tsptalk]

FundSurfer -
I started looking at your spreadsheet. I will look closer at those differences in returns but I have to say the way you have it layed out is more confusing to me :*. The return on each line is actually for the previous line.It's hard for me to follow. kind of like me putting the ending date is tough to understand.

Like I said, I am taking a look at those returns and I will postmy findings.

Thanks for your help!!
Tom

[grandma]

tsptalk wrote:
http://www.tsptalk.com/utilities.html (http://www.tsptalk.com/utilities.html)

http://www.tsptalk.com/utilities/instructions.html (http://www.tsptalk.com/utilities/instructions.html)

Please let me know if you find any problems.

Thanks,
Tom

I haven't found a problem, I just Have one - :oo

I have Dec 31 prices in that first line named 2004. I have placed the Jan 3 updated share prices as instructed into line 1. But , even with the instructions in front of me concerning the Fund Allocation squares, I don't remember if Iuse my numbers for Before noon est, or After noon est for Jan 3 allotments.

So, if you please, some one please :# !!! And I thank you very much! :^

[tsptalk]

grandma wrote:
I have Dec 31 prices in that first line named 2004. I have placed the Jan 3 updated share prices as instructed into line 1. But , even with the instructions in front of me concerning the Fund Allocation squares, I don't remember if Iuse my numbers for Before noon est, or After noon est for Jan 3 allotments.
grandma,
Can you me the days you made your transactions (from Dec 31 on) if any, and tell me if it was before or after the 12 noon deadline? Also, if you'd like, tell me the allocations and I will tell you how it should look.

Thanks,
Tom

[grandma]

tsptalk wrote:

...the days you made your transactions (from Dec 31 on) if any, and tell me if it was before or after the 12 noon deadline?
Okay - I sent it e-mail. Thank you, sir...you are most appreciated.......;)