Donate to Remove ads

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

Thanks to OLTB,Cornytiv34,Blatter,eyeball08,ADrunkenMarcus, for Donating to support the site

Share Prices in Excel - NEW update

Discussions regarding financial software
kiloran
Lemon Quarter
Posts: 2132
Joined: November 4th, 2016, 9:24 am
Has thanked: 679 times
Been thanked: 938 times

Re: Share Prices in Excel - NEW update

#249568

Postby kiloran » September 5th, 2019, 1:22 pm

peterh wrote:
eventide wrote:It appears to me that the yahoo api is down (again). As usual my fear is they've switched it off permanently but in the past it has come back in a few hours or days.

In the event anyone still has the addin working it would be good to know as it would eliminate the above as a cause of my problems.

The tlfaddin is working for me at the moment - but a lot slower than usual. I thought that it might have been because I am on a different PC but, now I've seen this news, it could be related to the Yahoo issues.

I looked at the Excel and LibreOffice versions of HYPTUSS and they both successfully get prices from Yahoo, but very, very slow. Normally get data back in 1-2 seconds, but now it's nearer 30. Strangely, a browser-based query such as https://query1.finance.yahoo.com/v7/fin ... se.L,vod.l still works almost immediately, and this is the same data that is read by HYPTUSS

--kiloran

Breelander
Lemon Quarter
Posts: 2900
Joined: November 4th, 2016, 9:42 pm
Has thanked: 486 times
Been thanked: 940 times

Re: Share Prices in Excel - NEW update

#249612

Postby Breelander » September 5th, 2019, 3:04 pm

kiloran wrote:I looked at the Excel and LibreOffice versions of HYPTUSS and they both successfully get prices from Yahoo, but very, very slow....


I have just tried in LibreOffice Version: 6.2.4.2 and the speed is normal. Yahoo has been having server problems this morning that took down Yahoo Mail (back now). This may have been a related problem.

kiloran
Lemon Quarter
Posts: 2132
Joined: November 4th, 2016, 9:24 am
Has thanked: 679 times
Been thanked: 938 times

Re: Share Prices in Excel - NEW update

#249622

Postby kiloran » September 5th, 2019, 3:32 pm

Breelander wrote:
kiloran wrote:I looked at the Excel and LibreOffice versions of HYPTUSS and they both successfully get prices from Yahoo, but very, very slow....


I have just tried in LibreOffice Version: 6.2.4.2 and the speed is normal. Yahoo has been having server problems this morning that took down Yahoo Mail (back now). This may have been a related problem.

Yes, looks like we are back to normal, Bree. I wonder if the Yahoo techies can now fix Brexit :)

--kiloran

eventide
Lemon Pip
Posts: 68
Joined: October 24th, 2017, 3:29 pm
Has thanked: 2 times
Been thanked: 66 times

Re: Share Prices in Excel - NEW update

#252579

Postby eventide » September 18th, 2019, 7:47 pm

I've replied to someone with an issue with this addin on another random request thread. I don't think it is an issue with the addin itself but you never know:

viewtopic.php?f=27&t=19575&p=252578#p252578

But as you can see from my response, basically I'm moving on from this addin solution to better technology so won't be able to support it much anymore on here. I hope it was useful while it lasted, and hopefully for a while more if the api continues to be supported by yahoo.

kiloran
Lemon Quarter
Posts: 2132
Joined: November 4th, 2016, 9:24 am
Has thanked: 679 times
Been thanked: 938 times

Re: Share Prices in Excel - NEW update

#252912

Postby kiloran » September 20th, 2019, 3:33 pm

eventide wrote:I've replied to someone with an issue with this addin on another random request thread. I don't think it is an issue with the addin itself but you never know:

viewtopic.php?f=27&t=19575&p=252578#p252578

But as you can see from my response, basically I'm moving on from this addin solution to better technology so won't be able to support it much anymore on here. I hope it was useful while it lasted, and hopefully for a while more if the api continues to be supported by yahoo.

Hi eventide. I was going to send you a PM but you have disabled the reception of PMs, so I hope you don't mind this public post.

You mentioned that you don't plan on further supporting the tlfAddin.xla. It's a tool which has clearly been well-received and it would be a pity if it were lost to the community. Would you have any objections if I added it to our software repository at http://lemonfoolfinancialsoftware.weebly.com/
I could add a few notes on its usage, and perhaps also provide some support in future (I've never played with Excel add-ins in the past, but I'm sure it's not grossly different to 'normal' VBA).
A user recently commented that the password 'ipisnotfree' did not work. I had the same problem, but managed to crack the password and remove it, so I could publish a password-free version in our software repository. I also quite fancy having a go at a LibreOffice equivalent, though that would have to wait for a while.

Any thoughts?

--kiloran

Itsallaguess
Lemon Quarter
Posts: 4238
Joined: November 4th, 2016, 1:16 pm
Has thanked: 1569 times
Been thanked: 2764 times

Re: Share Prices in Excel - NEW update

#253067

Postby Itsallaguess » September 21st, 2019, 4:49 pm

kiloran wrote:
A user recently commented that the password 'ipisnotfree' did not work.

I had the same problem, but managed to crack the password and remove it, so I could publish a password-free version in our software repository.


Are you sure you're using the XLA download linked from the first post on this thread kiloran?

https://www.lemonfool.co.uk/viewtopic.php?f=27&t=8332#p94736

I only ask because the download linked on that post does, for me at least, open the VBA using the 'ipisnotfree' password, so I just thought I'd check if there's a different version people are downloading from somewhere else that I might be missing?

http://www.mediafire.com/file/t5kdjwmhqg3njdf/tlfAddin.xla/file

Cheers,

Itsallaguess

kiloran
Lemon Quarter
Posts: 2132
Joined: November 4th, 2016, 9:24 am
Has thanked: 679 times
Been thanked: 938 times

Re: Share Prices in Excel - NEW update

#253102

Postby kiloran » September 22nd, 2019, 9:14 am

Itsallaguess wrote:
kiloran wrote:
A user recently commented that the password 'ipisnotfree' did not work.

I had the same problem, but managed to crack the password and remove it, so I could publish a password-free version in our software repository.


Are you sure you're using the XLA download linked from the first post on this thread kiloran?

https://www.lemonfool.co.uk/viewtopic.php?f=27&t=8332#p94736

I only ask because the download linked on that post does, for me at least, open the VBA using the 'ipisnotfree' password, so I just thought I'd check if there's a different version people are downloading from somewhere else that I might be missing?

http://www.mediafire.com/file/t5kdjwmhqg3njdf/tlfAddin.xla/file

Cheers,

Itsallaguess

You are right (now there's a surprise ;) )
There's no way of distinguishing one version from another, without having saved the files with different names.

Many thanks

--kiloran

eventide
Lemon Pip
Posts: 68
Joined: October 24th, 2017, 3:29 pm
Has thanked: 2 times
Been thanked: 66 times

Re: Share Prices in Excel - NEW update

#253387

Postby eventide » September 23rd, 2019, 6:39 pm

kiloran wrote:Would you have any objections if I added it to our software repository at http://lemonfoolfinancialsoftware.weebly.com/
I could add a few notes on its usage, and perhaps also provide some support in future (I've never played with Excel add-ins in the past, but I'm sure it's not grossly different to 'normal' VBA).
A user recently commented that the password 'ipisnotfree' did not work. I had the same problem, but managed to crack the password and remove it, so I could publish a password-free version in our software repository. I also quite fancy having a go at a LibreOffice equivalent, though that would have to wait for a while.

Any thoughts?

--kiloran


No problem

Kerryn
Posts: 1
Joined: March 1st, 2018, 11:37 am
Been thanked: 1 time

Re: Share Prices in Excel - NEW update

#277817

Postby Kerryn » January 16th, 2020, 11:12 am

I've been using this addin for a while now and find it very useful.
However recently it started throwing up ::tick_err:: for every reference.
Interestingly, when I installed an older version of Excel it sorted the problem - for a while, but then it re-occurred.
I was able to get at the code and the problem seemed to be that the XML call wasn't returning "OK" in .StatusText.
I've subsequently changed this to test for .Status = 200 and everything is running fine again.

Just thought I'd mention this in case anyone else is having a similar problem.


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest