12 New Messages
Digest #2474
Messages
Sun Jan 20, 2013 11:58 am (PST) . Posted by:
"iamruf" iamruf
Hi Randy,
The page/site below provides coverage of Canadian Mutual Funds.
The page provides Quote info plus Risk Rating & Statistics.
From the Quote section, I would like to retrieve NAV, MER, 52-Week Range, Category.
From the Risk & Rating Statistics section I would like to retrieve Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g. 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
Is it possible to retrieve this data?
If so, what is the best formula/way?
Best Regards & thanks for all you do!
http://quote.morningstar.ca/QuickTakes/fund/riskrating.aspx?t=AIM24873®ion=CAN&culture=en-CA
The page/site below provides coverage of Canadian Mutual Funds.
The page provides Quote info plus Risk Rating & Statistics.
From the Quote section, I would like to retrieve NAV, MER, 52-Week Range, Category.
From the Risk & Rating Statistics section I would like to retrieve Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g. 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
Is it possible to retrieve this data?
If so, what is the best formula/way?
Best Regards & thanks for all you do!
http://quote.
Sun Jan 20, 2013 1:13 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, that web page is generated dynamically. The source data for
the web page is in other web pages:
http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE
http://performance.morningstar.com/RatingRiskHtml/fund/mpt-statistics.action?symbol=F0CAN070P4
http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4
http://performance.morningstar.com/RatingRiskHtml/fund/volatility-measurements.action?symbol=F0CAN070P4
On Sun, Jan 20, 2013 at 12:58 PM, iamruf iamruf@yahoo.com > wrote:
> Hi Randy,
> The page/site below provides coverage of Canadian Mutual Funds.
> The page provides Quote info plus Risk Rating & Statistics.
> From the Quote section, I would like to retrieve NAV, MER, 52-Week Range,
> Category.
> From the Risk & Rating Statistics section I would like to retrieve
> Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g.
> 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
> Is it possible to retrieve this data?
> If so, what is the best formula/way?
> Best Regards & thanks for all you do!
>
> http://quote.morningstar.ca/QuickTakes/fund/riskrating.aspx?t=AIM24873®ion=CAN&culture=en-CA
>
the web page is in other web pages:
http://globalquote.
http://performance.
http://performance.
http://performance.
On Sun, Jan 20, 2013 at 12:58 PM, iamruf iamruf@yahoo.
> Hi Randy,
> The page/site below provides coverage of Canadian Mutual Funds.
> The page provides Quote info plus Risk Rating & Statistics.
> From the Quote section, I would like to retrieve NAV, MER, 52-Week Range,
> Category.
> From the Risk & Rating Statistics section I would like to retrieve
> Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g.
> 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
> Is it possible to retrieve this data?
> If so, what is the best formula/way?
> Best Regards & thanks for all you do!
>
> http://quote.
>
Sun Jan 20, 2013 3:49 pm (PST) . Posted by:
"Undisclosed" iamruf
Hi Randy,
Can you supply me with a sample =smfGetTagContent or other statement for these?
Thanks
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, January 20, 2013 4:13 PM
Subject: Re: [smf_addin] Morningstar Canada
Unfortunately, that web page is generated dynamically. The source data for the web page is in other web pages:
http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE
http://performance.morningstar.com/RatingRiskHtml/fund/mpt-statistics.action?symbol=F0CAN070P4
http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4
http://performance.morningstar.com/RatingRiskHtml/fund/volatility-measurements.action?symbol=F0CAN070P4
On Sun, Jan 20, 2013 at 12:58 PM, iamruf iamruf@yahoo.com > wrote:
Hi Randy,
>The page/site below provides coverage of Canadian Mutual Funds.
>The page provides Quote info plus Risk Rating & Statistics.
>From the Quote section, I would like to retrieve NAV, MER, 52-Week Range, Category.
>From the Risk & Rating Statistics section I would like to retrieve Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g. 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
>Is it possible to retrieve this data?
>If so, what is the best formula/way?
>Best Regards & thanks for all you do!
>http://quote.morningstar.ca/QuickTakes/fund/riskrating.aspx?t=AIM24873®ion=CAN&culture=en-CA
>
Can you supply me with a sample =smfGetTagContent or other statement for these?
Thanks
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Sunday, January 20, 2013 4:13 PM
Subject: Re: [smf_addin] Morningstar Canada
Unfortunately, that web page is generated dynamically. The source data for the web page is in other web pages:
http://globalquote.
http://performance.
http://performance.
http://performance.
On Sun, Jan 20, 2013 at 12:58 PM, iamruf iamruf@yahoo.
Hi Randy,
>The page/site below provides coverage of Canadian Mutual Funds.
>The page provides Quote info plus Risk Rating & Statistics.
>From the Quote section, I would like to retrieve NAV, MER, 52-Week Range, Category.
>From the Risk & Rating Statistics section I would like to retrieve Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g. 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
>Is it possible to retrieve this data?
>If so, what is the best formula/way?
>Best Regards & thanks for all you do!
>http://quote.
>
Sun Jan 20, 2013 4:22 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
NAV would be:
=0+smfStrExtr(RCHGetWebData("
http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE
","vkey:"),"NAV:""","""")
3-Year MorningStar Return would be:
=RCHGetTableCell("
http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4 ",2,">Morningstar
Return",,,,2,"
http://quote.morningstar.ca/QuickTakes/fund/riskrating.aspx?t=AIM24873 ","symbol
= "),"""","""")
On Sun, Jan 20, 2013 at 4:49 PM, Undisclosed iamruf@yahoo.com > wrote:
> Can you supply me with a sample =smfGetTagContent or other statement for
> these?
>
> ------------------------------
> *From:* Randy Harmelink rharmelink@gmail.com >
> *To:* smf_addin@yahoogroups.com
> *Sent:* Sunday, January 20, 2013 4:13 PM
> *Subject:* Re: [smf_addin] Morningstar Canada
>
> Unfortunately, that web page is generated dynamically. The source data for
> the web page is in other web pages:
>
>
> http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE
>
> http://performance.morningstar.com/RatingRiskHtml/fund/mpt-statistics.action?symbol=F0CAN070P4
>
> http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4
>
> http://performance.morningstar.com/RatingRiskHtml/fund/volatility-measurements.action?symbol=F0CAN070P4
>
> On Sun, Jan 20, 2013 at 12:58 PM, iamruf iamruf@yahoo.com > wrote:
>
> Hi Randy,
> The page/site below provides coverage of Canadian Mutual Funds.
> The page provides Quote info plus Risk Rating & Statistics.
> From the Quote section, I would like to retrieve NAV, MER, 52-Week Range,
> Category.
> From the Risk & Rating Statistics section I would like to retrieve
> Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g.
> 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
> Is it possible to retrieve this data?
> If so, what is the best formula/way?
> Best Regards & thanks for all you do!
>
> http://quote.morningstar.ca/QuickTakes/fund/riskrating.aspx?t=AIM24873®ion=CAN&culture=en-CA
>
>
=0+smfStrExtr(
http://globalquote.
","
3-Year MorningStar Return would be:
=RCHGetTableCell(
http://performance.
Return"
http://quote.
= "),"
On Sun, Jan 20, 2013 at 4:49 PM, Undisclosed iamruf@yahoo.
> Can you supply me with a sample =smfGetTagContent or other statement for
> these?
>
> ------------
> *From:* Randy Harmelink rharmelink@gmail.
> *To:* smf_addin@yahoogrou
> *Sent:* Sunday, January 20, 2013 4:13 PM
> *Subject:* Re: [smf_addin] Morningstar Canada
>
> Unfortunately, that web page is generated dynamically. The source data for
> the web page is in other web pages:
>
>
> http://globalquote.
>
> http://performance.
>
> http://performance.
>
> http://performance.
>
> On Sun, Jan 20, 2013 at 12:58 PM, iamruf iamruf@yahoo.
>
> Hi Randy,
> The page/site below provides coverage of Canadian Mutual Funds.
> The page provides Quote info plus Risk Rating & Statistics.
> From the Quote section, I would like to retrieve NAV, MER, 52-Week Range,
> Category.
> From the Risk & Rating Statistics section I would like to retrieve
> Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g.
> 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
> Is it possible to retrieve this data?
> If so, what is the best formula/way?
> Best Regards & thanks for all you do!
>
> http://quote.
>
>
Sun Jan 20, 2013 7:05 pm (PST) . Posted by:
"Undisclosed" iamruf
Hi Randy,
Your formulas are working just great! Thanks for your patience and help!
1. Is there a way of retrieving the MER 2.51%?
I tried the following formula to no avail - obviously I need to understand better what the formula is doing.
=0+smfStrExtr(RCHGetWebData("http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE ","vkey:"),"MER:""","""")
2. Also need the 52-Week Range 11.49-13.81
3. I tried the following for the 3_Year Morningstar Rating but unless you know of a trick the result is a blank - guess this is because the Rating is represented as stars ****?
=RCHGetTableCell("http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4 ",2,">Morningstar Rating",,,,2,"
rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, January 20, 2013 7:22 PM
Subject: Re: [smf_addin] Morningstar Canada
NAV would be:
=0+smfStrExtr(RCHGetWebData("http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE ","vkey:"),"NAV:""","""")
3-Year MorningStar Return would be:
=RCHGetTableCell("http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4 ",2,">Morningstar Return",,,,2,"
http://quote.morningstar.ca/QuickTakes/fund/riskrating.aspx?t=AIM24873 ","symbol = "),"""","""")
On Sun, Jan 20, 2013 at 4:49 PM, Undisclosed iamruf@yahoo.com > wrote:
Can you supply me with a sample =smfGetTagContent or other statement for these?
>
>
>
>________________________________
> From: Randy Harmelink rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Sunday, January 20, 2013 4:13 PM
>Subject: Re: [smf_addin] Morningstar Canada
>
>
>Unfortunately, that web page is generated dynamically. The source data for the web page is in other web pages:
>
>http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE
>http://performance.morningstar.com/RatingRiskHtml/fund/mpt-statistics.action?symbol=F0CAN070P4
>http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4
>http://performance.morningstar.com/RatingRiskHtml/fund/volatility-measurements.action?symbol=F0CAN070P4
>
>
>On Sun, Jan 20, 2013 at 12:58 PM, iamruf iamruf@yahoo.com > wrote:
>
>Hi Randy,
>>The page/site below provides coverage of Canadian Mutual Funds.
>>The page provides Quote info plus Risk Rating & Statistics.
>>From the Quote section, I would like to retrieve NAV, MER, 52-Week Range, Category.
>>From the Risk & Rating Statistics section I would like to retrieve Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g. 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
>>Is it possible to retrieve this data?
>>If so, what is the best formula/way?
>>Best Regards & thanks for all you do!
>>http://quote.morningstar.ca/QuickTakes/fund/riskrating.aspx?t=AIM24873®ion=CAN&culture=en-CA
>>
Your formulas are working just great! Thanks for your patience and help!
1. Is there a way of retrieving the MER 2.51%?
I tried the following formula to no avail - obviously I need to understand better what the formula is doing.
=0+smfStrExtr(
2. Also need the 52-Week Range 11.49-13.
3. I tried the following for the 3_Year Morningstar Rating but unless you know of a trick the result is a blank - guess this is because the Rating is represented as stars ****?
=RCHGetTableCell(
rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Sunday, January 20, 2013 7:22 PM
Subject: Re: [smf_addin] Morningstar Canada
NAV would be:
=0+smfStrExtr(
3-Year MorningStar Return would be:
=RCHGetTableCell(
http://quote.
On Sun, Jan 20, 2013 at 4:49 PM, Undisclosed iamruf@yahoo.
Can you supply me with a sample =smfGetTagContent or other statement for these?
>
>
>
>________
> From: Randy Harmelink rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Sunday, January 20, 2013 4:13 PM
>Subject: Re: [smf_addin] Morningstar Canada
>
>
>Unfortunately, that web page is generated dynamically. The source data for the web page is in other web pages:
>
>http://globalquote.
>http://performance.
>http://performance.
>http://performance.
>
>
>On Sun, Jan 20, 2013 at 12:58 PM, iamruf iamruf@yahoo.
>
>Hi Randy,
>>The page/site below provides coverage of Canadian Mutual Funds.
>>The page provides Quote info plus Risk Rating & Statistics.
>>From the Quote section, I would like to retrieve NAV, MER, 52-Week Range, Category.
>>From the Risk & Rating Statistics section I would like to retrieve Morningstar Return, Morningstar Risk, Morningstar Rating, Date(e.g. 31/12/2012), 3-Year, 5-Year, 10-Year, Overall.
>>Is it possible to retrieve this data?
>>If so, what is the best formula/way?
>>Best Regards & thanks for all you do!
>>http://quote.
>>
Sun Jan 20, 2013 7:31 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Variations on a them:
1. MER is labeled as "ExpenseRatio:", so:
=0+smfStrExtr(RCHGetWebData("
http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE
","vkey:"),"ExpenseRatio:""","""")
2. Labeled as "52Week:", so:
=smfStrExtr(RCHGetWebData("
http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE
","vkey:"),"52Week:""","""")
3. MorningStar has changed star ratings to be the width of a "span" tag,
so we need the table cell coding instead of the table cell value:
=0+smfStrExtr(smfGetTagContent("
http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4 ","td",2,">Morningstar
Rating","
iamruf@yahoo.com > wrote:
>
>
> Hi Randy,
> Your formulas are working just great! Thanks for your patience and help!
> 1. Is there a way of retrieving the MER 2.51%?
> I tried the following formula to no avail - obviously I need to understand
> better what the formula is doing.
> =0+smfStrExtr(RCHGetWebData("
> ttp://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE >
> ","vkey:"),"MER:""","""")
>
> 2. Also need the 52-Week Range 11.49-13.81
>
> 3. I tried the following for the 3_Year Morningstar Rating but unless you
> know of a trick the result is a blank - guess this is because the Rating is
> represented as stars ****?
> =RCHGetTableCell("
> http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4
> ",2,">Morningstar Rating",,,,2,"
> Best Regards
>
1. MER is labeled as "ExpenseRatio:
=0+smfStrExtr(
http://globalquote.
","
2. Labeled as "52Week:
=smfStrExtr(
http://globalquote.
","
3. MorningStar has changed star ratings to be the width of a "span" tag,
so we need the table cell coding instead of the table cell value:
=0+smfStrExtr(
http://performance.
Rating"
iamruf@yahoo.
>
>
> Hi Randy,
> Your formulas are working just great! Thanks for your patience and help!
> 1. Is there a way of retrieving the MER 2.51%?
> I tried the following formula to no avail - obviously I need to understand
> better what the formula is doing.
> =0+smfStrExtr(
> ttp://globalquote.
> ","
>
> 2. Also need the 52-Week Range 11.49-13.81
>
> 3. I tried the following for the 3_Year Morningstar Rating but unless you
> know of a trick the result is a blank - guess this is because the Rating is
> represented as stars ****?
> =RCHGetTableCell(
> http://performance.
> ",2,"
> Best Regards
>
Mon Jan 21, 2013 5:59 am (PST) . Posted by:
"Undisclosed" iamruf
Awesome as usual!
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, January 20, 2013 10:31 PM
Subject: Re: [smf_addin] Morningstar Canada
Variations on a them:
1. MER is labeled as "ExpenseRatio:", so:
=0+smfStrExtr(RCHGetWebData("http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE ","vkey:"),"ExpenseRatio:""","""")
2. Labeled as "52Week:", so:
=smfStrExtr(RCHGetWebData("http://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE ","vkey:"),"52Week:""","""")
3. MorningStar has changed star ratings to be the width of a "span" tag, so we need the table cell coding instead of the table cell value:
=0+smfStrExtr(smfGetTagContent("http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4 ","td",2,">Morningstar Rating","
iamruf@yahoo.com > wrote:
>
>
>Hi Randy,
>Your formulas are working just great! Thanks for your patience and help!
>1. Is there a way of retrieving the MER 2.51%?
>I tried the following formula to no avail - obviously I need to understand better what the formula is doing.
> =0+smfStrExtr(RCHGetWebData("ttp://globalquote.morningstar.com/globalcomponent/commonjs.ashx?ctrl=Header,Title,Graph&ticker=AIM24873®ion=CAN&lan=en-CA&tmple=_955ONE ","vkey:"),"MER:""","""")
>
>2. Also need the 52-Week Range 11.49-13.81
>
>
>3. I tried the following for the 3_Year Morningstar Rating but unless you know of a trick the result is a blank - guess this is because the Rating is represented as stars ****?
>=RCHGetTableCell("http://performance.morningstar.com/RatingRiskHtml/fund/rating-risk.action?symbol=F0CAN070P4 ",2,">Morningstar Rating",,,,2,"
>
>
>Best Regards
>
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Sunday, January 20, 2013 10:31 PM
Subject: Re: [smf_addin] Morningstar Canada
Variations on a them:
1. MER is labeled as "ExpenseRatio:
=0+smfStrExtr(
2. Labeled as "52Week:
=smfStrExtr(
3. MorningStar has changed star ratings to be the width of a "span" tag, so we need the table cell coding instead of the table cell value:
=0+smfStrExtr(
iamruf@yahoo.
>
>
>Hi Randy,
>Your formulas are working just great! Thanks for your patience and help!
>1. Is there a way of retrieving the MER 2.51%?
>I tried the following formula to no avail - obviously I need to understand better what the formula is doing.
> =0+smfStrExtr(
>
>2. Also need the 52-Week Range 11.49-13.
>
>
>3. I tried the following for the 3_Year Morningstar Rating but unless you know of a trick the result is a blank - guess this is because the Rating is represented as stars ****?
>=RCHGetTableCel
>
>
>Best Regards
>
Sun Jan 20, 2013 12:00 pm (PST) . Posted by:
"Rosendo Jose" rosendojose
Hi Randy,
Once more I need your help to understand the origin of some errors results
in specific RCHGetElementNumbers fomulas as you can see in the attached
spreadsheet.
I've two kinds of errors:
The first one is the most strange. Using the SMFUpdateDownloadTable macro,
I obtain "error" for formulas as "Zacks Rank" (848), "Stock Signal" (826)
and so on. However, typing directly the RCHGetElementNumber formula I
obtain the correct information. Why the divergence?
The second, is an older one, because applying the formula to Piotroski and
Altman scores (15010 and 15011). I never could obtain any information for
these indicators.
For your better reference, I'm using Excel 2010 and the last version of SMF
(dated December, 29).
Thanking in advance for your precious colaboration.
Rosendo José
Lisbon
Once more I need your help to understand the origin of some errors results
in specific RCHGetElementNumber
spreadsheet.
I've two kinds of errors:
The first one is the most strange. Using the SMFUpdateDownloadTa
I obtain "error" for formulas as "Zacks Rank" (848), "Stock Signal" (826)
and so on. However, typing directly the RCHGetElementNumber formula I
obtain the correct information. Why the divergence?
The second, is an older one, because applying the formula to Piotroski and
Altman scores (15010 and 15011). I never could obtain any information for
these indicators.
For your better reference, I'm using Excel 2010 and the last version of SMF
(dated December, 29).
Thanking in advance for your precious colaboration.
Rosendo José
Lisbon
Attachments with this message:
1 of 1 File(s)
Sun Jan 20, 2013 1:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The smfUpdateDownloadTable issue with elements 826 and 848 are because of
the way those elements are defined -- as another formula.
If I just change "RCHGetElementNumber("~~~~~",848)" and
"RCHGetElementNumber("~~~~~",826)" to "848" and "826", they work fine here.
That's because I added code to the last release of the add-in that bypasses
the RCHGetElementNumber() function and goes directly to the other function.
For example, element 848 is defined as:
0+smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/quote/~~~~~/detailed-estimates ","p",-1,"Zacks
Rank:"),": ","-")
The Piotroski and Altman section of your workbook works fine for me:
Number *AAPL* Piotroski 1 15001 *1* *AAPL* Piotroski 2 15002 *1* *
AAPL* Piotroski 3 15003 *1* *AAPL* Piotroski 4 15004 *1* *AAPL* Piotroski
5 15005 * * *AAPL* Piotroski 6 15006 * * *AAPL* Piotroski 7 15007 * * *
AAPL* Piotroski 8 15008 *1* *AAPL* Piotroski 9 15009 * * *AAPL* Piotroski
Score 15010 *5* *AAPL* Altman Z Score 15011 *7.7477416*
What are you seeing? Those use AdvFN elements -- do you have issues with
those? For example, what do you get with:
=RCHGetElementNumber("MMM";, 10786)
On Sun, Jan 20, 2013 at 1:00 PM, Rosendo Jose rosendo.jose@gmail.com >wrote:
>
> Once more I need your help to understand the origin of some errors results
> in specific RCHGetElementNumbers fomulas as you can see in the attached
> spreadsheet.
>
> I've two kinds of errors:
>
> The first one is the most strange. Using the SMFUpdateDownloadTable macro,
> I obtain "error" for formulas as "Zacks Rank" (848), "Stock Signal" (826)
> and so on. However, typing directly the RCHGetElementNumber formula I
> obtain the correct information. Why the divergence?
>
> The second, is an older one, because applying the formula to Piotroski and
> Altman scores (15010 and 15011). I never could obtain any information for
> these indicators.
>
> For your better reference, I'm using Excel 2010 and the last version of
> SMF (dated December, 29).
>
>
the way those elements are defined -- as another formula.
If I just change "RCHGetElement
"RCHGetElement
That's because I added code to the last release of the add-in that bypasses
the RCHGetElementNumber
For example, element 848 is defined as:
0+smfStrExtr(
http://www.zacks.
Rank:")
The Piotroski and Altman section of your workbook works fine for me:
Number *AAPL* Piotroski 1 15001 *1* *AAPL* Piotroski 2 15002 *1* *
AAPL* Piotroski 3 15003 *1* *AAPL* Piotroski 4 15004 *1* *AAPL* Piotroski
5 15005 * * *AAPL* Piotroski 6 15006 * * *AAPL* Piotroski 7 15007 * * *
AAPL* Piotroski 8 15008 *1* *AAPL* Piotroski 9 15009 * * *AAPL* Piotroski
Score 15010 *5* *AAPL* Altman Z Score 15011 *7.7477416*
What are you seeing? Those use AdvFN elements -- do you have issues with
those? For example, what do you get with:
=RCHGetElementNumbe
On Sun, Jan 20, 2013 at 1:00 PM, Rosendo Jose rosendo.jose@
>
> Once more I need your help to understand the origin of some errors results
> in specific RCHGetElementNumber
> spreadsheet.
>
> I've two kinds of errors:
>
> The first one is the most strange. Using the SMFUpdateDownloadTa
> I obtain "error" for formulas as "Zacks Rank" (848), "Stock Signal" (826)
> and so on. However, typing directly the RCHGetElementNumber formula I
> obtain the correct information. Why the divergence?
>
> The second, is an older one, because applying the formula to Piotroski and
> Altman scores (15010 and 15011). I never could obtain any information for
> these indicators.
>
> For your better reference, I'm using Excel 2010 and the last version of
> SMF (dated December, 29).
>
>
Mon Jan 21, 2013 2:03 am (PST) . Posted by:
"Abdur" abdurrofiq@rocketmail.com
Hi Randy, et al.
I wanna say thank before because of your work. Can I use RCHGetYahooHistory for more than one ticker. I need closing price and volume for several tickers, but in the same date range. For example; I have 10 tickers in coloum, and the same range data for those tickers in row.I have tried to use this formula: RCHGetYahoohistory("IBM,MMM, MRK,MM,etc",2010,3,10,2011,3,10,"w";"tdcv). but it doesn't work. Could you help me, which formula I should use?..
thank you.
best regard
I wanna say thank before because of your work. Can I use RCHGetYahooHistory for more than one ticker. I need closing price and volume for several tickers, but in the same date range. For example; I have 10 tickers in coloum, and the same range data for those tickers in row.I have tried to use this formula: RCHGetYahoohistory(
thank you.
best regard
Mon Jan 21, 2013 2:07 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You would need do a separate RCHGetYahooHistory() function for each ticker
symbol. It doesn't allow multiple ticker symbols to be passed -- there
would be no reason to, since each ticker symbol would still need a separate
Internet access to get the data.
On Mon, Jan 21, 2013 at 2:36 AM, Abdur abdurrofiq@rocketmail.com > wrote:
>
> I wanna say thank before because of your work. Can I use
> RCHGetYahooHistory for more than one ticker. I need closing price and
> volume for several tickers, but in the same date range. For example; I have
> 10 tickers in coloum, and the same range data for those tickers in row.I
> have tried to use this formula: RCHGetYahoohistory("IBM,MMM,
> MRK,MM,etc",2010,3,10,2011,3,10,"w";"tdcv). but it doesn't work. Could you
> help me, which formula I should use?..
>
symbol. It doesn't allow multiple ticker symbols to be passed -- there
would be no reason to, since each ticker symbol would still need a separate
Internet access to get the data.
On Mon, Jan 21, 2013 at 2:36 AM, Abdur abdurrofiq@rocketma
>
> I wanna say thank before because of your work. Can I use
> RCHGetYahooHistory for more than one ticker. I need closing price and
> volume for several tickers, but in the same date range. For example; I have
> 10 tickers in coloum, and the same range data for those tickers in row.I
> have tried to use this formula: RCHGetYahoohistory(
> MRK,MM,etc"
> help me, which formula I should use?..
>
Mon Jan 21, 2013 5:34 am (PST) . Posted by:
"daul3285" daul3285
Hello!
I imported some data from this page http://www.kase.kz/en/emitters/show/NRBN using rchgettablecell, now i need to import whole table from that page. I need whole table under title "Instruments of Nurbank JSC included into trade lists" and last 10 news (only headers) under title "Last 10 news about Nurbank JSC for last 4 months". I tried to use rchgethtmltable, but can't understand how to use it. And how i can import data, not table to excel using your adding?
I imported some data from this page http://www.kase.
Tidak ada komentar:
Posting Komentar