Google Answers Logo
View Question
 
Q: attn juggler-ga: Additional Wash Sale Calcs ( No Answer,   0 Comments )
Question  
Subject: attn juggler-ga: Additional Wash Sale Calcs
Category: Business and Money > Accounting
Asked by: cmaury-ga
List Price: $15.00
Posted: 01 Feb 2004 12:30 PST
Expires: 11 Feb 2004 12:50 PST
Question ID: 302507
You may or may not remember me from this time last year.

Here's links to our original work:

http://answers.google.com/answers/threadview?id=177442
http://answers.google.com/answers/threadview?id=178286

I know enough about wash sales to know that I don't want to calc this (again!)

Based on the transaction data provided, please provide the data
necessary to fill out my records.  For each entry that I need to put
in my records, I need 1) A Description 2)Net Sale Price 3)Date Sold
4)Cost or Basis and 5)Date Aquired.

I need to know which of the 7 transactions represent Wash Sales
(if any.)


***************************************************

The amount paid for this information will be increased by at least $25
dollars (as a tip.)  I'll try to give more.

Thank you in advance.

(Btw, here's the info for calculating ACTR, since it was purchased in '02:
12/30/2002	ACTR	Buy	6161	0.18	1108.98	1118.97)

Trade Date	Symbol	Action	Quantity	Price	Amount	Net Amount
1/2/2003	ACTR	Sell	8461	0.18	1522.98	1512.94
5/20/2003	AMR	Buy	520	6.24	3244.8	3254.79
5/20/2003	AMR	Sell	520	6.06	3151.2	3141.06
5/20/2003	AMR	Buy	517	6.07	3138.19	3148.18
5/20/2003	AMR	Sell	517	6.15	3179.55	3169.41
5/20/2003	AMR	Buy	522	6.05	3158.1	3168.09
5/21/2003	AMR	Sell	522	6.01	3137.22	3127.08
6/3/2003	ATML	Buy	865	2.91	2517.15	2527.14
6/3/2003	ATML	Sell	125	2.89	361.25	351.24
6/3/2003	ATML	Sell	740	2.87	2123.8	2113.71
4/25/2003	AVAN	Buy	2609	1.51	3939.59	3949.58
4/25/2003	AVAN	Sell	100	1.45	145	135
4/25/2003	AVAN	Sell	2509	1.36	3412.24	3402.09
5/5/2003	CMGI	Sell	1363	1.09	1485.67	1475.61
5/5/2003	CMGI	Buy	1320	1.11	1465.2	1475.19
5/5/2003	CMGI	Sell	1320	1.13	1491.6	1481.54
5/5/2003	CMGI	Buy	3200	1.12	3584	3593.99
5/5/2003	CMGI	Buy	1363	1.07	1458.41	1468.4
5/5/2003	CMGI	Sell	3200	1.09	3488	3477.84
5/5/2003	CMGI	Buy	3183	1.09	3469.47	3479.46
5/6/2003	CMGI	Sell	3183	1.1	3501.3	3491.14
5/9/2003	CMGI	Buy	3431	1.03	3533.93	3543.92
5/9/2003	CMGI	Sell	3431	1.04	3568.24	3558.08
5/9/2003	CMGI	Buy	3444	1.03	3547.32	3557.31
5/9/2003	CMGI	Sell	3444	1.04	3581.76	3571.6
5/9/2003	CMGI	Buy	1350	1.03	1390.5	1400.49
5/9/2003	CMGI	Sell	1350	1.05	1417.5	1407.44
5/9/2003	CMGI	Buy	3432	1.04	3569.28	3579.27
5/9/2003	CMGI	Sell	3432	1.05	3603.6	3593.44
5/9/2003	CMGI	Buy	3349	1.07	3583.43	3593.42
5/9/2003	CMGI	Sell	3349	1.08	3616.92	3606.76
5/9/2003	CMGI	Buy	3331	1.08	3597.48	3607.47
5/12/2003	CMGI	Sell	3331	0.98	3264.38	3254.23
5/19/2003	CMGI	Buy	2787	1.16	3232.92	3242.91
5/19/2003	CMGI	Sell	2787	1.16	3232.92	3222.77
1/6/2003	DDIC	Buy	3058	0.24	733.92	743.91
1/6/2003	DDIC	Sell	2059	0.24	494.16	494.14
1/6/2003	DDIC	Sell	500	0.24	120	119.99
1/6/2003	DDIC	Sell	399	0.24	95.76	85.76
1/6/2003	DDIC	Sell	100	0.24	24	23.99
1/8/2003	DDIC	Sell	3386	0.23	778.78	768.76
1/8/2003	DDIC	Buy	3000	0.22	660	669.99
1/8/2003	DDIC	Buy	386	0.22	84.92	84.92
1/9/2003	DDIC	Buy	3600	0.21	756	765.99
1/9/2003	DDIC	Sell	3000	0.22	660	659.98
1/9/2003	DDIC	Sell	500	0.22	110	109.99
1/9/2003	DDIC	Sell	100	0.22	22	12
3/25/2003	DDIC	Buy	4008	0.12	480.96	490.95
3/26/2003	DDIC	Sell	4008	0.13	521.04	511.03
3/26/2003	DDIC	Buy	3992	0.13	518.96	528.95
3/26/2003	DDIC	Buy	1500	0.13	195	204.99
3/26/2003	DDIC	Buy	2000	0.13	260	260
3/26/2003	DDIC	Buy	353	0.13	45.89	45.89
3/26/2003	DDIC	Sell	3853	0.14	539.42	529.41
3/27/2003	DDIC	Sell	3992	0.13	518.96	508.95
3/27/2003	DDIC	Buy	3326	0.15	498.9	508.89
3/27/2003	DDIC	Sell	3326	0.16	532.16	522.15
3/28/2003	DDIC	Buy	2694	0.19	511.86	521.85
3/28/2003	DDIC	Sell	2694	0.22	592.68	582.67
3/28/2003	DDIC	Buy	2604	0.22	572.88	582.87
4/14/2003	DDIC	Sell	2604	0.1	260.4	250.39
5/19/2003	ENMD	Buy	925	3.51	3246.75	3256.74
5/19/2003	ENMD	Sell	925	3.55	3283.75	3273.6
1/9/2003	FTGX	Buy	2000	0.12	240	240
1/9/2003	FTGX	Buy	1900	0.12	228	228
1/9/2003	FTGX	Buy	1200	0.12	144	144
1/9/2003	FTGX	Buy	900	0.12	108	117.99
1/10/2003	FTGX	Buy	6280	0.12	753.6	763.59
1/10/2003	FTGX	Sell	6000	0.12	720	709.98
1/13/2003	FTGX	Buy	8500	0.13	1105	1114.99
1/13/2003	FTGX	Sell	6280	0.13	816.4	806.38
1/21/2003	FTGX	Sell	8500	0.12	1020	1009.97
1/21/2003	FTGX	Buy	8350	0.12	1002	1011.99
3/24/2003	FTGX	Sell	8350	0.06	501	490.99
5/22/2003	IVAN	Buy	4860	0.66	3207.6	3217.59
5/23/2003	IVAN	Sell	4860	0.64	3110.4	3100.26
5/28/2003	IVAN	Sell	6000	0.43	2580	2569.88
5/28/2003	IVAN	Buy	6000	0.41	2460	2469.99
5/28/2003	IVAN	Sell	6000	0.42	2520	2509.89
5/28/2003	IVAN	Buy	5927	0.43	2548.61	2558.6
5/28/2003	IVAN	Sell	5927	0.44	2607.88	2597.76
5/28/2003	IVAN	Buy	6000	0.43	2580	2589.99
6/11/2003	IVAN	Buy	3670	0.77	2825.9	2835.89
6/11/2003	IVAN	Sell	3670	0.77	2825.9	2815.77
6/11/2003	IVAN	Buy	3450	0.8	2760	2769.99
6/11/2003	IVAN	Sell	3450	1.02	3519	3508.84
6/11/2003	IVAN	Buy	3111	1.14	3546.54	3556.53
6/11/2003	IVAN	Sell	3111	1.11	3453.21	3443.05
6/11/2003	IVAN	Buy	3200	1.07	3424	3433.99
6/11/2003	IVAN	Sell	2200	1.04	2288	2281.06
6/11/2003	IVAN	Sell	1000	1.06	1060	1056.79
6/11/2003	IVAN	Buy	3000	1.08	3240	3249.99
6/11/2003	IVAN	Sell	3000	1	3000	2989.86
6/11/2003	IVAN	Buy	2903	1.05	3048.15	3058.14
6/11/2003	IVAN	Sell	2903	0.94	2728.82	2718.7
6/11/2003	IVAN	Buy	2738	1	2738	2747.99
6/11/2003	IVAN	Sell	2738	0.94	2573.72	2563.6
5/29/2003	IWAV	Sell	58	2.41	139.78	129.78
6/5/2003	IWAV	Sell	125	2.41	301.25	291.24
5/1/2003	IWAVD	Sell	800	2.71	2168	2157.9
5/1/2003	IWAVD	Buy	862	2.56	2206.72	2216.71
5/2/2003	IWAVD	Sell	62	2.71	168.02	158.02
5/2/2003	IWAVD	Buy	900	2.56	2304	2313.99
5/5/2003	IWAVD	Buy	680	2.16	1468.8	1478.79
5/5/2003	IWAVD	Sell	1580	2.28	3602.4	3592.24
5/6/2003	IWAVD	Buy	1619	2.15	3480.85	3490.84
5/7/2003	IWAVD	Sell	450	2.19	985.5	975.46
5/9/2003	IWAVD	Sell	500	2.25	1125	1114.95
5/9/2003	IWAVD	Sell	669	2.3	1538.7	1528.63
5/9/2003	IWAVD	Buy	100	2.32	232	241.99
5/9/2003	IWAVD	Buy	200	2.32	464	473.99
5/9/2003	IWAVD	Sell	300	2.34	702	691.97
5/27/2003	IWAVD	Buy	683	2.36	1611.88	1621.87
5/27/2003	IWAVD	Sell	100	2.41	241	230.99
5/28/2003	IWAVD	Sell	400	2.38	952	941.96
5/7/2003	LU	Buy	435	2.22	965.7	975.69
5/9/2003	LU	Sell	435	2.28	991.8	981.76
5/9/2003	LU	Buy	1255	2.31	2899.05	2909.04
5/9/2003	LU	Sell	1255	2.28	2861.4	2851.27
5/29/2003	LU	Buy	1070	2.4	2568	2577.99
6/2/2003	LU	Sell	1070	2.25	2407.5	2397.39
1/23/2003	MTWV	Buy	2600	0.21	546	555.99
1/23/2003	MTWV	Buy	7000	0.21	1470	1470
1/23/2003	MTWV	Buy	4347	0.23	999.81	1009.8
1/23/2003	MTWV	Sell	4347	0.24	1043.28	1033.25
1/23/2003	MTWV	Sell	9600	0.22	2112	2101.94
1/24/2003	MTWV	Buy	12160	0.2	2432	2441.99
1/24/2003	MTWV	Buy	9775	0.21	2052.75	2062.74
1/24/2003	MTWV	Sell	9775	0.21	2052.75	2042.69
1/24/2003	MTWV	Buy	11680	0.2	2336	2345.99
1/24/2003	MTWV	Sell	11680	0.21	2452.8	2442.73
1/24/2003	MTWV	Buy	12160	0.2	2432	2441.99
1/24/2003	MTWV	Buy	9775	0.21	2052.75	2062.74
1/24/2003	MTWV	Sell	9775	0.21	2052.75	2042.69
1/24/2003	MTWV	Buy	11680	0.2	2336	2345.99
1/24/2003	MTWV	Sell	11680	0.21	2452.8	2442.73
1/27/2003	MTWV	Sell	500	0.04	20	10
1/27/2003	MTWV	Sell	11660	0.04	466.4	466.38
1/2/2003	NSSI	Buy	4660	0.16	745.6	755.59
1/6/2003	NSSI	Buy	5100	0.14	714	723.99
1/8/2003	NSSI	Sell	5100	0.15	765	754.98
1/10/2003	NSSI	Sell	2000	0.16	320	310
1/24/2003	NSSI	Sell	2660	0.1	266	256
1/24/2003	NSSI	Sell	2660	0.1	266	256
5/28/2003	ORCH	Buy	2133	1.26	2687.58	2697.57
5/28/2003	ORCH	Sell	2133	1.28	2730.24	2720.12
5/28/2003	ORCH	Buy	2069	1.31	2710.39	2720.38
5/28/2003	ORCH	Sell	2069	1.33	2751.77	2741.65
5/28/2003	ORCH	Buy	2054	1.33	2731.82	2741.81
5/28/2003	ORCH	Sell	2054	1.26	2588.04	2577.92
5/28/2003	ORCH	Buy	1976	1.3	2568.8	2578.79
5/28/2003	ORCH	Sell	1976	1.28	2529.28	2519.17
4/22/2003	SGI	Buy	218	1.18	257.24	267.23
4/25/2003	SGI	Buy	3122	1.13	3527.86	3537.85
5/1/2003	SGI	Buy	1318	1.09	1436.62	1446.61
5/1/2003	SGI	Sell	3340	1.1	3674	3663.83
5/5/2003	SGI	Sell	1318	1.12	1476.16	1466.1
5/12/2003	SGI	Sell	2595	1.27	3295.65	3285.5
5/12/2003	SGI	Buy	2595	1.25	3243.75	3253.74
5/12/2003	SGI	Buy	2558	1.28	3274.24	3284.23
5/12/2003	SGI	Sell	1558	1.3	2025.4	2015.31
5/12/2003	SGI	Buy	1567	1.28	2005.76	2015.75
5/12/2003	SGI	Sell	2567	1.3	3337.1	3326.95
5/12/2003	SGI	Buy	2532	1.31	3316.92	3326.91
5/13/2003	SGI	Sell	2532	1.26	3190.32	3180.18
5/19/2003	SGI	Buy	2868	1.12	3212.16	3222.15
5/19/2003	SGI	Sell	2868	1.14	3269.52	3259.37
5/19/2003	SGI	Sell	2916	1.13	3295.08	3284.93
5/19/2003	SGI	Buy	2951	1.11	3275.61	3285.6
5/19/2003	SGI	Sell	2951	1.11	3275.61	3265.46
5/19/2003	SGI	Buy	2916	1.12	3265.92	3275.91
5/21/2003	SGI	Buy	2787	1.12	3121.44	3131.43
5/21/2003	SGI	Sell	2787	1.14	3177.18	3167.04
5/22/2003	SGI	Buy	2735	1.17	3199.95	3209.94
5/22/2003	SGI	Sell	2735	1.18	3227.3	3217.15
5/22/2003	SGI	Buy	2770	1.14	3157.8	3167.79
5/22/2003	SGI	Sell	2770	1.16	3213.2	3203.05
5/22/2003	SGI	Buy	2752	1.16	3192.32	3202.31
5/22/2003	SGI	Sell	2752	1.17	3219.84	3209.69
5/23/2003	SGI	Buy	2862	1.08	3090.96	3100.95
5/23/2003	SGI	Sell	2862	1.09	3119.58	3109.44
5/23/2003	SGI	Buy	2869	1.08	3098.52	3108.51
5/23/2003	SGI	Sell	2869	1.09	3127.21	3117.07
5/23/2003	SGI	Buy	2851	1.09	3107.59	3117.58
5/27/2003	SGI	Sell	1458	1.12	1632.96	1622.89
5/27/2003	SGI	Buy	2858	1.1	3143.8	3153.79
5/27/2003	SGI	Sell	2851	1.11	3164.61	3154.47
5/27/2003	SGI	Sell	1400	1.11	1554	1543.93
5/28/2003	SGI	Buy	1550	1.14	1767	1776.99
5/28/2003	SGI	Sell	1550	1.14	1767	1756.92
6/2/2003	SGI	Buy	2200	1.14	2508	2517.99
6/3/2003	SGI	Sell	2200	1.15	2530	2519.89
6/6/2003	SGI	Buy	2390	1.15	2748.5	2758.49
6/6/2003	SGI	Sell	2390	1.18	2820.2	2810.07
6/6/2003	SGI	Buy	2295	1.22	2799.9	2809.89
6/6/2003	SGI	Buy	100	1.25	125	134.99
6/6/2003	SGI	Buy	745	1.25	931.25	931.25
6/6/2003	SGI	Buy	600	1.25	750	750
6/6/2003	SGI	Buy	800	1.25	1000	1000
6/6/2003	SGI	Sell	2295	1.22	2799.9	2789.77
6/6/2003	SGI	Buy	2230	1.23	2742.9	2752.89
6/6/2003	SGI	Sell	2230	1.25	2787.5	2777.37
6/6/2003	SGI	Buy	2244	1.25	2805	2814.99
6/6/2003	SGI	Sell	2244	1.26	2827.44	2817.31
6/9/2003	SGI	Sell	2245	1.29	2896.05	2885.92
6/9/2003	SGI	Buy	1063	1.33	1413.79	1423.78
6/9/2003	SGI	Sell	1063	1.38	1466.94	1456.88
6/9/2003	SGI	Buy	2093	1.39	2909.27	2919.26
6/10/2003	SGI	Sell	2093	1.36	2846.48	2836.35
6/10/2003	SGI	Buy	2094	1.35	2826.9	2836.89
6/10/2003	SGI	Sell	2094	1.36	2847.84	2837.71
6/11/2003	SGI	Buy	1877	1.36	2552.72	2562.71
6/13/2003	SGI	Sell	1877	1.25	2346.25	2336.15
6/3/2003	SIRI	Buy	1054	2.33	2455.82	2465.81
6/3/2003	SIRI	Sell	1054	2.35	2476.9	2466.79
1/3/2003	SONS	Buy	650	1.13	734.5	744.49
1/3/2003	SONS	Sell	550	1.14	627	626.98
1/3/2003	SONS	Sell	100	1.14	114	104
4/14/2003	SONS	Buy	77	3.12	240.24	250.23
4/21/2003	SONS	Sell	77	3.6	277.2	267.19
5/13/2003	SUNW	Buy	600	4.24	2544	2552.02
5/13/2003	SUNW	Buy	147	4.238	622.99	624.96
5/19/2003	SUNW	Sell	747	4.35	3249.45	3239.3
6/13/2003	WBR	Sell	1090	0.64	697.6	687.57
6/13/2003	WBR	Buy	3575	0.65	2323.75	2333.74
6/13/2003	WBR	Sell	3575	0.62	2216.5	2206.4
6/13/2003	WBR	Buy	3490	0.63	2198.7	2208.69
6/16/2003	WBR	Buy	1130	0.6	678	687.99
6/18/2003	WBR	Sell	3530	0.64	2259.2	2249.1
6/18/2003	WBR	Buy	3553	0.63	2238.39	2248.38
6/18/2003	WBR	Sell	3553	0.65	2309.45	2299.35
6/18/2003	WBR	Buy	3469	0.66	2289.54	2299.53
6/18/2003	WBR	Sell	3469	0.64	2220.16	2210.06
6/18/2003	WBR	Buy	3492	0.63	2199.96	2209.95
6/18/2003	WBR	Sell	3492	0.64	2234.88	2224.78
6/18/2003	WBR	Sell	3460	0.65	2249	2238.9
6/18/2003	WBR	Buy	3460	0.64	2214.4	2224.39
6/18/2003	WBR	Buy	3328	0.67	2229.76	2239.75
6/19/2003	WBR	Sell	3328	0.68	2263.04	2252.94
6/19/2003	WBR	Buy	3398	0.66	2242.68	2252.67
7/1/2003	WBR	Sell	3398	0.48	1631.04	1620.97
7/1/2003	WBR	Buy	3287	0.49	1610.63	1620.62
7/1/2003	WBR	Sell	387	0.51	197.37	187.37
7/1/2003	WBR	Sell	2900	0.5	1450	1439.94
7/1/2003	WBR	Buy	3236	0.5	1618	1627.99
7/9/2003	WBR	Sell	3236	0.5	1618	1607.93
7/9/2003	WBR	Buy	2905	0.55	1597.75	1607.74
7/9/2003	WBR	Sell	2905	0.53	1539.65	1529.58
7/9/2003	WBR	Buy	2923	0.52	1519.96	1529.95
7/9/2003	WBR	Sell	2923	0.53	1549.19	1539.12
7/9/2003	WBR	Buy	2940	0.52	1528.8	1538.79
7/21/2003	WBR	Sell	2940	0.45	1323	1312.94
7/22/2003	WBR	Buy	2550	0.51	1300.5	1310.49
7/24/2003	WBR	Sell	2550	0.52	1326	1315.94
7/24/2003	WBR	Buy	2560	0.51	1305.6	1315.59
7/24/2003	WBR	Sell	1060	0.52	551.2	541.18
7/24/2003	WBR	Buy	1068	0.5	534	543.99
8/4/2003	WBR	Sell	2568	0.48	1232.64	1222.59
8/5/2003	WBR	Buy	750	0.44	330	339.99
8/5/2003	WBR	Buy	2000	0.44	880	880
8/11/2003	WBR	Sell	2750	0.39	1072.5	1062.45

Clarification of Question by cmaury-ga on 01 Feb 2004 12:32 PST
Opps, I noticed that I talked about 7 transactions, but that is
obviously a mistake.  I simply copied the original post and forgot to
edit it out.  I know there are more than 7 here.

Request for Question Clarification by juggler-ga on 01 Feb 2004 13:00 PST
Hi CMaury,

Nice to hear from you again!

A couple questions...

Is there another 'buy' date for ACTR?  I notice that you bought 6161
shares on 12/30, but sold 8461.  When did you buy the other 2300
shares?

When do you need this done by?

Clarification of Question by cmaury-ga on 01 Feb 2004 13:10 PST
I REALLY need to start checking my work a little more closely... :)

Here's the beginning transaction
12/27/2002	ACTR	Buy	3300	0.19	627	636.99

followed by a partial sale
12/27/2002	ACTR	Sell	1000	0.2	200	190

and this will account for the missing 2300 shares.

I need it when you can get it to me.  The sooner I get it, the sooner
I can file.  This is one of the last items I have to calculate.  Let
me know an estimate, if you can.

ty

Request for Question Clarification by juggler-ga on 01 Feb 2004 15:14 PST
I haven't actually started preparing, but I skimmed through your numbers once.  

You have two unbalanced transactions.

The following entries appear twice in your list:

1/24/2003	MTWV	Buy	12160	0.2	2432	2441.99

1/24/2003	NSSI	Sell	2660	0.1	266	256


Each of the duplicate entries is only off-set once.

Is it possible that you accidentally duplicated these entries?

Or were these entries related to prior-year transactions? 

-----

As for an estimate...  I don't know.  Maybe by tomorrow if I devoted a
lot of time to it.  I have done it before, so I have a feel for it,
but it's still a rather large project.  Considering the amount of
hours I'll need to put in to it, the bigger the proffered tip, the
faster I'll try to do it. Would $100 be possible?

Request for Question Clarification by juggler-ga on 02 Feb 2004 02:09 PST
Disregard my previous "maybe by tomorrow" comment... 

Based on the amount of time it's taking me for each sale, Monday is
impossible.  This is seriously like a 12+ hour project. I can't devote
that much time to it today, but I might be able to have it done by
Wednesday or Thursday.
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy