Calculating quantity of shares in excel

A

ajmol95

New Member
Joined
Oct 25, 2018
Messages
4
Hello,
Does anybody know how I can calculate the quantity of shares in a sheet where the specific date isn’t there?

The question is: what the holding positions (quantity of shares) would be for the following dates:

15th March 2003
14th March 2004

These dates are not in the actual sheet. Is there a formula I can use to work it out?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
Hello,

Without a clear explanation of the worksheets' structure ... impossible to answer to such a generic question ...

But ... be reassured ... with Excel ... everything IS possible ...!!!
 
Upvote 0
Hello James,

Thank you for that. Do you maybe have an email address and I can send you exactly what I am talking about? It is a bit difficult to explain over this thread.

Regards,
Ajmol.
 
Upvote 0
ajmol95 said:
Do you maybe have an email address and I can send you exactly what I am talking about? It is a bit difficult to explain over this thread.
Click to expand...
Welcome to the MrExcel board!

Please make yourself aware of the Forum Rules, but particularly #4 and keep all the communication public.
 
Upvote 0
ajmol95 said:
Apologies about that, I was not aware of it.
Click to expand...
We understand that you are new here. :)

My signature block below has a link for how to post small copyable screen shots in your post. Just make sure any sensitive data is removed or disguised.
 
Upvote 0
Thank you. The sheet I am using is below. The question that i need help answering is:
" Please calculate (using Excel formulae as appropriate) what the holding position (quantity of shares) would be for the following dates:
15th March 2003
14th March 2004"

Any answer of the formulae to use will be appreciated. Please have a look below for the sheet.


Security NameCusip/SedolTrade DateCurrencyNumber Of SharePrice Per ShareTotal AmountTransaction_Type
YUKOS CORP98849W10813-Jan-03USD70014299435BUY
YUKOS CORP98849W10831-Jan-03USD500000HOLDING
YUKOS CORP98849W10828-Feb-03USD500000HOLDING
YUKOS CORP98849W10812-Mar-03USD200153.774830744.03SELL
YUKOS CORP98849W10813-Mar-03USD100152.833315277.86SELL
YUKOS CORP98849W10813-Mar-03USD300153.546033.61SELL
YUKOS CORP98849W10814-Mar-03USD200148.916729772.44SELL
YUKOS CORP98849W10827-Mar-03USD300146.2843867.89SELL
YUKOS CORP98849W10827-Mar-03USD100146.714664.63SELL
YUKOS CORP98849W10828-Mar-03USD20014829589.25SELL
YUKOS CORP98849W10831-Mar-03USD360000HOLDING
YUKOS CORP98849W10801-Apr-03USD200146.529288.62SELL
YUKOS CORP98849W10801-Apr-03USD300146.7544007.93SELL
YUKOS CORP98849W10801-Apr-03USD1100146160600SELL
YUKOS CORP98849W10802-Apr-03USD200146.529288.62SELL
YUKOS CORP98849W10808-Apr-03USD400144.34957716.89SELL
YUKOS CORP98849W10809-Apr-03USD400146.083358410.58SELL
YUKOS CORP98849W10809-Apr-03USD300146.06943803.64SELL
YUKOS CORP98849W10810-Apr-03USD10014414394.32SELL
YUKOS CORP98849W10816-Apr-03USD200154.430868.55SELL
YUKOS CORP98849W10817-Apr-03USD400154.500261777.18SELL
YUKOS CORP98849W10825-Nov-03USD30046.7514040BUY
YUKOS CORP98849W10826-Nov-03USD70048.1533740BUY
YUKOS CORP98849W10826-Nov-03USD100048.293348343.3BUY
YUKOS CORP98849W10828-Nov-03USD150045.275667988.4BUY
YUKOS CORP98849W10830-Nov-03USD350000HOLDING
YUKOS CORP98849W10801-Dec-03USD100043.8143860BUY
YUKOS CORP98849W10802-Dec-03USD70043.7530660BUY
YUKOS CORP98849W10802-Dec-03USD60043.7526280BUY
YUKOS CORP98849W10831-Dec-03USD580000HOLDING
YUKOS CORP98849W10828-Jan-04USD200408010BUY
YUKOS CORP98849W10829-Jan-04USD390040.6307158654.73BUY
YUKOS CORP98849W10830-Jan-04USD50040.673720361.85BUY
YUKOS CORP98849W10831-Jan-04USD1040000HOLDING
YUKOS CORP98849W10829-Feb-04USD1040000HOLDING
YUKOS CORP98849W10829-Mar-04USD60054.932932.71SELL
YUKOS CORP98849W10831-Mar-04USD980000HOLDING
YUKOS CORP98849W10830-Apr-04USD980000HOLDING
YUKOS CORP98849W10806-May-04USD130040.767353062.49BUY
YUKOS CORP98849W10813-May-04USD70038.237926801.53BUY
YUKOS CORP98849W10814-May-04USD220037.4682522BUY
YUKOS CORP98849W10817-May-04USD40038.923715589.48BUY
YUKOS CORP98849W10821-May-04USD160038.762000BUY
YUKOS CORP98849W10825-May-04USD20036.157240BUY
YUKOS CORP98849W10827-May-04USD30036.112910848.87BUY
YUKOS CORP98849W10831-May-04USD1650000HOLDING
YUKOS CORP98849W10802-Jun-04USD300028.384868.01SELL
YUKOS CORP98849W10802-Jun-04USD400028.5567114024.12SELL
YUKOS CORP98849W10802-Jun-04USD9003026954.36SELL
YUKOS CORP98849W10802-Jun-04USD90030.2527179.36SELL
YUKOS CORP98849W10802-Jun-04USD40030.2512079.71SELL
YUKOS CORP98849W10803-Jun-04USD90030.67527561.85SELL
YUKOS CORP98849W10803-Jun-04USD220030.44766871.83SELL
YUKOS CORP98849W10803-Jun-04USD200316189.85SELL
YUKOS CORP98849W10804-Jun-04USD40030.412139.71SELL
YUKOS CORP98849W10804-Jun-04USD130030.3339363.07SELL
YUKOS CORP98849W10807-Jun-04USD80031.326925020.93SELL
YUKOS CORP98849W10808-Jun-04USD150032.945249341.64SELL

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 
Upvote 0
You must log in or register to reply here.

Similar threads

Agnarr
  • Question
VBA problem with creating new sheets
Replies
0
Views
352
Agnarr
Agnarr
J
  • Question
Commission Sheet auto load into commission log
Replies
3
Views
106
Rijnsent
Rijnsent
E
  • Question
From two dates, dividing the years into different columns, create hyperlinks organized by quantity and not by dates
Replies
0
Views
146
ExcelenteNovel
E
A
  • Question
Calculate Optimum Duration in Loan
Replies
1
Views
329
anuradhagrewal
A
B
  • Question
Help with VBA code to copy/paste into another workbook then email
Replies
1
Views
234
bh24524
B

Forum statistics

Threads
1,215,063
Messages
6,122,928
Members
449,094
Latest member
teemeren

Share this page

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
Back
Top