divi update
-
- Lemon Pip
- Posts: 80
- Joined: November 4th, 2016, 3:03 pm
divi update
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.
invalid procedure call or argument
This appears after first 5 divis updated?
Can you help me? best regards Dickie.
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: divi update
If the first 5 are OK, sounds like the 6th share has a problem.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.
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
-
- Lemon Pip
- Posts: 80
- Joined: November 4th, 2016, 3:03 pm
Re: divi update
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.
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.
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: divi update
What do you mean by "Dixons". What stock symbol?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.
I have a suspicion that "Dixons" (or whatever) became Carphone Warehouse Group (stock symbol CPW)
--kiloran
-
- Lemon Pip
- Posts: 80
- Joined: November 4th, 2016, 3:03 pm
Re: divi update
Kiloran, Dixons Carphone ticker DC
Regards Dickie.
Regards Dickie.
-
- Lemon Pip
- Posts: 80
- Joined: November 4th, 2016, 3:03 pm
Re: divi update
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.
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: divi update
Dixons Carphone ticker DC. is no morebiffinsbridge wrote:Kiloran, Dixons Carphone ticker DC
Regards Dickie.
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
-
- Lemon Pip
- Posts: 80
- Joined: November 4th, 2016, 3:03 pm
Re: divi update
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.
Best regards Dickie.
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: divi update
Sorry about the delay, I've been waiting to see if the various data sources that HYPTUSS uses would be updated.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.
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
-
- 2 Lemon pips
- Posts: 229
- Joined: November 4th, 2016, 7:03 pm
Re: divi update
I went to view the video for updating the data sheet and VIMEO wanted me to log in
-
- Lemon Half
- Posts: 8675
- Joined: November 4th, 2016, 1:16 pm
Re: divi update
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.granretire wrote:
I went to view the video for updating the data sheet and VIMEO wanted me to log in
Cheers,
Itsallaguess
-
- Lemon Pip
- Posts: 80
- Joined: November 4th, 2016, 3:03 pm
Re: divi update
Gooday, Have now installed the data sheet & everything now works perfectly. Thank you very much for your help, much appreciated. Very Best Regards Dickie.