Jumat, 27 Februari 2015

[smf_addin] Digest Number 3339

6 Messages

Digest #3339
1a
Re: Bond prices? by "Randy Harmelink" rharmelink
2a
ETF.com data by rus101
2b
Re: ETF.com data by "Randy Harmelink" rharmelink
3b
Re: Problem with MarketWatch Site by "Randy Harmelink" rharmelink

Messages

Thu Feb 26, 2015 5:16 am (PST) . Posted by:

"Randy Harmelink" rharmelink

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

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




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

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.

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.
>

Thu Feb 26, 2015 8:43 pm (PST) . Posted by:

electronicjason

If I have the ticker AAPL how do I get the full name Apple Computer Company? What element will do that? A line item will suffice. Thank you.


For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar