15 Messages
Digest #3023
Messages
Thu Mar 27, 2014 6:34 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
What I have found is that when I leave a spreadsheet open for a few days and test with it I run into the 1,000 page limit.
I close and reopen and it works find.
That may or may not be your problem
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of gbusolini@yahoo.com
Sent: Wednesday, March 26, 2014 6:32 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Google data retrieval issues
Good evening
I am trying to download financial statement info from Google. However I would like to do this for many tickers at the same time, for example 500 at a time with around 20 data items for each.
For reference I am using a series of
=RCHGetElementNumber queries in separate excel cells.
I can successfully do this for a single ticker, or a small quantity of tickers. However the problem I encounter, is that after a few requests for small batches of tickers, I consistently get "Error" returned.
Does anyone know whether there is some kind of limit set by Google on how much information can be pulled by a single IP address over a defined timeframe?
Many thanks in advance for any help.
I close and reopen and it works find.
That may or may not be your problem
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of gbusolini@yahoo.com
Sent: Wednesday, March 26, 2014 6:32 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Google data retrieval issues
Good evening
I am trying to download financial statement info from Google. However I would like to do this for many tickers at the same time, for example 500 at a time with around 20 data items for each.
For reference I am using a series of
=RCHGetElementNumbe
I can successfully do this for a single ticker, or a small quantity of tickers. However the problem I encounter, is that after a few requests for small batches of tickers, I consistently get "Error" returned.
Does anyone know whether there is some kind of limit set by Google on how much information can be pulled by a single IP address over a defined timeframe?
Many thanks in advance for any help.
Thu Mar 27, 2014 7:52 am (PDT) . Posted by:
"Jacob Jose" pepecan47
Hi Randy - using this formula for the yearly dividend amounts:
=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&B1,"",1,"",1,,6,26),4)
Is there a way to get, for example, the 2013 dividend only? or the 2012 only? without having to get the 26 elements of the array in the spreadsheet?
And in this formula that give me the yields at the end of the year:
=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&B1,"",1,"",1,,6,26),6)
Can I get, for example, the average yield of the last 5 years, again without having to put all the data in the spreadsheet?
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, March 12, 2014 12:23:39 AM
Subject: Re: [smf_addin] Morningstar dynamic pages
Sure, either across a row:
=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS","",1,"",1,,6,26),6)
...or down a column:
=TRANSPOSE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS","",1,"",1,,6,26),6))
On Tue, Mar 11, 2014 at 9:03 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>Hey Randy, this is amazing. Is there a way to get all this data as an array? I love the year end yield.
>
>I used to get the dividend history from Yahoo, but I am fed up, too many errors and omissions.
>
=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&B1,"",1,"",1,,6,26),4)
Is there a way to get, for example, the 2013 dividend only? or the 2012 only? without having to get the 26 elements of the array in the spreadsheet?
And in this formula that give me the yields at the end of the year:
=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&B1,"",1,"",1,,6,26),6)
Can I get, for example, the average yield of the last 5 years, again without having to put all the data in the spreadsheet?
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, March 12, 2014 12:23:39 AM
Subject: Re: [smf_addin] Morningstar dynamic pages
Sure, either across a row:
=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS","",1,"",1,,6,26),6)
...or down a column:
=TRANSPOSE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS","",1,"",1,,6,26),6))
On Tue, Mar 11, 2014 at 9:03 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>Hey Randy, this is amazing. Is there a way to get all this data as an array? I love the year end yield.
>
>I used to get the dividend history from Yahoo, but I am fed up, too many errors and omissions.
>
Thu Mar 27, 2014 8:04 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Thu, Mar 27, 2014 at 7:49 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> Hi Randy - using this formula for the yearly dividend amounts:
>
> =INDEX(RCHGetHTMLTable("
> http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&B1,"",1,"",1,,6,26),4
> )
>
> Is there a way to get, for example, the 2013 dividend only? or the 2012
> only? without having to get the 26 elements of the array in the spreadsheet?
>
How about the simple old fashioned way (for 2013):
=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&$B$1,25,">Dividend
Amount")
Just change the "25" to "24" to get 2012.
And in this formula that give me the yields at the end of the year:
> =INDEX(RCHGetHTMLTable("
> http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&B1,"",1,"",1,,6,26),6
> )
>
> Can I get, for example, the average yield of the last 5 years, again
> without having to put all the data in the spreadsheet?
>
Just ask for those 5 years of data and average them:
=AVERAGE(INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t=
"&$B$1,"",1,"",1,,6,6),4))
>
> Hi Randy - using this formula for the yearly dividend amounts:
>
> =INDEX(RCHGetHTMLTable("
> http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&B1,"",1,"",1,,6,26),4
> )
>
> Is there a way to get, for example, the 2013 dividend only? or the 2012
> only? without having to get the 26 elements of the array in the spreadsheet?
>
How about the simple old fashioned way (for 2013):
=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&$B$1,25,">Dividend
Amount")
Just change the "25" to "24" to get 2012.
And in this formula that give me the yields at the end of the year:
> =INDEX(RCHGetHTMLTable("
> http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&B1,"",1,"",1,,6,26),6
> )
>
> Can I get, for example, the average yield of the last 5 years, again
> without having to put all the data in the spreadsheet?
>
Just ask for those 5 years of data and average them:
=AVERAGE(INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t=
"&$B$1,
Thu Mar 27, 2014 8:50 am (PDT) . Posted by:
"Jacob Jose" pepecan47
Thank you Randy - for the second formula, the 5 years average:
=AVERAGE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t="&$B$1,"",1,"",1,,6,6),6))
Y want to do for 3 and 10 years as well. I don't understand the formula, the documentation is:
=RCHGetHTMLTable( URL, Find Begin, Begin Direction, Find End, End Direction )
but in the formula there are 7 parameters and in the doc only 5.
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, March 27, 2014 11:04:53 AM
Subject: Re: [smf_addin] Morningstar dynamic pages - dividend history
On Thu, Mar 27, 2014 at 7:49 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>Hi Randy - using this formula for the yearly dividend amounts:
>
>=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=%22&B1,%22%22,1,%22%22,1,,6,26),4)
>
>Is there a way to get, for example, the 2013 dividend only? or the 2012 only? without having to get the 26 elements of the array in the spreadsheet?
How about the simple old fashioned way (for 2013):
=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&$B$1,25,">Dividend Amount")
Just change the "25" to "24" to get 2012.
And in this formula that give me the yields at the end of the year:
>=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=%22&B1,%22%22,1,%22%22,1,,6,26),6)
>
>Can I get, for example, the average yield of the last 5 years, again without having to put all the data in the spreadsheet?
>
Just ask for those 5 years of data and average them:
=AVERAGE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t="&$B$1,"",1,"",1,,6,6),4))
=AVERAGE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t="&$B$1,"",1,"",1,,6,6),6))
Y want to do for 3 and 10 years as well. I don't understand the formula, the documentation is:
=RCHGetHTMLTable( URL, Find Begin, Begin Direction, Find End, End Direction )
but in the formula there are 7 parameters and in the doc only 5.
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, March 27, 2014 11:04:53 AM
Subject: Re: [smf_addin] Morningstar dynamic pages - dividend history
On Thu, Mar 27, 2014 at 7:49 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>Hi Randy - using this formula for the yearly dividend amounts:
>
>=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=%22&B1,%22%22,1,%22%22,1,,6,26),4)
>
>Is there a way to get, for example, the 2013 dividend only? or the 2012 only? without having to get the 26 elements of the array in the spreadsheet?
How about the simple old fashioned way (for 2013):
=RCHGetTableCell("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t="&$B$1,25,">Dividend Amount")
Just change the "25" to "24" to get 2012.
And in this formula that give me the yields at the end of the year:
>=INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=%22&B1,%22%22,1,%22%22,1,,6,26),6)
>
>Can I get, for example, the average yield of the last 5 years, again without having to put all the data in the spreadsheet?
>
Just ask for those 5 years of data and average them:
=AVERAGE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t="&$B$1,
Thu Mar 27, 2014 9:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Actually, the function has 10 possible parameters... :)
The "pDim1" and "pDim2" parameters tell the function how many rows and
columns of data to return. Typically, that is automatically defined by the
range the function is array-entered over, so they are irrelevant. I had to
add those parameters when I wanted to use them in VBA, where there is no
"range" concept. I later discovered they could be useful in the worksheet
as well. But I hesitate to put the into the documentation, because I fear
they would cause confusion rather than be helpful.
In any case, the "6,6" says to return 6 rows and 6 columns of data. The "6"
parameter of the INDEX() function just says to return only the 6th row of
data (i.e. the "Dividend Amount" row). The 6 items on that row would be the
label and the 5 years of requested data (i.e. "y=5" in the URL).
On Thu, Mar 27, 2014 at 8:47 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> Thank you Randy - for the second formula, the 5 years average:
> =AVERAGE(INDEX(RCHGetHTMLTable("
> http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t="&$B$1,"",1,"",1,,6,6),6
> ))
>
> Y want to do for 3 and 10 years as well. I don't understand the formula,
> the documentation is:
> *=RCHGetHTMLTable( URL, Find Begin, Begin Direction, Find End, End
> Direction ) *
>
> *but in the formula there are 7 parameters and in the doc only 5.*
>
The "pDim1" and "pDim2" parameters tell the function how many rows and
columns of data to return. Typically, that is automatically defined by the
range the function is array-entered over, so they are irrelevant. I had to
add those parameters when I wanted to use them in VBA, where there is no
"range" concept. I later discovered they could be useful in the worksheet
as well. But I hesitate to put the into the documentation, because I fear
they would cause confusion rather than be helpful.
In any case, the "6,6" says to return 6 rows and 6 columns of data. The "6"
parameter of the INDEX() function just says to return only the 6th row of
data (i.e. the "Dividend Amount" row). The 6 items on that row would be the
label and the 5 years of requested data (i.e. "y=5" in the URL).
On Thu, Mar 27, 2014 at 8:47 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> Thank you Randy - for the second formula, the 5 years average:
> =AVERAGE(INDEX(RCHGetHTMLTable("
> http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t="&$B$1,
> ))
>
> Y want to do for 3 and 10 years as well. I don't understand the formula,
> the documentation is:
> *=RCHGetHTMLTable( URL, Find Begin, Begin Direction, Find End, End
> Direction ) *
>
> *but in the formula there are 7 parameters and in the doc only 5.*
>
Thu Mar 27, 2014 9:59 am (PDT) . Posted by:
"Jacob Jose" pepecan47
Randy, is it possible to get the average yield of the last 3 years?
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, March 27, 2014 12:20:34 PM
Subject: Re: [smf_addin] Morningstar dynamic pages - dividend history
Actually, the function has 10 possible parameters... :)
The "pDim1" and "pDim2" parameters tell the function how many rows and columns of data to return. Typically, that is automatically defined by the range the function is array-entered over, so they are irrelevant. I had to add those parameters when I wanted to use them in VBA, where there is no "range" concept. I later discovered they could be useful in the worksheet as well. But I hesitate to put the into the documentation, because I fear they would cause confusion rather than be helpful.
In any case, the "6,6" says to return 6 rows and 6 columns of data. The "6" parameter of the INDEX() function just says to return only the 6th row of data (i.e. the "Dividend Amount" row). The 6 items on that row would be the label and the 5 years of requested data (i.e. "y=5" in the URL).
On Thu, Mar 27, 2014 at 8:47 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>Thank you Randy - for the second formula, the 5 years average:
>=AVERAGE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t=%22&$B$1,%22%22,1,%22%22,1,,6,6),6))
>
>Y want to do for 3 and 10 years as well. I don't understand the formula, the documentation is:
>=RCHGetHTMLTable( URL, Find Begin, Begin Direction, Find End, End Direction )
>
>but in the formula there are 7 parameters and in the doc only 5.
>
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, March 27, 2014 12:20:34 PM
Subject: Re: [smf_addin] Morningstar dynamic pages - dividend history
Actually, the function has 10 possible parameters... :)
The "pDim1" and "pDim2" parameters tell the function how many rows and columns of data to return. Typically, that is automatically defined by the range the function is array-entered over, so they are irrelevant. I had to add those parameters when I wanted to use them in VBA, where there is no "range" concept. I later discovered they could be useful in the worksheet as well. But I hesitate to put the into the documentation, because I fear they would cause confusion rather than be helpful.
In any case, the "6,6" says to return 6 rows and 6 columns of data. The "6" parameter of the INDEX() function just says to return only the 6th row of data (i.e. the "Dividend Amount" row). The 6 items on that row would be the label and the 5 years of requested data (i.e. "y=5" in the URL).
On Thu, Mar 27, 2014 at 8:47 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>Thank you Randy - for the second formula, the 5 years average:
>=AVERAGE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t=%22&$B$1,%22%22,1,%22%22,1,,6,6),6))
>
>Y want to do for 3 and 10 years as well. I don't understand the formula, the documentation is:
>=RCHGetHTMLTabl
>
>but in the formula there are 7 parameters and in the doc only 5.
>
Thu Mar 27, 2014 10:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sure. Just change "y=5" to "y=3" and the number of columns to return (i.e.
pDim2) from 6 to 4:
So, 3-year average:
=AVERAGE(INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=3&t=
"&$B$1,"",1,"",1,,6,4),4))
....5-year average:
=AVERAGE(INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t=
"&$B$1,"",1,"",1,,6,6),4))
...10-year average (setting y=10 and pDim2 to 11):
=AVERAGE(INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=10&t=
"&$B$1,"",1,"",1,,6,11),4))
On Thu, Mar 27, 2014 at 9:56 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> Randy, is it possible to get the average yield of the last 3 years?
>
pDim2) from 6 to 4:
So, 3-year average:
=AVERAGE(INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=3&t=
"&$B$1,"",1,"",1,,6,4),4))
....5-year average:
=AVERAGE(INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t=
"&$B$1,"",1,"",1,,6,6),4))
...10-year average (setting y=10 and pDim2 to 11):
=AVERAGE(INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=10&t=
"&$B$1,"",1,"",1,,6,11),4))
On Thu, Mar 27, 2014 at 9:56 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> Randy, is it possible to get the average yield of the last 3 years?
>
Thu Mar 27, 2014 11:17 am (PDT) . Posted by:
"Jacob Jose" pepecan47
Hey Randy, thank you very much (again and again), you are a darling!!
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, March 27, 2014 1:15:03 PM
Subject: Re: [smf_addin] Morningstar dynamic pages - dividend history
Sure. Just change "y=5" to "y=3" and the number of columns to return (i.e. pDim2) from 6 to 4:
So, 3-year average:
=AVERAGE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=3&t="&$B$1,"",1,"",1,,6,4),4))
....5-year average:
=AVERAGE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=5&t="&$B$1,"",1,"",1,,6,6),4))
...10-year average (setting y=10 and pDim2 to 11):
=AVERAGE(INDEX(RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=10&t="&$B$1,"",1,"",1,,6,11),4))
On Thu, Mar 27, 2014 at 9:56 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>Randy, is it possible to get the average yield of the last 3 years?
>
Thu Mar 27, 2014 8:08 am (PDT) . Posted by:
elderbands
I'm an Novice when it comes to anything with the computer (besides being
an Old Coot 84 yrs young) Is there a web site where I can track a stock
during the trading hours to watch it trade?
thank you,
_elderbands@aol.com_ (mailto:elderbands@aol.com)
an Old Coot 84 yrs young) Is there a web site where I can track a stock
during the trading hours to watch it trade?
thank you,
_elderbands@aol.com_ (mailto:elderbands@aol.com)
Thu Mar 27, 2014 8:28 am (PDT) . Posted by:
patrickvb
Dear,
How can I get data from http://www.valueexplorer.com/analyzer/company/US38141G1040/ http://www.valueexplorer.com/analyzer/company/US38141G1040/ I want to retrieve the data in bold, I Try with smfGetTagContent but without success
The HTML code
<div><strong><label for="isin">ISIN:</label> <input type="text" name="isin" value="US38141G1040" id="isin" class="autocompleteWidget" /> </strong></div> <div style="width:300px;"><strong><label for="name">Company Name:</label> <input type="text" name="name" value="GOLDMAN SACHS GROUP INC" id="name" class="autocompleteWidget" /> </strong></div><div class="newline"></div> <div class="newline"></div> <div id="last_price" class="col3">Last Price: 166.95</div> <div id="website" class="col3"><a href="http://www.gs.com http://www.gs.com/" target="_blank">www.gs.com</a></div> <div id="google_finance">Latest News: <a href="http://www.google.com/finance?q=GOLDMAN+SACHS+GROUP+INC http://www.google.com/finance?q=GOLDMAN+SACHS+GROUP+INC" target="_blank">Google Finance</a></div> <div class="newline"></div> <div id="country" class="col3">Country: US</div> <div id="groupname" class="col3">Group: Banks</div> <div id="sectorname" class="col3">Sector: Financial</div> <div class="newline"></div> <div id="market_capitalization_in_millions"; class="col3">Market Cap. Mio: 75587</div> <div id="ev_equity_value" class="col3">Enterprise Value: 513609</div> <div class="newline"></div> <h2>FAIR STOCK VALUE ESTIMATES:</h2> <div id="upside_normalised_multiple_abs" class="col3">Mean Multiple Value: 243.08</div> <div id="upside_normalised_profitability_abs" class="col3">Graham Intrinsic Value: 215.87</div> <div id="upside_current_profitability_abs" class="col3">Greenblatt Fair Value: 217.54</div> <h2>UPSIDE TO FAIR STOCK VALUE (MARGIN-OF-SAFETY):</h2> <div id="upside_normalised_multiple" class="col3">Mean Multiple Upside [%]: 45.6</div> <div id="upside_normalised_profitability" class="col3">Graham Upside [%]: 29.3</div> <div id="upside_current_profitability" class="col3">Greenblatt Upside [%]: 30.3</div>
How can I get data from http://www.valueexplorer.com/analyzer/company/US38141G1040/ http://www.valueexplorer.com/analyzer/company/US38141G1040/ I want to retrieve the data in bold, I Try with smfGetTagContent but without success
The HTML code
<div><strong><label for="isin">ISIN:</label> <input type="text" name="isin" value="US38141G1040" id="isin" class="autocompleteWidget" /> </strong></div> <div style="width:300px;"><strong><label for="name">Company Name:</label> <input type="text" name="name" value="GOLDMAN SACHS GROUP INC" id="name" class="autocompleteWidget" /> </strong></div><div class="newline"></div> <div class="newline"></div> <div id="last_price" class="col3">Last Price: 166.95</div> <div id="website" class="col3"><a href="http://www.gs.com http://www.gs.com/" target="_blank">www.gs.com</a></div> <div id="google_finance">Latest News: <a href="http://www.google.com/finance?q=GOLDMAN+SACHS+GROUP+INC http://www.google.com/finance?q=GOLDMAN+SACHS+GROUP+INC" target="
Thu Mar 27, 2014 8:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Seemed straight forward (but I do it all the time) - get the tag content,
extract the desired text, convert it into a number. For example:
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.valueexplorer.com/analyzer/company/US38141G1040/","div",-1,"Enterprise
value:"),":","~"))
The others are the same except for the search term.
On Thu, Mar 27, 2014 at 8:28 AM, <patrick.van.beesen@perso.be> wrote:
>
> How can I get data from
> http://www.valueexplorer.com/analyzer/company/US38141G1040/
> I want to retrieve the data in bold, I Try with smfGetTagContent but
> without success
>
> The HTML code
> <div><strong><label for="isin">ISIN:</label><input type="text" name="isin"
> value="US38141G1040" id="isin" class="autocompleteWidget" /></strong>
> </div><div style="width:300px;"><strong><label for="name">Company Name:
> </label><input type="text" name="name" value="GOLDMAN SACHS GROUP INC" id
> ="name" class="autocompleteWidget" /></strong></div><div class="newline">
> </div><div class="newline"></div><div id="last_price" class="col3">Last
> Price: 166.95</div><div id="website" class="col3"><a href="
> http://www.gs.com" target="_blank">www.gs.com</a></div><div id="
> google_finance">Latest News: <a href="
> http://www.google.com/finance?q=GOLDMAN+SACHS+GROUP+INC" target="_blank">Google
> Finance</a></div><div class="newline"></div><div id="country" class="col3
> ">Country: US</div><div id="groupname" class="col3">Group: Banks</div><div
> id="sectorname" class="col3">Sector: Financial</div><div class="newline">
> </div><div id="market_capitalization_in_millions"; class="col3">Market
> Cap. Mio: 75587</div><div id="ev_equity_value" class="col3">Enterprise
> Value: 513609</div><div class="newline"></div><h2>FAIR STOCK VALUE
> ESTIMATES:</h2><div id="upside_normalised_multiple_abs" class="col3">Mean
> Multiple Value: 243.08</div><div id="upside_normalised_profitability_abs"
> class="col3">Graham Intrinsic Value: 215.87</div><div id="
> upside_current_profitability_abs" class="col3">Greenblatt Fair Value:
> 217.54</div><h2>UPSIDE TO FAIR STOCK VALUE (MARGIN-OF-SAFETY):</h2><div id
> ="upside_normalised_multiple" class="col3">Mean Multiple Upside [%]: 45.6
> </div><div id="upside_normalised_profitability" class="col3">Graham
> Upside [%]: 29.3</div><div id="upside_current_profitability" class="col3">Greenblatt
> Upside [%]: 30.3</div>
>
extract the desired text, convert it into a number. For example:
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.valueexplorer.com/analyzer/company/US38141G1040/","div",-1,"Enterprise
value:"),":","~"))
The others are the same except for the search term.
On Thu, Mar 27, 2014 at 8:28 AM, <patrick.van.beesen@perso.be> wrote:
>
> How can I get data from
> http://www.valueexplorer.com/analyzer/company/US38141G1040/
> I want to retrieve the data in bold, I Try with smfGetTagContent but
> without success
>
> The HTML code
> <div><strong><label for="isin">ISIN:</label><input type="text" name="isin"
> value="US38141G1040" id="isin" class="autocompleteWidget" /></strong>
> </div><div style="width:300px;"><strong><label for="name">Company Name:
> </label><input type="text" name="name" value="GOLDMAN SACHS GROUP INC" id
> ="name" class="autocompleteWidget" /></strong></div><div class="newline">
> </div><div class="newline"></div><div id="last_price" class="col3">Last
> Price: 166.95</div><div id="website" class="col3"><a href="
> http://www.gs.com" target="_blank">www.gs.com</a></div><div id="
> google_finance">Latest News: <a href="
> http://www.google.com/finance?q=GOLDMAN+SACHS+GROUP+INC" target="
> Finance</
> ">Country: US</div>
> id="sectorname
> </div>
> Cap. Mio: 75587</div>
> Value: 513609</div>
> ESTIMATES:<
> Multiple Value: 243.08</div>
> class="
> upside_current_
> 217.54</div>
> ="upside_
> </div>
> Upside [%]: 29.3</div>
> Upside [%]: 30.3</div>
>
Thu Mar 27, 2014 10:33 am (PDT) . Posted by:
"Patrick Van Beesen" patrickvb
Thanks Randy,
It works wonderfully.
Patrick
On 3/27/2014 4:46 PM, Randy Harmelink wrote:
> =smfConvertData(smfstrExtr(smfGetTagContent("http://www.valueexplorer.com/analyzer/company/US38141G1040/","div",-1,"Enterprise
> value:"),":","~"))
---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com
It works wonderfully.
Patrick
On 3/27/2014 4:46 PM, Randy Harmelink wrote:
> =smfConvertData(smfstrExtr(smfGetTagContent("http://www.valueexplorer.com/analyzer/company/US38141G1040/","div",-1,"Enterprise
> value:"),":","~"))
---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com
Thu Mar 27, 2014 8:56 am (PDT) . Posted by:
"Nikola Ganev" ganevniko
Hi Randy,
Here is what I get :
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, March 26, 2014 7:31 PM
Subject: Re: [smf_addin] Issue with smfGetAdvFNElement formula
On the machine that's not working, what do you get for:
=RCHGetElementNumber("MMM",5204)
=RCHGetElementNumber("Version")
=RCHGetWebData("http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM", "/exchanges/", 50)
=RCHGetWebData("http://www.advfn.com/exchanges/NYSE/MMM/financials", "/exchanges/", 50)
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/financials?btn=start_date&start_date=11&mode=annual_reports",1,">Year End Date")
=smfGetAdvFNElement("MMM","A",999)
=smfGetAdvFNElement("MMM","A",1,">year end date<")
On Wed, Mar 26, 2014 at 1:55 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
>Sorry to bother again Randy,
>Both of the machines are in USA and when I open the link
>http://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-price
> It doesn't redirect me anywhere, the link opens with www prefix. Can it be something else?
>
Error
Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files\SMF Add-In; 1)
/exchanges/NYSE/MMM/financials?mode=quarterly_repo
/exchanges/NYSE/MMM/financials"><link rel='stylesh
2004/12
Error
Error
Here is what I get :
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, March 26, 2014 7:31 PM
Subject: Re: [smf_addin] Issue with smfGetAdvFNElement formula
On the machine that's not working, what do you get for:
=RCHGetElementNumber("MMM",5204)
=RCHGetElementNumber("Version")
=RCHGetWebData("http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM", "/exchanges/", 50)
=RCHGetWebData("http://www.advfn.com/exchanges/NYSE/MMM/financials", "/exchanges/", 50)
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/financials?btn=start_date&start_date=11&mode=annual_reports",1,">Year End Date")
=smfGetAdvFNElement("MMM","A",999)
=smfGetAdvFNElement("MMM","A",1,">year end date<")
On Wed, Mar 26, 2014 at 1:55 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
>Sorry to bother again Randy,
>Both of the machines are in USA and when I open the link
>http://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-pricehttp://www.advfn.com/exchanges/NYSE/MMM/stock-price
> It doesn't redirect me anywhere, the link opens with www prefix. Can it be something else?
>
Error
Stock Market Functions add-in, Version 2.1.2012.12.
/exchanges/NYSE/
/exchanges/NYSE/
2004/12
Error
Error
Thu Mar 27, 2014 9:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The problem is you have an older version of the add-in on that computer --
2.1.2012.12.29.
I had to make a change to the smfGetAdvFNElement() function in 2013 to
because of AdvFN website changes. From the change log:
*Date* *Routine* *Description* 2013-10-16 smfGetAdvFNElement Changed this
routine to use the new AdvFN web site structure 2013-10-17
smfGetAdvFNElement Additional fix of above change
I did note that as a possible issue earlier:
"Are both machines running the same version of the add-in? I did have to
make changes to the add-in last year to allow AdvFN data retrievals to
continue working."
On Thu, Mar 27, 2014 at 8:53 AM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
> Here is what I get :
>
> Error
> Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program
> Files\SMF Add-In; 1)
> /exchanges/NYSE/MMM/financials?mode=quarterly_repo
> /exchanges/NYSE/MMM/financials"><link rel='stylesh
> 2004/12
> Error
> Error
>
2.1.2012.12.29.
I had to make a change to the smfGetAdvFNElement() function in 2013 to
because of AdvFN website changes. From the change log:
*Date* *Routine* *Description* 2013-10-16 smfGetAdvFNElement Changed this
routine to use the new AdvFN web site structure 2013-10-17
smfGetAdvFNElement Additional fix of above change
I did note that as a possible issue earlier:
"Are both machines running the same version of the add-in? I did have to
make changes to the add-in last year to allow AdvFN data retrievals to
continue working."
On Thu, Mar 27, 2014 at 8:53 AM, Nikola Ganev <ganevniko@yahoo.com> wrote:
>
> Here is what I get :
>
> Error
> Stock Market Functions add-in, Version 2.1.2012.12.
> Files\SMF Add-In; 1)
> /exchanges/NYSE/
> /exchanges/NYSE/
> 2004/12
> Error
> Error
>
Thu Mar 27, 2014 11:00 am (PDT) . Posted by:
jaja3279
Randy, thanks. After reading the thread, I agree that Google is not an acceptable alternative. Which data source do you think is better for historical quotes?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
As I recently mentioned on another thread, because of issues with Google historical quotes, I don't consider them an acceptable alternative to Yahoo. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20792 https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20792
On Wed, Mar 26, 2014 at 1:30 PM, <karerat@... mailto:karerat@...> wrote:
Thank you Randy, I'll check it out. Problems with Yahoo historical quotes continue unresolved. I am having serious doubts about Yahoo as a reliable data provider. It would be nice to have a set of Google APIs that work the same way as smfPricesbyDates and RCHGetYahooHistory. Or a configuration option to send the requests to Google instead of Yahoo could also work. To be honest, I haven't yet looked into the existing Google APIs for quotes, so they may already be there. Just thinking aloud at this point; I'll check them out as soon as I get a chance.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
As I recently mentioned on another thread, because of issues with Google historical quotes, I don't consider them an acceptable alternative to Yahoo. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20792 https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20792
On Wed, Mar 26, 2014 at 1:30 PM, <karerat@
Thank you Randy, I'll check it out. Problems with Yahoo historical quotes continue unresolved. I am having serious doubts about Yahoo as a reliable data provider. It would be nice to have a set of Google APIs that work the same way as smfPricesbyDates and RCHGetYahooHistory. Or a configuration option to send the requests to Google instead of Yahoo could also work. To be honest, I haven't yet looked into the existing Google APIs for quotes, so they may already be there. Just thinking aloud at this point; I'll check them out as soon as I get a chance.
Tidak ada komentar:
Posting Komentar