The Lemon Fool

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.

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

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

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)?

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.

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.

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

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.

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

eventide wrote:Follow the steps in the post above.

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

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.

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

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

Debug /Compile tlfAddin

File / Save tlfAddin.xla

InStep

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

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.

Not just the API, the whole site is down.

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

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.

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.

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.