12 New Messages
Digest #2427
4b
Re: Randy, function RCHGetElementNumber(ticker,14320 ) not working by "Randy Harmelink" rharmelink
Messages
Fri Dec 7, 2012 7:54 am (PST) . Posted by:
"Jacob Jose" pepecan47
I use the following formula to get the M* Fair Value:
=RCHGetTableCell("http://quicktake.morningstar.com/Stock/PrintReport.asp?Country=USA&Symbol= "&A33,2,"Morningstar Rating",,,,1)
When I have as a symbol UTX, I get $88.00 which is correct.
For several symbols I get "Error" eventhough I see the M* FV when I access M* via IE.
Symbols with "Error": RSG, BTU, POT
This used to work perfectly for all my tickers until a few days ago.
Regards,
Jose L. Jacob
=RCHGetTableCell(
When I have as a symbol UTX, I get $88.00 which is correct.
For several symbols I get "Error" eventhough I see the M* FV when I access M* via IE.
Symbols with "Error": RSG, BTU, POT
This used to work perfectly for all my tickers until a few days ago.
Regards,
Jose L. Jacob
Fri Dec 7, 2012 8:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I think they are phasing out the "Print Report" page. They replaced it with
a PDF file, and are mostly converting to dynamically generated web pages,
which means the data isn't in the source code of the web page, for the
add-in to extract.
On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> I use the following formula to get the M* Fair Value:
> =RCHGetTableCell("
> http://quicktake.morningstar.com/Stock/PrintReport.asp?Country=USA&Symbol= "&A33,2,"MorningstarRating",,,,1)
>
> When I have as a symbol UTX, I get $88.00 which is correct.
>
> For several symbols I get "Error" eventhough I see the M* FV when I access
> M* via IE.
> Symbols with "Error": RSG, BTU, POT
>
> This used to work perfectly for all my tickers until a few days ago.
>
a PDF file, and are mostly converting to dynamically generated web pages,
which means the data isn't in the source code of the web page, for the
add-in to extract.
On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.
>
> I use the following formula to get the M* Fair Value:
> =RCHGetTableCell(
> http://quicktake.
>
> When I have as a symbol UTX, I get $88.00 which is correct.
>
> For several symbols I get "Error" eventhough I see the M* FV when I access
> M* via IE.
> Symbols with "Error": RSG, BTU, POT
>
> This used to work perfectly for all my tickers until a few days ago.
>
Fri Dec 7, 2012 8:33 am (PST) . Posted by:
"Randy H" rharmelink
Hmmm. Try changing the URL to:
=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.\
aspx?Country=USA&Symbol= "&C10,2,"Morningstar Rating",,,,1)
On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.ca
<mailto:pepecan47@yahoo.ca > > wrote:
RCHGetTableCell("http://quicktake.morningstar.com/Stock/PrintReport.asp?\
Country=USA&Symbol= "&A33,2,"Morningstar Rating",,,,1)
=RCHGetTableCell(
aspx?Country=
On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.
<mailto:pepecan47@yahoo.
RCHGetTableCell(
Country=USA&
Fri Dec 7, 2012 10:07 am (PST) . Posted by:
"Ron Spruell" hashky
Are you both using M* Premium?
>________________________________
> From: Randy H <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, December 7, 2012 10:33 AM
>Subject: [smf_addin] Re: M* Fair Value
>
>
>
>Hmmm. Try changing the URL to:
>
>=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?Country=USA&Symbol= "&C10,2,"Morningstar Rating",,,,1)
>
>
>On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
>RCHGetTableCell("http://quicktake.morningstar.com/Stock/PrintReport.asp?Country=USA&Symbol= "&A33,2,"Morningstar Rating",,,,1)
>
>
>
>
>___________
> From: Randy H <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Friday, December 7, 2012 10:33 AM
>Subject: [smf_addin] Re: M* Fair Value
>
>
>
>Hmmm. Try changing the URL to:
>
>=RCHGetTableCell(
>
>
>On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.
>
>RCHGetTableCell(
>
>
>
>
Fri Dec 7, 2012 10:14 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I am using M* Premium. What I'm saying is that this web page no longer
exists:
http://quicktake.morningstar.com/Stock/PrintReport.asp?Country=USA&Symbol=MMM
...but this one does:
http://quicktake.morningstar.com/stocknet/PrintReport.aspx?Country=USA&Symbol=MMM
On Fri, Dec 7, 2012 at 11:07 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> Are you both using M* Premium?
>
> On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> RCHGetTableCell("http://quicktake.morningstar.com/*Stock/PrintReport*.asp?Country=USA&Symbol= "&A33,2,"Morningstar
> Rating",,,,1)
>
>
exists:
http://quicktake.
...but this one does:
http://quicktake.
On Fri, Dec 7, 2012 at 11:07 AM, Ron Spruell <hashky@yahoo.
>
> Are you both using M* Premium?
>
> On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.
>
> RCHGetTableCell(
> Rating",,,,1)
>
>
Fri Dec 7, 2012 2:18 pm (PST) . Posted by:
"Jacob Jose" pepecan47
"The man who knows only the HOW is always at the mercy of the man who also knows the WHY".
Randy, how do you know this? I cannot find the Print Report in M*......
Regards,
Jose L. Jacob
________________________________
From: Randy H <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Friday, December 7, 2012 11:33:55 AM
Subject: [smf_addin] Re: M* Fair Value
Hmmm. Try changing the URL to:
=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?Country=USA&Symbol= "&C10,2,"Morningstar Rating",,,,1)
On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
RCHGetTableCell("http://quicktake.morningstar.com/Stock/PrintReport.asp?Country=USA&Symbol= "&A33,2,"Morningstar Rating",,,,1)
Randy, how do you know this? I cannot find the Print Report in M*......
Regards,
Jose L. Jacob
____________
From: Randy H <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Friday, December 7, 2012 11:33:55 AM
Subject: [smf_addin] Re: M* Fair Value
Hmmm. Try changing the URL to:
=RCHGetTableCell(
On Fri, Dec 7, 2012 at 8:54 AM, Jacob Jose <pepecan47@yahoo.
RCHGetTableCell(
Fri Dec 7, 2012 2:24 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I believe on one of the tries of your URL that worked, I noticed it had
actually redirected me to that other URL.
The print report used to be a standard option on the quotes page of a
stock, but it appears to have been replaced by that PDF option.
On Fri, Dec 7, 2012 at 3:18 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
> Randy, how do you know this? I cannot find the Print Report in M*......
>
>
actually redirected me to that other URL.
The print report used to be a standard option on the quotes page of a
stock, but it appears to have been replaced by that PDF option.
On Fri, Dec 7, 2012 at 3:18 PM, Jacob Jose <pepecan47@yahoo.
> Randy, how do you know this? I cannot find the Print Report in M*......
>
>
Fri Dec 7, 2012 8:46 am (PST) . Posted by:
"smf_addin@yahoogroups.com"
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Works-In-Progress/
Uploaded by : rharmelink <rharmelink@gmail.
Description : Contains updates to Morningstar data element definitions for elements #877-883, which had to be redefined because of URL changes. These definitions are used by the RCHGetElementNumber
You can access this file at the URL:
http://groups.
To learn more about file sharing for your group, please visit:
http://help.
Regards,
rharmelink <rharmelink@gmail.
Fri Dec 7, 2012 12:28 pm (PST) . Posted by:
"thomas91112" thomas91112
Would like to download the historical Cash (Spot) prices for an array of options. Is there an identifier or datacode for Cash?
Fri Dec 7, 2012 1:45 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Not that I'm aware of, but I'm not quite sure what you're asking either. I
don't do anything with futures.
On Fri, Dec 7, 2012 at 1:28 PM, thomas91112 <thomas91112@yahoo.com > wrote:
> Would like to download the historical Cash (Spot) prices for an array of
> options. Is there an identifier or datacode for Cash?
>
don't do anything with futures.
On Fri, Dec 7, 2012 at 1:28 PM, thomas91112 <thomas91112@
> Would like to download the historical Cash (Spot) prices for an array of
> options. Is there an identifier or datacode for Cash?
>
Fri Dec 7, 2012 11:08 pm (PST) . Posted by:
"zbgb952" zbgb952
Is there another number other than 14320 then that will retrieve the same info?...3 yr eps growth?..as well as the other info that is no longer there? thx.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The M* web page it came from no longer exists. They've added it to a
> dynamically generated web page, which means there is no data in the source
> code of that web page to extract.
>
> I've been suggesting people use this on a separate worksheet, and grab the
> data from it:
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM ")
>
> On Fri, Dec 7, 2012 at 12:10 AM, zbgb952 <mb0329@...> wrote:
>
> > Randy, I am finding several are returning me an 'error' message in all
> > cases. This one is supposed to return eps 3 yr growth. Any idea why?
> >
>
--- In smf_addin@yahoogrou
>
> The M* web page it came from no longer exists. They've added it to a
> dynamically generated web page, which means there is no data in the source
> code of that web page to extract.
>
> I've been suggesting people use this on a separate worksheet, and grab the
> data from it:
>
> =smfGetCSVFile(
> http://financials.
>
> On Fri, Dec 7, 2012 at 12:10 AM, zbgb952 <mb0329@...> wrote:
>
> > Randy, I am finding several are returning me an 'error' message in all
> > cases. This one is supposed to return eps 3 yr growth. Any idea why?
> >
>
Sat Dec 8, 2012 12:16 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Just the CSV file I mentioned...
On Sat, Dec 8, 2012 at 12:08 AM, zbgb952 <mb0329@msn.com> wrote:
> Is there another number other than 14320 then that will retrieve the same
> info?...3 yr eps growth?..as well as the other info that is no longer
> there? thx.
>
On Sat, Dec 8, 2012 at 12:08 AM, zbgb952 <mb0329@msn.com> wrote:
> Is there another number other than 14320 then that will retrieve the same
> info?...3 yr eps growth?..as well as the other info that is no longer
> there? thx.
>
Tidak ada komentar:
Posting Komentar