url genereate spreadsheet function

Concatenate function in Excel and Google Docs


So as previously mentioned, I’m (gradually) improving at using Excel for fun and profit. Actually, in this case I’m using Google Docs, since it uses most of the same features and syntax, with a few random add-ons.

Here’s one little project that actually got somewhere. It’s a Google Docs spreadsheet where I’m taking a copy-pasted table of last year’s ex-dividend announcements in the month of May, trimmed them down to stock symbols, and then used those stock symbols to automatically generate links.

Why do this? Well, some stocks do a quick “jump” after the dividend announcement, it would be convenient to have an automatically-generated list of links to observe each stock’s performance post-announcement. These announcements usually come around the same date each year. I generated this list to test my theory, but it should be emphasized that this just spreadsheet advice, and definitely not financial advice!

How to make it:

The first step was to copy-paste the dividend calendars from last year into the spreadsheet. Because the info is already in table format, you just need to select the box that you want to become the upper-left-hand corner of the pasted information. This is repeated until you have a nice, long list of stocks and info, which can then be sorted by Excel/Google Sheets. You can also freeze the upper row of the sheet, so that you have labels as you scroll through.