Minggu, 23 Juni 2013

[smf_addin] Digest Number 2668

12 New Messages

Digest #2668
1a
1b
Re: Quote data for NASDAQ and DJIA by "Randy Harmelink" rharmelink
1c
Re: Quote data for NASDAQ and DJIA by "Tom Bruin" tg.bruin

Messages

Sat Jun 22, 2013 3:20 am (PDT) . Posted by:

"Thomas" tg.bruin



Thank you for your reply. I just want to make sure I understood your answer on NASDAQ data. Here is the formula I am using to get NASDAQ data: =RCHGetYahooQuotes("^IXIC";,"l1",NOW())
I just refreshed (at 5AM CDT today) and this returned a price of 3,452.13
I just checked at finance.yahoo and the price for NASDAQ is completely different:

NASDAQ Composite (^IXIC) -Nasdaq GIDS
3,357.25 7.39(0.22%) Jun 21

So, does this mean that Yahoo is sending "bad" data to the add-in? In other words, I will need to check and input NASDAQ data manually?

The finance.yahoo
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> - The add-in is processing ^IXIC properly. That's what Yahoo is sending.
> You can always check by going here:
>
> http://finance.yahoo.com/q?s=^IXIC
>
> ...and clicking on the "Download Data (delayed)" link. That's a version
> of file that the add-in is using.
>
> - But it won't work for ^DJI. About a year or so ago, Dow Jones cracked
> down on usage of their quotes an their licensing agreement with Yahoo won't
> let Yahoo provide and Dow Jones quotes in CSV format. Note that if you go
> to:
>
> http://finance.yahoo.com/q?s=^DJI
>
> ...there is no "Download Data (delayed)" link.
>
> - I prefer to refresh add-in functions with the smfForceRecalculation
> macro. It's required for refreshing many of the other functions. I have the
> macro on a button on my toolbar. More info on the macro can be found in the
> LINKS area of the group.
>
> - If you want to speed up your RCHGetYahooQuotes() data retrieval, you
> should array-enter the function(s) over a range. Then it can return
> numerous data items on up to 200 stocks with a single Internet access.
> Otherwise, if you enter one function per cell, each function requires an
> individual Internet access. Very slow if you have a number of them.
>
> On Fri, Jun 21, 2013 at 5:47 AM, Thomas <thos.bruin@...> wrote:
>
> > I am able to get quotes just fine for the SnP500 but cannot get quotes for
> > NAZ or DJI. I am tring to retrieve Hi/Lo/Last (or close)prices for each
> > index. I am using following formula/syntax:
> >
> > =RCHGetYahooQuotes(B3,"l1",NOW())
> >
> > the cell reference in this example is for NASDAQ using the symbol ^IXIC
> > (what finance.yahoo.com shows as the symbol for Nasdaq.) The formula
> > returns a price that is not correct, and the formula adjusted for
> > retrieving high and low prices retrieves the exact same price as Last.
> >
> > For DJIA I am using the symbol ^DJI and it returns the message "missing
> > symbols list"
> >
> > SECOND QUESTION: I assume that unless I include the NOW() parameter,
> > there is no other way to refresh the data? I am also using the formula
> > above for individual stock quotes, and it is working just fine for that,
> > but it seems to really slow down the operation of my spreadsheet, and when
> > I hit F9 to refresh it takes a very long time to cycle thru the refresh.
> >
> > Any help is appreciated, thanks.
> >
> > P.S. -- I know a similar question was posted here (re: quotes for indices)
> > but I did not understand your reply.
> >
>

Sat Jun 22, 2013 4:05 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yes. Yahoo is sending bad data. You can verify this -- click on that
"Download Data (delayed)" link from here:

http://finance.yahoo.com/q?s=^IXIC

...and the price quoted will be 3423.555 (looks like the June 14th closing
price, and the download file says the last traded date was June 15th). The
data Yahoo puts onto that file is the same data that Yahoo puts onto the
file that the add-in uses. So that is the quote that the add-in will report.

You should click on the "Send Feedback" link at the bottom of the page and
tell Yahoo that the quotes on their "Download Data" option don't match what
is being reported on the web page.

On Sat, Jun 22, 2013 at 3:20 AM, Thomas <thos.bruin@gmail.com> wrote:

>
> Thank you for your reply. I just want to make sure I understood your
> answer on NASDAQ data. Here is the formula I am using to get NASDAQ data:
> =RCHGetYahooQuotes("^IXIC";,"l1",NOW())
> I just refreshed (at 5AM CDT today) and this returned a price of 3,452.13
> I just checked at finance.yahoo and the price for NASDAQ is completely
> different:
>
> NASDAQ Composite (^IXIC) -Nasdaq GIDS
> 3,357.25 7.39(0.22%) Jun 21
>
> So, does this mean that Yahoo is sending "bad" data to the add-in? In
> other words, I will need to check and input NASDAQ data manually?
>

Sat Jun 22, 2013 6:13 am (PDT) . Posted by:

"Tom Bruin" tg.bruin

Thanks

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, June 22, 2013 6:05 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Quote data for NASDAQ and DJIA

Yes. Yahoo is sending bad data. You can verify this -- click on that "Download Data (delayed)" link from here:

http://finance.yahoo.com/q?s=^IXIC

...and the price quoted will be 3423.555 (looks like the June 14th closing price, and the download file says the last traded date was June 15th). The data Yahoo puts onto that file is the same data that Yahoo puts onto the file that the add-in uses. So that is the quote that the add-in will report.

You should click on the "Send Feedback" link at the bottom of the page and tell Yahoo that the quotes on their "Download Data" option don't match what is being reported on the web page.

On Sat, Jun 22, 2013 at 3:20 AM, Thomas <thos.bruin@gmail.com> wrote:

Thank you for your reply. I just want to make sure I understood your answer on NASDAQ data. Here is the formula I am using to get NASDAQ data: =RCHGetYahooQuotes("^IXIC";,"l1",NOW())
I just refreshed (at 5AM CDT today) and this returned a price of 3,452.13
I just checked at finance.yahoo and the price for NASDAQ is completely different:

NASDAQ Composite (^IXIC) -Nasdaq GIDS
3,357.25 7.39(0.22%) Jun 21

So, does this mean that Yahoo is sending "bad" data to the add-in? In other words, I will need to check and input NASDAQ data manually?

Sat Jun 22, 2013 5:26 am (PDT) . Posted by:

"nap1805" nap1805

I have no issues with AdvFN-A. For example, =RCHGetElementNumber("MCD";,7811)returns a P/CF ratio of 19.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. I also get the message about the query returning no data. But I can
> still access the web page with the add-in functions.
>
> The very fact you can bring up the web page in EXCEL means you don't have a
> firewall preventing access to it.
>
> I'm really at a loss to explain why you can't access the Google data.
>
> Can you access AdvFN data? In the LINKS area of the group, there is an IE
> setting that needs to be toggled to access AdvFN data. It could be the same
> setting is preventing access to Google. But I'm grasping at straws for that.
>
> On Fri, Jun 21, 2013 at 3:48 PM, nap1805 <nap1805@...> wrote:
>
> > I just get the value of "error". I am able to visit the website using
> > Excel query and it looks normal but I am unable to import the date. I get a
> > message from excel stating "This query returned no data..." This does not
> > happen when I try to import data from yahoo.finance or others. I don't
> > think I have a firewall. I will double check.
> >
>

Sat Jun 22, 2013 8:05 am (PDT) . Posted by:

"weekeewawa" weekeewawa

hello randy

as you can see from the code below

=RCHGetElementNumber(A$2,13638)

i used it to extract the beta from reuters of for example

http://www.reuters.com/finance/stocks/financialHighlights?symbol=IBM

however, i realised that while extracting data from certain stocks such as from asian exchanges, it displays ERROR although on checking upon reuters, it has data

is there a reason for it?

so i decided i would prefer to change it to RCHGETCELL

but then again, i ran into a problem

using the code

=RCHGetTableCell("http://www.reuters.com/finance/stocks/financialHighlights?symbol="&A2,1,"Beta")

gives me an ERROR as well

is there any pointers you can give?

thanks!

Sat Jun 22, 2013 9:23 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Can you give me an example of a stock that didn't work?

On Sat, Jun 22, 2013 at 8:05 AM, weekeewawa <weekeewawa@yahoo.com> wrote:

> hello randy
>
> as you can see from the code below
>
> =RCHGetElementNumber(A$2,13638)
>
> i used it to extract the beta from reuters of for example
>
> http://www.reuters.com/finance/stocks/financialHighlights?symbol=IBM
>
> however, i realised that while extracting data from certain stocks such as
> from asian exchanges, it displays ERROR although on checking upon reuters,
> it has data
>
> is there a reason for it?
>
> so i decided i would prefer to change it to RCHGETCELL
>
> but then again, i ran into a problem
>
> using the code
>
> =RCHGetTableCell("
> http://www.reuters.com/finance/stocks/financialHighlights?symbol=
> "&A2,1,"Beta")
>
> gives me an ERROR as well
>
> is there any pointers you can give?
>
> thanks!
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

Sat Jun 22, 2013 9:32 am (PDT) . Posted by:

"weekeewawa" weekeewawa

this stock for example

http://uk.reuters.com/business/quotes/financialHighlights?symbol=LTIG.SI

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Can you give me an example of a stock that didn't work?
>
> On Sat, Jun 22, 2013 at 8:05 AM, weekeewawa <weekeewawa@...> wrote:
>
> > hello randy
> >
> > as you can see from the code below
> >
> > =RCHGetElementNumber(A$2,13638)
> >
> > i used it to extract the beta from reuters of for example
> >
> > http://www.reuters.com/finance/stocks/financialHighlights?symbol=IBM
> >
> > however, i realised that while extracting data from certain stocks such as
> > from asian exchanges, it displays ERROR although on checking upon reuters,
> > it has data
> >
> > is there a reason for it?
> >
> > so i decided i would prefer to change it to RCHGETCELL
> >
> > but then again, i ran into a problem
> >
> > using the code
> >
> > =RCHGetTableCell("
> > http://www.reuters.com/finance/stocks/financialHighlights?symbol=
> > "&A2,1,"Beta")
> >
> > gives me an ERROR as well
> >
> > is there any pointers you can give?
> >
> > thanks!
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>

Sat Jun 22, 2013 2:29 pm (PDT) . Posted by:

"B B" kokdari82

When I do =RCHGetElementNumber(Ticker,3) the output is "New York Stock Exchange" instead of "NYSE".
Just happened recently.
Is there a way to grab the exchange or another place where I can grab the exchange info from?

Sat Jun 22, 2013 3:00 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, MSN once again felt a need to do things just a bit
differently on their web pages. Sigh. Happens almost annually.

I would suggest the RCHGetYahooQuotes() function, particularly because it
can get the exchange on up to 200 companies in a single Internet access.

On Sat, Jun 22, 2013 at 2:29 PM, B B <kokdari82@yahoo.com> wrote:

> When I do =RCHGetElementNumber(Ticker,3) the output is "New York Stock
> Exchange" instead of "NYSE".
> Just happened recently.
> Is there a way to grab the exchange or another place where I can grab the
> exchange info from?
>

Sat Jun 22, 2013 9:31 pm (PDT) . Posted by:

"B B" kokdari82

Thanks I konw what you mean by the msn issue. Seems like they keep changing the data on the site.

In terms of using RCHGetYahooQuotes(), the downside is that it doesn't pick up the exchange for small caps.

e.g JOEZ shows up as NCM when it should be Nasdaq.
For other stocks, it also shows NGM which I have no clue what that means.

Have you seen this?

Anyone know of where to find a site that gives the exchange info?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Unfortunately, MSN once again felt a need to do things just a bit
> differently on their web pages. Sigh. Happens almost annually.
>
> I would suggest the RCHGetYahooQuotes() function, particularly because it
> can get the exchange on up to 200 companies in a single Internet access.
>
> On Sat, Jun 22, 2013 at 2:29 PM, B B <kokdari82@...> wrote:
>
> > When I do =RCHGetElementNumber(Ticker,3) the output is "New York Stock
> > Exchange" instead of "NYSE".
> > Just happened recently.
> > Is there a way to grab the exchange or another place where I can grab the
> > exchange info from?
> >
>

Sat Jun 22, 2013 10:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

NGM = NASDAQ Global Market

NCM = NASDAQ Capital Market

NGS = NASDAQ Global Select Market

http://www.quantumonline.com/glossary.cfm#NASDAQ

On Sat, Jun 22, 2013 at 9:31 PM, B B <kokdari82@yahoo.com> wrote:

> Thanks I konw what you mean by the msn issue. Seems like they keep
> changing the data on the site.
>
> In terms of using RCHGetYahooQuotes(), the downside is that it doesn't
> pick up the exchange for small caps.
>
> e.g JOEZ shows up as NCM when it should be Nasdaq.
> For other stocks, it also shows NGM which I have no clue what that means.
>
> Have you seen this?
>
> Anyone know of where to find a site that gives the exchange info?
>
Diposting oleh EXCEL FEED LEARNING di 01.34

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)