4 New Messages
Digest #2262
| 1a Re: Morningstar Premium data extraction by "oryxius" oryxius 1b Re: Morningstar Premium data extraction by "Randy Harmelink" rharmelink 2a Re: Getting currency from Google and MSN by "antonvanas1989" antonvanas1989 2b Re: Getting currency from Google and MSN by "Randy Harmelink" rharmelink |
Fri Jun 29, 2012 5:28 am (PDT) . Posted by: "oryxius" oryxius
Thank you Randy. This is truly helpful. It works when I log in from within the Web Query. Is there a way to make the Web Query's version of IE compatible with the external one?
Also, I managed to extract all the data points from Morningstar, except the star rating as it is not listed as an HTML element but rather as attributes. Here is what I found about JPM for example:
<img src="http://im.morningstar.com/im/4
stars_purple.gif
 " alt="4 stars">
Is it possible to extract the image or the last attribute?
Thank you!
m.k.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Your formula is working fine for me when I'm logged in.
>
> The quickest way to test if you are logged in properly is to visit the URL
> of the function with the EXCEL Web Query process, and check to see if you
> can see the Fair Value estimate there. If not, log in there.
>
> On some machines, the version of IE used by EXCEL and the version of IE
> used as a browser are different versions of IE. If that is the case,
> logging in with the browser will not allow EXCEL to be logged in, since
> that version of IE would have a different set of security cookies. It's
> happened only rarely, but it is why I usually mention a preference to
> logging in via the Web Query dialog over the browser.
>
> You may need to run the smfForceRecalculation macro (see the LINKS area of
> the Yahoo group for more info) to make sure you have a fresh web page after
> logging in.
>
> On Fri, Jun 29, 2012 at 1:36 AM, oryxius <oryxius@...> wrote:
>
> > I was using the Automated Fair-Value Estimator Mstar experiments.xls
> > sheet, kindly developed and shared by osmangulseven and txbeekeeper, but I
> > could not download the Morningstar premium data even though I have a
> > premium account and I was logged in into it on IE when I ran the
> > calculations.
> >
> > Any idea how to get Morningstar to recognize a premium account connection
> > and to extract its premium data such as Fair Price Estimate and Economic
> > Moat?
> >
> > By the way, the sheet uses the following formula for the Fair Value
> > estimate:
> >
> > =RCHGetTableCell("
> > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol= "&C1,2,"Morningstar
> > Rating",,,,1)
> >
> > But it returns "Premium"
> >
>
Also, I managed to extract all the data points from Morningstar, except the star rating as it is not listed as an HTML element but rather as attributes. Here is what I found about JPM for example:
<img src="http://im.morningst
Is it possible to extract the image or the last attribute?
Thank you!
m.k.
--- In smf_addin@yahoogrou
>
> Your formula is working fine for me when I'm logged in.
>
> The quickest way to test if you are logged in properly is to visit the URL
> of the function with the EXCEL Web Query process, and check to see if you
> can see the Fair Value estimate there. If not, log in there.
>
> On some machines, the version of IE used by EXCEL and the version of IE
> used as a browser are different versions of IE. If that is the case,
> logging in with the browser will not allow EXCEL to be logged in, since
> that version of IE would have a different set of security cookies. It's
> happened only rarely, but it is why I usually mention a preference to
> logging in via the Web Query dialog over the browser.
>
> You may need to run the smfForceRecalculati
> the Yahoo group for more info) to make sure you have a fresh web page after
> logging in.
>
> On Fri, Jun 29, 2012 at 1:36 AM, oryxius <oryxius@...
>
> > I was using the Automated Fair-Value Estimator Mstar experiments.
> > sheet, kindly developed and shared by osmangulseven and txbeekeeper, but I
> > could not download the Morningstar premium data even though I have a
> > premium account and I was logged in into it on IE when I ran the
> > calculations.
> >
> > Any idea how to get Morningstar to recognize a premium account connection
> > and to extract its premium data such as Fair Price Estimate and Economic
> > Moat?
> >
> > By the way, the sheet uses the following formula for the Fair Value
> > estimate:
> >
> > =RCHGetTableCell(
> > http://quicktake.
> > Rating",,,,1)
> >
> > But it returns "Premium"
> >
>
Fri Jun 29, 2012 5:59 am (PDT) . Posted by: "Randy Harmelink" rharmelink
The one mentioned in the message archives of the group still works for me:
=VALUE(RCHGetWebData("
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=
"&C1,"stars_purple.gif",1,-11))
I'm not sure why the EXCEL IE object and the browser IE object get out of
sync. Or how to correct it. I never use IE as a browser, so it's never been
an issue for me.
On Fri, Jun 29, 2012 at 5:28 AM, oryxius <oryxius@yahoo.com > wrote:
> Thank you Randy. This is truly helpful. It works when I log in from within
> the Web Query. Is there a way to make the Web Query's version of IE
> compatible with the external one?
>
> Also, I managed to extract all the data points from Morningstar, except
> the star rating as it is not listed as an HTML element but rather as
> attributes. Here is what I found about JPM for example:
>
> <img src="http://im.morningstar.com/im/4
> stars_purple.gif
> " alt="4 stars">
>
> Is it possible to extract the image or the last attribute?
>
=VALUE(RCHGetWebDat
http://quicktake.
"&C1,"stars_
I'm not sure why the EXCEL IE object and the browser IE object get out of
sync. Or how to correct it. I never use IE as a browser, so it's never been
an issue for me.
On Fri, Jun 29, 2012 at 5:28 AM, oryxius <oryxius@yahoo.
> Thank you Randy. This is truly helpful. It works when I log in from within
> the Web Query. Is there a way to make the Web Query's version of IE
> compatible with the external one?
>
> Also, I managed to extract all the data points from Morningstar, except
> the star rating as it is not listed as an HTML element but rather as
> attributes. Here is what I found about JPM for example:
>
> <img src="http://im.morningst
> stars_purple.
> " alt="4 stars">
>
> Is it possible to extract the image or the last attribute?
>
Fri Jun 29, 2012 8:30 am (PDT) . Posted by: "antonvanas1989" antonvanas1989
Thanxs!
But how can i make it so i see a currency symbol like $?
I thaught about if formula, but i can't get it fixed..
--- In smf_addin@yahoogroups.com , "antonvanas1989" <antonvanas1989@...> wrote:
>
> Hi Randy,
>
> I'm trying to get the Currency from the Google finance and MSN webpage.
>
> http://investing.money.msn.com/investments/financial-statements?symbol=rds.a
>
> http://www.google.com/finance?q=NYSE:RDS.A&fstype=ii
>
> Here are some weblinks where the currency is reported. I'm wondering if there is some line for msn that also checked the othere pages where they report the currency because i think MSN not always uses the same data with one ticker.
>
But how can i make it so i see a currency symbol like $?
I thaught about if formula, but i can't get it fixed..
--- In smf_addin@yahoogrou
>
> Hi Randy,
>
> I'm trying to get the Currency from the Google finance and MSN webpage.
>
> http://investing.
>
> http://www.google.
>
> Here are some weblinks where the currency is reported. I'm wondering if there is some line for msn that also checked the othere pages where they report the currency because i think MSN not always uses the same data with one ticker.
>
Fri Jun 29, 2012 8:59 am (PDT) . Posted by: "Randy Harmelink" rharmelink
I think you'd need to create it, based on some type of lookup table.
On Fri, Jun 29, 2012 at 8:28 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
>
> But how can i make it so i see a currency symbol like $?
>
> I thaught about if formula, but i can't get it fixed..
>
On Fri, Jun 29, 2012 at 8:28 AM, antonvanas1989 <antonvanas1989@
>
> But how can i make it so i see a currency symbol like $?
>
> I thaught about if formula, but i can't get it fixed..
>
Tidak ada komentar:
Posting Komentar