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).
Got a credit card? use our Credit Card & Finance Calculators
Thanks to niord,gvonge,Shelford,GrahamPlatt,gpadsa, for Donating to support the site
Tools (Excel) to view & download Future XD dates?
-
- Lemon Half
- Posts: 8471
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1554 times
- Been thanked: 3454 times
-
- Lemon Quarter
- Posts: 2306
- Joined: November 4th, 2016, 4:20 pm
- Has thanked: 1909 times
- Been thanked: 871 times
Re: Tools (Excel) to view & download Future XD dates?
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 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.
-
- Lemon Half
- Posts: 6139
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 1589 times
- Been thanked: 1801 times
Re: Tools (Excel) to view & download Future XD dates?
A good place to discuss this might be at Financial Software - Discussion:
http://www.lemonfool.co.uk/viewforum.php?f=27
http://www.lemonfool.co.uk/viewforum.php?f=27
Moderator Message:
Not a topic for HYP - Practical. Will move to the one suggested. Raptor.
Not a topic for HYP - Practical. Will move to the one suggested. Raptor.
-
- Lemon Quarter
- Posts: 4120
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3272 times
- Been thanked: 2859 times
Re: Tools (Excel) to view & download Future XD dates?
staffordian wrote: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
-
- Lemon Quarter
- Posts: 2306
- Joined: November 4th, 2016, 4:20 pm
- Has thanked: 1909 times
- Been thanked: 871 times
Re: Tools (Excel) to view & download Future XD dates?
Yes, sorry to confuse.
Should have read the question more closely.
Staffordian
Should have read the question more closely.
Staffordian
-
- Lemon Half
- Posts: 8471
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1554 times
- Been thanked: 3454 times
Re: Tools (Excel) to view & download Future XD dates?
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!!
Thanks!!
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 7 guests