Your 'Go To' for Custom Excel Solutions
excel-applications-blue2

Dividend Data Extract

Another free spreadsheet from XLAutomation, this one to provide a consolidated routine that extracts dividend information for your list of securities. It accesses multiple sources (eg Yahoo) of information and returns it in different formats for use in your trading analysis.

Dividend Data Extract

To extend the range of free spreadsheets we provide the Dividend Data extract which enables the extraction of dividend data for a given set of stocks over an investment period. The data is returned in created worksheets or separate CSV files. The data is sourced from available websites that provide dividend data.

Note: Dividend historical data is provided for information only and should not be used as the basis for share trading. XLAutomation accepts no liability for errors and/or delays in data or for transactions carried out on the basis thereof.

Features - Dividend Extract v2 - Released 3rd January, 2018

This extract workbook is similar in processing to the Historical Price Extract released last year following a change to the Yahoo website that affected the download of historical prices. You provide a list of security codes and set the extract parameters and then extract the data. Here are some of the key features of this new data extract spreadsheet.

  • Security Code copy in each security code that is required for extraction. No need to worry about duplicates as processing is included to remove duplicates if they are included to the list of securities.
  • Extract End Date is set to the date up to which you want to extract the dividend data. To get the latest you set this to today's date.
  • Number of Periods is set to the number of months prior to the extract date that you want to search for dividend data
  • List of Errors will display any securities that could not be found.
  • AUD dividend details are extracted from a information website that provides franking details, these details are included to the outputs if found. AUD securities are identified by the exchange code ".AX", all other securities are sourced from Yahoo and do not include any franking details.
  • Output is defaulted to "Worksheet" which will display the results on a separate worksheet for each security and the worksheet "CombinedOutput". You can select the option to export the data to separate "CSV" files if that is required for your processing.

Tell us what other features you think this workbook should have and we will include it to the enhancement list. Click on the button below to jump to the page comments

Another Free Spreadsheet by XLAutomation.

If you found this spreadsheet helpful please make a donation.

Free Sample Excel Workbook

See below an image to demo the sample workbook that is provided. Enter the security code and required date into the highlighted cells then click "Extract Historical Data". The historical dividend data will then be returned for each security. The date returned will be the closest possible prior to the supplied date.

Note: This workbook has been tested on Windows running Office 2013. No testing on MAC has been performed. To run in a MAC environment will require Windows virtualisation.

Download Your Free Dividend Data Extract Spreadsheet

Enter your details below to receive your copy of Dividend Data Extract 

Note: If you previously downloaded Dividend Data Extract, enter your email address again to receive the updated version

Another Free Spreadsheet by XLAutomation.

If you found this spreadsheet helpful please make a donation.

promise

 

Our Promise: "We will only use your contact details to share the latest news, free spreadsheets and product information from the XLAutomation team. We will never share your contact details with anyone else.

Tell us what you think...

Thanks to the trading community who have downloaded our spreadsheet. We would love to know how useful you've found this solution, and if you think we could include anything else to make it even better! Leave a comment and let us know.

2 Comments

  1. Sambhu Jana on May 3, 2018 at 7:33 pm

    How to download dividend data for preferred stock?

    • Scott Lindsay on May 4, 2018 at 4:16 am

      You can specify your preferred stock in the list of stocks in column A of the download sheet

Leave a Comment