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...
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...
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...
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...
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...
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...
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...
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...
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...
I have a series of transactions and need to calculate the average cost which includes both buys and sells.
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 *...
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...
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...
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...
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...
I have data as in the example below:
Sky TV Shares
ING Investment Bond
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...
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...
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)...
I need a formula that will show me what the share price needs to be before I make a profit
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...