9 New Messages
Digest #2860
Messages
Fri Nov 15, 2013 1:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
This should work:
=RCHGetTableCell("http://quotes.morningstar.com/stock/c-financials?&t=adi
",2,"<table",,,,3,"</table")
I haven't decided how far I will go with MorningStar. I don't use it as a
source myself, because I don't like having to visit the site manually at
the start of each day, to get any extractions to work.
I have updated all element definitions that were previously defined. For
financial statements data, I'd almost prefer people use the CSV option,
since it has ways to customize the output.
On Fri, Nov 15, 2013 at 10:06 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> I am trying to extract data from
> http://quotes.morningstar.com/stock/c-financials?&t=adi
>
> I need some help to get the "last year date " in Annual. The value is
> 2012-10
>
> Randy, are you planning to define elements from this page?.
>
>
=RCHGetTableCell(
",2,"
I haven't decided how far I will go with MorningStar. I don't use it as a
source myself, because I don't like having to visit the site manually at
the start of each day, to get any extractions to work.
I have updated all element definitions that were previously defined. For
financial statements data, I'd almost prefer people use the CSV option,
since it has ways to customize the output.
On Fri, Nov 15, 2013 at 10:06 AM, Jacob Jose <pepecan47@yahoo.
>
> I am trying to extract data from
> http://quotes.
>
> I need some help to get the "last year date " in Annual. The value is
> 2012-10
>
> Randy, are you planning to define elements from this page?.
>
>
Fri Nov 15, 2013 1:33 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
On Fri, Nov 15, 2013 at 8:10 AM, Jim Ranum <amt2100@gmail.com> wrote:
> Sorry to hijack this thread.
>
> I found the source code referencing the Shiller PE Ratio on Guru:
>
> href="#" class="subMenu" title="Shiller PE Ratio" id="ShillerPE">ShillerPE Ratio
> </a>
>
>
>
> And interestingly, one time that I opened my spreadsheet, that cell did
> populate.
>
> What do you make of that/this?
>
Not a clue, sorry.
Does this source code suggest anything specific I should use in the formula?
>
The ">Shiller PE Ratio" looks like it might be unique.
I did find the data buried in the code.
>
> How would I pull this out of here?
>
> The number I'm looking for is the 'tdnormalttm' title='12.50'
>
> 12.50 for last TTM.
>
I think you'll need to use the scheme mentioned earlier, using the negative
values for pCells, to go backwards from the end of the row. Because of
companies that may have limited years and/or quarters presented.
> Sorry to hijack this thread.
>
> I found the source code referencing the Shiller PE Ratio on Guru:
>
> href="#
> </a>
>
>
>
> And interestingly, one time that I opened my spreadsheet, that cell did
> populate.
>
> What do you make of that/this?
>
Not a clue, sorry.
Does this source code suggest anything specific I should use in the formula?
>
The ">Shiller PE Ratio" looks like it might be unique.
I did find the data buried in the code.
>
> How would I pull this out of here?
>
> The number I'm looking for is the 'tdnormalttm' title='12.50'
>
> 12.50 for last TTM.
>
I think you'll need to use the scheme mentioned earlier, using the negative
values for pCells, to go backwards from the end of the row. Because of
companies that may have limited years and/or quarters presented.
Fri Nov 15, 2013 1:38 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
On Fri, Nov 15, 2013 at 8:52 AM, <holmberg_tommy@yahoo.com> wrote:
> I would however have one further question. Is it so that the data that
> "RCHGetTableCell" brings in to spreadsheet is in text format and can't
> therefore be used in any math formula? or is there any way to convert it to
> number format?
>
RCHGetTableCell() should convert text into numbers where it can. If there
is other text in the cell besides the numbers, you'll need to do that
conversion yourself.
Can I replace reference cell for instance in :
>
> =smfConvertData(smfGetTagContent("
> http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO
> ";"span";2;"sectionQuoteDetail"))
>
> And how it's carried out?
>
Just use the normal EXCEL concatenation operator:
=smfConvertData(smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=<http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO>
"&A1;"span";2;"sectionQuoteDetail"))
> I would however have one further question. Is it so that the data that
> "RCHGetTableCe
> therefore be used in any math formula? or is there any way to convert it to
> number format?
>
RCHGetTableCell(
is other text in the cell besides the numbers, you'll need to do that
conversion yourself.
Can I replace reference cell for instance in :
>
> =smfConvertData(
> http://www.reuters.
> ";"
>
> And how it's carried out?
>
Just use the normal EXCEL concatenation operator:
=smfConvertData(
http://www.reuters.
"&A1;"
Fri Nov 15, 2013 1:39 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Go to your membership settings:
http://groups.yahoo.com/neo/groups/smf_addin/management/membership
...and change your "Message Delivery" setting to either "No Email" or
"Special Notices".
On Fri, Nov 15, 2013 at 9:05 AM, AMIT GORE <amitgore2000@yahoo.com> wrote:
>
> I have just joined the group yesterday, and my email is getting flooded
> with all the postings.
>
> Is there some way I can choose not to receive the postings, but yet remain
> a part of the group and access it when I want?
>
http://groups.
...and change your "Message Delivery" setting to either "No Email" or
"Special Notices"
On Fri, Nov 15, 2013 at 9:05 AM, AMIT GORE <amitgore2000@
>
> I have just joined the group yesterday, and my email is getting flooded
> with all the postings.
>
> Is there some way I can choose not to receive the postings, but yet remain
> a part of the group and access it when I want?
>
Fri Nov 15, 2013 2:24 pm (PST) . Posted by:
"Jacob Jose" pepecan47
Hi Randy, thank you for your fast response
when using
=smfGetTagContent("http://quotes.morningstar.com/stock/c-morningstar-take?&t="&A3,"span",1,">Economic Moat")
I get Error for every ticker.
Another thing, the response time getting data from c-morningstar-take is much faster than from printreport.aspx. And I have the feeling that printreport.aspx will disappear any time.
Regards,
Jose L. Jacob
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, November 15, 2013 4:12:09 PM
Subject: Re: [smf_addin] Morningstart Moat
That's because "Economic Moat" isn't unique enough as a search string. For McDonald's, the first place that string appears on the page is in the description of the company. And the next "span" tag contains "Read Full Analyst Report". This is why I often use the ">" suffix from the preceding HTML tag to make a string unique.
For example, this is the formula used in the template in the FILES area of the group:
=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol="&B$2,
2,">Economic Moat",,,,1)
On Fri, Nov 15, 2013 at 1:53 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>I use the following formula to extract the Economic Moat:
>
>=smfGetTagContent("http://quotes.morningstar.com/stock/c-morningstar-take?&t=%22&A3,%22span%22,1,%22Economic Moat")
>
>It works with several tickers, ADI, BAX, CTL, GIS
>
>But, for AFL and MCD I get: Read full Analyst Report
>
>I have a premium membership and I am loggged on to Morningstar.
>
when using
=smfGetTagContent(
I get Error for every ticker.
Another thing, the response time getting data from c-morningstar-
Regards,
Jose L. Jacob
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Friday, November 15, 2013 4:12:09 PM
Subject: Re: [smf_addin] Morningstart Moat
That's because "Economic Moat" isn't unique enough as a search string. For McDonald'
For example, this is the formula used in the template in the FILES area of the group:
=RCHGetTableCell(
2,">
On Fri, Nov 15, 2013 at 1:53 PM, Jacob Jose <pepecan47@yahoo.
>
>I use the following formula to extract the Economic Moat:
>
>=smfGetTagConte
>
>It works with several tickers, ADI, BAX, CTL, GIS
>
>But, for AFL and MCD I get: Read full Analyst Report
>
>I have a premium membership and I am loggged on to Morningstar.
>
Fri Nov 15, 2013 2:31 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The ">" is all dependent on how the web page is coded. Maybe the best
solution is to use two search strings:
=smfGetTagContent("
http://quotes.morningstar.com/stock/c-morningstar-take?&t="&B5,
"span",1,"idMstarRecommendationContent","Economic Moat")
On Fri, Nov 15, 2013 at 3:24 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> when using
> =smfGetTagContent("
> http://quotes.morningstar.com/stock/c-morningstar-take?&t="&A3,"span",1,">EconomicMoat")
>
> I get Error for every ticker.
>
> Another thing, the response time getting data from c-morningstar-take is
> much faster than from printreport.aspx. And I have the feeling that
> printreport.aspx will disappear any time._
>
solution is to use two search strings:
=smfGetTagContent(
http://quotes.
"span"
On Fri, Nov 15, 2013 at 3:24 PM, Jacob Jose <pepecan47@yahoo.
>
> when using
> =smfGetTagContent(
> http://quotes.
>
> I get Error for every ticker.
>
> Another thing, the response time getting data from c-morningstar-
> much faster than from printreport.
> printreport.
>
Fri Nov 15, 2013 3:39 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I updated/added some MorningStar "Take" and "Profile" element definitions,
#877-#891, to smf-elements-4.txt:
# Usage Source Element Template or Notes 877 S MorningStarP Industry Updated
2013-11-15 878 S MorningStarP Sector Updated 2013-11-15 879 S
MorningStarP Stock
Type Updated 2013-11-15 880 S MorningStarP Morningstar Style Box Updated
2013-11-15 881 S MorningStarT Stock Grades -- Growth Updated 2013-11-15
882 S MorningStarT Stock Grades -- Profitability Updated 2013-11-15 884 S
MorningStarT Take -- Morningstar Credit Rating Added 2013-11-15 885 S
MorningStarT Take -- Company Notes Added 2013-11-15 886 S MorningStarT Take
-- Fair Value Estimate Added 2013-11-15 887 S MorningStarT Take --
Consider Buying Added 2013-11-15 888 S MorningStarT Take -- Consider
Selling Added 2013-11-15 889 S MorningStarT Take -- Fair Value
Uncertainty Added
2013-11-15 890 S MorningStarT Take -- Economic Moat Added 2013-11-15 891 S
MorningStarT Take -- Stewardship Added 2013-11-15
To install the updates to the element definitions, replace the
smf-elements-4.txt
in your SMF add-in folder with this new file. Then, you'll either need to
exit and restart EXCEL, or run the smfForceRecalculation macro, in order
for the add-in to load the new definitions.
On Fri, Nov 15, 2013 at 1:53 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> I use the following formula to extract the Economic Moat:
>
> =smfGetTagContent("
> http://quotes.morningstar.com/stock/c-morningstar-take?&t="&A3,"span",1,"EconomicMoat")
>
> It works with several tickers, ADI, BAX, CTL, GIS
>
> But, for AFL and MCD I get: Read full Analyst Report
>
> I have a premium membership and I am loggged on to Morningstar.
>
>
#877-#891, to smf-elements-
# Usage Source Element Template or Notes 877 S MorningStarP Industry Updated
2013-11-15 878 S MorningStarP Sector Updated 2013-11-15 879 S
MorningStarP Stock
Type Updated 2013-11-15 880 S MorningStarP Morningstar Style Box Updated
2013-11-15 881 S MorningStarT Stock Grades -- Growth Updated 2013-11-15
882 S MorningStarT Stock Grades -- Profitability Updated 2013-11-15 884 S
MorningStarT Take -- Morningstar Credit Rating Added 2013-11-15 885 S
MorningStarT Take -- Company Notes Added 2013-11-15 886 S MorningStarT Take
-- Fair Value Estimate Added 2013-11-15 887 S MorningStarT Take --
Consider Buying Added 2013-11-15 888 S MorningStarT Take -- Consider
Selling Added 2013-11-15 889 S MorningStarT Take -- Fair Value
Uncertainty Added
2013-11-15 890 S MorningStarT Take -- Economic Moat Added 2013-11-15 891 S
MorningStarT Take -- Stewardship Added 2013-11-15
To install the updates to the element definitions, replace the
smf-elements-
in your SMF add-in folder with this new file. Then, you'll either need to
exit and restart EXCEL, or run the smfForceRecalculati
for the add-in to load the new definitions.
On Fri, Nov 15, 2013 at 1:53 PM, Jacob Jose <pepecan47@yahoo.
>
> I use the following formula to extract the Economic Moat:
>
> =smfGetTagContent(
> http://quotes.
>
> It works with several tickers, ADI, BAX, CTL, GIS
>
> But, for AFL and MCD I get: Read full Analyst Report
>
> I have a premium membership and I am loggged on to Morningstar.
>
>
Fri Nov 15, 2013 7:59 pm (PST) . Posted by:
peteontheroad
Here is what I get:
Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files\SMF Add-in; 1)
=0+smfStrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/~~~~~/detailed-estimates","p",-1,"Zacks Rank:"),": ","-")
Error
3
Zacks Rank : 3-Hold <sup class="help_text" title="Zacks Rank
Hold3
3
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I just tried it and it's working here.
What version of EXCEL are you using?
Do you have the updated element definitions from smf-elements-6.txt? See:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294 http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("P-URL",848)
=RCHGetElementNumber("MMM";,848)
=smfConvertData(smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank :"),": ","-"))
=smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank :")
=RCHGetTableCell("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates",1,">Premium Research",">Zacks Rank")
=smfConvertData(smfstrExtr(RCHGetWebData("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","Zacks Rank :",30),":","-"))
On Wed, Nov 13, 2013 at 9:15 PM, <peteontheroad@... mailto:peteontheroad@...> wrote:
RCHGetelement 848 is definitely not working, it only returns errors. How can we fix this?
Stock Market Functions add-in, Version 2.1.2012.12.
=0+smfStrExtr(
Error
3
Zacks Rank : 3-Hold <sup class="
Hold3
3
---In smf_addin@yahoogrou
I just tried it and it's working here.
What version of EXCEL are you using?
Do you have the updated element definitions from smf-elements-
http://groups.
What do you get with:
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfConvertData(
=smfGetTagContent(
=RCHGetTableCell(
=smfConvertData(
On Wed, Nov 13, 2013 at 9:15 PM, <peteontheroad@
RCHGetelement 848 is definitely not working, it only returns errors. How can we fix this?
Fri Nov 15, 2013 8:14 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You have the old element definition. It no longer works. See the link I
gave you.
On Fri, Nov 15, 2013 at 8:59 PM, <peteontheroad@yahoo.com> wrote:
> Here is what I get:
>
> Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program
> Files\SMF Add-in; 1)
>
> =0+smfStrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/~~~~~/detailed-estimates","p",-1,"ZacksRank:"),": ","-")
>
> Error
>
> 3
>
> *Zacks Rank : 3-Hold <sup class="help_text" title="Zacks Rank*
>
> *Hold3*
>
> *3*
>
gave you.
On Fri, Nov 15, 2013 at 8:59 PM, <peteontheroad@
> Here is what I get:
>
> Stock Market Functions add-in, Version 2.1.2012.12.
> Files\SMF Add-in; 1)
>
> =0+smfStrExtr(
> http://www.zacks.
>
> Error
>
> 3
>
> *Zacks Rank : 3-Hold <sup class="
>
> *Hold3*
>
> *3*
>
Tidak ada komentar:
Posting Komentar