Selasa, 26 Maret 2013

[smf_addin] Digest Number 2560

4 New Messages

Digest #2560
1a
Yahoo quotes? Live? by "andyha8" andyha8
1b
Re: Yahoo quotes? Live? by "Randy Harmelink" rharmelink
2a
Re: IBD Rating by "focus_man_focus" focus_man_focus
2b
Re: IBD Rating by "Randy Harmelink" rharmelink

Messages

Mon Mar 25, 2013 9:22 am (PDT) . Posted by:

"andyha8" andyha8

I have a few questions about Yahoo quotes.

1. Are the quotes live now days or are they still 15 minute delayed?

2. Why are the quotes that I am getting in excel using RCHGetYahooQuotes different than those on the yahoo website?

i.e at this moment MCD here http://finance.yahoo.com/q?s=mcd&ql=1 is at 98.60 but in my excel spreadsheet it is at 98.68.

Mon Mar 25, 2013 1:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The quotes are delayed unless you are signed up for live quotes and create
an IE security cookie before using the function.

An 8 cent difference could easily be just a change in the last traded
price. However, you should make sure your Internet Options are set up so
that a fresh copy of the web page is always retrieved, instead of using
cached web pages.

The RCHGetYahooQuotes() function just uses the CSV option that is available
on the quotes page. That is, the "Download Data" link.

On Mon, Mar 25, 2013 at 9:22 AM, andyha8 <andyha8@gmail.com> wrote:

> I have a few questions about Yahoo quotes.
>
> 1. Are the quotes live now days or are they still 15 minute delayed?
>
> 2. Why are the quotes that I am getting in excel using RCHGetYahooQuotes
> different than those on the yahoo website?
>
> i.e at this moment MCD here http://finance.yahoo.com/q?s=mcd&ql=1 is at
> 98.60 but in my excel spreadsheet it is at 98.68.
>

Mon Mar 25, 2013 9:06 pm (PDT) . Posted by:

"focus_man_focus" focus_man_focus



Randy,

Is the IBD worksheet example you mentioned still available? I could not find it.

My older worksheet used a statement like this which no longer seems to work.

=RCHGetTableCell("http://research.investors.com/Quote.aspx?symbol="&A2,1,"Composite Rating")

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Check out the RCHGetTableCell-Template-IBD-Stock-Checkup.xls example in the
> FILES area of the group.
>
> You'll need to create a security cookie before using it, by logging in with
> either the EXCEL Web Query dialog (preferred) or IE.
>
> On Fri, Mar 22, 2013 at 4:45 AM, tgilbride1 <tgilbride@...> wrote:
>
> > Is there a way to pull the rating from Investors Business Daily? I do
> > have a subsciption and I have seen some posts about IBD.
> >
>

Mon Mar 25, 2013 11:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's in the RCHGetTableCell() sub-folder of the Templates and Examples
folder.

Your old formula won't work because IBD no longer uses the ticker symbol as
the parameter to get to the web pages.

On Mon, Mar 25, 2013 at 7:20 PM, focus_man_focus <mattwolf67@yahoo.com>wrote:

>
> Is the IBD worksheet example you mentioned still available? I could not
> find it.
>
> My older worksheet used a statement like this which no longer seems to
> work.
>
> =RCHGetTableCell("http://research.investors.com/Quote.aspx?symbol="&A2,1,"Composite
> Rating")
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Check out the RCHGetTableCell-Template-IBD-Stock-Checkup.xls example in
> the
> > FILES area of the group.
> >
> > You'll need to create a security cookie before using it, by logging in
> with
> > either the EXCEL Web Query dialog (preferred) or IE.
>

Tidak ada komentar:

Posting Komentar