Page 1 of 1
divi update
Posted: September 17th, 2021, 5:05 pm
by biffinsbridge
Gooday, having problem updating divis? v11-73 in excel. microsoft visual basic. run-time error '5':
invalid procedure call or argument
This appears after first 5 divis updated?
Can you help me? best regards Dickie.
Re: divi update
Posted: September 17th, 2021, 5:13 pm
by kiloran
biffinsbridge wrote:Gooday, having problem updating divis? v11-73 in excel. microsoft visual basic. run-time error '5':
invalid procedure call or argument
This appears after first 5 divis updated?
Can you help me? best regards Dickie.
If the first 5 are OK, sounds like the 6th share has a problem.
What shares are you looking at (the first 8-10 will do)? Please provide these in the same order as your main HYP sheet.
What is your dividend source?
--kiloran
Re: divi update
Posted: September 17th, 2021, 5:55 pm
by biffinsbridge
Shares are from 1 to 15 BP
BAT
BLAND
BT
CENTRICA
DIXONS
GSK
IMB
LLOYDS
MARS
NAT GRID
RIO
TATE
TW
UU
The first 5 are updated so from Dixons down nothing. Divi source is stockopedia. regards Dickie.
Re: divi update
Posted: September 17th, 2021, 5:59 pm
by kiloran
biffinsbridge wrote:Shares are from 1 to 15 BP
BAT
BLAND
BT
CENTRICA
DIXONS
GSK
IMB
LLOYDS
MARS
NAT GRID
RIO
TATE
TW
UU
The first 5 are updated so from Dixons down nothing. Divi source is stockopedia. regards Dickie.
What do you mean by "Dixons". What stock symbol?
I have a suspicion that "Dixons" (or whatever) became Carphone Warehouse Group (stock symbol CPW)
--kiloran
Re: divi update
Posted: September 17th, 2021, 6:06 pm
by biffinsbridge
Kiloran, Dixons Carphone ticker DC
Regards Dickie.
Re: divi update
Posted: September 17th, 2021, 6:29 pm
by biffinsbridge
biffinsbridge wrote:Kiloran, Dixons Carphone ticker DC. have deleted DC from portfolio & now all divis updated not sure if i should put it back,
Regards Dickie.
Re: divi update
Posted: September 17th, 2021, 9:04 pm
by kiloran
biffinsbridge wrote:Kiloran, Dixons Carphone ticker DC
Regards Dickie.
Dixons Carphone ticker DC. is no more
It is now Currys ticker CURY as of yesterday, but Stockopedia has now got its knickers in a twist.... there is no data for DC. and CURY is screwed up
It may take a few days for web sites to catch up with the change
See:
https://www.londonstockexchange.com/new ... e/15136478
I'll look at this further tomorrow
--kiloran
Re: divi update
Posted: September 22nd, 2021, 4:00 pm
by biffinsbridge
Gooday Kiloran, thanks yours. Any info on when 'Add a share' will include Currys? or will it auto change Dixons to Currys?
Best regards Dickie.
Re: divi update
Posted: September 22nd, 2021, 4:42 pm
by kiloran
biffinsbridge wrote:Gooday Kiloran, thanks yours. Any info on when 'Add a share' will include Currys? or will it auto change Dixons to Currys?
Best regards Dickie.
Sorry about the delay, I've been waiting to see if the various data sources that HYPTUSS uses would be updated.
As usual, it's a mixed bunch. Dividends for CURY are available from ADVFN and Sharecast. Dividend Data has nothing for CURY and Stockopedia is a real mess and I can't see any way to notify them. I'm sure they will get cleaned up given time.
The new company_data_sheet.txt file is at
http://lemonfoolfinancialsoftware.weebl ... op-up.html
This replaces DC. with CURY
You will have to manually change your entry in the High Yield Portfolio sheet
--kiloran
Re: divi update
Posted: September 26th, 2021, 8:56 am
by granretire
I went to view the video for updating the data sheet and VIMEO wanted me to log in
Re: divi update
Posted: September 26th, 2021, 9:06 am
by Itsallaguess
granretire wrote:
I went to view the video for updating the data sheet and VIMEO wanted me to log in
Thanks for letting us know about that - it looks like Vimeo have changed a recent categorisation setting on all existing videos by default, so I've removed those restrictions on the Vimeo tutorials I've created and they should all work fine again now.
Cheers,
Itsallaguess
Re: divi update
Posted: September 26th, 2021, 9:18 am
by granretire
Thanks
Re: divi update
Posted: September 27th, 2021, 4:21 pm
by biffinsbridge
Gooday, Have now installed the data sheet & everything now works perfectly. Thank you very much for your help, much appreciated. Very Best Regards Dickie.