Dividend Comparison

The Dividend Comparison Add-on provides historical dividend per year for selected stocks traded on Nasdaq.

Multiple stocks traded on Nasdaq can be selected. The user can select the period of dividend Data to retrieve. The Absolute Cash Amount or Relative Change in Cash Amount between consecutive years can be retrieved The Add-on can calculate the CAGR for each of the selected stocks for the selected period. The user can insert a graph of the generated table.

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.

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.

The 'Dividend Comparison' menu can be found in the Google Sheets™ menu under 'Extensions' → 'Add-ons'. It consists of four elements:

• 'Dividend Comparison' 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.

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 list' to be filled with a comma separated ticker list of a securities traded on the Nasdaq Stock Exchange.
• 'Number of Years Backwards' with the amount of years for which to retrieve Cash Amounts.
• 'Comparison Type' where the user specifies how to compare the stocks. 'Absolute' shows the cash amount per share for each of the selected securities. 'Relative' calculates the difference in cash amount per share between two consecutive years, for each of the selected securities.
• '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 'Chart' is selected for 'Outputs', a chart will be inserted below the generated table. The chart horizontal axis will be the years. The chart vertical axis will be the Cash Amount, if 'Absolute' was selected for 'Comparison Type'. It will be the relative change if 'Relative' was selected.

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.

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 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 symbols. None of the entered symbol is trading on the Nasdaq Stock Exchange.
• No more function calls are available. Please purchase additional calls directly in the Google Sheets™ menu under Extensions → Add-ons → Dividend Info → Purchase Calls.