4 New Messages
Digest #2560
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.
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.
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.
>
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(
on the quotes page. That is, the "Download Data" link.
On Mon, Mar 25, 2013 at 9:22 AM, andyha8 <andyha8@gmail.
> 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.
> 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(
--- In smf_addin@yahoogrou
>
> Check out the RCHGetTableCell-
> 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@
>
> > 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.
>
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.
>
> 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(
> Rating"
>
> --- In smf_addin@yahoogrou
> >
> > Check out the RCHGetTableCell-
> 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