Update to HYP Top-Up spreadsheet

[NeilW]

(and Neil, if you are reading this, I still have your problem on my to-do list. There always seems to be other problems to work on )

--kiloran

I am, and I know and appreciate that feeling.

As ever I am grateful for your attention. It's not an easy problem to solve.

[kiloran]

(and Neil, if you are reading this, I still have your problem on my to-do list. There always seems to be other problems to work on )
--kiloran

I am, and I know and appreciate that feeling.
As ever I am grateful for your attention. It's not an easy problem to solve.

NeilW.... did you see the PM I sent a few days ago?

--kiloran

[woodenman]

Don't know if anyone else is experiencing this, but I am having an issue getting DL forecast yields in the watchlist after going from LibreOffice a-y to b-a

Clicking on the button shows the 'Processing XXX' with the expected first ticker, but nothing seems to happen. It's not a total hang of the application and forecast yields still works on the HYP page. I even tried removing my top watched company (ASHM) to see if that was the issue, but it also hangs on the next row (TATE) and ASHM still works on my a-y sheet.

Running on latest LO (after upgrading to see if that was the issue) on Win10. Tried debugging, but I'm not familiar with LO's macro system and it appears some things run fine clicking the button which don't work on step-through (it complains about not finding the 'downloads' sheet, for instance)

[Breelander]

Don't know if anyone else is experiencing this, but I am having an issue getting DL forecast yields in the watchlist after going from LibreOffice a-y to b-a

Clicking on the button shows the 'Processing XXX' with the expected first ticker, but nothing seems to happen. It's not a total hang of the application and forecast yields still works on the HYP page.

Yes, I've just tested it. In b-a the 'get DL yields' works on the HYP page but not on the Watchlist, either for a Watchlist imported (copy & pasted) from my (working) a-t sheet, or for a Watchlist created from scratch within b-a.

[kiloran]

Don't know if anyone else is experiencing this, but I am having an issue getting DL forecast yields in the watchlist after going from LibreOffice a-y to b-a

Clicking on the button shows the 'Processing XXX' with the expected first ticker, but nothing seems to happen. It's not a total hang of the application and forecast yields still works on the HYP page. I even tried removing my top watched company (ASHM) to see if that was the issue, but it also hangs on the next row (TATE) and ASHM still works on my a-y sheet.

Me too! Mea culpa. I'll have a look at it.

Running on latest LO (after upgrading to see if that was the issue) on Win10. Tried debugging, but I'm not familiar with LO's macro system and it appears some things run fine clicking the button which don't work on step-through (it complains about not finding the 'downloads' sheet, for instance)

I'm not sure what you mean by clicking the button which don't work on step-through. I have a suspicion that you might be single-stepping through the code. This can only be done with Basic, but the vast majority of the OpenOffice version uses Python so you cannot step through the code. I left the original Basic code in there for posterity; maybe I should remove it.

--kiloran

[Breelander]

Don't know if anyone else is experiencing this, but I am having an issue getting DL forecast yields in the watchlist after going from LibreOffice a-y to b-a

Me too! Mea culpa. I'll have a look at it.

If it helps, it worked in a-z.

[woodenman]

Running on latest LO (after upgrading to see if that was the issue) on Win10. Tried debugging, but I'm not familiar with LO's macro system and it appears some things run fine clicking the button which don't work on step-through (it complains about not finding the 'downloads' sheet, for instance)

I'm not sure what you mean by clicking the button which don't work on step-through. I have a suspicion that you might be single-stepping through the code. This can only be done with Basic, but the vast majority of the OpenOffice version uses Python so you cannot step through the code. I left the original Basic code in there for posterity; maybe I should remove it.

--kiloran

That may be the issue then - I was attempting to step through the basic code and it was complaining at several points. By 'the button' I meant the button in the UI that you usually use to kick off the process vs stepping through the code (it would let you kick off the procedure by using the 'step into / step over' buttons in the debugger which I was using as my breakpoints weren't working (prob due to it using Python)

[kiloran]

Dear Kiloran
There was a bug in a previous version of the Open/Libre Office version (a-x) which did not complete the processing after downloading dividends causing the sheet to hang and although the sheet could be saved it was still inoperative needing a force quit followed by a recovery to make it work

Having downloaded the new version this appears still to be the case. Have I missed something ?
Regards
Colin

Colin, have you seen the Private Message I sent you on 24Dec16? PM link is towards the top-right of this page

--kiloran

[Urbandreamer]

Is anyone else having difficulty retrieving dividend dates?

I'm currently using v11.11 but v11.23 also seems to decide that BP and SL (for test) have no dividend dates.

[kiloran]

Is anyone else having difficulty retrieving dividend dates?

I'm currently using v11.11 but v11.23 also seems to decide that BP and SL (for test) have no dividend dates.

Works OK for me.
Are you saying that BP and SL are specific problems, or are you having problems with all shares? Did you make many requests for data and found that it failed after a number of successes?

If the latter, I suspect you have been blacklisted by Dividend Data for overuse. Does this work in your browser: http://www.dividenddata.co.uk/ex-divide ... rchTerm=bp. or do you get a 403:Forbidden response?

http://lemonfoolfinancialsoftware.weebl ... bsite.html

If you get 403:Forbidden, the website has decided that you have made too many queries and blocked your IP address. At times, they seem to be very sensitive, I do wonder if they want people to use their site. You may find that the block is removed after a day or two. You can overcome this problem immediately by getting a new IP Address.

1. Check your current IP Address using: https://www.whatismyip.com/
2. Reboot your broadband router
3. Recheck your current IP Address using: https://www.whatismyip.com/

You might need to reboot your router a few times, and maybe your ISP always gives you the same IP. If you still have problems, try using ADVFN as the dividend source.

--kiloran

[Urbandreamer]

If the latter, I suspect you have been blacklisted by Dividend Data for overuse. Does this work in your browser: http://www.dividenddata.co.uk/ex-divide ... rchTerm=bp. or do you get a 403:Forbidden response?

http://lemonfoolfinancialsoftware.weebl ... bsite.html

--kiloran

Thanks. Of course when the problem first turned up I kept trying to see if it was a tempory issue.

It looks like I'm blocked both at home and work. I'll reset my home router and try and lay off for a while. I suspect that I checked dates a bit too frequently in Dec trying to guess when IBT might turn up. Once a month sounds a more sensible frequency.

I wonder if they'll eventually forgive my work IP.

[Raptor]

I did get a few "no response" when running it recently whilst testing some changes to my modified spreadsheet, but in the end this resolved itself.

Have been lucky with the blocking, but then again I do have a revolving list of 5 ip addresses so keeping fingers crossed as am about to start working on a few more changes that I have put off for a few years.

Raptor.