The Dividend Data Add-on provides extensive Data about historical and future dividend events.
Works with:
4K+
Overview
Introduction
The Dividend Data Add-on provides extensive Data about historical and future dividend events for a selected stock traded on Nasdaq.

Features
Any stock traded on Nasdaq can be selected. The user can select the period and the type of dividend Data to retrieve. The Add-on provides cash amount per stock unit, declaration date, ex-dividend date, record date and pay date for up to five years backwards. For older dividend events, up to 25 years backwards, the Add-on provides cash amount per share and ex-dividend date. The user can select which of this Data to display. The Add-on can display dividend event list in rows or columns. The user can select if to insert a header to the event list. The user can insert a graph of the generated table.

Availability
All features of the Add-on are available for free, immediately after installation. The Add-on can be called 50 times for free. Additional Calls can be purchased on line directly from the Add-on side bar. The Add-on informs the user about the remaining number of Calls.

Accountability
In case the user calls the Add-on but an error occurs, the Call will not be accounted and the remaining number of Calls will not be modified.

'Dividend Data' Menu
The 'Dividend Data' Menu can be found in Google Spreadsheet Menu under 'Add-ons'. It consists of four elements:

'Dividend Data' opens a side bar where the user can select which dividend Data to retrieve and how to display it.
'Purchase Calls' opens a side bar where the user can check how many Calls are available and select how many Calls to purchase.
'Help' opens this front window.
'About' opens a front window with details about the Add-on version and the author.
'Dividend Data' side bar
This sidebar is the main interface of the Add-on. Here the user can select which dividend Data to retrieve and how to display it. The elements of this side bar are:

'Symbol' to be filled with a ticker of a security traded on the Nasdaq Stock Exchange.
'Date Range' with 'Start' and 'End' dates to capture the event. A dividend event is captured if the ex-dividend date is within the specified start and end dates.
'Data to Fetch' where the user specifies which dividend Data to fetch from the databases. If only the 'Cash Amount' and 'Ex Date' are requested, dividend events of up to 25 years can be retrieved. If any other dividend Data is requested, dividend events of up to five years can be retrieved.
'Put Data per event in a' 'Row' or 'Column'. Dividend Data of one captured dividend event are put in one row, if 'Row' is selected, or are put in one column, if 'Column' is selected.
If 'Insert Header' is requested, the Add-on will add an additional row (if 'Row' is seleted) or column (if 'Column' is selected) with the name of the dividend Data. The order of dividend Data displayed per event is fixed and described in the next section.
If 'Insert Chart' is requested, and the 'Data to Fetch' 'Cash Amount' is checked and at least one more 'Data to Fetch' is fetched, and 'Put Data per event in a Row' is selected, then a chart will be inserted below the generated table. The chart horizontal axis will be 'Declaration Date' if checked, otherwise, 'Ex Date' if checked, otherwise 'Record Date' if checked, otherwise 'Pay Date'. The chart vertical axis will be the Cash Amount.
Press the 'Submit' button to call the Add-on, retrieve the dividend Data and display it starting from the current active cell in the current sheet. The 'Reset' button deletes the content of the side bar. The 'Cancel' button closes the side bar without executing the Add-on.

Dividend Data Order
Only the dividend Data requested in 'Data to Fetch' is displayed. The order of dividend Data displayed per event is fixed and is as follow:

Cash Amount, if requested.
Declaration Date, if requested.
Ex dividend Date, if requested.
Record Date, if requested.
Pay Date, if requested.
'Purchase Calls' side bar
This sidebar has two purposes: report the number of Calls available and purchase additional Add-on Calls. In order to purchase additional Calls, select how many Calls to purchase. Note the price discount increases with the bigger purchase. Press the 'Proceed' button that opens a new sidebar to select the method of payment. After selecting the method of Payment, a new PayPal front window will open to perform the payment. After a successful transaction, a pop up window will inform about the number of Calls available. The 'Dividend Data' side bar will be visible where the user can immediately retrieve new dividend Data using the newly purchased Calls.

Error Messages
Error messages are pop up windows that appear when no dividend Data was retrieved after pressing the 'Submit' button in the 'Dividend Data' side bar. The captured types of errors are:

Unrecognized symbol. The entered symbol is not trading on the Nasdaq Stock Exchange.
Invalid date range. The End Date is earlier than the Start Date
No dividend event. There was no dividend event between the Start Date and the End Date, or the date range is pointing to dates older than available in the database. Try widening your date range, provide more recent dates, or, request to retrieve only the Cash Amount and/or Ex dividend Date.
No more function Calls. Please purchase additional calls directly in Google Spreadsheet Menu, Add-on>Dividend Data>Purchase Calls.
Additional information
PricingNot available
Developer
Trader status unspecified
SupportNot available
Privacy policy
Terms of service
Dividend Data will ask for the permissions shown below. Learn more
Dividend Data will need access to your Google account
This will allow Dividend Data to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
828991
August 23, 2024
It does not work
Is this review helpful?
Yes
No
Profile Picture
Geoffrey Lordi
May 19, 2023
I could not establish even basic functionality within Sheets: no dividend prints, ticker identification, or dates. I deleted it.
Is this review helpful?
Yes
No
Profile Picture
Jandré Botha
September 7, 2023
Does not work.
Is this review helpful?
Yes
No
Profile Picture
J D
May 27, 2023
Doesnt work...
Is this review helpful?
Yes
No
Profile Picture
A User of Dividend Data
June 12, 2020
Tried this its not accurate or worth it. As a test I tried getting data on IMB and Nike (NKE) it would only pull data for the past six years. Tried another smaller random stock CLM and data was inaccurate and it only pulled 2 years history. Great concept would gladly pay for it, if it worked as intended.
Is this review helpful?
Yes
No
Profile Picture
Gareth van Rensburg
August 31, 2022
This is a scam and puts malware on your PC.
Is this review helpful?
Yes
No
Profile Picture
A User of Dividend Data
March 24, 2020
Works, but it's static. I can do a search for a company's dividend and copy/paste . Would be great if it could be used like a function in a formula, dynamically referencing a stock symbol in a cell, and allowed you to use the upcoming or most recent dividend payment in a formula.
Is this review helpful?
Yes
No
Profile Picture
Kyle J Hartman
August 14, 2020
Doesn't work at all. Looks promising, but I could not get it to run
Is this review helpful?
Yes
No
Profile Picture
Carlos Battousai
March 8, 2020
Does nothing
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 3, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
1-10 of 10
Search
Clear search
Close search
Google apps
Main menu