Lukket

Calculation of Share Gains/Losses

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

Evner: Ingeniørarbejde, MySQL, PHP, Software Arkitektur, Software Testning, SQL

Se mere: sample received form, hire bot coder, date of hire, amount received, stock shares, sql commands, share, share trade, share platform, date calculation, trade stock, file share server, multiple trades, database stock trade, php calculate date, engineering calculations, php code calculate total, calculation php form, bot share, bot seller

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt ID: #3327632

25 freelancere byder i gennemsnit $213 på dette job

TakeRealUK

See private message.

$119 USD in 21 dage
(551 bedømmelser)
6.7
solutionsummit

See private message.

$127.5 USD in 21 dage
(72 bedømmelser)
6.7
association

See private message.

$144.5 USD in 21 dage
(110 bedømmelser)
6.5
vw391686vw

See private message.

$807.5 USD in 21 dage
(49 bedømmelser)
6.3
maramayvw

See private message.

$85 USD in 21 dage
(94 bedømmelser)
5.5
sergruch

See private message.

$170 USD in 21 dage
(84 bedømmelser)
5.4
getacoder

See private message.

$85 USD in 21 dage
(15 bedømmelser)
4.6
subhashnair

See private message.

$127.5 USD in 21 dage
(7 bedømmelser)
4.4
expertphpcodervw

See private message.

$85 USD in 21 dage
(10 bedømmelser)
3.7
mrunwal

See private message.

$255 USD in 21 dage
(12 bedømmelser)
3.4
lateralleap

See private message.

$170 USD in 21 dage
(2 bedømmelser)
2.6
raojune

See private message.

$135.15 USD in 21 dage
(7 bedømmelser)
2.4
andreismirnov

See private message.

$127.5 USD in 21 dage
(1 bedømmelse)
1.9
esafesystems

See private message.

$123.25 USD in 21 dage
(6 bedømmelser)
1.7
solarsoftvw

See private message.

$85 USD in 21 dage
(3 bedømmelser)
0.6
infoprovw

See private message.

$212.5 USD in 21 dage
(0 bedømmelser)
0.0
icreativevw

See private message.

$340 USD in 21 dage
(0 bedømmelser)
0.0
jbanxvw

See private message.

$85 USD in 21 dage
(1 bedømmelse)
0.8
seanhederman

See private message.

$85 USD in 21 dage
(0 bedømmelser)
0.0
Mikler

See private message.

$85 USD in 21 dage
(0 bedømmelser)
0.0