3 Messages
Digest #3670
Messages
Wed Apr 6, 2016 4:07 am (PDT) . Posted by:
holmberg_tommy
Hi Randy,
I'm running to some difficulties and hopefully you could help me to solve them.
First, is there any maximum amount of companies that could be added to automatic sheet? I have added about 330 companies on my watchlist and for some reason more and more cells are filled with "error" message. Currently, sheet gives this message for 80 companies so is the maximum amount limited to 250?
Secondly, if I would like to get the "industry"; from Morningstar's web page (under company profile) using the smfcovertdata(smfgettagcontent...), how that would go?
- Tommy
I'm running to some difficulties and hopefully you could help me to solve them.
First, is there any maximum amount of companies that could be added to automatic sheet? I have added about 330 companies on my watchlist and for some reason more and more cells are filled with "error" message. Currently, sheet gives this message for 80 companies so is the maximum amount limited to 250?
Secondly, if I would like to get the "industry"
- Tommy
Wed Apr 6, 2016 7:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There is a limit. The add-in is designed for ad hoc data retrieval, not
database building. It can only retrieve data from 1000 web pages in a given
"session". Once that limit is reached, all further web page retrievals
return "Error". That's because the add-in saves a copy of the web page
before it extracts anything, and there are only 1000 slots for saving web
pages.
So if you access four different web pages for data on 250 ticker symbols,
that would be it.
You should be using another product to "prescreen" your universe and winnow
it down to a small set of companies that you want to collect more data on.
It isn't fair to the companies that provide free data to use something like
that add-in to grab lots of data from their sites. They could easily make
it so the add-in could not access the data at all.
You can get sector and industry from M* with elements #877 and #878, or
with formulas like:
=smfGetTagContent("
http://quotes.morningstar.com/stock/c-company-profile?t=MMM","span",1,"Company
WebSite","Sector")
=smfGetTagContent("
http://quotes.morningstar.com/stock/c-company-profile?t=MMM","span",1,"Company
WebSite","Industry")
On Wed, Apr 6, 2016 at 4:07 AM, holmberg_tommy@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm running to some difficulties and hopefully you could help me to solve
> them.
>
> First, is there any maximum amount of companies that could be added to
> automatic sheet? I have added about 330 companies on my watchlist and for
> some reason more and more cells are filled with "error" message. Currently,
> sheet gives this message for 80 companies so is the maximum amount limited
> to 250?
>
> Secondly, if I would like to get the "industry"; from Morningstar's web
> page (under company profile) using the smfcovertdata(smfgettagcontent...),
> how that would go?
>
>
>
database building. It can only retrieve data from 1000 web pages in a given
"session". Once that limit is reached, all further web page retrievals
return "Error". That's because the add-in saves a copy of the web page
before it extracts anything, and there are only 1000 slots for saving web
pages.
So if you access four different web pages for data on 250 ticker symbols,
that would be it.
You should be using another product to "prescreen" your universe and winnow
it down to a small set of companies that you want to collect more data on.
It isn't fair to the companies that provide free data to use something like
that add-in to grab lots of data from their sites. They could easily make
it so the add-in could not access the data at all.
You can get sector and industry from M* with elements #877 and #878, or
with formulas like:
=smfGetTagContent("
http://quotes.morningstar.com/stock/c-company-profile?t=MMM","span",1,"Company
WebSite","Sector")
=smfGetTagContent("
http://quotes.morningstar.com/stock/c-company-profile?t=MMM","span",1,"Company
WebSite","Industry")
On Wed, Apr 6, 2016 at 4:07 AM, holmberg_tommy@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm running to some difficulties and hopefully you could help me to solve
> them.
>
> First, is there any maximum amount of companies that could be added to
> automatic sheet? I have added about 330 companies on my watchlist and for
> some reason more and more cells are filled with "error" message. Currently,
> sheet gives this message for 80 companies so is the maximum amount limited
> to 250?
>
> Secondly, if I would like to get the "industry"
> page (under company profile) using the smfcovertdata(
> how that would go?
>
>
>
Wed Apr 6, 2016 8:36 am (PDT) . Posted by:
herbshack13
Good idea, but those box urls have arbitrary structure.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar