Shares Trading

sajad570

New Member
Joined
Aug 1, 2011
Messages
3
Hi,
I need to manipulate some data related to shares trading.
info i have
1. Opening Stock
2. daily buying and selling report

What i need is
1. to be able to view the profit all transaction by selecting a date range.
2. maintain a stock in hand report as of each day.



Sheet 1

Stock Report
As of 31-Dec-2013
CompanySharesAvg CostAmount
Company 1 30,000.00 28.38 851,370.19
Company 2 10,000.00 30.16 301,631.15

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Sheet 2
Daily Trading Report
01-Jan-2014 Opening Balance 1,853,637.79 1,853,637.79
07-Jan-2014Buy4003United Electronics Company (4,000)96.500167.91Ref: (386,167.91) - 1,467,469.88
07-Jan-2014Sell1211Saudi Arabian Mining Co. 30,00033.304-434.71Ref: - 998,680.19 2,466,150.07
07-Jan-2014Buy2050Savola Group (1,202)62.75032.81Ref: (75,458.31) - 2,390,691.76
09-Jan-2014Buy1010Riyad Bank (30,000)30.700400.64Ref: (921,400.64) - 1,469,291.12
09-Jan-2014Sell1040Saudi Hollandi Bank 10,00042.000-182.70Ref: - 419,817.30 1,889,108.42

<colgroup><col><col><col><col><col><col><col><col span="3"><col><col></colgroup><tbody>
</tbody>




Sheet 3
Portfolio Activity
From1-Jan-2014.
To12-Jan-14
DateDescriptionSalesPurchase / Cost of SalesGPGP%
Qty@SARQty@SAR
07-Jan-2014Company 1 30,000 33.29 998,680.19 30,000 28.38 851,370 147,310.0014.75%
09-Jan-2014Company 2 10,000 41.98 419,817.30 10,000 30.16 301,631 118,186.1528.15%
Total 40,000 1,418,497.49 40,000 1,153,001 265,49618.72%
07-Jan-2014United Electronics Company (4,000) 96.54 (386,167.91)
07-Jan-2014Savola Group (1,202) 62.78 (75,458.31)
09-Jan-2014Riyad Bank (30,000) 30.71 (921,400.64)
Total (35,202) (1,383,026.86)

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,123,270
Messages
5,600,637
Members
414,398
Latest member
dhune

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top