Hi all,

I am trying to firm up in my mind the cloumn on the valuation statement in CA3 listed "First Buy or Valuation Date"  I was thinking that it would be beneficial that is the club sells all it's shares in a certian stock, that the First Buy or Valuation Date would reset to the date of the second purchase, instead of staying with the first purchase.

Say we bought Aflac in 1998 and sold all of it in 2006.  Then in 2009 we purchase Aflac again, it seems loigical to me that the First Buy or Valuation Date column would list 2007 as the correct date.  However, the curret setup shows First Buy or Valuation Date as 1998.   Say in the two years since we purchased the stock in 2009 it had gone up 12% that would be pretty good return, however as it lists now it might "look" like that the stock had only returned 12% since 1998-  not so hot.

What am I missing or can someone help me understand this? 

Thanks

Mark

In addition, here are instructions for myICLUB.com that Sean posted previously in the Toolshed forum in Support Ticket 40: Re-bought stock.

Doug,

Perhaps this may have something to do with it.  I went in and printed out a transaction history on MCD and found this entry

Feb 11,2011 we sold 25 shares and while these came out of our blocks 22 & 23, the blocks listed on the report list 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,22

We sold out of MCD in total Nov, 2002 and no activity was noted until April 2009.  In the early years the club used dividend reinvestment and did not realize how troublesome that is for treasurers,  putting in 0.061620 shares quarterly.  But that was before I took over as treasurer. 

So, I don't understand why the program wants to sell shares now (2011) of the first lot that was bought in 1995 and closed out in 2002.  It should list 22 and 23 only, not earlier lots and when you review the transaction it only list the current lots and inparticular 22 & 23.

Mark

 Hi Mark,

From my experience with this, I'd suggest the following:

1. Make a backup
2. Go into the transaction history for the club, and for the sell transactions in 11/14/02 , 11/19/02 AND 02/11/11, double-click to open up the details.
3. Copy down the details for those transactions, then delete all three of them.
4. Once all three are deleted, then re-enter them, using the same dates, ammounts, etc. It may sound obvious, but re-ener them in order from the earliest to the newest.

I suspect even though the Total shares and total cost show 0.00 after the 11/19/02 transaction, that there must have been some fractional cost basis, or bit of a share left over that got picked up on the 02/11/11 Sell transaction. The process of re-doing these transactions should get the program to re-check them, and hopefully work out the cost basis correctly.

If this doesn't work, then best to Restore the backup from step 1, and get a copy of the data sent in to us through the regular support line.  I'm setting up a ticket in the support queue with this information, so if need be, you can reply back to that with the file attached.