How to get Upcoming Ex-Dividend Dates in MS Excel with MarketXLS

Discussion in 'Stock Screener' started by marketxls, Apr 10, 2017.

How to get Upcoming Ex-Dividend Dates in MS Excel with MarketXLS

  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    616
    Likes Received:
    5
    MarketXLS gives data for Upcoming Ex-Dividend Dates in MS Excel. But first lets understand the term and its importance.

    What is Ex-Dividend?
    Ex-dividend is a classification of trading shares when a declared dividend belongs to the seller rather than the buyer. A stock will be given ex-dividend status if a person has been confirmed by the company to receive the dividend payment.

    What is Ex-Dividend Date?
    When a company decides to declare a dividend, its board of directors establishes a record date. This is the date when a person must be on the company’s record as a shareholder to receive the dividend payment.

    Why its knowledge is important?
    Investors need to buy the dividend-paying stock at least three days before the record date, since trades take three days to settle.

    How can you get Upcoming Ex-Dividend Dates in MS Excel using MarketXLS?
    1) Click on Upcoming Ex-Dividend Dates under Stock Screeners option in the MarketXLS tab in Microsoft Excel. It will show you the upcoming Ex-Dividend dates for Stocks and ETFs.

    Upcoming-ex-dividend-dates[1].png

    2) You can now sort the data Yield wise and take data for top yielding stocks and ETFs.

    3) More the Dividend Yield value, better is the Stocks/ETF for buying.

    table[1].png
     
    #1 marketxls, Apr 10, 2017
    Last edited: Apr 10, 2017

Share This Page