Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

divi update

Discussions regarding financial software
biffinsbridge
Lemon Pip
Posts: 80
Joined: November 4th, 2016, 3:03 pm
Has thanked: 3107 times
Been thanked: 55 times

divi update

#443093

Postby biffinsbridge » September 17th, 2021, 5:05 pm

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: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: divi update

#443097

Postby kiloran » September 17th, 2021, 5:13 pm

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
Has thanked: 3107 times
Been thanked: 55 times

Re: divi update

#443110

Postby biffinsbridge » September 17th, 2021, 5:55 pm

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: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: divi update

#443113

Postby kiloran » September 17th, 2021, 5:59 pm

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
Has thanked: 3107 times
Been thanked: 55 times

Re: divi update

#443118

Postby biffinsbridge » September 17th, 2021, 6:06 pm

Kiloran, Dixons Carphone ticker DC
Regards Dickie.

biffinsbridge
Lemon Pip
Posts: 80
Joined: November 4th, 2016, 3:03 pm
Has thanked: 3107 times
Been thanked: 55 times

Re: divi update

#443121

Postby biffinsbridge » September 17th, 2021, 6:29 pm

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: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: divi update

#443160

Postby kiloran » September 17th, 2021, 9:04 pm

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
Has thanked: 3107 times
Been thanked: 55 times

Re: divi update

#444477

Postby biffinsbridge » September 22nd, 2021, 4:00 pm

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: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: divi update

#444482

Postby kiloran » September 22nd, 2021, 4:42 pm

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: 236
Joined: November 4th, 2016, 7:03 pm
Has thanked: 616 times
Been thanked: 48 times

Re: divi update

#445367

Postby granretire » September 26th, 2021, 8:56 am

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

Itsallaguess
Lemon Half
Posts: 9129
Joined: November 4th, 2016, 1:16 pm
Has thanked: 4140 times
Been thanked: 10023 times

Re: divi update

#445368

Postby Itsallaguess » September 26th, 2021, 9:06 am

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: 236
Joined: November 4th, 2016, 7:03 pm
Has thanked: 616 times
Been thanked: 48 times

Re: divi update

#445371

Postby granretire » September 26th, 2021, 9:18 am

Thanks

biffinsbridge
Lemon Pip
Posts: 80
Joined: November 4th, 2016, 3:03 pm
Has thanked: 3107 times
Been thanked: 55 times

Re: divi update

#445658

Postby biffinsbridge » September 27th, 2021, 4:21 pm

Gooday, Have now installed the data sheet & everything now works perfectly. Thank you very much for your help, much appreciated. Very Best Regards Dickie.


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 8 guests