400+ transactions Stock profit & loss calculation in Excel

IN PROGRESS
Bids
22
Avg Bid (USD)
$117
Project Budget (USD)
$30 - $250

Project Description:
using accounting method, first in first out (FIFO)calculate profit/loss.
see the example in first sheet, 30-40% is already completed as example.

400+ transactions Stock profit & loss calculation in Microsoft Excel

Description

Please take a look at the attached files (this is only an example, the actual sheet that I have has much more approx 418 lines, but I prepared this one for the sake of the example).

3 Files:
freelancer 2006 DCL 1099.pdf
freelancer-Stock - DCL ONLY v4.xls (2 tabs, one short by symbol, another by date)
sample entry page.jpg

freelance provider prerequisite:
understand stock transactions
understand FIFO accounting methods
understand 1099 form only documents sells of transaction, no information on buying (cost basis)

Jobs:
1. I need to produce another excel that match form 1099’s dates, and other information that needs to complete the “sample entry page.jpg“

List of things needed are:
1) Descriptions:
2) Gross Proceeds from Gross Sale After Commission and Fees.
3) Cost Basis
4) Date of sale
5) Date of Acquired.

To qualify this job:
Must send sample “answer” calculations from date 6/6/2006 symbol SCHW (high lighted in yellow) about 15 transactions.

Must provide estimated number of hours that will be using for this project and estimate completion date and time.

Some of the works has already been completed.


Additional info:
What solution would you suggest here? Is it possible to produce the sheets using excel or would it need an external software to make this process efficient.

Open to suggestions.

Thank you!

Additional Project Description:
11/19/2010 at 23:13 EST
also make mark/notices of the cost basis according to the US stock wash sale rules

http://en.wikipedia.org/wiki/Wash_sale


11/20/2010 at 13:19 EST
the stock transaction is "sort by date" which follows the form 1099, that's was one of our goal.

there are 2 tabs, one sort by date, another sort symbol.

we needed you to calculate "cost basis" to match the 1099.

Skills required:
Accounting, Audit, Data Processing, Excel
Additional Files: freelancer-Stock+-+DCL+ONLY+v4.xls sample+entry+page.JPG 2006+DCL+1099+-+Freelacner1.pdf
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire waqar21081974
$ 150
in 3 days
$ 100
in 3 days
Hire UltimateJob
$ 100
in 1 days
$ 99
in 10 days
Hire techmbapat
$ 100
in 1 days
Hire musukhan
$ 80
in 2 days
Hire Alishanuj
$ 150
in 5 days
Hire imii1981
$ 100
in 2 days
Hire Ranpariya
$ 70
in 2 days
Hire WealthManager
$ 50
in 30 days