dividend

  1. R

    If value in report combobox A, B or C, then another combo box d or e.

    Good day all, I have a simple issue that I am struggling to resolve. In an access report I have a combobox (Called "InterestCode") that looks up a value from a query and outputs that value. There are a number of options , eg. M1, M2, M3, P1, P2 etc. Depending on this value, I would like...
  2. M

    Dividend Increase per year knowing the starting dividend and the ending dividend.

    It's such a simple question, but I don't know how to write the formula... Here's the question: If one knows that in 2018 that $3.59 was paid in dividends, and that in 2024 the expected dividend is $7.10, what is the percentage increase per year that will get you from $3.59 to $7.10? Thanks...
  3. U

    Extract unique value between two dates based on multiple occurrences of a unique ID

    Hi, I'm trying to extract the dividend rate for a stock(ticker) from a data spreadsheet but I only need the dividend rate if the dividend's ex date and pay date fall before and after a certain date. In the "data" spreadsheet, in column A I have a list of tickers or unique IDs but there can...
  4. S

    Combining multiple into one, and ordering the data

    Good evening everyone, I'm build a sheet following an investment portfolio and I need to extract all dividend data so I can update the portfolio total value in chronological order. I'm currently using a database (Factset) which is feeding by some of the raw data (Dividend amounts, dates etc)...
  5. S

    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...
  6. B

    If then add

    Good afternoon all Dividing the below, when the result is greater than 8 add .5 to the divisor and then divide the dividend by the new divisor. <colgroup><col width="70" style="width:53pt"> <col width="86" style="width:65pt"> <col width="96" style="width:72pt"> </colgroup><tbody> 70.25...
  7. M

    Oldtimer trying to learn

    Hello Everyone, I'm a rather new user to Excel but I have been learning alot through self study. I found this forum today an I am hoping someone can explain how I would develop a formula to help with analyzing stock dividend information. I have copied and pasted stock data into the excel...
  8. B

    Copy Unknown Rows To Another Sheet

    Hello I have a spreadsheet with multiple columns that after filtering column G I want to copy those lines onto another spreadsheet. My hurdle is that those lines vary, it could be one, ten, etc. Without getting into too much detail here is part of the code. Essentially I want to copy any lines...

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