Author Topic: In search of online dividend date tool  (Read 2519 times)

MarcherLady

  • Magnum Stache
  • ******
  • Posts: 3712
  • Age: 6
  • Location: Somewhere North of the Arctic Circle, UK
In search of online dividend date tool
« on: September 17, 2014, 11:13:55 AM »
I'm looking for an online tool which will allow me to enter the holdings in my portfolio and show me the published, upcoming dividend dates and values, all of them on one page.  For free, obviously ☺. My investment platform holds that data, but only on each holding's detailed page, not in one easy to compare table. My holding are mainly Vanguard  and individual UK stocks.  Anyone have any suggestions? 

J'onn J'onzz

  • 5 O'Clock Shadow
  • *
  • Posts: 62
  • Age: 43
  • Location: Dallas, TX
Re: In search of online dividend date tool
« Reply #1 on: September 17, 2014, 02:48:33 PM »
You can use the formula below in a google spreadsheet to get the amount of the next payment, as stated by google finance. As far as upcoming dates I do not know how to get that.

=IF(ISBLANK($A12)," ",(REGEXextract(REGEXreplace(index (importhtml("https://www.google.com/finance?q=NYSE%3A" &A12, "table", 2), 1, 2); "[()]"; "") ; "([^/]*)/"))*1)

where both A12 is replaced by whatever cell holds the ticket of the stock you want the dividend of.

sheepstache

  • Handlebar Stache
  • *****
  • Posts: 2419
Re: In search of online dividend date tool
« Reply #2 on: September 17, 2014, 03:27:43 PM »
Helpful, J'onn J'onzz!  I'm assuming it will populate the field on the date when they're declared, which would at least remind me to check when it's being paid out.

Subscribing in case there's an answer to the original question.

J'onn J'onzz

  • 5 O'Clock Shadow
  • *
  • Posts: 62
  • Age: 43
  • Location: Dallas, TX
Re: In search of online dividend date tool
« Reply #3 on: September 17, 2014, 03:35:15 PM »
The field will always be populated with the latest declared dividend payment. If a dividend increase is declared the new value usually shows up within a day or 2 of declaration.


MarcherLady

  • Magnum Stache
  • ******
  • Posts: 3712
  • Age: 6
  • Location: Somewhere North of the Arctic Circle, UK
Re: In search of online dividend date tool
« Reply #4 on: September 18, 2014, 03:04:20 AM »
Oh, cool, that would work, thanks :-)

MarcherLady

  • Magnum Stache
  • ******
  • Posts: 3712
  • Age: 6
  • Location: Somewhere North of the Arctic Circle, UK
Re: In search of online dividend date tool
« Reply #5 on: September 18, 2014, 03:29:50 AM »
For UK holdings replace the URL in that query with "https://www.google.co.uk/finance?q=LON%3A"

Edit:
The original query as posted by J'onn J'onzz returns the price range of a UK stock when my URL above is substituted for his.  Not sure if that's as a result of the substitution, or a typo in the original query.  J'onn J'onzz, if you have time please can you confirm?  In the mean time I'm playing with it myself and will post if I get the correct result.  But RegEx is not my strong suit :-)

2nd Edit:
Ah, got it, nothing wrong with J'onn J'onzz's regex.  For the next dividend replace the bolded 2 with a 3: This works both for NYSE using the original URL and UKX using my URL.  Thanks J'onn J'onzz.

=IF(ISBLANK($A12)," ",(REGEXextract(REGEXreplace(index (importhtml("https://www.google.com/finance?q=NYSE%3A" &A12, "table", 2), 1, 2); "[()]"; "") ; "([^/]*)/"))*1)
« Last Edit: September 18, 2014, 03:47:27 AM by MarcherLady »

deborah

  • Senior Mustachian
  • ********
  • Posts: 10110
  • Location: Australia or another awesome area
Re: In search of online dividend date tool
« Reply #6 on: September 18, 2014, 03:37:54 AM »
Ah, the Australian version is ASX or https://www.google.com/finance?q=ASX%3A
« Last Edit: September 18, 2014, 03:40:42 AM by deborah »