15 New Messages
Digest #2856
Messages
Wed Nov 13, 2013 4:58 am (PST) . Posted by:
wongkayau
Hi Randy
I have a quick question on RCHGetTableCell(URL, Cell#, [Find1], [Find2], [Find3], [Find4], [Row#]).
I want to move down by one row. For example, I am working on a 4x4 table and have located at [2,2]. I want to grab a data in [3,2], However, if I set [Row#]=1, RCHGetTableCell will grab the cell at the end of row2. If I set [Row#]=2, RCHGetTableCell will grab end of row3.
Indirectly, I can grab the data by setting [Row#]=1 and then Cell#=2. But, can I directly move down by one row? It is because the dimension of tables varies and it may be 4x4, 8x20, 9x30.... I want to locate a cell (using date) and then grab the cell immediately below it.
Thank you so much for your help!
Cheers,
Laurent
I have a quick question on RCHGetTableCell(
I want to move down by one row. For example, I am working on a 4x4 table and have located at [2,2]. I want to grab a data in [3,2], However, if I set [Row#]=1, RCHGetTableCell will grab the cell at the end of row2. If I set [Row#]=2, RCHGetTableCell will grab end of row3.
Indirectly, I can grab the data by setting [Row#]=1 and then Cell#=2. But, can I directly move down by one row? It is because the dimension of tables varies and it may be 4x4, 8x20, 9x30.... I want to locate a cell (using date) and then grab the cell immediately below it.
Thank you so much for your help!
Cheers,
Laurent
Wed Nov 13, 2013 6:48 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, you can't just move down a row. The add-in extracts data
based on string searches within HTML source code, not on rendered HTML
structures.
The behavior you mention about grabbing the cell at the end of a row is not
consistent with what the add-in should be doing. Not unless you're using a
negative value for the cell#. I'd like to see an example of an extraction
that is doing that.
On Wed, Nov 13, 2013 at 5:58 AM, <wongkayau@yahoo.com> wrote:
> I have a quick question on RCHGetTableCell(URL, Cell#, [Find1], [Find2],
> [Find3], [Find4], [Row#]).
>
> I want to move down by one row. For example, I am working on a 4x4 table
> and have located at [2,2]. I want to grab a data in [3,2], However, if I
> set [Row#]=1, RCHGetTableCell will grab the cell at the end of row2. If I
> set [Row#]=2, RCHGetTableCell will grab end of row3.
>
> Indirectly, I can grab the data by setting [Row#]=1 and then Cell#=2. But,
> can I directly move down by one row? It is because the dimension of tables
> varies and it may be 4x4, 8x20, 9x30.... I want to locate a cell (using
> date) and then grab the cell immediately below it.
>
based on string searches within HTML source code, not on rendered HTML
structures.
The behavior you mention about grabbing the cell at the end of a row is not
consistent with what the add-in should be doing. Not unless you're using a
negative value for the cell#. I'd like to see an example of an extraction
that is doing that.
On Wed, Nov 13, 2013 at 5:58 AM, <wongkayau@yahoo.
> I have a quick question on RCHGetTableCell(
> [Find3], [Find4], [Row#]).
>
> I want to move down by one row. For example, I am working on a 4x4 table
> and have located at [2,2]. I want to grab a data in [3,2], However, if I
> set [Row#]=1, RCHGetTableCell will grab the cell at the end of row2. If I
> set [Row#]=2, RCHGetTableCell will grab end of row3.
>
> Indirectly, I can grab the data by setting [Row#]=1 and then Cell#=2. But,
> can I directly move down by one row? It is because the dimension of tables
> varies and it may be 4x4, 8x20, 9x30.... I want to locate a cell (using
> date) and then grab the cell immediately below it.
>
Wed Nov 13, 2013 7:38 am (PST) . Posted by:
wongkayau
thanks Randy for your prompt reply.
=RCHGetTableCell("http://finance.yahoo.com/q/is?s=MMM+Income+Statement&annual http://finance.yahoo.com/q/is?s=MMM+Income+Statement&annual", 0, "Total Revenue",,,,B)
For B=1, result = 26,662,000, which is the end cell of same row as "Total Revenue"
For B=2, result = 13,831,000, which is the end cell of next row of "Total Revenue"
Thanks.
Cheers, Laurent
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Unfortunately, you can't just move down a row. The add-in extracts data based on string searches within HTML source code, not on rendered HTML structures.
The behavior you mention about grabbing the cell at the end of a row is not consistent with what the add-in should be doing. Not unless you're using a negative value for the cell#. I'd like to see an example of an extraction that is doing that.
On Wed, Nov 13, 2013 at 5:58 AM, <wongkayau@... mailto:wongkayau@...> wrote:
I have a quick question on RCHGetTableCell(URL, Cell#, [Find1], [Find2], [Find3], [Find4], [Row#]). I want to move down by one row. For example, I am working on a 4x4 table and have located at [2,2]. I want to grab a data in [3,2], However, if I set [Row#]=1, RCHGetTableCell will grab the cell at the end of row2. If I set [Row#]=2, RCHGetTableCell will grab end of row3.
Indirectly, I can grab the data by setting [Row#]=1 and then Cell#=2. But, can I directly move down by one row? It is because the dimension of tables varies and it may be 4x4, 8x20, 9x30.... I want to locate a cell (using date) and then grab the cell immediately below it.
=RCHGetTableCell(
For B=1, result = 26,662,000, which is the end cell of same row as "Total Revenue"
For B=2, result = 13,831,000, which is the end cell of next row of "Total Revenue"
Thanks.
Cheers, Laurent
---In smf_addin@yahoogrou
Unfortunately, you can't just move down a row. The add-in extracts data based on string searches within HTML source code, not on rendered HTML structures.
The behavior you mention about grabbing the cell at the end of a row is not consistent with what the add-in should be doing. Not unless you're using a negative value for the cell#. I'd like to see an example of an extraction that is doing that.
On Wed, Nov 13, 2013 at 5:58 AM, <wongkayau@
I have a quick question on RCHGetTableCell(
Indirectly, I can grab the data by setting [Row#]=1 and then Cell#=2. But, can I directly move down by one row? It is because the dimension of tables varies and it may be 4x4, 8x20, 9x30.... I want to locate a cell (using date) and then grab the cell immediately below it.
Wed Nov 13, 2013 7:59 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Ah. You're getting that behavior because you have "pCells" set to zero.
So, pRows=1 moves you to the end of the row, and then pCells=0 says go no
further.
pRows=2 move you to the end of the next row, and then pCells=0 says go no
further.
On Wed, Nov 13, 2013 at 8:38 AM, <wongkayau@yahoo.com> wrote:
>
>
> =RCHGetTableCell("
> http://finance.yahoo.com/q/is?s=MMM+Income+Statement&annual", 0, "Total
> Revenue",,,,B)
>
> For B=1, result = *26,662,000*, which is the end cell of same row as
> "Total Revenue"
>
> For B=2, result = *13,831,000*, which is the end cell of next row of
> "Total Revenue"
>
>
>
So, pRows=1 moves you to the end of the row, and then pCells=0 says go no
further.
pRows=2 move you to the end of the next row, and then pCells=0 says go no
further.
On Wed, Nov 13, 2013 at 8:38 AM, <wongkayau@yahoo.
>
>
> =RCHGetTableCell(
> http://finance.
> Revenue"
>
> For B=1, result = *26,662,000*
> "Total Revenue"
>
> For B=2, result = *13,831,000*
> "Total Revenue"
>
>
>
Wed Nov 13, 2013 8:34 am (PST) . Posted by:
wongkayau
Thanks Randy!
Cheers,
Laurent
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Ah. You're getting that behavior because you have "pCells" set to zero.
So, pRows=1 moves you to the end of the row, and then pCells=0 says go no further.
pRows=2 move you to the end of the next row, and then pCells=0 says go no further.
On Wed, Nov 13, 2013 at 8:38 AM, <wongkayau@... mailto:wongkayau@...> wrote:
=RCHGetTableCell("http://finance.yahoo.com/q/is?s=MMM+Income+Statement&annual http://finance.yahoo.com/q/is?s=MMM+Income+Statement&annual", 0, "Total Revenue",,,,B)
For B=1, result = 26,662,000, which is the end cell of same row as "Total Revenue"
For B=2, result = 13,831,000, which is the end cell of next row of "Total Revenue"
Cheers,
Laurent
---In smf_addin@yahoogrou
Ah. You're getting that behavior because you have "pCells" set to zero.
So, pRows=1 moves you to the end of the row, and then pCells=0 says go no further.
pRows=2 move you to the end of the next row, and then pCells=0 says go no further.
On Wed, Nov 13, 2013 at 8:38 AM, <wongkayau@
=RCHGetTableCell(
For B=1, result = 26,662,000, which is the end cell of same row as "Total Revenue"
For B=2, result = 13,831,000, which is the end cell of next row of "Total Revenue"
Wed Nov 13, 2013 5:03 am (PST) . Posted by:
wongkayau
Hello Randy,
RCHGetTableCell(URL, Cell#, [Find1], [Find2], [Find3], [Find4], [Row#]).
I want to move down by one row. For example, I am working on a 4x4 table and have located at [2,2]. I want to grab a data in [3,2], However, if I set [Row#]=1, RCHGetTableCell will grab the cell at the end of row2. If I set [Row#]=2, RCHGetTableCell will grab end of row3.
Indirectly, I can grab the data by setting [Row#]=1 and then Cell#=2. But, can I directly move down by one row? It is because the dimension of tables varies and it may be 4x4, 8x20, 9x30.... I want to locate a cell (using date) and then grab the cell immediately below it.
Thank you so much for your help!
Cheers,
Laurent
RCHGetTableCell(
I want to move down by one row. For example, I am working on a 4x4 table and have located at [2,2]. I want to grab a data in [3,2], However, if I set [Row#]=1, RCHGetTableCell will grab the cell at the end of row2. If I set [Row#]=2, RCHGetTableCell will grab end of row3.
Indirectly, I can grab the data by setting [Row#]=1 and then Cell#=2. But, can I directly move down by one row? It is because the dimension of tables varies and it may be 4x4, 8x20, 9x30.... I want to locate a cell (using date) and then grab the cell immediately below it.
Thank you so much for your help!
Cheers,
Laurent
Wed Nov 13, 2013 12:05 pm (PST) . Posted by:
racecar00
Hi Randy,
I am trying to capture risk metrics for ETFs using Morningstar's data. When using the RCHGetTableCell function & Morningstar I prefer to use the printreport pages but Morningstar seems to be trending towards the dynamic pages more and more.
I am trying to capture risj metrics using the following formula and link:
=RCHGetTableCell("http://performance.morningstar.com/funds/etf/ratings-risk.action?t="&$C8,1,"AFK", "Beta")
I am having trouble with the syntax for identifying row and column - in this example, the beta metric for the ticker 'AFK'. There are three rows of data depending on benchmark preference.
Can you help me solve the syntax for using row 1 for ticker AFK (cell reference willbe used), column 4 titled "Beta".
Thanks in advance for your help!
I am trying to capture risk metrics for ETFs using Morningstar&#
I am trying to capture risj metrics using the following formula and link:
=RCHGetTableCell(
I am having trouble with the syntax for identifying row and column - in this example, the beta metric for the ticker 'AFK'
Can you help me solve the syntax for using row 1 for ticker AFK (cell reference willbe used), column 4 titled "Beta"
Thanks in advance for your help!
Wed Nov 13, 2013 1:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The URL you are using *is* a dynamic web page, so you can't extract the
data from there. By going over the JavaScript code, I've learned that
MorningStar *does* keep the data on static pages, but then loads them onto
the dynamic page. In this case, the data you want is on this page (assuming
you want the 3-year beta):
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK
Here's how to extract the five possible definitions of beta:
=RCHGetTableCell("
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK
",
4,"Best-Fit Index","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK
",
4,"Standard Index","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=5&t=AFK
",
4,"Standard Index","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=10&t=AFK
",
4,"Standard Index","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=15&t=AFK
",
4,"Standard Index","<tr","<tr")
My current status on extraction of ETF data from MorningStar has been to
identify these pages as potential sources of raw data (either from their
web page or because it is loaded onto a dynamic web page):
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=5&t=AFK
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=10&t=AFK
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=15&t=AFK
http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=3&t=AFK
http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=5&t=AFK
http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=10&t=AFK
http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=15&t=AFK
http://portfolios.morningstar.com/fund/summary?t=AFK
http://performance.morningstar.com/Performance/cef/premium-discount.action?t=AFK
http://performance.morningstar.com/Performance/cef/cost-risk.action?t=AFK
http://performance.morningstar.com/Performance/cef/performance-history.action?t=AFK
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=AFK
http://performance.morningstar.com/Performance/cef/standardized-returns.action?t=AFK
http://portfolios.morningstar.com/fund/holdings?t=AFK
http://portfolios.morningstar.com/fund/ajax/holdings_tab?&t=AFK
http://portfolios.morningstar.com/fund/ajax/holdings_performanceChart?&t=AFK
http://investors.morningstar.com/ownership/shareholders-overview.html?t=AFK
http://investors.morningstar.com/ownership/equityOS-fund.html?t=AFK
http://investors.morningstar.com/ownership/equityOS-inst.html?t=AFK
http://investors.morningstar.com/ownership/owner-activity.html?t=AFK
http://investors.morningstar.com/ownership/shareholders-concentrated.html?t=AFK
http://investors.morningstar.com/ownership/shareholders-buying.html?t=AFK
http://investors.morningstar.com/ownership/shareholders-selling.html?t=AFK
On Wed, Nov 13, 2013 at 1:05 PM, <agelhausen@gmail.com> wrote:
>
> I am trying to capture risk metrics for ETFs using Morningstar's data.
> When using the RCHGetTableCell function & Morningstar I prefer to use the
> printreport pages but Morningstar seems to be trending towards the dynamic
> pages more and more.
>
> I am trying to capture risj metrics using the following formula and link:
>
> =RCHGetTableCell("
> http://performance.morningstar.com/funds/etf/ratings-risk.action?t="&$C8,1,"AFK",
> "Beta")
>
> I am having trouble with the syntax for identifying row and column - in
> this example, the beta metric for the ticker 'AFK'. There are three rows
> of data depending on benchmark preference.
>
> Can you help me solve the syntax for using row 1 for ticker AFK (cell
> reference willbe used), column 4 titled "Beta".
>
>
data from there. By going over the JavaScript code, I've learned that
MorningStar *does* keep the data on static pages, but then loads them onto
the dynamic page. In this case, the data you want is on this page (assuming
you want the 3-year beta):
http://performance.
Here's how to extract the five possible definitions of beta:
=RCHGetTableCell(
http://performance.
",
4,"Best-
=RCHGetTableCell(
http://performance.
",
4,"Standard Index",
=RCHGetTableCell(
http://performance.
",
4,"Standard Index",
=RCHGetTableCell(
http://performance.
",
4,"Standard Index",
=RCHGetTableCell(
http://performance.
",
4,"Standard Index",
My current status on extraction of ETF data from MorningStar has been to
identify these pages as potential sources of raw data (either from their
web page or because it is loaded onto a dynamic web page):
http://performance.
http://performance.
http://performance.
http://performance.
http://performance.
http://performance.
http://performance.
http://performance.
http://portfolios.
http://performance.
http://performance.
http://performance.
http://performance.
http://performance.
http://portfolios.
http://portfolios.
http://portfolios.
http://investors.
http://investors.
http://investors.
http://investors.
http://investors.
http://investors.
http://investors.
On Wed, Nov 13, 2013 at 1:05 PM, <agelhausen@gmail.
>
> I am trying to capture risk metrics for ETFs using Morningstar&#
> When using the RCHGetTableCell function & Morningstar I prefer to use the
> printreport pages but Morningstar seems to be trending towards the dynamic
> pages more and more.
>
> I am trying to capture risj metrics using the following formula and link:
>
> =RCHGetTableCell(
> http://performance.
> "Beta"
>
> I am having trouble with the syntax for identifying row and column - in
> this example, the beta metric for the ticker 'AFK'
> of data depending on benchmark preference.
>
> Can you help me solve the syntax for using row 1 for ticker AFK (cell
> reference willbe used), column 4 titled "Beta"
>
>
Wed Nov 13, 2013 1:17 pm (PST) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
I'm trying to extract the Shiller PE Ratio from Gurufocus and getting a
blank cell.
I have a premium membership and have access to the data on the website, but
how do I get that into Excel? I can't seem to get any of the Premium content
at the bottom of the 10-yr Financial page to fill in.
=RCHGetTableCell("http://www.gurufocus.com/financials/"&F43,10,">Fiscal
Period",">Shiller PE Ratio")
(F43 is the cell with the ticker)
I tried changing the Fiscal Period header to the Valuation Ratios header and
that just gives an error.
Thanks,
Jim
I'm trying to extract the Shiller PE Ratio from Gurufocus and getting a
blank cell.
I have a premium membership and have access to the data on the website, but
how do I get that into Excel? I can't seem to get any of the Premium content
at the bottom of the 10-yr Financial page to fill in.
=RCHGetTableCell(
Period"
(F43 is the cell with the ticker)
I tried changing the Fiscal Period header to the Valuation Ratios header and
that just gives an error.
Thanks,
Jim
Wed Nov 13, 2013 1:55 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't have access to premium content, so not sure how much help I can be.
When I use this:
=smfGetTagContent("http://www.gurufocus.com/financials/MMM","td",10,">Fiscal
Period",">Shiller PE Ratio")
...I do get the content of the table cell, which is to display the blurred
image we non-subscribers see. So it is getting to that cell. If I do:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$B2,10,">Fiscal
Period",">Shiller PE Ratio")
...I get an empty content returned, which is correct based on what content
I can see.
I'm not sure why you would get "Error" returned for that second formula, if
you have different content in the cell.
On Wed, Nov 13, 2013 at 2:17 PM, Jim Ranum <amt2100@gmail.com> wrote:
>
>
> I'm trying to extract the Shiller PE Ratio from Gurufocus and getting a
> blank cell.
>
> I have a premium membership and have access to the data on the website,
> but how do I get that into Excel? I can't seem to get any of the Premium
> content at the bottom of the 10-yr Financial page to fill in.
>
>
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/"&F43,10,">Fiscal
> Period",">Shiller PE Ratio")
>
> (F43 is the cell with the ticker)
>
>
>
> I tried changing the Fiscal Period header to the Valuation Ratios header
> and that just gives an error.
>
>
>
> Thanks,
>
> Jim
>
>
>
>
>
>
When I use this:
=smfGetTagContent(
Period"
...I do get the content of the table cell, which is to display the blurred
image we non-subscribers see. So it is getting to that cell. If I do:
=RCHGetTableCell(
Period"
...I get an empty content returned, which is correct based on what content
I can see.
I'm not sure why you would get "Error" returned for that second formula, if
you have different content in the cell.
On Wed, Nov 13, 2013 at 2:17 PM, Jim Ranum <amt2100@gmail.
>
>
> I'm trying to extract the Shiller PE Ratio from Gurufocus and getting a
> blank cell.
>
> I have a premium membership and have access to the data on the website,
> but how do I get that into Excel? I can't seem to get any of the Premium
> content at the bottom of the 10-yr Financial page to fill in.
>
>
>
> =RCHGetTableCell(
> Period"
>
> (F43 is the cell with the ticker)
>
>
>
> I tried changing the Fiscal Period header to the Valuation Ratios header
> and that just gives an error.
>
>
>
> Thanks,
>
> Jim
>
>
>
>
>
>
Wed Nov 13, 2013 2:23 pm (PST) . Posted by:
"Jim Ranum" amt2100
Thanks Randy.
Have you ever used this on a website that you have to "Login" for? Is there something that can be entered in the VBA code?
Unfortunately I am not knowledgeable about VBA.
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, November 13, 2013 4:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Shiller PE in Gurufocus (Premium content)
I don't have access to premium content, so not sure how much help I can be.
When I use this:
=smfGetTagContent("http://www.gurufocus.com/financials/MMM","td",10,">Fiscal Period",">Shiller PE Ratio")
...I do get the content of the table cell, which is to display the blurred image we non-subscribers see. So it is getting to that cell. If I do:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$B2,10,">Fiscal Period",">Shiller PE Ratio")
...I get an empty content returned, which is correct based on what content I can see.
I'm not sure why you would get "Error" returned for that second formula, if you have different content in the cell.
On Wed, Nov 13, 2013 at 2:17 PM, Jim Ranum <amt2100@gmail.com> wrote:
I'm trying to extract the Shiller PE Ratio from Gurufocus and getting a blank cell.
I have a premium membership and have access to the data on the website, but how do I get that into Excel? I can't seem to get any of the Premium content at the bottom of the 10-yr Financial page to fill in.
=RCHGetTableCell("http://www.gurufocus.com/financials/"&F43,10,">Fiscal Period",">Shiller PE Ratio")
(F43 is the cell with the ticker)
I tried changing the Fiscal Period header to the Valuation Ratios header and that just gives an error.
Thanks,
Jim
Have you ever used this on a website that you have to "Login" for? Is there something that can be entered in the VBA code?
Unfortunately I am not knowledgeable about VBA.
Thanks,
Jim
From: smf_addin@yahoogrou
Sent: Wednesday, November 13, 2013 4:55 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Shiller PE in Gurufocus (Premium content)
I don't have access to premium content, so not sure how much help I can be.
When I use this:
=smfGetTagContent(
...I do get the content of the table cell, which is to display the blurred image we non-subscribers see. So it is getting to that cell. If I do:
=RCHGetTableCell(
...I get an empty content returned, which is correct based on what content I can see.
I'm not sure why you would get "Error" returned for that second formula, if you have different content in the cell.
On Wed, Nov 13, 2013 at 2:17 PM, Jim Ranum <amt2100@gmail.
I'm trying to extract the Shiller PE Ratio from Gurufocus and getting a blank cell.
I have a premium membership and have access to the data on the website, but how do I get that into Excel? I can't seem to get any of the Premium content at the bottom of the 10-yr Financial page to fill in.
=RCHGetTableCell(
(F43 is the cell with the ticker)
I tried changing the Fiscal Period header to the Valuation Ratios header and that just gives an error.
Thanks,
Jim
Wed Nov 13, 2013 2:25 pm (PST) . Posted by:
"Jim Ranum" amt2100
Anyone know another website that we can pull the Shiller PE Ratio for a ticker?
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, November 13, 2013 4:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Shiller PE in Gurufocus (Premium content)
I don't have access to premium content, so not sure how much help I can be.
When I use this:
=smfGetTagContent("http://www.gurufocus.com/financials/MMM","td",10,">Fiscal Period",">Shiller PE Ratio")
...I do get the content of the table cell, which is to display the blurred image we non-subscribers see. So it is getting to that cell. If I do:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$B2,10,">Fiscal Period",">Shiller PE Ratio")
...I get an empty content returned, which is correct based on what content I can see.
I'm not sure why you would get "Error" returned for that second formula, if you have different content in the cell.
On Wed, Nov 13, 2013 at 2:17 PM, Jim Ranum <amt2100@gmail.com> wrote:
I'm trying to extract the Shiller PE Ratio from Gurufocus and getting a blank cell.
I have a premium membership and have access to the data on the website, but how do I get that into Excel? I can't seem to get any of the Premium content at the bottom of the 10-yr Financial page to fill in.
=RCHGetTableCell("http://www.gurufocus.com/financials/"&F43,10,">Fiscal Period",">Shiller PE Ratio")
(F43 is the cell with the ticker)
I tried changing the Fiscal Period header to the Valuation Ratios header and that just gives an error.
Thanks,
Jim
Thanks,
Jim
From: smf_addin@yahoogrou
Sent: Wednesday, November 13, 2013 4:55 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Shiller PE in Gurufocus (Premium content)
I don't have access to premium content, so not sure how much help I can be.
When I use this:
=smfGetTagContent(
...I do get the content of the table cell, which is to display the blurred image we non-subscribers see. So it is getting to that cell. If I do:
=RCHGetTableCell(
...I get an empty content returned, which is correct based on what content I can see.
I'm not sure why you would get "Error" returned for that second formula, if you have different content in the cell.
On Wed, Nov 13, 2013 at 2:17 PM, Jim Ranum <amt2100@gmail.
I'm trying to extract the Shiller PE Ratio from Gurufocus and getting a blank cell.
I have a premium membership and have access to the data on the website, but how do I get that into Excel? I can't seem to get any of the Premium content at the bottom of the 10-yr Financial page to fill in.
=RCHGetTableCell(
(F43 is the cell with the ticker)
I tried changing the Fiscal Period header to the Valuation Ratios header and that just gives an error.
Thanks,
Jim
Wed Nov 13, 2013 1:29 pm (PST) . Posted by:
digsupply
Hello, Randy. Is there an update for this template: RCHGetWebData-Template-BarChart-Quotes-Extract.xls ? I used it to see the 5 minute chart, but it has stopped working. Any ideas? Thank you for your help
Wed Nov 13, 2013 1:45 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I just tried the 5-minute interval with ticker symbol MMM with the workbook
from the FILES area of the group and it worked fine for me.
What ticker were you using?
On Wed, Nov 13, 2013 at 2:29 PM, <picsound@gmail.com> wrote:
>
> Hello, Randy. Is there an update for this template:
> RCHGetWebData-Template-BarChart-Quotes-Extract.xls ? I used it to see the 5
> minute chart, but it has stopped working. Any ideas? Thank you for your help
>
from the FILES area of the group and it worked fine for me.
What ticker were you using?
On Wed, Nov 13, 2013 at 2:29 PM, <picsound@gmail.
>
> Hello, Randy. Is there an update for this template:
> RCHGetWebData-
> minute chart, but it has stopped working. Any ideas? Thank you for your help
>
Wed Nov 13, 2013 3:32 pm (PST) . Posted by:
"tn mc" tnmc77
How do I get total weekly volume of QQQ. One that I get from yahoo appears
to be an average volume per day during any given week. That means that one
has to multiply it with 5 (or 4 if there is a holiday during the week) to
get total weekly volume.
Thanks.
Shashank
to be an average volume per day during any given week. That means that one
has to multiply it with 5 (or 4 if there is a holiday during the week) to
get total weekly volume.
Thanks.
Shashank
Tidak ada komentar:
Posting Komentar