undefeatedbrowns
New Member
- Joined
- Oct 3, 2018
- Messages
- 1
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 be multiple instances of the unique ID if the stock paid multiple dividends during the year. In column C is the dividend rate, column D is the ex-date and column E is the pay date.
In my output spreadsheet I have a ticker and I'm trying to write a formula that would pull the dividend rate if the ex-date is less than or equal to a date in my output spread sheet (cell A3) and the pay date is greater the date in my output spreadsheet (cell A3).
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 be multiple instances of the unique ID if the stock paid multiple dividends during the year. In column C is the dividend rate, column D is the ex-date and column E is the pay date.
In my output spreadsheet I have a ticker and I'm trying to write a formula that would pull the dividend rate if the ex-date is less than or equal to a date in my output spread sheet (cell A3) and the pay date is greater the date in my output spreadsheet (cell A3).