6 Messages
Digest #4625
Messages
Fri Oct 11, 2019 12:53 pm (PDT) . Posted by:
waterboy5555
I have gotten the add in to work and pull data in, but I am getting an "error" message for the formula you provided. What could be the error?
Fri Oct 11, 2019 12:55 pm (PDT) . Posted by:
waterboy5555
In the formula you provided, what is the "td" you mention? Then what is ,,,,1 at the end? I am just trying to get an understanding of the way the formula works. Thanks.
Fri Oct 11, 2019 3:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
"td" = The type of HTML tag to retrieve content from -- "table", "td",
"li", "span", etc.
"1" = Strip off any HTML tags and attempt to convert what remains into a
numeric value
On Fri, Oct 11, 2019 at 12:55 PM bopha99@... wrote:
>
> In the formula you provided, what is the "td" you mention? Then what is ,,,,1
> at the end? I am just trying to get an understanding of the way the
> formula works. Thanks.
>
>
>
"li"
"1" = Strip off any HTML tags and attempt to convert what remains into a
numeric value
On Fri, Oct 11, 2019 at 12:55 PM bopha99@... wrote:
>
> In the formula you provided, what is the "td" you mention? Then what is ,,,,1
> at the end? I am just trying to get an understanding of the way the
> formula works. Thanks.
>
>
>
Fri Oct 11, 2019 3:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The web page you gave me before, which the formula used, no longer exists.
Try:
=smfGetTagContent("
https://markets.cboe.com/us/options/market_statistics/daily/","td",1,"Index
Put/Call Ratio",,,,1)
On Fri, Oct 11, 2019 at 12:55 PM bopha99@... wrote:
>
> I have gotten the add in to work and pull data in, but I am getting an
> "error" message for the formula you provided. What could be the error?
>
>
>
Try:
=smfGetTagContent("
https://markets.cboe.com/us/options/market_statistics/daily/","
Put/Call Ratio",
On Fri, Oct 11, 2019 at 12:55 PM bopha99@... wrote:
>
> I have gotten the add in to work and pull data in, but I am getting an
> "error" message for the formula you provided. What could be the error?
>
>
>
Fri Oct 11, 2019 12:57 pm (PDT) . Posted by:
waterboy5555
I use the formula
=RCHGetTableCell("https://finance.yahoo.com/quote/PRNHX/holdings?ltr=1",1,"Equity Holdings","Price/Earnings")
where i am trying to grab the P/E ratio for PRNHX. I get the result Name in the cell. What am I doing wrong? Thanks in advance.
=RCHGetTableCell("https://finance.yahoo.com/quote/PRNHX/holdings?ltr=1",1,"
where i am trying to grab the P/E ratio for PRNHX. I get the result Name in the cell. What am I doing wrong? Thanks in advance.
Fri Oct 11, 2019 3:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The data you are trying to extract isn't being presented in an HTML table,
so you're getting the first table cell on the web page, which is the header
of the first column of the "Top 10 Holdings" table. Try:
=smfGetTagContent("https://finance.yahoo.com/quote/PRNHX/holdings
","span",1,">Price/Earnings",,,,1)
On Fri, Oct 11, 2019 at 12:59 PM bopha99@... wrote:
> I use the formula
>
> =RCHGetTableCell("https://finance.yahoo.com/quote/PRNHX/holdings?ltr=1",1,"Equity
> Holdings","Price/Earnings")
>
> where i am trying to grab the P/E ratio for PRNHX. I get the result Name
> in the cell. What am I doing wrong? Thanks in advance.
>
>
so you're getting the first table cell on the web page, which is the header
of the first column of the "Top 10 Holdings" table. Try:
=smfGetTagContent("https://finance.yahoo.com/quote/PRNHX/holdings
","span",1,">Price/Earnings",,,,1)
On Fri, Oct 11, 2019 at 12:59 PM bopha99@... wrote:
> I use the formula
>
> =RCHGetTableCell("https://finance.yahoo.com/quote/PRNHX/holdings?ltr=1",1,"
> Holdings"
>
> where i am trying to grab the P/E ratio for PRNHX. I get the result Name
> in the cell. What am I doing wrong? Thanks in advance.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar