6 Messages

Digest #3339

Re: Bond prices? by "Randy Harmelink" rharmelink

ETF.com data by rus101

Re: ETF.com data by "Randy Harmelink" rharmelink

Problem with MarketWatch Site by mikeoverinlr

Re: Problem with MarketWatch Site by "Randy Harmelink" rharmelink

What is the Element to Get the Tickers Full Name? by electronicjason

Messages

1a

Depends on the source. I don't do anything with bonds, so I'm not aware of
a source of historical quotes.

On Wed, Feb 25, 2015 at 2:22 AM, Marion Stuchlik marion_stuchlik@... wrote:

>
> Is it possible to download historical bonds prices?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2a

ETF.com data

Thu Feb 26, 2015 7:32 am (PST) . Posted by:

rus101

Hi Randy, thanks for keeping up the good work here, I've been using the plug-in for year and love it!

I was wondering if there is a way to extract the data from ETF.com.

For example, on the link below, is it possible to get datapoints from tables on the right, specifically "Assets Under Management"

HACK ETF: Holdings, Quote, Analysis, Ratings | ETF.com http://www.etf.com/HACK

HACK ETF: Holdings, Quote, Analysis, Ratings | ETF.com http://www.etf.com/HACK Get quotes, holdings, analyses, and ratings on PureFunds ISE Cyber Security ETF (HACK) with ETF.com's institutional research and tools.

View on www.etf.com http://www.etf.com/HACK
Preview by Yahoo

Thanks,
Denis

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: ETF.com data

Thu Feb 26, 2015 8:31 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfConvertData(smfGetTagContent("http://www.etf.com/HACK","span",1,">Assets
Under Management"))

...although the result will be in thousands of dollars.

On Thu, Feb 26, 2015 at 8:32 AM, rus101@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi Randy, thanks for keeping up the good work here, I've been using the
> plug-in for year and love it!
>
> I was wondering if there is a way to extract the data from ETF.com.
>
> For example, on the link below, is it possible to get datapoints from
> tables on the right, specifically "Assets Under Management"
>
> HACK ETF: Holdings, Quote, Analysis, Ratings | ETF.com
> <http://www.etf.com/HACK>
>
>
> HACK ETF: Holdings, Quote, Analysis, Ratings | ETF.com
> <http://www.etf.com/HACK>
> Get quotes, holdings, analyses, and ratings on PureFunds ISE Cyber
> Security ETF (HACK) with ETF.com's institutional research and tools.
>
> View on www.etf.com <http://www.etf.com/HACK>
> Preview by Yahoo
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3a

Problem with MarketWatch Site

Thu Feb 26, 2015 3:48 pm (PST) . Posted by:

mikeoverinlr

Randy - Why will this formula not pull in the Return on Invested Capital for CAT?
=RCHGetTableCell("http://www.marketwatch.com/investing/stock/CAT/profile",1,"Return on Invested Capital")

The result I get is "Name". I've tried all kinds of modifications but have had no luck. Thank you for all the hard work that you put into this.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3b

Re: Problem with MarketWatch Site

Thu Feb 26, 2015 3:55 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Because the data item you want to extract is NOT in an HTML table. It uses
other HTML tags to simulate a table structure. So the first REAL table cell
after "Return on Invested Capital" is the header line of the "Officers and
Executives" table way down below.

Instead, try:

=smfConvertData(smfGetTagContent("
http://www.marketwatch.com/investing/stock/CAT/profile","p",1,"Return on
Invested Capital"))

On Thu, Feb 26, 2015 at 4:48 PM, mikedaleover@... wrote:

> Randy - Why will this formula not pull in the Return on Invested Capital
> for CAT?
>
> =RCHGetTableCell("http://www.marketwatch.com/investing/stock/CAT/profile",1,"Return
> on Invested Capital")
>
> The result I get is "Name". I've tried all kinds of modifications but
> have had no luck. Thank you for all the hard work that you put into this.
>