4 New Messages
Digest #2704
Messages
Sun Jul 21, 2013 1:10 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetTableCell("https://www.google.com/finance?fstype=ii&q= "&C4,D4,">Accumulated
Depreciation")
What is this blog you mention?
On Sun, Jul 21, 2013 at 1:03 AM, Lawrence <lawrence.leesh@gmail.com > wrote:
>
> I read from the blog that there is no element number for Accumulated
> Depreciation for Google Finance. Could you pls give me a RCHGetTableCell
> formula for this in the format below so that I can fill in symbol and year
> in another cell.
>
=RCHGetTableCell(
Depreciation"
What is this blog you mention?
On Sun, Jul 21, 2013 at 1:03 AM, Lawrence <lawrence.leesh@
>
> I read from the blog that there is no element number for Accumulated
> Depreciation for Google Finance. Could you pls give me a RCHGetTableCell
> formula for this in the format below so that I can fill in symbol and year
> in another cell.
>
Sun Jul 21, 2013 1:20 am (PDT) . Posted by:
"Lawrence" lawleesh
Thanks. I meant your blog.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =RCHGetTableCell("https://www.google.com/finance?fstype=ii&q= "&C4,D4,">Accumulated
> Depreciation")
>
> What is this blog you mention?
>
> On Sun, Jul 21, 2013 at 1:03 AM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > I read from the blog that there is no element number for Accumulated
> > Depreciation for Google Finance. Could you pls give me a RCHGetTableCell
> > formula for this in the format below so that I can fill in symbol and year
> > in another cell.
> >
>
--- In smf_addin@yahoogrou
>
> Try:
>
> =RCHGetTableCell(
> Depreciation"
>
> What is this blog you mention?
>
> On Sun, Jul 21, 2013 at 1:03 AM, Lawrence <lawrence.
>
> >
> > I read from the blog that there is no element number for Accumulated
> > Depreciation for Google Finance. Could you pls give me a RCHGetTableCell
> > formula for this in the format below so that I can fill in symbol and year
> > in another cell.
> >
>
Sun Jul 21, 2013 5:23 am (PDT) . Posted by:
"Tommy" atb1023
Randy
Can this be array entered so that a list of stock symbols can be used? If so, what is the proper coding to change the "MMM" to reference the cell with the stock symbol?
Thanks
-Tommy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I recently changed the definition of element 1285 to get it from the quotes
> page:
>
> =RCHGetTableCell("http://finance.yahoo.com/q?s=MMM ",1,"Next Earnings Date:")
>
> Yahoo wasn't consistently populating the previous web page I was extracting
> it from.
>
> Some sites like MorningStar (and IBD) require you to manually visit the
> website first, preferably via the EXCEL Web Query dialog, or via IE. That's
> because they do a check for an advertising redirection on your first visit
> without a current security cookie. And the add-in processing doesn't
> execute the web page, it just retrieves the source code, so it can't update
> the IE cookies to indicate you've visited the website.
>
> For AdvFN, an Internet Options security item may need to be set. See the
> entry for it in the LINKS area of the group.
>
> On Sun, Jun 23, 2013 at 7:17 AM, handc.jones@... <
> handc.jones@...> wrote:
>
> > Most of the websites do not work on my computer and I don't know how to
> > describe the errors I receive. So for now, rather than trying to figure it
> > out, wonder if you can give me the code for Yahoo's "Next Earnings Date" or
> > give me instructions on how to find the code. Yahoo is the only one that
> > seems to work on my PC.
> >
>
Can this be array entered so that a list of stock symbols can be used? If so, what is the proper coding to change the "MMM" to reference the cell with the stock symbol?
Thanks
-Tommy
--- In smf_addin@yahoogrou
>
> I recently changed the definition of element 1285 to get it from the quotes
> page:
>
> =RCHGetTableCell(
>
> Yahoo wasn't consistently populating the previous web page I was extracting
> it from.
>
> Some sites like MorningStar (and IBD) require you to manually visit the
> website first, preferably via the EXCEL Web Query dialog, or via IE. That's
> because they do a check for an advertising redirection on your first visit
> without a current security cookie. And the add-in processing doesn't
> execute the web page, it just retrieves the source code, so it can't update
> the IE cookies to indicate you've visited the website.
>
> For AdvFN, an Internet Options security item may need to be set. See the
> entry for it in the LINKS area of the group.
>
> On Sun, Jun 23, 2013 at 7:17 AM, handc.jones@
> handc.jones@
>
> > Most of the websites do not work on my computer and I don't know how to
> > describe the errors I receive. So for now, rather than trying to figure it
> > out, wonder if you can give me the code for Yahoo's "Next Earnings Date" or
> > give me instructions on how to find the code. Yahoo is the only one that
> > seems to work on my PC.
> >
>
Sun Jul 21, 2013 8:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There would be no advantage to array-entering it, since it needs to go to
the Internet for each ticker symbol anyway.
Using a cell reference would be normal EXCEL concatenation:
"http://finance.yahoo.com/q?s= "&A2
On Sun, Jul 21, 2013 at 5:23 AM, Tommy <tommybrown@cfl.rr.com > wrote:
>
> Can this be array entered so that a list of stock symbols can be used? If
> so, what is the proper coding to change the "MMM" to reference the cell
> with the stock symbol?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > I recently changed the definition of element 1285 to get it from the
> quotes
> > page:
> >
> > =RCHGetTableCell("http://finance.yahoo.com/q?s=MMM ",1,"Next Earnings
> Date:")
> >
> > Yahoo wasn't consistently populating the previous web page I was
> extracting
> > it from.
>
the Internet for each ticker symbol anyway.
Using a cell reference would be normal EXCEL concatenation:
"http://finance.
On Sun, Jul 21, 2013 at 5:23 AM, Tommy <tommybrown@cfl.
>
> Can this be array entered so that a list of stock symbols can be used? If
> so, what is the proper coding to change the "MMM" to reference the cell
> with the stock symbol?
>
> --- In smf_addin@yahoogrou
> >
> > I recently changed the definition of element 1285 to get it from the
> quotes
> > page:
> >
> > =RCHGetTableCell(
> Date:")
> >
> > Yahoo wasn't consistently populating the previous web page I was
> extracting
> > it from.
>
Tidak ada komentar:
Posting Komentar