10 New Messages
Digest #2261
| by "carmine288" carmine288 by "Randy Harmelink" rharmelink by "deevilboy1" deevilboy1 by "Randy Harmelink" rharmelink by "Mauricio Lan" morteritos by "Randy H" rharmelink by "antonvanas1989" antonvanas1989 by "Randy Harmelink" rharmelink by "oryxius" oryxius by "Randy Harmelink" rharmelink | |
Is there a way around that?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Because they are using JavaScript to disable such use of the mouse.
>
> On Wed, Jun 27, 2012 at 8:49 PM, carmine288 <carmine.nicoletta@...>wrote:
>
> >
> > Another thing. Do you why Ctrl+A is able to cut-and-paste the entire page,
> > but if you just want to highlight a few stocks from the screen,
> > cut-and-paste isn't grabbing any data?
> >
>
--- In smf_addin@yahoogrou
>
> Because they are using JavaScript to disable such use of the mouse.
>
> On Wed, Jun 27, 2012 at 8:49 PM, carmine288 <carmine.nicoletta@
>
> >
> > Another thing. Do you why Ctrl+A is able to cut-and-paste the entire page,
> > but if you just want to highlight a few stocks from the screen,
> > cut-and-paste isn't grabbing any data?
> >
>
I'm sure there is, but I don't know of anything offhand.
On Thu, Jun 28, 2012 at 6:29 AM, carmine288 <carmine.nicoletta@gmail.com >wrote:
> Is there a way around that?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Because they are using JavaScript to disable such use of the mouse.
> >
> > On Wed, Jun 27, 2012 at 8:49 PM, carmine288 <carmine.nicoletta@
> ...>wrote:
> >
> > > Another thing. Do you why Ctrl+A is able to cut-and-paste the entire
> page,
> > > but if you just want to highlight a few stocks from the screen,
> > > cut-and-paste isn't grabbing any data?
>
On Thu, Jun 28, 2012 at 6:29 AM, carmine288 <carmine.nicoletta@
> Is there a way around that?
>
> --- In smf_addin@yahoogrou
> >
> > Because they are using JavaScript to disable such use of the mouse.
> >
> > On Wed, Jun 27, 2012 at 8:49 PM, carmine288 <carmine.nicoletta@
> ...>wrote:
> >
> > > Another thing. Do you why Ctrl+A is able to cut-and-paste the entire
> page,
> > > but if you just want to highlight a few stocks from the screen,
> > > cut-and-paste isn't grabbing any data?
>
Hi,
I'm building a dynamic excel sheet. My tickers (like MSFT) are input in cell A1.
How do I modify the working code below so that instead of having to hardcode the ticker it references cell A1 to extract the ticker.
Note the example below the ticker is "cl"
=RCHGetTableCell( "http://finance. yahoo.com/ q/ao?s=cl" ,1,"Mean
Recommendation (this week)",,,,,, ,)
Thanks!
Mike
--- In smf_addin@yahoogroups.com , "Randy Harmelink" <rharmelink@...> wrote:
>
> Take a look in the files area. In the "Templates and Examples"
> folder, you should find this template:
>
> SMF-Template-Yahoo-Analyst-Estimates.xls
>
> On 4/30/08, nor_yh <nor_yh@...> wrote:
> >
> > Would you please give me some instruction to pull numbers of mean
> > recommendation (this week), mean recommendation (last week) and change
> > from Yahoo Analyst Opinion page. thanks a lot.
>
I'm building a dynamic excel sheet. My tickers (like MSFT) are input in cell A1.
How do I modify the working code below so that instead of having to hardcode the ticker it references cell A1 to extract the ticker.
Note the example below the ticker is "cl"
=RCHGetTableCell( "http://finance. yahoo.com/ q/ao?s=cl" ,1,"Mean
Recommendation (this week)",,,,,, ,)
Thanks!
Mike
--- In smf_addin@yahoogrou
>
> Take a look in the files area. In the "Templates and Examples"
> folder, you should find this template:
>
> SMF-Template-
>
> On 4/30/08, nor_yh <nor_yh@...> wrote:
> >
> > Would you please give me some instruction to pull numbers of mean
> > recommendation (this week), mean recommendation (last week) and change
> > from Yahoo Analyst Opinion page. thanks a lot.
>
Try:
"http://finance.yahoo.com/q/ao?s= "&C1
You need to concatenate (i.e. "&") the cell to the string. You have the
cell address as a string value, not as a cell reference.
On Thu, Jun 28, 2012 at 11:39 AM, deevilboy1 <deevilboy1@yahoo.com > wrote:
>
> I'm building a dynamic excel sheet. My tickers (like MSFT) are input in
> cell A1.
>
> How do I modify the working code below so that instead of having to
> hardcode the ticker it references cell A1 to extract the ticker.
>
> Note the example below the ticker is "cl"
>
>
> =RCHGetTableCell( "http://finance. yahoo.com/ q/ao?s=cl" ,1,"Mean
> Recommendation (this week)",,,,,, ,)
>
"http://finance.
You need to concatenate (i.e. "&") the cell to the string. You have the
cell address as a string value, not as a cell reference.
On Thu, Jun 28, 2012 at 11:39 AM, deevilboy1 <deevilboy1@yahoo.
>
> I'm building a dynamic excel sheet. My tickers (like MSFT) are input in
> cell A1.
>
> How do I modify the working code below so that instead of having to
> hardcode the ticker it references cell A1 to extract the ticker.
>
> Note the example below the ticker is "cl"
>
>
> =RCHGetTableCell( "http://finance. yahoo.com/ q/ao?s=cl" ,1,"Mean
> Recommendation (this week)",,,,,, ,)
>
Hi Randy.
I'm new with this add, and its amazing.
I have a question.
When I try to get the 10 year average P/E, I'm trying to use the element 163 with " =RCHGetElementNumber("CSCO",163) " But it says Error, what i'm doing wrong??
Thank you very much again.
I'm new with this add, and its amazing.
I have a question.
When I try to get the 10 year average P/E, I'm trying to use the element 163 with " =RCHGetElementNumbe
Thank you very much again.
You probably just need this update:
http://finance.
--- In smf_addin@yahoogrou
>
> Hi Randy.
>
> I'm new with this add, and its amazing.
>
> I have a question.
> When I try to get the 10 year average P/E, I'm trying to use
> the element 163 with "=RCHGetElementNumb
> it says Error, what i'm doing wrong??
>
> Thank you very much again.
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.
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.
Possibly?
=smfGetTagContent("
http://investing.money.msn.com/investments/financial-statements?symbol=rds.a ","span",-1,"Financial
Data in")
=RCHGetTableCell("http://www.google.com/finance?q=NYSE:RDS.A&fstype=ii ",0,"per
share items")
On Thu, Jun 28, 2012 at 3:18 PM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
>
> 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.
>
=smfGetTagContent(
http://investing.
Data in")
=RCHGetTableCell(
share items")
On Thu, Jun 28, 2012 at 3:18 PM, antonvanas1989 <antonvanas1989@
>
> 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.
>
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"
Many thanks.
m.k.
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(
But it returns "Premium"
Many thanks.
m.k.
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@yahoo.com > 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"
>
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@yahoo.
> 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"
>
Tidak ada komentar:
Posting Komentar