Calculation of Share Gains/Losses

Closed Posted Aug 25, 2004 Paid on delivery
Closed Paid on delivery

I have a database of stock transactions covering a 60 day period.

The file contains:

account

type of stock (common vs. preferred)

number of shares bot/sold (+/-)

trade date

share price

Allocating shares on a first in/first out basis. For each purchase, I need to calculate:

how many shares were sold on Days 1-15 and at what aggregate value (so # of shares and and total amount received)

how many were sold on Day 16 and at what aggregate value

how many were sold on Day 17 and at what aggregate value

how many were sold on Day 18-60 and at what aggregate value

how many shares were held by the account at the end of the period.

There are multiple accounts in the file - and the calculations need to be done separately for each class of stock.

Should be noted that there isn't always a 1:1 matchup between trades. Purchases can be allocated amoong several sales - and sales can be allocated among several purchases.

This needs to be done in T-SQL to run on a MS SQL Server 2000 installation.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done (SQL Commands/Scripts - including sample tabales).<BR>

2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Sql Server 2000

Engineering MySQL PHP Software Architecture Software Testing SQL

Project ID: #3327632

About the project

25 proposals Remote project Active Sep 15, 2004

25 freelancers are bidding on average $213 for this job

TakeRealUK

See private message.

$119 USD in 21 days
(551 Reviews)
6.7
solutionsummit

See private message.

$127.5 USD in 21 days
(72 Reviews)
6.7
association

See private message.

$144.5 USD in 21 days
(110 Reviews)
6.5
vw391686vw

See private message.

$807.5 USD in 21 days
(49 Reviews)
6.3
maramayvw

See private message.

$85 USD in 21 days
(94 Reviews)
5.5
sergruch

See private message.

$170 USD in 21 days
(84 Reviews)
5.4
getacoder

See private message.

$85 USD in 21 days
(15 Reviews)
4.6
subhashnair

See private message.

$127.5 USD in 21 days
(7 Reviews)
4.4
expertphpcodervw

See private message.

$85 USD in 21 days
(10 Reviews)
3.7
mrunwal

See private message.

$255 USD in 21 days
(12 Reviews)
3.4
lateralleap

See private message.

$170 USD in 21 days
(2 Reviews)
2.6
raojune

See private message.

$135.15 USD in 21 days
(7 Reviews)
2.4
andreismirnov

See private message.

$127.5 USD in 21 days
(1 Review)
1.9
esafesystems

See private message.

$123.25 USD in 21 days
(6 Reviews)
1.7
solarsoftvw

See private message.

$85 USD in 21 days
(3 Reviews)
0.6
infoprovw

See private message.

$212.5 USD in 21 days
(0 Reviews)
0.0
vishalhporwalvw

See private message.

$85 USD in 21 days
(1 Review)
1.7
salussl

See private message.

$552.5 USD in 21 days
(1 Review)
0.0
mail2veejay

See private message.

$85 USD in 21 days
(1 Review)
0.0
Mikler

See private message.

$85 USD in 21 days
(0 Reviews)
0.0