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

Share Prices in Excel - NEW update

Discussions regarding financial software
JamesMuenchen
Lemon Slice
Posts: 668
Joined: November 4th, 2016, 9:05 pm
Has thanked: 141 times
Been thanked: 167 times

Re: Share Prices in Excel - NEW update

#238220

Postby JamesMuenchen » July 21st, 2019, 2:13 pm

OK, so maybe this way:
File -> Options -> Add-Ins -> Manage: Excel Add-ins, click Go.
Then the Add-Ins dialog box pops-up and you can tick the box for Tlfaddin.

spiderbill
Lemon Slice
Posts: 543
Joined: November 4th, 2016, 9:12 am
Has thanked: 156 times
Been thanked: 182 times

Re: Share Prices in Excel - NEW update

#238245

Postby spiderbill » July 21st, 2019, 4:00 pm

That did it! Wonderful James, many thanks.

I'd got to that dialog before but the add-in hadn't been listed on that occasion. This time it was there and it seems to stay around even after closing this time. And as an added bonus it seems to have killed the security popup too!!

Usually I can diagnose most things but this one had me banging my head on the desk.

Thanks again
Spiderbill

eventide
2 Lemon pips
Posts: 102
Joined: October 24th, 2017, 3:29 pm
Has thanked: 3 times
Been thanked: 83 times

Re: Share Prices in Excel - NEW update

#247980

Postby eventide » August 30th, 2019, 9:03 am

If this addin is not working and throwing an "XMLcall" error:

ALT-F11 to open VBA editor:

CTRL-F to open search/replace box

Search for the following string in the whole project:
If .StatusText <> "OK"


Replace it with the following string:
If .Status <> 200

peterh
2 Lemon pips
Posts: 128
Joined: November 4th, 2016, 12:08 pm
Has thanked: 18 times
Been thanked: 37 times

Re: Share Prices in Excel - NEW update

#248049

Postby peterh » August 30th, 2019, 1:01 pm

eventide wrote:If this addin is not working and throwing an "XMLcall" error:

Hi Eventide, many thanks for your great add in!

I came here after getting an error today - the 'getdata' function returns a 'tick_err' value, rather than the XMLcall error. Is it related to the issue you posted about?

In any case, I can't follow the advice you gave, as the VBA module is protected. Are you willing to share the password (by PM if needed)?

eventide
2 Lemon pips
Posts: 102
Joined: October 24th, 2017, 3:29 pm
Has thanked: 3 times
Been thanked: 83 times

Re: Share Prices in Excel - NEW update

#248397

Postby eventide » August 31st, 2019, 11:08 pm

peterh wrote:
eventide wrote:If this addin is not working and throwing an "XMLcall" error:

Hi Eventide, many thanks for your great add in!

I came here after getting an error today - the 'getdata' function returns a 'tick_err' value, rather than the XMLcall error. Is it related to the issue you posted about?

In any case, I can't follow the advice you gave, as the VBA module is protected. Are you willing to share the password (by PM if needed)?


'tick_err' simply means you have requested a ticker that yahoo finance does not know.
You can check if the ticker is good on the yahoo finance website.

You reminded me that the VBA is protected so I will update the file at the download host soon if this problem affects others.

peterh
2 Lemon pips
Posts: 128
Joined: November 4th, 2016, 12:08 pm
Has thanked: 18 times
Been thanked: 37 times

Re: Share Prices in Excel - NEW update

#248408

Postby peterh » September 1st, 2019, 2:12 am

eventide wrote:
peterh wrote:
eventide wrote:If this addin is not working and throwing an "XMLcall" error:

Hi Eventide, many thanks for your great add in!

I came here after getting an error today - the 'getdata' function returns a 'tick_err' value, rather than the XMLcall error. Is it related to the issue you posted about?

In any case, I can't follow the advice you gave, as the VBA module is protected. Are you willing to share the password (by PM if needed)?


'tick_err' simply means you have requested a ticker that yahoo finance does not know.
You can check if the ticker is good on the yahoo finance website.

You reminded me that the VBA is protected so I will update the file at the download host soon if this problem affects others.


Thanks, but the reason I mentioned it is because I set the file up with my portfolio when you first released the file and it has been working perfectly until this error started on Friday. I haven't changed anything. Is it still working for you?

For instance, the tickers HSBA.L and ^FTSE both give me the error, but https://uk.finance.yahoo.com/ recognises them.

Instep
2 Lemon pips
Posts: 159
Joined: November 4th, 2016, 4:52 pm
Has thanked: 176 times
Been thanked: 15 times

Re: Share Prices in Excel - NEW update

#248488

Postby Instep » September 1st, 2019, 4:42 pm

eventide wrote:
peterh wrote:
eventide wrote:If this addin is not working and throwing an "XMLcall" error:

Hi Eventide, many thanks for your great add in!

I came here after getting an error today - the 'getdata' function returns a 'tick_err' value, rather than the XMLcall error. Is it related to the issue you posted about?

In any case, I can't follow the advice you gave, as the VBA module is protected. Are you willing to share the password (by PM if needed)?


'tick_err' simply means you have requested a ticker that yahoo finance does not know.
You can check if the ticker is good on the yahoo finance website.

You reminded me that the VBA is protected so I will update the file at the download host soon if this problem affects others.


Hi Eventide.
This problem does affect others.
I can confirm that my copy of the add-in was working fine up to about 05:00 p.m. on Friday 30th August, when I saved a copy of the latest prices for my portfolio.
Every instance of getdata() in my spreadsheet is now returning a ::tick_err:: so something appears to have been broken.
I can confirm that Yahoo is still returning correct values when called by the HYPTUSS software, although that does not use your add-in.
I hope this is something that can be fixed.
Kind regards and thanks again for this add-in
InStep

eventide
2 Lemon pips
Posts: 102
Joined: October 24th, 2017, 3:29 pm
Has thanked: 3 times
Been thanked: 83 times

Re: Share Prices in Excel - NEW update

#248531

Postby eventide » September 1st, 2019, 8:07 pm

Instep wrote:
eventide wrote:
peterh wrote:Hi Eventide, many thanks for your great add in!

I came here after getting an error today - the 'getdata' function returns a 'tick_err' value, rather than the XMLcall error. Is it related to the issue you posted about?

In any case, I can't follow the advice you gave, as the VBA module is protected. Are you willing to share the password (by PM if needed)?


'tick_err' simply means you have requested a ticker that yahoo finance does not know.
You can check if the ticker is good on the yahoo finance website.

You reminded me that the VBA is protected so I will update the file at the download host soon if this problem affects others.


Hi Eventide.
This problem does affect others.
I can confirm that my copy of the add-in was working fine up to about 05:00 p.m. on Friday 30th August, when I saved a copy of the latest prices for my portfolio.
Every instance of getdata() in my spreadsheet is now returning a ::tick_err:: so something appears to have been broken.
I can confirm that Yahoo is still returning correct values when called by the HYPTUSS software, although that does not use your add-in.
I hope this is something that can be fixed.
Kind regards and thanks again for this add-in
InStep



The VBA password is ipisnotfree. How ironic.


Follow the steps in the post above.

Instep
2 Lemon pips
Posts: 159
Joined: November 4th, 2016, 4:52 pm
Has thanked: 176 times
Been thanked: 15 times

Re: Share Prices in Excel - NEW update

#248547

Postby Instep » September 1st, 2019, 9:24 pm

eventide wrote:
Instep wrote:
Hi Eventide.
This problem does affect others.
I can confirm that my copy of the add-in was working fine up to about 05:00 p.m. on Friday 30th August, when I saved a copy of the latest prices for my portfolio.
Every instance of getdata() in my spreadsheet is now returning a ::tick_err:: so something appears to have been broken.
I can confirm that Yahoo is still returning correct values when called by the HYPTUSS software, although that does not use your add-in.
I hope this is something that can be fixed.
Kind regards and thanks again for this add-in
InStep



The VBA password is ipisnotfree. How ironic.


Follow the steps in the post above.


I will give it a try tomorrow. Thanks for your help
InStep

peterh
2 Lemon pips
Posts: 128
Joined: November 4th, 2016, 12:08 pm
Has thanked: 18 times
Been thanked: 37 times

Re: Share Prices in Excel - NEW update

#248549

Postby peterh » September 1st, 2019, 9:24 pm

eventide wrote:Follow the steps in the post above.

That did the trick! Thanks very much again for the addin!

Anders
Posts: 1
Joined: August 30th, 2019, 11:54 pm

Re: Share Prices in Excel - NEW update

#248581

Postby Anders » September 2nd, 2019, 1:00 am

eventide wrote:'tick_err' simply means you have requested a ticker that yahoo finance does not know.
You can check if the ticker is good on the yahoo finance website.


I had been experiencing the same :tick_err: issue as Instep and peterh since late last week. Modifying the code as instructed resolved the problem for me as well.

marben100
Posts: 10
Joined: November 6th, 2016, 2:43 pm
Has thanked: 5 times
Been thanked: 2 times

Re: Share Prices in Excel - NEW update

#248602

Postby marben100 » September 2nd, 2019, 7:59 am

Hi eventide,

I am trying to implement your solution, but am struggling to access the add-in. I wonder if you can see what I'm doing wrong?

I have the VBA editor open, which lists VBA Project add-ins in the left hand pane. When I try to expansd the one on the workbook containing your add-in, I get a prompt for VBA Project password. When I enter ipisnotfree it returns "invalid password", so I'm stuck.

Note that i'm using the original (early) version of your file/add-in, so I don't know whether you had a different password on that one. I didn't change it to the newer version because it took me ages to update the many spreadsheets I have that link to a master spreadsheet that uses your add-in to retrieve prices, when you originally implemented it.

Any help you can offer much appreciated.

Best,
Mark

Instep
2 Lemon pips
Posts: 159
Joined: November 4th, 2016, 4:52 pm
Has thanked: 176 times
Been thanked: 15 times

Re: Share Prices in Excel - NEW update

#248605

Postby Instep » September 2nd, 2019, 8:23 am

eventide wrote:If this addin is not working and throwing an "XMLcall" error:

ALT-F11 to open VBA editor:

CTRL-F to open search/replace box

Search for the following string in the whole project:
If .StatusText <> "OK"


Replace it with the following string:
If .Status <> 200


Thanks again. The instructions above are fine, with two additional notes which might avoid having to do it twice, as I did :oops:

Debug /Compile tlfAddin

File / Save tlfAddin.xla

InStep

eventide
2 Lemon pips
Posts: 102
Joined: October 24th, 2017, 3:29 pm
Has thanked: 3 times
Been thanked: 83 times

Re: Share Prices in Excel - NEW update

#248607

Postby eventide » September 2nd, 2019, 8:35 am

marben100 wrote:Hi eventide,

I am trying to implement your solution, but am struggling to access the add-in. I wonder if you can see what I'm doing wrong?

I have the VBA editor open, which lists VBA Project add-ins in the left hand pane. When I try to expansd the one on the workbook containing your add-in, I get a prompt for VBA Project password. When I enter ipisnotfree it returns "invalid password", so I'm stuck.

Note that i'm using the original (early) version of your file/add-in, so I don't know whether you had a different password on that one. I didn't change it to the newer version because it took me ages to update the many spreadsheets I have that link to a master spreadsheet that uses your add-in to retrieve prices, when you originally implemented it.

Any help you can offer much appreciated.

Best,
Mark


I cannot help

eventide
2 Lemon pips
Posts: 102
Joined: October 24th, 2017, 3:29 pm
Has thanked: 3 times
Been thanked: 83 times

Re: Share Prices in Excel - NEW update

#249457

Postby eventide » September 5th, 2019, 8:07 am

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.

spiderbill
Lemon Slice
Posts: 543
Joined: November 4th, 2016, 9:12 am
Has thanked: 156 times
Been thanked: 182 times

Re: Share Prices in Excel - NEW update

#249463

Postby spiderbill » September 5th, 2019, 8:32 am

Not just the API, the whole site is down.

spiderbill
Lemon Slice
Posts: 543
Joined: November 4th, 2016, 9:12 am
Has thanked: 156 times
Been thanked: 182 times

Re: Share Prices in Excel - NEW update

#249466

Postby spiderbill » September 5th, 2019, 8:54 am

Hmm, Sharecast seems to be down too - showing a php error message.

seagles
Lemon Slice
Posts: 490
Joined: August 19th, 2017, 8:37 am
Has thanked: 153 times
Been thanked: 235 times

Re: Share Prices in Excel - NEW update

#249472

Postby seagles » September 5th, 2019, 9:17 am

Just got this flashed up when trying to get to Yahoo:-

Thank you for your patience.

Our engineers are working quickly to resolve the issue.

seagles
Lemon Slice
Posts: 490
Joined: August 19th, 2017, 8:37 am
Has thanked: 153 times
Been thanked: 235 times

Re: Share Prices in Excel - NEW update

#249478

Postby seagles » September 5th, 2019, 9:43 am

Seems to be bigger problem. Went to login to my BT mail.

Sorry, but we're having problems with BT Yahoo Mail. We're working to get them sorted as soon as possible.


Also unable to get to my Yahoo mail login

Give up off to the GYM.

peterh
2 Lemon pips
Posts: 128
Joined: November 4th, 2016, 12:08 pm
Has thanked: 18 times
Been thanked: 37 times

Re: Share Prices in Excel - NEW update

#249536

Postby peterh » September 5th, 2019, 12:19 pm

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.


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 5 guests