Tools (Excel) to view & download Future XD dates?

[monabri]

I would be grateful if anyone could suggest tools to download predicted dates when shares go XD in 2017?

I'm using the HYP_top_up file.xls to pick up the predicted overall dividends for 2017 but I get an error when I click on the "view dividends" macro button.

The error report is:-

(Forbidden -You don't have permission to access /dividend-payment-dates.py on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request).

[staffordian]

The spreadsheet you are using has ADVFN as an alternative source for dividend information, there is a config tab* on which you can set the source.

The dividend data site is great, but very intolerant of multiple hits, hence the message you are getting.

There are threads about it on LemonFool.

HTH

Staffordian

*I think it's called this; I'm not using my laptop at the moment so am going from memory.

[PinkDalek]

A good place to discuss this might be at Financial Software - Discussion:

http://www.lemonfool.co.uk/viewforum.php?f=27

Moderator Message:
Not a topic for HYP - Practical. Will move to the one suggested. Raptor.

[kiloran]

The spreadsheet you are using has ADVFN as an alternative source for dividend information, there is a config tab* on which you can set the source.
The dividend data site is great, but very intolerant of multiple hits, hence the message you are getting.
There are threads about it on LemonFool.
HTH

Staffordian
*I think it's called this; I'm not using my laptop at the moment so am going from memory.

The "View Dividends" on the main "High Yield Portfolio" sheet unfortunately is hard-coded to get data from the Dividend Data website. It's only the Dividend sheet that has optional data sources.
Maybe we can think about changing this so that "View Dividends" picks up the selected data source.

For the moment, the only solution is to (hopefully!) get a new IP address by rebooting the router

--kiloran

[staffordian]

Yes, sorry to confuse.

Should have read the question more closely.

Staffordian

[monabri]

Problem resolved !! After reading your mgs above I discovered the pull down menu on the "parameters" sheet which was set to "upcoming dividends". I toggled this to "ADVDN" and this sorted it in the "Dividends" sheet. This is exactly what I was looking for!

Thanks!!