excel-formulastock
Calculate number of shares needed to buy to reach target price per share
Let's say you bought 10 shares at $146 a while ago totaling $1460. The price of per share today increased to $300. How many new shares do I need to buy to get the average price of all shares to, say, $200? Below is my excel. The answer in this scenario is 5.4 shares. How do I put this logic in a formula?
Solution
Perhaps the following:
=B2*(B7-B3)/(B6-B7)
- What is the equivalent of the "Days" function or number of days between 2 dates in excel 2007?
- Need help aligning a table to a column based on similar values in one table field
- Index rows and columns unexpected results
- Automatic numbering in Excel with hierarchy
- How to do a row-wise sum in an array formula in Excel?
- Transform datatable from column-based to row-based
- Combine most recent 5 records into one cell in Excel
- Matching multiple number rows and check corresponding dates within 90 days
- Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
- How can I use countif to return only a count if sum is > 0 but only count it once
- excel No of hours in a shift
- How do transform a "matrix"-table to one line for each entry in excel
- How to fill fast for integer number calculation?
- Find Corresponding Value Based on Today's Date Falling Between Week-Ending Dates in Excel
- Date format issue when I try to find the first occurrence of names with associated dates
- Excel - How can we replace multiple characters or whole words in a cell using LAMBDA()
- Nested if statements in EXCEL dependent on first condition
- List only workdays in given dynamic month
- INDIRECT array to refer to a table column not working with array formulas
- Putting a concatenate inside of a count if
- Excel: how to search by two rows and one column
- Excel - Check existing digit count, if <10 then add prefix "100" to make it 10 digit
- Custom Excel formula for length restriction of substring within a string in a cell
- COUNTIFS across multiple columns with multiple criteria
- Occurrence by month using Excel Functions
- Strange behavior in Excel when counting Work Hours and Work Super Hours
- Need help fixing my excel formula so it doesn't show #VALUE! error in end result
- Can I guarantee the Image Formula Function is finished before printing the result?
- Excel filter data in date intervals excluding all 0 values
- Count cells with two conditions