15 Messages
Digest #3168
Messages
Tue Sep 2, 2014 11:39 am (PDT) . Posted by:
pgh2377
I am trying to get a better understanding of the GetWebData function. I noticed a template for the website dividata.com so I will reference my question for assistance to this site.
If I use the GetWebData function for the following page:
http://www.dividata.com/stock/TXT http://www.dividata.com/stock/TXT
How do I grab the number of years paying? So confused but awesome plugin. Will help me with my research.
If I use the GetWebData function for the following page:
http://www.dividata.com/stock/TXT http://www.dividata.com/stock/TXT
How do I grab the number of years paying? So confused but awesome plugin. Will help me with my research.
Tue Sep 2, 2014 12:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The first thing I would do is look at the source code of the web page. If
you search that source code for "Years Paying", you'd find HTML code
looking like this:
<td class="descrip"><span title="Number of consecutive years a stock has
paid dividends.">Years Paying:</span></td><td class="number">29</td>
So, there are at least three ways to grab the data:
1. RCHGetTableCell()
Because the data is with table tags (i.e. <td> and </td>), you could use:
=RCHGetTableCell("http://www.dividata.com/stock/TXT",1,">Years Paying")
In other words, find the ">Years Paying" string, then go ahead "1" table
cell and extract the data from that table cell. I added the ">" to the
search string because sometimes there may be text that contains "...years
paying..." and I want to prevent that string from being what I find. The
search string are case insensitive, so it doesn't matter whether you use
upper case in them or not.
2. smfGetTagContent()
This is just a more general form of RCHGetTableCell(), but it returns a
text string. So:
=smfConvertData(smfGetTagContent("http://www.dividata.com/stock/TXT","td",1,">Years
Paying"))
Note the only real difference is that I had to tell it I was extracting
data from a table cell (i.e. the "td" parameter). I added the
smfConvertData() function to convert any purely numeric data into a number
instead of leaving it as text.
If you have a version of the add-in after 2014-04-10, you can use a
parameter in the smfGetTagContent() that tells the function to strip out
any embedded HTML code and then do the smfConvertData() function -- those
two things were already automatically done within the RCHGetTableCell()
function.
So, with my version of the add-in, I can just do the above function as:
=smfGetTagContent("http://www.dividata.com/stock/TXT","td",1,">Years
Paying",,,,1)
3. RCHGetWebData()
You can use this function to grab the data, but I usually use it as a
function of last resort because then I have to do all the extraction work
myself. Most often, I use it when I need to extract the data out of
JavaScript code, because it doesn't have any HTML tags to use as delimiters
for extracting the data. In any case, the extraction with this function
could look like:
=smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData("
http://www.dividata.com/stock/TXT",">Years
Paying",100),"<td","</td"),">","~"))
So, I used the ">Years Paying" string to grab 100 characters of data from
the source code of the web page, then used two smfStrExtr() functions to
extract the desired string data, then used the smfConvertData() function to
convert the text string into a number.
------------------------------
So, I would just go with the RCHGetTableCell() function, because it's the
most straight-forward.
Hope that helps...
On Tue, Sep 2, 2014 at 11:39 AM, pgh2377@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I am trying to get a better understanding of the GetWebData function. I
> noticed a template for the website dividata.com so I will reference my
> question for assistance to this site.
>
> If I use the GetWebData function for the following page:
>
> http://www.dividata.com/stock/TXT
>
> How do I grab the number of years paying? So confused but awesome plugin.
> Will help me with my research.
>
you search that source code for "Years Paying", you'd find HTML code
looking like this:
<td class="descrip"><span title="Number of consecutive years a stock has
paid dividends.">Years Paying:</span></td><td class="number">29</td>
So, there are at least three ways to grab the data:
1. RCHGetTableCell()
Because the data is with table tags (i.e. <td> and </td>), you could use:
=RCHGetTableCell("http://www.dividata.com/stock/TXT",1,">Years Paying")
In other words, find the ">Years Paying" string, then go ahead "1" table
cell and extract the data from that table cell. I added the ">" to the
search string because sometimes there may be text that contains "...years
paying..." and I want to prevent that string from being what I find. The
search string are case insensitive, so it doesn't matter whether you use
upper case in them or not.
2. smfGetTagContent()
This is just a more general form of RCHGetTableCell(), but it returns a
text string. So:
=smfConvertData(smfGetTagContent("http://www.dividata.com/stock/TXT","td",1,">Years
Paying"))
Note the only real difference is that I had to tell it I was extracting
data from a table cell (i.e. the "td" parameter). I added the
smfConvertData() function to convert any purely numeric data into a number
instead of leaving it as text.
If you have a version of the add-in after 2014-04-10, you can use a
parameter in the smfGetTagContent() that tells the function to strip out
any embedded HTML code and then do the smfConvertData() function -- those
two things were already automatically done within the RCHGetTableCell()
function.
So, with my version of the add-in, I can just do the above function as:
=smfGetTagContent("http://www.dividata.com/stock/TXT","td",1,">Years
Paying",,,,1)
3. RCHGetWebData()
You can use this function to grab the data, but I usually use it as a
function of last resort because then I have to do all the extraction work
myself. Most often, I use it when I need to extract the data out of
JavaScript code, because it doesn't have any HTML tags to use as delimiters
for extracting the data. In any case, the extraction with this function
could look like:
=smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData("
http://www.dividata.com/stock/TXT",">Years
Paying",100),"<td","</td"),">","~"))
So, I used the ">Years Paying" string to grab 100 characters of data from
the source code of the web page, then used two smfStrExtr() functions to
extract the desired string data, then used the smfConvertData() function to
convert the text string into a number.
------------------------------
So, I would just go with the RCHGetTableCell() function, because it's the
most straight-forward.
Hope that helps...
On Tue, Sep 2, 2014 at 11:39 AM, pgh2377@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I am trying to get a better understanding of the GetWebData function. I
> noticed a template for the website dividata.com so I will reference my
> question for assistance to this site.
>
> If I use the GetWebData function for the following page:
>
> http://www.dividata.com/stock/TXT
>
> How do I grab the number of years paying? So confused but awesome plugin.
> Will help me with my research.
>
Tue Sep 2, 2014 4:35 pm (PDT) . Posted by:
digsupply
Hi again. Thank you for your answer.
I tried several versions of the formula, but they didnt't work. I substituted numbers for "...row...", leaving the dots, and I got the result #VALUE! like this:
=smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/" & Ticker &"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [ ","]"),…2...,"}"),…2...,","),": ","~"),"""","""")
I also tried without the dots:
=smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/" & Ticker &"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [ ","]"),12,"}"),4,","),": ","~"),"""","""")
Anything I am doing wrong?
Another question, I also need to pull the Business Summary from the Yahoo page: http://finance.yahoo.com/q/pr?s=MMM+Profile. http://finance.yahoo.com/q/pr?s=MMM+Profile I tried using the "SMF-Quick-Webpage-Examination" that you recommended, with no success. I'm only asking because I couldn't do it.
Thanks again Robert
I tried several versions of the formula, but they didnt't work. I substituted numbers for "...row...", leaving the dots, and I got the result #VALUE! like this:
=smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/" & Ticker &"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [ ","]"),…2...,"}"),…2...,","),": ","~"),"""","""")
I also tried without the dots:
=smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/" & Ticker &"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [ ","]"),12,"}"),4,","),": ","~"),"""","""")
Anything I am doing wrong?
Another question, I also need to pull the Business Summary from the Yahoo page: http://finance.yahoo.com/q/pr?s=MMM+Profile. http://finance.yahoo.com/q/pr?s=MMM+Profile I tried using the "SMF-Quick-
Thanks again Robert
Tue Sep 2, 2014 5:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Shouldn't keep the dots. Your second formula worked fine for me. That is:
=smfStrExtr(smfStrExtr(smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/" &C5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
","]"),12,"}"),4,","),": ","~"),"""","""")
...returned "11/16/2011" for "MMM" in cell C5.
I did a search on "business summary" of the group message archive and found
this for the business summary:
=smfGetTagContent(" http://finance.yahoo.com/q/pr?s="&C5,"p",1,">Business
Summary")
It still works for me.
On Tue, Sep 2, 2014 at 4:33 PM, picsound@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Hi again. Thank you for your answer.
>
> I tried several versions of the formula, but they didnt't work. I
> substituted numbers for "...row...", leaving the dots, and I got the result
> #VALUE! like this:
>
> =smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("
> http://www.zacks.com/stock/research/" & Ticker
> &"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
> ","]"),…2...,"}"),…2...,","),": ","~"),"""","""")
>
> I also tried without the dots:
>
> =smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("
> http://www.zacks.com/stock/research/" & Ticker
> &"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
> ","]"),12,"}"),4,","),": ","~"),"""","""")
>
> Anything I am doing wrong?
>
> Another question, I also need to pull the Business Summary from the Yahoo
> page: http://finance.yahoo.com/q/pr?s=MMM+Profile.
> <http://finance.yahoo.com/q/pr?s=MMM+Profile> I tried using the
> "SMF-Quick-Webpage-Examination" that you recommended, with no success. I'm
> only asking because I couldn't do it.
>
=smfStrExtr(smfStrExtr(smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/" &C5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
","]"),12,"}"),4,","),": ","~"),"""","""")
...returned "11/16/2011" for "MMM" in cell C5.
I did a search on "business summary" of the group message archive and found
this for the business summary:
=smfGetTagContent(" http://finance.yahoo.com/q/pr?s="&C5,"p",1,">Business
Summary")
It still works for me.
On Tue, Sep 2, 2014 at 4:33 PM, picsound@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Hi again. Thank you for your answer.
>
> I tried several versions of the formula, but they didnt't work. I
> substituted numbers for "...row...", leaving the dots, and I got the result
> #VALUE! like this:
>
> =smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("
> http://www.zacks.com/stock/research/" & Ticker
> &"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
> ","]"),…2...,"}"),…2...,","),": ","~"),"""","""")
>
> I also tried without the dots:
>
> =smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("
> http://www.zacks.com/stock/research/" & Ticker
> &"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
> ","]"),12,"}"),4,","),": ","~"),"""","""")
>
> Anything I am doing wrong?
>
> Another question, I also need to pull the Business Summary from the Yahoo
> page: http://finance.yahoo.com/q/pr?s=MMM+Profile.
> <http://finance.yahoo.com/q/pr?s=MMM+Profile> I tried using the
> "SMF-Quick-
> only asking because I couldn't do it.
>
Tue Sep 2, 2014 7:19 pm (PDT) . Posted by:
digsupply
Unfortunately the second formula doesn't work for me. The result is a blank cell.
Is there anything you think I can do?
I have already deleted the IE cookies, in case anything there could be blocking the Zacks page.
When I deleted them the RCHGetElementNumber started working with Yahoo, which was the topic of a previous conversation:" 26828 Re: RCHGetElementNumber doesn't work with office 2010" Could there be anything else tha could be blocking the Zacks site?
As regards to the Business summary, it works perfectly, thank you.
Is there anything you think I can do?
I have already deleted the IE cookies, in case anything there could be blocking the Zacks page.
When I deleted them the RCHGetElementNumber started working with Yahoo, which was the topic of a previous conversation:
As regards to the Business summary, it works perfectly, thank you.
Tue Sep 2, 2014 8:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Well, let's go to the base function -- what do you get with:
=smfGetTagContent("
http://www.zacks.com/stock/research/SDRL/earnings-announcements","script",-1,"Payable
Date")
I get:
window.app_data_dividends = { columns :
[ { "mDataProp" : "Payable Date" ,
"sTitle" : "Payable Date" , "sClass" :
"alpha" , "sType" : "us_date"
} , {
"mDataProp" : "Amount" , "sTitle" :
"Amount" , "sClass" : "" ,
"sType" : "string" }
, { "mDataProp" : "Announcement
Date" , "sTitle" : "Announcement
Date" , "sClass" :
"align_center" , "sType" :
"us_date" } ,
{ "mDataProp" : "Ex-Div Date" ,
"sTitle" : "Ex-Div Date" , "sClass" :
"alpha" , "sType" : "us_date"
} ] , "data" : [ { "Payable Date" :
"12/31/1969", "Amount" : "$0.88", "Announcement Date" : "12/31/1969",
"Ex-Div Date" : "5/6/2013" } , { "Payable Date" : "6/19/2014", "Amount" :
"$1.00", "Announcement Date" : "5/28/2014", "Ex-Div Date" : "6/10/2014" }
, { "Payable Date" : "3/20/2014", "Amount" : "$0.98", "Announcement Date"
: "2/27/2014", "Ex-Div Date" : "3/5/2014" } , { "Payable Date" :
"12/20/2013", "Amount" : "$0.95", "Announcement Date" : "11/26/2013",
"Ex-Div Date" : "12/3/2013" } , { "Payable Date" : "9/20/2013", "Amount"
: "$0.91", "Announcement Date" : "8/28/2013", "Ex-Div Date" : "9/5/2013" }
, { "Payable Date" : "12/21/2012", "Amount" : "$1.70", "Announcement
Date" : "1/2/2013", "Ex-Div Date" : "12/4/2012" } , { "Payable Date" :
"9/20/2012", "Amount" : "$0.84", "Announcement Date" : "8/28/2012", "Ex-Div
Date" : "9/4/2012" } , { "Payable Date" : "6/7/2012", "Amount" : "$0.82",
"Announcement Date" : "5/16/2012", "Ex-Div Date" : "5/22/2012" } , {
"Payable Date" : "3/23/2012", "Amount" : "$0.80", "Announcement Date" :
"3/1/2012", "Ex-Div Date" : "3/8/2012" } , { "Payable Date" :
"12/21/2011", "Amount" : "$0.76", "Announcement Date" : "12/1/2011",
"Ex-Div Date" : "12/8/2011" } , { "Payable Date" : "9/20/2011", "Amount"
: "$0.75", "Announcement Date" : "8/29/2011", "Ex-Div Date" : "9/6/2011" }
, { "Payable Date" : "6/17/2011", "Amount" : "$0.70", "Announcement Date"
: "5/31/2011", "Ex-Div Date" : "6/6/2011" } , { "Payable Date" :
"3/16/2011", "Amount" : "$0.68", "Announcement Date" : "2/25/2011", "Ex-Div
Date" : "3/2/2011" } , { "Payable Date" : "12/30/2010", "Amount" :
"$0.65", "Announcement Date" : "12/14/2010", "Ex-Div Date" : "12/16/2010" }
, { "Payable Date" : "9/24/2010", "Amount" : "$0.61", "Announcement Date"
: "9/1/2010", "Ex-Div Date" : "9/8/2010" } , { "Payable Date" :
"7/2/2010", "Amount" : "$0.60", "Announcement Date" : "6/8/2010", "Ex-Div
Date" : "6/15/2010" } ] }
Someone else today said that they had trouble accessing Yahoo until they
changed the "http" to "https". This was also a problem for some with
Google. The solution there was the cross-domain fix documented for AdvFN.
If you don't get something with the above formula, try changing the "http"
to "https" and see if that does anything.
On Tue, Sep 2, 2014 at 7:17 PM, picsound@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Unfortunately the second formula doesn't work for me. The result is a
> blank cell.
>
> Is there anything you think I can do?
> I have already deleted the IE cookies, in case anything there could be
> blocking the Zacks page.
> When I deleted them the RCHGetElementNumber started working with Yahoo,
> which was the topic of a previous conversation:" 26828 Re:
> RCHGetElementNumber doesn't work with office 2010" Could there be
> anything else tha could be blocking the Zacks site?
>
=smfGetTagContent("
http://www.zacks.com/stock/research/SDRL/earnings-announcements","script",-1,"Payable
Date")
I get:
window.app_data_dividends = { columns :
[ { "mDataProp" : "Payable Date" ,
"sTitle" : "Payable Date" , "sClass" :
"alpha" , "sType" : "us_date"
} , {
"mDataProp" : "Amount" , "sTitle" :
"Amount" , "sClass" : "" ,
"sType" : "string" }
, { "mDataProp" : "Announcement
Date" , "sTitle" : "Announcement
Date" , "sClass" :
"align_center" , "sType" :
"us_date" } ,
{ "mDataProp" : "Ex-Div Date" ,
"sTitle" : "Ex-Div Date" , "sClass" :
"alpha" , "sType" : "us_date"
} ] , "data" : [ { "Payable Date" :
"12/31/1969", "Amount" : "$0.88", "Announcement Date" : "12/31/1969",
"Ex-Div Date" : "5/6/2013" } , { "Payable Date" : "6/19/2014", "Amount" :
"$1.00", "Announcement Date" : "5/28/2014", "Ex-Div Date" : "6/10/2014" }
, { "Payable Date" : "3/20/2014", "Amount" : "$0.98", "Announcement Date"
: "2/27/2014", "Ex-Div Date" : "3/5/2014" } , { "Payable Date" :
"12/20/2013", "Amount" : "$0.95", "Announcement Date" : "11/26/2013",
"Ex-Div Date" : "12/3/2013" } , { "Payable Date" : "9/20/2013", "Amount"
: "$0.91", "Announcement Date" : "8/28/2013", "Ex-Div Date" : "9/5/2013" }
, { "Payable Date" : "12/21/2012", "Amount" : "$1.70", "Announcement
Date" : "1/2/2013", "Ex-Div Date" : "12/4/2012" } , { "Payable Date" :
"9/20/2012", "Amount" : "$0.84", "Announcement Date" : "8/28/2012", "Ex-Div
Date" : "9/4/2012" } , { "Payable Date" : "6/7/2012", "Amount" : "$0.82",
"Announcement Date" : "5/16/2012", "Ex-Div Date" : "5/22/2012" } , {
"Payable Date" : "3/23/2012", "Amount" : "$0.80", "Announcement Date" :
"3/1/2012", "Ex-Div Date" : "3/8/2012" } , { "Payable Date" :
"12/21/2011", "Amount" : "$0.76", "Announcement Date" : "12/1/2011",
"Ex-Div Date" : "12/8/2011" } , { "Payable Date" : "9/20/2011", "Amount"
: "$0.75", "Announcement Date" : "8/29/2011", "Ex-Div Date" : "9/6/2011" }
, { "Payable Date" : "6/17/2011", "Amount" : "$0.70", "Announcement Date"
: "5/31/2011", "Ex-Div Date" : "6/6/2011" } , { "Payable Date" :
"3/16/2011", "Amount" : "$0.68", "Announcement Date" : "2/25/2011", "Ex-Div
Date" : "3/2/2011" } , { "Payable Date" : "12/30/2010", "Amount" :
"$0.65", "Announcement Date" : "12/14/2010", "Ex-Div Date" : "12/16/2010" }
, { "Payable Date" : "9/24/2010", "Amount" : "$0.61", "Announcement Date"
: "9/1/2010", "Ex-Div Date" : "9/8/2010" } , { "Payable Date" :
"7/2/2010", "Amount" : "$0.60", "Announcement Date" : "6/8/2010", "Ex-Div
Date" : "6/15/2010" } ] }
Someone else today said that they had trouble accessing Yahoo until they
changed the "http" to "https". This was also a problem for some with
Google. The solution there was the cross-domain fix documented for AdvFN.
If you don't get something with the above formula, try changing the "http"
to "https" and see if that does anything.
On Tue, Sep 2, 2014 at 7:17 PM, picsound@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Unfortunately the second formula doesn't work for me. The result is a
> blank cell.
>
> Is there anything you think I can do?
> I have already deleted the IE cookies, in case anything there could be
> blocking the Zacks page.
> When I deleted them the RCHGetElementNumber started working with Yahoo,
> which was the topic of a previous conversation:
> RCHGetElementNumber doesn't work with office 2010" Could there be
> anything else tha could be blocking the Zacks site?
>
Tue Sep 2, 2014 8:29 pm (PDT) . Posted by:
digsupply
=smfGetTagContent("http://www.zacks.com/stock/research/SDRL/earnings-announcements http://www.zacks.com/stock/research/SDRL/earnings-announcements","script",-1,"Payable Date")
The result is the same
window.app_data_dividends = { columns : [ { "mDataProp" : "Payable Date" , "sTitle" : "Payable Date" , "sClass" : "alpha" , "sType" : "us_date" } , { "mDataProp" : "Amount" , "sTitle" : "Amount" , "sClass" : "" , "sType" : "string" } , { "mDataProp" : "Announcement Date" , "sTitle" : "Announcement Date" , "sClass" : "align_center" , "sType" : "us_date" } , { "mDataProp" : "Ex-Div Date" , "sTitle" : "Ex-Div Date" , "sClass" : "alpha" , "sType" : "us_date" } ] , "data" : [ { "Payable Date" : "12/31/1969", "Amount" : "$0.88", "Announcement Date" : "12/31/1969", "Ex-Div Date" : "5/6/2013"; } , { "Payable Date" : "6/19/2014", "Amount" : "$1.00", "Announcement Date" : "5/28/2014", "Ex-Div Date" : "6/10/2014" } , { "Payable Date" : "3/20/2014", "Amount" : "$0.98", "Announcement Date" : "2/27/2014", "Ex-Div Date" : "3/5/2014"; } , { "Payable Date" : "12/20/2013", "Amount" : "$0.95", "Announcement Date" : "11/26/2013", "Ex-Div Date" : "12/3/2013" } , { "Payable Date" : "9/20/2013", "Amount" : "$0.91", "Announcement Date" : "8/28/2013", "Ex-Div Date" : "9/5/2013"; } , { "Payable Date" : "12/21/2012", "Amount" : "$1.70", "Announcement Date" : "1/2/2013";, "Ex-Div Date" : "12/4/2012" } , { "Payable Date" : "9/20/2012", "Amount" : "$0.84", "Announcement Date" : "8/28/2012", "Ex-Div Date" : "9/4/2012"; } , { "Payable Date" : "6/7/2012";, "Amount" : "$0.82", "Announcement Date" : "5/16/2012", "Ex-Div Date" : "5/22/2012" } , { "Payable Date" : "3/23/2012", "Amount" : "$0.80", "Announcement Date" : "3/1/2012";, "Ex-Div Date" : "3/8/2012"; } , { "Payable Date" : "12/21/2011", "Amount" : "$0.76", "Announcement Date" : "12/1/2011", "Ex-Div Date" : "12/8/2011" } , { "Payable Date" : "9/20/2011", "Amount" : "$0.75", "Announcement Date" : "8/29/2011", "Ex-Div Date" : "9/6/2011"; } , { "Payable Date" : "6/17/2011", "Amount" : "$0.70", "Announcement Date" : "5/31/2011", "Ex-Div Date" : "6/6/2011"; } , { "Payable Date" : "3/16/2011", "Amount" : "$0.68", "Announcement Date" : "2/25/2011", "Ex-Div Date" : "3/2/2011"; } , { "Payable Date" : "12/30/2010", "Amount" : "$0.65", "Announcement Date" : "12/14/2010", "Ex-Div Date" : "12/16/2010" } , { "Payable Date" : "9/24/2010", "Amount" : "$0.61", "Announcement Date" : "9/1/2010";, "Ex-Div Date" : "9/8/2010"; } , { "Payable Date" : "7/2/2010";, "Amount" : "$0.60", "Announcement Date" : "6/8/2010";, "Ex-Div Date" : "6/15/2010" } ] }
The result is the same
window.app_data_
Tue Sep 2, 2014 9:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. OK, then let's go step-by-step through the various functions in that
formula and see where it fails. At what point to you start getting blanks
returned (using ticker symbol MMM in cell C5):
------------------------------
Step 1:
=smfStrExtr(smfGetTagContent("http://www.zacks.com/stock/research/" &$C$5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [ ","]")
gives me the whole set of data:
{ "Payable Date" : "9/12/2014", "Amount" : "$0.86", "Announcement Date" :
"8/12/2014", "Ex-Div Date" : "8/20/2014" } , { "Payable Date" :
"6/12/2014", "Amount" : "$0.86", "Announcement Date" : "5/13/2014", "Ex-Div
Date" : "5/21/2014" } , { "Payable Date" : "3/12/2014", "Amount" :
"$0.86", "Announcement Date" : "12/17/2013", "Ex-Div Date" : "2/12/2014" }
, { "Payable Date" : "12/12/2013", "Amount" : "$0.64", "Announcement
Date" : "11/12/2013", "Ex-Div Date" : "11/20/2013" } , { "Payable Date" :
"9/12/2013", "Amount" : "$0.64", "Announcement Date" : "8/14/2013", "Ex-Div
Date" : "8/21/2013" } , { "Payable Date" : "6/12/2013", "Amount" :
"$0.64", "Announcement Date" : "5/15/2013", "Ex-Div Date" : "5/22/2013" }
, { "Payable Date" : "3/12/2013", "Amount" : "$0.64", "Announcement Date"
: "2/5/2013", "Ex-Div Date" : "2/13/2013" } , { "Payable Date" :
"12/12/2012", "Amount" : "$0.59", "Announcement Date" : "11/13/2012",
"Ex-Div Date" : "11/20/2012" } , { "Payable Date" : "9/12/2012", "Amount"
: "$0.59", "Announcement Date" : "9/7/2012", "Ex-Div Date" : "8/22/2012" }
, { "Payable Date" : "6/12/2012", "Amount" : "$0.59", "Announcement Date"
: "5/9/2012", "Ex-Div Date" : "5/16/2012" } , { "Payable Date" :
"3/12/2012", "Amount" : "$0.59", "Announcement Date" : "2/9/2012", "Ex-Div
Date" : "2/15/2012" } , { "Payable Date" : "12/12/2011", "Amount" :
"$0.55", "Announcement Date" : "11/16/2011", "Ex-Div Date" : "11/22/2011" }
, { "Payable Date" : "9/12/2011", "Amount" : "$0.55", "Announcement Date"
: "8/10/2011", "Ex-Div Date" : "8/17/2011" } , { "Payable Date" :
"6/12/2011", "Amount" : "$0.55", "Announcement Date" : "5/12/2011", "Ex-Div
Date" : "5/18/2011" } , { "Payable Date" : "3/12/2011", "Amount" :
"$0.55", "Announcement Date" : "2/10/2011", "Ex-Div Date" : "2/16/2011" }
, { "Payable Date" : "12/12/2010", "Amount" : "$0.53", "Announcement
Date" : "11/9/2010", "Ex-Div Date" : "11/17/2010" } , { "Payable Date" :
"9/12/2010", "Amount" : "$0.53", "Announcement Date" : "8/11/2010", "Ex-Div
Date" : "8/18/2010" } , { "Payable Date" : "6/12/2010", "Amount" :
"$0.53", "Announcement Date" : "5/13/2010", "Ex-Div Date" : "5/19/2010" }
, { "Payable Date" : "3/12/2010", "Amount" : "$0.53", "Announcement Date"
: "2/11/2010", "Ex-Div Date" : "2/17/2010" } , { "Payable Date" :
"12/12/2009", "Amount" : "$0.51", "Announcement Date" : "11/11/2009",
"Ex-Div Date" : "11/18/2009" } , { "Payable Date" : "9/12/2009", "Amount"
: "$0.51", "Announcement Date" : "8/12/2009", "Ex-Div Date" : "8/19/2009" }
, { "Payable Date" : "6/12/2009", "Amount" : "$0.51", "Announcement Date"
: "5/14/2009", "Ex-Div Date" : "5/20/2009" }
------------------------------
Step 2:
=smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/"&$C$5&"/earnings-announcements","script",-1,"Payable
Date"),"""data"" : [ ","]"),12,"}")
...gives me the 12th line of data:
, { "Payable Date" : "12/12/2011", "Amount" : "$0.55", "Announcement
Date" : "11/16/2011", "Ex-Div Date" : "11/22/2011"
------------------------------
Step 3:
=smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/" &$C$5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
","]"),12,"}"),4,",")
...gives me the 4th item in that 12th line of data:
"Announcement Date" : "11/16/2011"
------------------------------
Step 4:
=smfStrExtr(smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/" &$C$5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
","]"),12,"}"),4,","),": ","~")
...gives me the data portion of that:
"11/16/2011"
------------------------------
Step 5 (end result):
=smfStrExtr(smfStrExtr(smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/" &$C$5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
","]"),12,"}"),4,","),": ","~"),"""","""")
...gives me the end result of just the date:
11/16/2011
------------------------------
On Tue, Sep 2, 2014 at 8:29 PM, picsound@... wrote:
> =smfGetTagContent("
> http://www.zacks.com/stock/research/SDRL/earnings-announcements
> http://www.zacks.com/stock/research/SDRL/earnings-announcements","script",-1,"Payable
> Date")
>
> The result is the same
>
> window.app_data_dividends = { columns : [
> { "mDataProp" : "Payable Date" , "sTitle"
> : "Payable Date" , "sClass" : "alpha"
> , "sType" : "us_date" }
> , { "mDataProp" : "Amount"
> , "sTitle" : "Amount" , "sClass" :
> "" , "sType" : "string" }
> , { "mDataProp" :
> "Announcement Date" , "sTitle" : "Announcement
> Date" , "sClass" : "align_center"
> , "sType" : "us_date" } ,
> { "mDataProp" : "Ex-Div Date"
> , "sTitle" : "Ex-Div Date" , "sClass"
> : "alpha" , "sType" : "us_date"
> } ] , "data" : [ { "Payable Date" :
> "12/31/1969", "Amount" : "$0.88", "Announcement Date" : "12/31/1969",
> "Ex-Div Date" : "5/6/2013"; } , { "Payable Date" : "6/19/2014", "Amount" :
> "$1.00", "Announcement Date" : "5/28/2014", "Ex-Div Date" : "6/10/2014" }
> , { "Payable Date" : "3/20/2014", "Amount" : "$0.98", "Announcement Date"
> : "2/27/2014", "Ex-Div Date" : "3/5/2014"; } , { "Payable Date" :
> "12/20/2013", "Amount" : "$0.95", "Announcement Date" : "11/26/2013",
> "Ex-Div Date" : "12/3/2013" } , { "Payable Date" : "9/20/2013", "Amount"
> : "$0.91", "Announcement Date" : "8/28/2013", "Ex-Div Date" : "9/5/2013"; }
> , { "Payable Date" : "12/21/2012", "Amount" : "$1.70", "Announcement
> Date" : "1/2/2013";, "Ex-Div Date" : "12/4/2012" } , { "Payable Date" :
> "9/20/2012", "Amount" : "$0.84", "Announcement Date" : "8/28/2012", "Ex-Div
> Date" : "9/4/2012"; } , { "Payable Date" : "6/7/2012";, "Amount" : "$0.82",
> "Announcement Date" : "5/16/2012", "Ex-Div Date" : "5/22/2012" } , {
> "Payable Date" : "3/23/2012", "Amount" : "$0.80", "Announcement Date" :
> "3/1/2012";, "Ex-Div Date" : "3/8/2012"; } , { "Payable Date" :
> "12/21/2011", "Amount" : "$0.76", "Announcement Date" : "12/1/2011",
> "Ex-Div Date" : "12/8/2011" } , { "Payable Date" : "9/20/2011", "Amount"
> : "$0.75", "Announcement Date" : "8/29/2011", "Ex-Div Date" : "9/6/2011"; }
> , { "Payable Date" : "6/17/2011", "Amount" : "$0.70", "Announcement Date"
> : "5/31/2011", "Ex-Div Date" : "6/6/2011"; } , { "Payable Date" :
> "3/16/2011", "Amount" : "$0.68", "Announcement Date" : "2/25/2011", "Ex-Div
> Date" : "3/2/2011"; } , { "Payable Date" : "12/30/2010", "Amount" :
> "$0.65", "Announcement Date" : "12/14/2010", "Ex-Div Date" : "12/16/2010" }
> , { "Payable Date" : "9/24/2010", "Amount" : "$0.61", "Announcement Date"
> : "9/1/2010";, "Ex-Div Date" : "9/8/2010"; } , { "Payable Date" :
> "7/2/2010";, "Amount" : "$0.60", "Announcement Date" : "6/8/2010";, "Ex-Div
> Date" : "6/15/2010" } ] }
>
formula and see where it fails. At what point to you start getting blanks
returned (using ticker symbol MMM in cell C5):
------------------------------
Step 1:
=smfStrExtr(smfGetTagContent("http://www.zacks.com/stock/research/" &$C$5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [ ","]")
gives me the whole set of data:
{ "Payable Date" : "9/12/2014", "Amount" : "$0.86", "Announcement Date" :
"8/12/2014", "Ex-Div Date" : "8/20/2014" } , { "Payable Date" :
"6/12/2014", "Amount" : "$0.86", "Announcement Date" : "5/13/2014", "Ex-Div
Date" : "5/21/2014" } , { "Payable Date" : "3/12/2014", "Amount" :
"$0.86", "Announcement Date" : "12/17/2013", "Ex-Div Date" : "2/12/2014" }
, { "Payable Date" : "12/12/2013", "Amount" : "$0.64", "Announcement
Date" : "11/12/2013", "Ex-Div Date" : "11/20/2013" } , { "Payable Date" :
"9/12/2013", "Amount" : "$0.64", "Announcement Date" : "8/14/2013", "Ex-Div
Date" : "8/21/2013" } , { "Payable Date" : "6/12/2013", "Amount" :
"$0.64", "Announcement Date" : "5/15/2013", "Ex-Div Date" : "5/22/2013" }
, { "Payable Date" : "3/12/2013", "Amount" : "$0.64", "Announcement Date"
: "2/5/2013", "Ex-Div Date" : "2/13/2013" } , { "Payable Date" :
"12/12/2012", "Amount" : "$0.59", "Announcement Date" : "11/13/2012",
"Ex-Div Date" : "11/20/2012" } , { "Payable Date" : "9/12/2012", "Amount"
: "$0.59", "Announcement Date" : "9/7/2012", "Ex-Div Date" : "8/22/2012" }
, { "Payable Date" : "6/12/2012", "Amount" : "$0.59", "Announcement Date"
: "5/9/2012", "Ex-Div Date" : "5/16/2012" } , { "Payable Date" :
"3/12/2012", "Amount" : "$0.59", "Announcement Date" : "2/9/2012", "Ex-Div
Date" : "2/15/2012" } , { "Payable Date" : "12/12/2011", "Amount" :
"$0.55", "Announcement Date" : "11/16/2011", "Ex-Div Date" : "11/22/2011" }
, { "Payable Date" : "9/12/2011", "Amount" : "$0.55", "Announcement Date"
: "8/10/2011", "Ex-Div Date" : "8/17/2011" } , { "Payable Date" :
"6/12/2011", "Amount" : "$0.55", "Announcement Date" : "5/12/2011", "Ex-Div
Date" : "5/18/2011" } , { "Payable Date" : "3/12/2011", "Amount" :
"$0.55", "Announcement Date" : "2/10/2011", "Ex-Div Date" : "2/16/2011" }
, { "Payable Date" : "12/12/2010", "Amount" : "$0.53", "Announcement
Date" : "11/9/2010", "Ex-Div Date" : "11/17/2010" } , { "Payable Date" :
"9/12/2010", "Amount" : "$0.53", "Announcement Date" : "8/11/2010", "Ex-Div
Date" : "8/18/2010" } , { "Payable Date" : "6/12/2010", "Amount" :
"$0.53", "Announcement Date" : "5/13/2010", "Ex-Div Date" : "5/19/2010" }
, { "Payable Date" : "3/12/2010", "Amount" : "$0.53", "Announcement Date"
: "2/11/2010", "Ex-Div Date" : "2/17/2010" } , { "Payable Date" :
"12/12/2009", "Amount" : "$0.51", "Announcement Date" : "11/11/2009",
"Ex-Div Date" : "11/18/2009" } , { "Payable Date" : "9/12/2009", "Amount"
: "$0.51", "Announcement Date" : "8/12/2009", "Ex-Div Date" : "8/19/2009" }
, { "Payable Date" : "6/12/2009", "Amount" : "$0.51", "Announcement Date"
: "5/14/2009", "Ex-Div Date" : "5/20/2009" }
------------------------------
Step 2:
=smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/"&$C$5&"/earnings-announcements","script",-1,"Payable
Date"),"""data"" : [ ","]"),12,"}")
...gives me the 12th line of data:
, { "Payable Date" : "12/12/2011", "Amount" : "$0.55", "Announcement
Date" : "11/16/2011", "Ex-Div Date" : "11/22/2011"
------------------------------
Step 3:
=smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/" &$C$5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
","]"),12,"}"),4,",")
...gives me the 4th item in that 12th line of data:
"Announcement Date" : "11/16/2011"
------------------------------
Step 4:
=smfStrExtr(smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/" &$C$5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
","]"),12,"}"),4,","),": ","~")
...gives me the data portion of that:
"11/16/2011"
------------------------------
Step 5 (end result):
=smfStrExtr(smfStrExtr(smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/" &$C$5
&"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [
","]"),12,"}"),4,","),": ","~"),"""","""")
...gives me the end result of just the date:
11/16/2011
------------------------------
On Tue, Sep 2, 2014 at 8:29 PM, picsound@... wrote:
> =smfGetTagContent("
> http://www.zacks.com/stock/research/SDRL/earnings-announcements
> http://www.zacks.com/stock/research/SDRL/earnings-announcements","
> Date")
>
> The result is the same
>
> window.app_data_
> { "mDataProp&quo
> : "Payable Date" , "sClass" : "alpha"
> , "sType" : "us_date" }
> , { "mDataProp&quo
> , "sTitle" : "Amount" , "sClass" :
> "" , "sType" : "string" }
> , { "mDataProp&quo
> "Announcement Date" , "sTitle" : "Announcement
> Date" , "sClass" : "align_
> , "sType" : "us_date" } ,
> { "mDataProp&quo
> , "sTitle" : "Ex-Div Date" , "sClass"
> : "alpha" , "sType" : "us_date"
> } ] , "data" : [ { "Payable Date" :
> "12/31/
> "Ex-Div Date" : "5/6/2013"
> "$1.00"
> , { "Payable Date" : "3/20/2014&quo
> : "2/27/2014&quo
> "12/20/
> "Ex-Div Date" : "12/3/2013&quo
> : "$0.91"
> , { "Payable Date" : "12/21/
> Date" : "1/2/2013"
> "9/20/2012&quo
> Date" : "9/4/2012"
> "Announcement Date" : "5/16/2012&quo
> "Payable Date" : "3/23/2012&quo
> "3/1/2012"
> "12/21/
> "Ex-Div Date" : "12/8/2011&quo
> : "$0.75"
> , { "Payable Date" : "6/17/2011&quo
> : "5/31/2011&quo
> "3/16/2011&quo
> Date" : "3/2/2011"
> "$0.65"
> , { "Payable Date" : "9/24/2010&quo
> : "9/1/2010"
> "7/2/2010"
> Date" : "6/15/2010&quo
>
Tue Sep 2, 2014 9:48 pm (PDT) . Posted by:
tarakayan
I use Windows 8.1 and Excel 2013….all my templates with RCH functions mainly yahoo are working well.
I tried the following in one of the cells, but says unable to open www.zacks.com…and blank in the step 1….I have the latest RCH files and updates.
Sent from Windows Mail
From: 'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin]
Sent: Wednesday, 03 September 2014 09:29
To: 'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin]
Hmmm. OK, then let's go step-by-step through the various functions in that formula and see where it fails. At what point to you start getting blanks returned (using ticker symbol MMM in cell C5):
Step 1:
=smfStrExtr(smfGetTagContent("http://www.zacks.com/stock/research/" &$C$5 &"/earnings-announcements","script",-1,"Payable Date"),"""data"" : [ ","]")
I tried the following in one of the cells, but says unable to open www.zacks.com…and blank in the step 1….I have the latest RCH files and updates.
Sent from Windows Mail
From: 'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin]
Sent: Wednesday, 03 September 2014 09:29
To: 'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin]
Hmmm. OK, then let's go step-by-step through the various functions in that formula and see where it fails. At what point to you start getting blanks returned (using ticker symbol MMM in cell C5):
Step 1:
=smfStrExtr(smfGetTagContent("http://www.zacks.com/stock/research/" &$C$5 &"/earnings-
Tue Sep 2, 2014 9:54 pm (PDT) . Posted by:
digsupply
this is the vba function in module "modutilities"
Function smfStrExtr(pString As String, pStart As String, pEnd As String)
'----------------------------------------------------------*
' 2010.01.22 -- Add function
' 2010.06.06 -- Add error checking
' 2011.07.12 -- Add dummy characters to represent start and end of input string
'----------------------------------------------------------*
If pStart = "~" Then
iPos1 = 1
iPos3 = 2
Else
iPos1 = InStr(pString, pStart) + Len(pStart)
iPos3 = iPos1
If iPos1 = Len(pStart) Then
smfStrExtr = ""
Exit Function
End If
End If
If pEnd = "~" Then iPos2 = Len(pString) + 1 Else iPos2 = InStr(iPos3, pString, pEnd)
If iPos2 = 0 Then
smfStrExtr = ""
Exit Function
End If
smfStrExtr = Mid(pString, iPos1, iPos2 - iPos1)
End Function
Function smfStrExtr(pString As String, pStart As String, pEnd As String)
'-------
' 2010.01.22 -- Add function
' 2010.06.06 -- Add error checking
' 2011.07.12 -- Add dummy characters to represent start and end of input string
'-------
If pStart = "~" Then
iPos1 = 1
iPos3 = 2
Else
iPos1 = InStr(pString, pStart) + Len(pStart)
iPos3 = iPos1
If iPos1 = Len(pStart) Then
smfStrExtr = ""
Exit Function
End If
End If
If pEnd = "~" Then iPos2 = Len(pString) + 1 Else iPos2 = InStr(iPos3, pString, pEnd)
If iPos2 = 0 Then
smfStrExtr = ""
Exit Function
End If
smfStrExtr = Mid(pString, iPos1, iPos2 - iPos1)
End Function
Tue Sep 2, 2014 4:55 pm (PDT) . Posted by:
iowatrader2
Just in case there is someone else like me who is too cheap to upgrade from Excel 2003. I was not able to retrieve data from Yahoo when I changed to Windows 8.1 (it worked fine in XP). I solution I found was to change all the 'http' addresses in the smf-elements-2.txt file to 'https' This change seems to work in both XP and in Windows 8.1. There may be other work arounds, but this worked for me.
Tue Sep 2, 2014 5:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When "http" vs "https" redirection was an issue for Google, applying the
cross-domains fix needed for AdvFN solved the problem:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/10464
On Tue, Sep 2, 2014 at 3:30 PM, lnbjohnson@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Just in case there is someone else like me who is too cheap to upgrade
> from Excel 2003. I was not able to retrieve data from Yahoo when I changed
> to Windows 8.1 (it worked fine in XP). I solution I found was to change all
> the 'http' addresses in the smf-elements-2.txt file to 'https' This change
> seems to work in both XP and in Windows 8.1. There may be other work
> arounds, but this worked for me.
>
cross-domains fix needed for AdvFN solved the problem:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/10464
On Tue, Sep 2, 2014 at 3:30 PM, lnbjohnson@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Just in case there is someone else like me who is too cheap to upgrade
> from Excel 2003. I was not able to retrieve data from Yahoo when I changed
> to Windows 8.1 (it worked fine in XP). I solution I found was to change all
> the 'http' addresses in the smf-elements-
> seems to work in both XP and in Windows 8.1. There may be other work
> arounds, but this worked for me.
>
Tue Sep 2, 2014 7:12 pm (PDT) . Posted by:
"Douglas Haas" mdouglashaas
Randy,
Is it possible to add the following data items:
Beta (RCHGetElementNumber = 24), Strong Buy (RCHGetElementNumber = 362),
Hold (RCHGetElementNumber = 370), Sell (RCHGetElementNumber = 378), to the
RCHGetYahooQuotes() function in order get these four data items for 100 or
so stocks.
If so, I would plan to use the RCHGetYahooQoutes() function as an array
entered formula to get the data more efficiently than using 400 separate
entries of RCHGetElementNumber().
My main focus is obtaining these four data items for 100 or so stocks in a
minimum of time and in the most efficient manner. If you have an alternative
suggestion, it would be appreciated.
Many thanks for your dedication and knowledge with respect to this Addin. It
is simply Super!
Douglas Haas
douglashaas4974@earthlink.net <mailto:douglashaas4974@earthlink.net>
Is it possible to add the following data items:
Beta (RCHGetElementNumber = 24), Strong Buy (RCHGetElementNumber = 362),
Hold (RCHGetElementNumber = 370), Sell (RCHGetElementNumber = 378), to the
RCHGetYahooQuotes() function in order get these four data items for 100 or
so stocks.
If so, I would plan to use the RCHGetYahooQoutes() function as an array
entered formula to get the data more efficiently than using 400 separate
entries of RCHGetElementNumber().
My main focus is obtaining these four data items for 100 or so stocks in a
minimum of time and in the most efficient manner. If you have an alternative
suggestion, it would be appreciated.
Many thanks for your dedication and knowledge with respect to this Addin. It
is simply Super!
Douglas Haas
douglashaas4974@earthlink.net <mailto:douglashaas4974@earthlink.net>
Tue Sep 2, 2014 8:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but it's not possible for me to add data items to
RCHGetYahooQuotes(). It is retrieving a data file from Yahoo, and parsing
the data out of that returned file. Yahoo defines what data elements can be
requested to be put onto the file.
That's the reason an array-entered RCHGetYahooQuotes() is so much faster --
all of the data can be requested in one Internet access, and Yahoo returns
the file with the requested data.
One workaround is to get the data from Zacks screener. For example, if you
set a criteria like "Price > 5", you'll get about 7000 stocks. Then add the
fields you want to see on the output file and export the CSV file. Then,
you can do VLOOKUP() functions on that returned data to grab the data you
want for your 100 companies. This is what a sample file might look like:
Company Name Ticker Beta Current Avg Broker Rec Last Close # Rating Strong
Buy or Buy # Rating Hold # Rating Strong Sell or Sell Average Target
Price AGILENT
TECH A 1.64 1.22 57.16 8 1 0 64 ALCOA INC AA 1.74 2.23 16.61 7 7 1 15.6 AAC
TECH HLDGS AACAY 0.61 4 61.96 0 0 1
On Tue, Sep 2, 2014 at 7:12 PM, 'Douglas Haas' douglashaas4974@... wrote:
>
> Is it possible to add the following data items:
>
> Beta (RCHGetElementNumber = 24), Strong Buy (RCHGetElementNumber = 362),
> Hold (RCHGetElementNumber = 370), Sell (RCHGetElementNumber = 378), to the
> RCHGetYahooQuotes() function in order get these four data items for 100 or
> so stocks.
>
> If so, I would plan to use the RCHGetYahooQoutes() function as an array
> entered formula to get the data more efficiently than using 400 separate
> entries of RCHGetElementNumber().
>
> My main focus is obtaining these four data items for 100 or so stocks in a
> minimum of time and in the most efficient manner. If you have an
> alternative suggestion, it would be appreciated.
>
> Many thanks for your dedication and knowledge with respect to this Addin.
> It is simply Super!
>
>
>
RCHGetYahooQuotes(
the data out of that returned file. Yahoo defines what data elements can be
requested to be put onto the file.
That's the reason an array-entered RCHGetYahooQuotes(
all of the data can be requested in one Internet access, and Yahoo returns
the file with the requested data.
One workaround is to get the data from Zacks screener. For example, if you
set a criteria like "Price > 5", you'll get about 7000 stocks. Then add the
fields you want to see on the output file and export the CSV file. Then,
you can do VLOOKUP() functions on that returned data to grab the data you
want for your 100 companies. This is what a sample file might look like:
Company Name Ticker Beta Current Avg Broker Rec Last Close # Rating Strong
Buy or Buy # Rating Hold # Rating Strong Sell or Sell Average Target
Price AGILENT
TECH A 1.64 1.22 57.16 8 1 0 64 ALCOA INC AA 1.74 2.23 16.61 7 7 1 15.6 AAC
TECH HLDGS AACAY 0.61 4 61.96 0 0 1
On Tue, Sep 2, 2014 at 7:12 PM, 'Douglas Haas' douglashaas4974@
>
> Is it possible to add the following data items:
>
> Beta (RCHGetElementNumbe
> Hold (RCHGetElementNumbe
> RCHGetYahooQuotes(
> so stocks.
>
> If so, I would plan to use the RCHGetYahooQoutes(
> entered formula to get the data more efficiently than using 400 separate
> entries of RCHGetElementNumber
>
> My main focus is obtaining these four data items for 100 or so stocks in a
> minimum of time and in the most efficient manner. If you have an
> alternative suggestion, it would be appreciated.
>
> Many thanks for your dedication and knowledge with respect to this Addin.
> It is simply Super!
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar