3 Messages
Digest #3929
Messages
Fri Feb 24, 2017 6:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
There is no ">Industry :" string on the web page. That may have been the
tag before, but now the ">Industry" portion is part of an HTML link.
Now, it would need to be:
=smfGetTagContent("https://www.zacks.com/stock/research/"&D7&"/industry-comparison","strong",1,">Industry</a>
: ")
Note the "</a>" closing of the anchor tag.
On Fri, Feb 24, 2017 at 6:51 PM, sjagers@
...wrote:
>
> Hi Randy... Thanks for updating smf-elements-6.txt. GetElements 850 works
> for me, now.
>
> During your absence, I used GetTagContent to retrieve Zacks Industry info.
> My Excel formula is:
>
>
> smfGetTagContent("https://www.zacks.com/stock/research/"&$
> S23&"/industry-comparison";,"strong",1,">Industry :")
>
> ... where cell "S23" contained the symbol to lookup.
>
> My formula has been working for several weeks, including just a few days
> ago, but it's returning an Error today.
>
> Any idea why it's not working now?
>
>
tag before, but now the ">Industry" portion is part of an HTML link.
Now, it would need to be:
=smfGetTagContent("https://www.zacks.com/stock/research/"&D7&"/industry-comparison","strong",1,">Industry</a>
: ")
Note the "</a>" closing of the anchor tag.
On Fri, Feb 24, 2017 at 6:51 PM, sjagers@
...wrote:
>
> Hi Randy... Thanks for updating smf-elements-6.txt. GetElements 850 works
> for me, now.
>
> During your absence, I used GetTagContent to retrieve Zacks Industry info.
> My Excel formula is:
>
>
> smfGetTagContent("https://www.zacks.com/stock/research/"&$
> S23&"/industry
>
> ... where cell "S23" contained the symbol to lookup.
>
> My formula has been working for several weeks, including just a few days
> ago, but it's returning an Error today.
>
> Any idea why it's not working now?
>
>
Sat Feb 25, 2017 3:27 pm (PST) . Posted by:
gbullr
Any thoughts on extracting data from the two tables on that page?
Thank you.
Thank you.
Sat Feb 25, 2017 3:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
First of all, you need to add your ticker symbol, as in:
=RCHGetHTMLTable("
https://www.dividendinvestor.com/dividend-quote-new/?Symbol=MMM","",1,,2)
Or, to get an individual item:
=RCHGetTableCell("
https://www.dividendinvestor.com/dividend-quote-new/?Symbol=MMM",1,">Dividend
Ex Date")
However, if I recall correctly from past usage of their site, you only get
a few companies (5? 10?) before it starts returning the signup page instead
of data for a company. $30/month was too pricey for me, for the data they
provide.
On Sat, Feb 25, 2017 at 4:24 PM, gaston.bullrich@
...wrote:
> Any thoughts on extracting data from the two tables on that page?
>
>
=RCHGetHTMLTable("
https://www.dividendinvestor.com/dividend-quote-new/?Symbol=MMM","",1,,2)
Or, to get an individual item:
=RCHGetTableCell("
https://www.dividendinvestor.com/dividend-quote-new/?Symbol=MMM",1,"
Ex Date")
However, if I recall correctly from past usage of their site, you only get
a few companies (5? 10?) before it starts returning the signup page instead
of data for a company. $30/month was too pricey for me, for the data they
provide.
On Sat, Feb 25, 2017 at 4:24 PM, gaston.bullrich@
...wrote:
> Any thoughts on extracting data from the two tables on that page?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar