shares

1. Formula to Calculate Shares

I am trying to calculate the amount of shares I can purchase using the formula below. However, when I use a calculator the amount of shares to buy is different from the excel shares to buy. What am I doing wrong with the formula? Thanks for your help. =(A2*B2)-C2/D2 or =A2*B2-C2/D2 Account...
2. Match dates to amount vba

Hi, I'm quite new to excel modelling, and I've been asked to create a model of controlling an employee warrant program. I'm in trouble of solving the following situation: An employee are exercising: 4/6 - 20 warrants 6/6 - 20 warrants 18/6 - 7 warrants When the warrants are exercised they...
3. Is it possible to look up individual prices in a range, and then calculate the number of items at individual price

This is share market related. Just trying to see how many shares, at various prices , were traded during day. This is an example of the csv file I want to work on Excel WorkbookABC1TimePrice \$Volume24:10:16 PM1.055256234:10:16 PM1.0552500044:10:16 PM1.051000054:10:16 PM1.0451000064:10:16...
4. Help with a formula

<tbody> Hi guys, I am trying to use a vlookup up to calculate whether a capital gain or loss has been made or lost when selling shares. A major problem I have is; if shares are purchased in two separate lots and at different prices, when I sell a portion of the shares I need...
5. Vlookup or something else?

<colgroup><col span="9"></colgroup><tbody> Hi guys, I am trying to use a vlookup up to calculate whether a capital gain or loss has been made or lost when selling shares. A major problem I have is; if shares are purchased in two separate lots and at different prices, when I...
6. Vlookup with multiple values and a limiter

Hi guys, I am trying to use a vlookup up to calculate whether a capital gain or loss has been made or lost when selling shares. A major problem I have is; if shares are purchased in two separate lots and at different prices, when I sell a portion of the shares I need to calculate the capital...
7. User Form Combo Box Not Filling?

Afternoon all, As a VBA beginner, I'm currently having an issue with my user form where the combo box isn't populating with the options "I Shares" and "S Shares". I suspect that it may be an issue due to the start of the code in terms of the userform_initialize? If I'm being honest I'm not...
8. SumIFS with specific text within a cell

I have a sheet of roughly 2,000 investors. I am trying to keep track of each of their investments. Some of them invest indivisually, some invest through a specific account. For example, John Smith has invested through three different accounts that appear as follows: Column A Column B...
9. Calculating quantity of shares in excel

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...
10. 2 variable data table not working

I am trying to do a very simple valuation. I am trying to do a two variable data table using PE as one variable and number of shares as second variable. As I increase the Pre-IPO number of shares, EPS will be reduced. So, the share price should also reduce. But I am seeing an increase of share...
11. Weighted average cost formula required

Hi, I have a series of transactions and need to calculate the average cost which includes both buys and sells. E.g. Purchase 100 shares @£1/share Purchase 50 shares @£1.50/share Sell 25 shares @£2/share Purchase 30 shares @£1.60/share Weighted total cost after each transaction £100 (100 *...
12. Sum an array up until a match

Good evening everyone, I'm on a big excel project and I've run into another problem and I feel a little stumped. I'm have a table here that is pulling data from multiple sources. We will use the SGC-US Dividends example (AK:AQ) Column AQ is pulling the history of our trades with that stock...
13. Linking to a website

I have a workbook containing data referring to the progress of my shares which is linked to a website which contains a table of historical data relating to the closing price of the shares. Unfortunately the web page does not remain static which means that the formulas in my spreadsheet do not...
14. Weighted Average

I am trying to find out how many shares of stock I can purchase based off the following: A) Total money available to spend on stocks is \$100. B) I want to buy two stocks. C) Stock #1 price is \$10. D) Stock #2 price is \$20. The question is this... How many shares can I buy if I can only...
15. Cookie setting question....

I'm using a custom web browser in my stocks & shares Excel workbook, it opens to a specific page based on the shares currently entered in the main sheet, and displays any RNS releases for those shares, everything is working fine with one minor annoyance........ cookies all the time i'm using...
16. Autcopy selected details to another worksheet, without blank rows between items

I have data as in the example below: <tbody> Investment Value Advice required? Barclays £100,000.00 Yes Ist National £50,000.00 No Buy-to-Let Property £325,000.00 Yes Sky TV Shares £1,000.00 Yes ING Investment Bond £50,000.00 No ICI Shares £30,000.00 No MG...
17. Rounding shares to whole numbers

Hi everyone, This is potentially more of a math question, but I'm hoping there is an excel formula that could also help. I'm trying to divide a number of shares by percentages with 14 decimals. The end number of shares needs to be a whole number, however whenever I round I am always left with...
18. Isolating dates for comparison

I have some shares and i want to do some comparisons. eg. This month vs last month, this week vs last week, this week vs last 6 weeks ect I have been experimenting with the advanced filter but keep bringing my self to confusion. For now what i need is to extract data for each year, month, and...
19. How to create a spreadsheet with alterable cells using vesting schedules

Hi! I have a chart with four columns: shares, grant date, vesting schedule, and prior sales. With this information, I have to create a spreadsheet that calculates how many of Employee X's shares will be vested on any given future date, taking into consideration (i.e. adding alterable cells)...
20. Stocks & Shares

I need a formula that will show me what the share price needs to be before I make a profit Example Share price bought at 0.41p Admin charge to buy £10 shares bought 24.33 Current share price 0.40p Admin charge to sell £10 So in theory I have lost £20.39 because the share price hasn't gone upto...

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

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