FundSurfer
Well-known member
imported post
I'd be willing to bet that I know the error you made in the spreadsheet. It is fairly common misperception. It took me a while to catch how Tom set up his spreadsheet as well. I actually use a modified version of Tom's worksheet to track a bunch of people at once. I've got it set up so I only have to update the share prices once instead of each time for each participant and set up to give me monthly percentages for the Tally page. I'd be glad to e-mail it. I have it in excel format and I have to change the extension since it has macros and hotmail doesn't like e-mailing doc's with macros. I actually cut all the macros out but it still gets hung up.
I'll PM you with my e-mail address. If you'll send me your spreadsheet with errors, I'll correct them and stick them in my tracking spreadsheet and send it back to you. That way you can see how the data is entered. Pyriel uses Tom's spreadsheet so his formating is almost exactly the same as Tom's (changes have been made to allow for people who make a bunch of trades). I've resisted changing over because I've found mine easier to update which is important when you are doing a bunch of people.
I'd be willing to bet that I know the error you made in the spreadsheet. It is fairly common misperception. It took me a while to catch how Tom set up his spreadsheet as well. I actually use a modified version of Tom's worksheet to track a bunch of people at once. I've got it set up so I only have to update the share prices once instead of each time for each participant and set up to give me monthly percentages for the Tally page. I'd be glad to e-mail it. I have it in excel format and I have to change the extension since it has macros and hotmail doesn't like e-mailing doc's with macros. I actually cut all the macros out but it still gets hung up.
I'll PM you with my e-mail address. If you'll send me your spreadsheet with errors, I'll correct them and stick them in my tracking spreadsheet and send it back to you. That way you can see how the data is entered. Pyriel uses Tom's spreadsheet so his formating is almost exactly the same as Tom's (changes have been made to allow for people who make a bunch of trades). I've resisted changing over because I've found mine easier to update which is important when you are doing a bunch of people.