Remove ads

Share Prices in Excel - NEW update

Discussions regarding financial software
funduffer
2 Lemon pips
Posts: 198
Joined: November 4th, 2016, 12:11 pm
Has thanked: 21 times
Been thanked: 57 times

Re: Share Prices in Excel - NEW update

#95651

Postby funduffer » November 14th, 2017, 4:37 pm

eventide,itsallaguess,

Many thanks for this.

I have never incorporated a share price scrape into any of my spreadsheets before due to my rather limited excel expertise.

However, I have now added in the add-in (so to speak) and it works a treat.

Excel 2013 running under Windows 10 in case you are interested.

FD

funduffer
2 Lemon pips
Posts: 198
Joined: November 4th, 2016, 12:11 pm
Has thanked: 21 times
Been thanked: 57 times

Re: Share Prices in Excel - NEW update

#95667

Postby funduffer » November 14th, 2017, 5:18 pm

funduffer wrote:eventide,itsallaguess,

Many thanks for this.

I have never incorporated a share price scrape into any of my spreadsheets before due to my rather limited excel expertise.

However, I have now added in the add-in (so to speak) and it works a treat.

Excel 2013 running under Windows 10 in case you are interested.

FD

I spoke a little too soon!

When I save, close and reload the sheet, the add-in is disabled. If I go to Manage add-ins and switch it off and then on again, it works again fine.

OK as a work around, but I think I may be missing something?

FD

GN100
Lemon Pip
Posts: 93
Joined: November 4th, 2016, 10:14 am
Has thanked: 3 times
Been thanked: 6 times

Re: Share Prices in Excel - NEW update

#95973

Postby GN100 » November 15th, 2017, 4:15 pm

I had some problems similar to yours - read through page 2 here and you may find an answer:-

viewtopic.php?f=27&t=8229&start=20

Sorry, I don't know how to link to the exact post as I used to on TMF.

eventide
Posts: 49
Joined: October 24th, 2017, 3:29 pm
Has thanked: 1 time
Been thanked: 48 times

Re: Share Prices in Excel - NEW update

#96015

Postby eventide » November 15th, 2017, 6:29 pm

GN100 wrote:I had some problems similar to yours - read through page 2 here and you may find an answer:-

viewtopic.php?f=27&t=8229&start=20

Sorry, I don't know how to link to the exact post as I used to on TMF.


Two thoughts:

(1) the addin rightclick menu additions only appear if the spreadsheet contains a getdata function call (no need for it otherwise!)


(2) Not sure if you have already done this, but you can avoid having to open the addin eachtime:

with excel open, search "addins", click the double cog icon, then browse, and browse to where you saved the addin, open it, and it should auto load from then on

it opens when excel opens

or in pre 2010 excel follow tools>addins >browse to location where you saved the addin>double click to "install the addin to run whenever excel is open

Nocton
Lemon Pip
Posts: 76
Joined: November 6th, 2016, 11:25 am
Has thanked: 5 times
Been thanked: 7 times

Re: Share Prices in Excel - NEW update

#98981

Postby Nocton » November 26th, 2017, 3:12 pm

Sorry to be behind on this as I have just seen this thread. I have Liveprice and, as reported, find it does not now work. I have downloaded tlfAddin.xla but not sure what to do with it. I have opened it. Nothing seems to happen and when I Refresh I get the error 'User-defined type not defined' on the line

Code: Select all

Dim MyHTTP As New XMLHTTP

I'm using an old version of Excel -2003 - but it works fine for other spreadsheets with macros.

Perhaps there is somewhere I can download a completely new copy of Liveprice with everything up to date, please?

Gostevie
Posts: 23
Joined: November 4th, 2016, 11:35 am
Has thanked: 21 times
Been thanked: 2 times

Re: Share Prices in Excel - NEW update

#117796

Postby Gostevie » February 13th, 2018, 8:37 am

Hi,

For the last couple of days, when I have been using this excellent add in, many of my shares are showing as nil value. It seems to affect those not listed in the FTSE350. Has anybody else noticed this?

Many thanks,

Steve

digitaria
Posts: 18
Joined: November 4th, 2016, 10:36 am
Has thanked: 17 times

Re: Share Prices in Excel - NEW update

#117892

Postby digitaria » February 13th, 2018, 3:47 pm

Gostevie wrote:Hi,

For the last couple of days, when I have been using this excellent add in, many of my shares are showing as nil value. It seems to affect those not listed in the FTSE350. Has anybody else noticed this?

Many thanks,

Steve


I am seeing similar problems - I think they relate to the Yahoo feeds. Specifically, the Bid / Offer prices are nil for a lot of my shares and if my valuation is based on those, it is reduced accordingly. If you use the "Last" price, you get a better result. I hope Yahoo will correct the feed eventually.

kiloran
Lemon Slice
Posts: 949
Joined: November 4th, 2016, 9:24 am
Has thanked: 103 times
Been thanked: 344 times

Re: Share Prices in Excel - NEW update

#117899

Postby kiloran » February 13th, 2018, 3:58 pm

Gostevie wrote:Hi,

For the last couple of days, when I have been using this excellent add in, many of my shares are showing as nil value. It seems to affect those not listed in the FTSE350. Has anybody else noticed this?

Many thanks,

Steve

Could you give some examples of some shares that show nil value?

--kiloran

Gostevie
Posts: 23
Joined: November 4th, 2016, 11:35 am
Has thanked: 21 times
Been thanked: 2 times

Re: Share Prices in Excel - NEW update

#117919

Postby Gostevie » February 13th, 2018, 4:54 pm

kiloran wrote:
Gostevie wrote:Hi,

For the last couple of days, when I have been using this excellent add in, many of my shares are showing as nil value. It seems to affect those not listed in the FTSE350. Has anybody else noticed this?

Many thanks,

Steve

Could you give some examples of some shares that show nil value?

--kiloran


Many thanks for your reply.

BLVN.L and CNCT.L (Bowleven and Connect) are two.

kiloran
Lemon Slice
Posts: 949
Joined: November 4th, 2016, 9:24 am
Has thanked: 103 times
Been thanked: 344 times

Re: Share Prices in Excel - NEW update

#117926

Postby kiloran » February 13th, 2018, 5:14 pm

Gostevie wrote:
kiloran wrote:
Gostevie wrote:Hi,

For the last couple of days, when I have been using this excellent add in, many of my shares are showing as nil value. It seems to affect those not listed in the FTSE350. Has anybody else noticed this?

Many thanks,

Steve

Could you give some examples of some shares that show nil value?

--kiloran


Many thanks for your reply.

BLVN.L and CNCT.L (Bowleven and Connect) are two.


I tried =getdata("BLVN.L","last") and it gave the same data as the raw data from Yahoo: http://jsonviewer.stack.hu/#http://quer ... ols=blvn.L
(see the regularMarketPrice field)

(using Excel 2010 on Windows 7)

Also worked fine for CNCT.L

Maybe it's time-dependent, I'll check again at various times tomorrow.

--kiloran

eventide
Posts: 49
Joined: October 24th, 2017, 3:29 pm
Has thanked: 1 time
Been thanked: 48 times

Re: Share Prices in Excel - NEW update

#118018

Postby eventide » February 14th, 2018, 6:58 am

Gostevie wrote:Hi,

For the last couple of days, when I have been using this excellent add in, many of my shares are showing as nil value. It seems to affect those not listed in the FTSE350. Has anybody else noticed this?

Many thanks,

Steve



Yes, it is a yahoo feed issue not a problem with the add-in. Many securities are returning zeros for the bid and the offer, but last seems to be ok.

It may be a further deprecation of the yahoo server which would be unfortunate, but this has happened before and righted itself so it is fingers crossed.

Gostevie
Posts: 23
Joined: November 4th, 2016, 11:35 am
Has thanked: 21 times
Been thanked: 2 times

Re: Share Prices in Excel - NEW update

#118147

Postby Gostevie » February 14th, 2018, 1:11 pm

kiloran wrote:
Gostevie wrote:
kiloran wrote:Could you give some examples of some shares that show nil value?

--kiloran


Many thanks for your reply.

BLVN.L and CNCT.L (Bowleven and Connect) are two.


I tried =getdata("BLVN.L","last") and it gave the same data as the raw data from Yahoo: http://jsonviewer.stack.hu/#http://quer ... ols=blvn.L
(see the regularMarketPrice field)

(using Excel 2010 on Windows 7)

Also worked fine for CNCT.L

Maybe it's time-dependent, I'll check again at various times tomorrow.

--kiloran


Many thanks! I've replaced the "2" (bid) with "4" (last) in the formula and it now works. I'll try changing it back next week to see if the Yahoo issue has been solved, otherwise it's a decent fix. Thanks again for your help with this.

Steve

eventide
Posts: 49
Joined: October 24th, 2017, 3:29 pm
Has thanked: 1 time
Been thanked: 48 times

Re: Share Prices in Excel - NEW update

#119489

Postby eventide » February 21st, 2018, 2:05 pm

The absence of bid and ask field data appears persistent across all UK stocks but not for US or European stocks. I can't find any information as to why so still stuck using last data for the time being. This is generally ok for bigger stocks but you can get pretty stale data for less liquid stuff

Gostevie
Posts: 23
Joined: November 4th, 2016, 11:35 am
Has thanked: 21 times
Been thanked: 2 times

Re: Share Prices in Excel - NEW update

#119600

Postby Gostevie » February 22nd, 2018, 8:44 am

eventide wrote:The absence of bid and ask field data appears persistent across all UK stocks but not for US or European stocks. I can't find any information as to why so still stuck using last data for the time being. This is generally ok for bigger stocks but you can get pretty stale data for less liquid stuff


This now appears to have been fixed.


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 2 guests