Showing posts with label smfGetGuruFocusItem(). Show all posts
Showing posts with label smfGetGuruFocusItem(). Show all posts

Tuesday, October 20, 2020

Alert -- Issue with smfGetGuruFocusItem()

 Unfortunately, GuruFocus has changed the way HTML class labels are used on their web page, and those were the labels that the function uses as search terms. I made some simple changes that fixed many, but there were also many that they didn't make the same changes to, so then those broke. It seems like any fix I make to the current algorithm to fix one extraction breaks some other extraction.

It looks like they've also changed a few line item labels.

...Later...

I made a compromise and abandoned the old search tags, now keying off the TTM item. That was the way I originally did it, but there were issues with companies that didn't have enough quarterly items. But I'd rather have it work for everything else and not those than not work for anything.

It looks like the things I'm getting an outright "Error" on are a result of the line item simply not existing for the company.

Because I am a subscriber, I never use this function. The smfGetGuruFocusCSVItem() function is much faster at data retrieval and more comprehensive. 

Here is an interim XLA file until I decide what more I want to do, if anything.

Updated XLA file

You should exit EXCEL before updating the XLA file.

Sunday, September 17, 2017

New ZIP file -- Version 2017.09.17

I'm starting this blog as an experiment, to use it as a way to note issues that have come up or updates that have been made to files on the web site. That way, people can keep up-to-date without having to deal with all the background noise on the Yahoo group.

For today, it was noted that the smfGetGuruFocusItem() function was not working. It turned out to be a simple label change on their web page, but did require an update to the XLA file.

I'm also taking this opportunity to phase out the beta release of the add-in and made the new ZIP file the official release. New files on the web site:
Best practice is to exit EXCEL when updating SMF add-in files.




You should subscribe to this RSS feed to get any updates. If you don't use an RSS reader, BlogTrottr can be used to send RSS feed updates as emails to your email client.