divi update

Discussions regarding financial software
Post Reply
biffinsbridge
Lemon Pip
Posts: 80
Joined: November 4th, 2016, 3:03 pm

divi update

Post 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.

kiloran
Lemon Quarter
Posts: 3865
Joined: November 4th, 2016, 9:24 am

Re: divi update

Post 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

biffinsbridge
Lemon Pip
Posts: 80
Joined: November 4th, 2016, 3:03 pm

Re: divi update

Post 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.

kiloran
Lemon Quarter
Posts: 3865
Joined: November 4th, 2016, 9:24 am

Re: divi update

Post 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

biffinsbridge
Lemon Pip
Posts: 80
Joined: November 4th, 2016, 3:03 pm

Re: divi update

Post by biffinsbridge »

Kiloran, Dixons Carphone ticker DC
Regards Dickie.

biffinsbridge
Lemon Pip
Posts: 80
Joined: November 4th, 2016, 3:03 pm

Re: divi update

Post 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.

kiloran
Lemon Quarter
Posts: 3865
Joined: November 4th, 2016, 9:24 am

Re: divi update

Post 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

biffinsbridge
Lemon Pip
Posts: 80
Joined: November 4th, 2016, 3:03 pm

Re: divi update

Post 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.

kiloran
Lemon Quarter
Posts: 3865
Joined: November 4th, 2016, 9:24 am

Re: divi update

Post 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

granretire
2 Lemon pips
Posts: 229
Joined: November 4th, 2016, 7:03 pm

Re: divi update

Post by granretire »

I went to view the video for updating the data sheet and VIMEO wanted me to log in

Itsallaguess
Lemon Half
Posts: 8675
Joined: November 4th, 2016, 1:16 pm

Re: divi update

Post 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

granretire
2 Lemon pips
Posts: 229
Joined: November 4th, 2016, 7:03 pm

Re: divi update

Post by granretire »

Thanks

biffinsbridge
Lemon Pip
Posts: 80
Joined: November 4th, 2016, 3:03 pm

Re: divi update

Post 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.

Post Reply

Return to “Financial Software - Discussion”