Calculating quantity of shares in excel

[ajmol95]

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?

 

[James006]

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 ...!!!

 

[ajmol95]

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.

 

[Peter_SSs]

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.

Welcome to the MrExcel board!

Please make yourself aware of the Forum Rules, but particularly #4 and keep all the communication public.

 

[ajmol95]

Apologies about that, I was not aware of it.

 

[Peter_SSs]

Apologies about that, I was not aware of it.

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.

 

[ajmol95]

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.


[TABLE="width: 833"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Security Name[/TD]
[TD]Cusip/Sedol[/TD]
[TD]Trade Date[/TD]
[TD]Currency[/TD]
[TD]Number Of Share[/TD]
[TD]Price Per Share[/TD]
[TD]Total Amount[/TD]
[TD]Transaction_Type[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]13-Jan-03[/TD]
[TD]USD[/TD]
[TD]700[/TD]
[TD]142[/TD]
[TD]99435[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]31-Jan-03[/TD]
[TD]USD[/TD]
[TD]5000[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]28-Feb-03[/TD]
[TD]USD[/TD]
[TD]5000[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]12-Mar-03[/TD]
[TD]USD[/TD]
[TD]200[/TD]
[TD]153.7748[/TD]
[TD]30744.03[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]13-Mar-03[/TD]
[TD]USD[/TD]
[TD]100[/TD]
[TD]152.8333[/TD]
[TD]15277.86[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]13-Mar-03[/TD]
[TD]USD[/TD]
[TD]300[/TD]
[TD]153.5[/TD]
[TD]46033.61[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]14-Mar-03[/TD]
[TD]USD[/TD]
[TD]200[/TD]
[TD]148.9167[/TD]
[TD]29772.44[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]27-Mar-03[/TD]
[TD]USD[/TD]
[TD]300[/TD]
[TD]146.28[/TD]
[TD]43867.89[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]27-Mar-03[/TD]
[TD]USD[/TD]
[TD]100[/TD]
[TD]146.7[/TD]
[TD]14664.63[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]28-Mar-03[/TD]
[TD]USD[/TD]
[TD]200[/TD]
[TD]148[/TD]
[TD]29589.25[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]31-Mar-03[/TD]
[TD]USD[/TD]
[TD]3600[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]01-Apr-03[/TD]
[TD]USD[/TD]
[TD]200[/TD]
[TD]146.5[/TD]
[TD]29288.62[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]01-Apr-03[/TD]
[TD]USD[/TD]
[TD]300[/TD]
[TD]146.75[/TD]
[TD]44007.93[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]01-Apr-03[/TD]
[TD]USD[/TD]
[TD]1100[/TD]
[TD]146[/TD]
[TD]160600[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]02-Apr-03[/TD]
[TD]USD[/TD]
[TD]200[/TD]
[TD]146.5[/TD]
[TD]29288.62[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]08-Apr-03[/TD]
[TD]USD[/TD]
[TD]400[/TD]
[TD]144.349[/TD]
[TD]57716.89[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]09-Apr-03[/TD]
[TD]USD[/TD]
[TD]400[/TD]
[TD]146.0833[/TD]
[TD]58410.58[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]09-Apr-03[/TD]
[TD]USD[/TD]
[TD]300[/TD]
[TD]146.069[/TD]
[TD]43803.64[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]10-Apr-03[/TD]
[TD]USD[/TD]
[TD]100[/TD]
[TD]144[/TD]
[TD]14394.32[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]16-Apr-03[/TD]
[TD]USD[/TD]
[TD]200[/TD]
[TD]154.4[/TD]
[TD]30868.55[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]17-Apr-03[/TD]
[TD]USD[/TD]
[TD]400[/TD]
[TD]154.5002[/TD]
[TD]61777.18[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]25-Nov-03[/TD]
[TD]USD[/TD]
[TD]300[/TD]
[TD]46.75[/TD]
[TD]14040[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]26-Nov-03[/TD]
[TD]USD[/TD]
[TD]700[/TD]
[TD]48.15[/TD]
[TD]33740[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]26-Nov-03[/TD]
[TD]USD[/TD]
[TD]1000[/TD]
[TD]48.2933[/TD]
[TD]48343.3[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]28-Nov-03[/TD]
[TD]USD[/TD]
[TD]1500[/TD]
[TD]45.2756[/TD]
[TD]67988.4[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]30-Nov-03[/TD]
[TD]USD[/TD]
[TD]3500[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]01-Dec-03[/TD]
[TD]USD[/TD]
[TD]1000[/TD]
[TD]43.81[/TD]
[TD]43860[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]02-Dec-03[/TD]
[TD]USD[/TD]
[TD]700[/TD]
[TD]43.75[/TD]
[TD]30660[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]02-Dec-03[/TD]
[TD]USD[/TD]
[TD]600[/TD]
[TD]43.75[/TD]
[TD]26280[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]31-Dec-03[/TD]
[TD]USD[/TD]
[TD]5800[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]28-Jan-04[/TD]
[TD]USD[/TD]
[TD]200[/TD]
[TD]40[/TD]
[TD]8010[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]29-Jan-04[/TD]
[TD]USD[/TD]
[TD]3900[/TD]
[TD]40.6307[/TD]
[TD]158654.73[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]30-Jan-04[/TD]
[TD]USD[/TD]
[TD]500[/TD]
[TD]40.6737[/TD]
[TD]20361.85[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]31-Jan-04[/TD]
[TD]USD[/TD]
[TD]10400[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]29-Feb-04[/TD]
[TD]USD[/TD]
[TD]10400[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]29-Mar-04[/TD]
[TD]USD[/TD]
[TD]600[/TD]
[TD]54.9[/TD]
[TD]32932.71[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]31-Mar-04[/TD]
[TD]USD[/TD]
[TD]9800[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]30-Apr-04[/TD]
[TD]USD[/TD]
[TD]9800[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]06-May-04[/TD]
[TD]USD[/TD]
[TD]1300[/TD]
[TD]40.7673[/TD]
[TD]53062.49[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]13-May-04[/TD]
[TD]USD[/TD]
[TD]700[/TD]
[TD]38.2379[/TD]
[TD]26801.53[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]14-May-04[/TD]
[TD]USD[/TD]
[TD]2200[/TD]
[TD]37.46[/TD]
[TD]82522[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]17-May-04[/TD]
[TD]USD[/TD]
[TD]400[/TD]
[TD]38.9237[/TD]
[TD]15589.48[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]21-May-04[/TD]
[TD]USD[/TD]
[TD]1600[/TD]
[TD]38.7[/TD]
[TD]62000[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]25-May-04[/TD]
[TD]USD[/TD]
[TD]200[/TD]
[TD]36.15[/TD]
[TD]7240[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]27-May-04[/TD]
[TD]USD[/TD]
[TD]300[/TD]
[TD]36.1129[/TD]
[TD]10848.87[/TD]
[TD]BUY[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]31-May-04[/TD]
[TD]USD[/TD]
[TD]16500[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]HOLDING[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]02-Jun-04[/TD]
[TD]USD[/TD]
[TD]3000[/TD]
[TD]28.3[/TD]
[TD]84868.01[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]02-Jun-04[/TD]
[TD]USD[/TD]
[TD]4000[/TD]
[TD]28.5567[/TD]
[TD]114024.12[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]02-Jun-04[/TD]
[TD]USD[/TD]
[TD]900[/TD]
[TD]30[/TD]
[TD]26954.36[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]02-Jun-04[/TD]
[TD]USD[/TD]
[TD]900[/TD]
[TD]30.25[/TD]
[TD]27179.36[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]02-Jun-04[/TD]
[TD]USD[/TD]
[TD]400[/TD]
[TD]30.25[/TD]
[TD]12079.71[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]03-Jun-04[/TD]
[TD]USD[/TD]
[TD]900[/TD]
[TD]30.675[/TD]
[TD]27561.85[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]03-Jun-04[/TD]
[TD]USD[/TD]
[TD]2200[/TD]
[TD]30.447[/TD]
[TD]66871.83[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]03-Jun-04[/TD]
[TD]USD[/TD]
[TD]200[/TD]
[TD]31[/TD]
[TD]6189.85[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]04-Jun-04[/TD]
[TD]USD[/TD]
[TD]400[/TD]
[TD]30.4[/TD]
[TD]12139.71[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]04-Jun-04[/TD]
[TD]USD[/TD]
[TD]1300[/TD]
[TD]30.33[/TD]
[TD]39363.07[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]07-Jun-04[/TD]
[TD]USD[/TD]
[TD]800[/TD]
[TD]31.3269[/TD]
[TD]25020.93[/TD]
[TD]SELL[/TD]
[/TR]
[TR]
[TD]YUKOS CORP[/TD]
[TD]98849W108[/TD]
[TD]08-Jun-04[/TD]
[TD]USD[/TD]
[TD]1500[/TD]
[TD]32.9452[/TD]
[TD]49341.64[/TD]
[TD]SELL[/TD]
[/TR]
</tbody>[/TABLE]