5 New Messages
Digest #2266
| 1a yahoo history repeating last date with bad data by "colinmmoors" colinmmoors 1b Re: yahoo history repeating last date with bad data by "dguillett1" donaldb36 1c Re: yahoo history repeating last date with bad data by "colinmmoors" colinmmoors 1d Re: yahoo history repeating last date with bad data by "Randy Harmelink" rharmelink 2a Re: No price history for Dow Indexes at Yahoo Finance by "da" dvdadie |
Wed Jul 4, 2012 5:45 am (PDT) . Posted by: "colinmmoors" colinmmoors
do you notice yahoo history is repeating the latest date and often with bad data? so that rchgetyahoohistory for the most recent date is often returning bad data? is it possible to force it to get the second row of data (which seems to be correct) until yahoo fixes this? or is there another source to use for history on a specific date?
thank you for all your work
thank you for all your work
Wed Jul 4, 2012 6:34 am (PDT) . Posted by: "dguillett1" donaldb36
Once in a while a server gets stuck and you have to keep trying until a DIFFERENT server shows it.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: colinmmoors
Sent: Wednesday, July 04, 2012 7:45 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] yahoo history repeating last date with bad data
do you notice yahoo history is repeating the latest date and often with bad data? so that rchgetyahoohistory for the most recent date is often returning bad data? is it possible to force it to get the second row of data (which seems to be correct) until yahoo fixes this? or is there another source to use for history on a specific date?
thank you for all your work
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: colinmmoors
Sent: Wednesday, July 04, 2012 7:45 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] yahoo history repeating last date with bad data
do you notice yahoo history is repeating the latest date and often with bad data? so that rchgetyahoohistory for the most recent date is often returning bad data? is it possible to force it to get the second row of data (which seems to be correct) until yahoo fixes this? or is there another source to use for history on a specific date?
thank you for all your work
Thu Jul 5, 2012 3:59 am (PDT) . Posted by: "colinmmoors" colinmmoors
please go to history for SPY in yahoo finance...
http://finance.yahoo.com/q/hp?s=SPY+Historical+Prices
do you see two rows for the most recent date with different data?
this has been the case now for almost a week
thanks
--- In smf_addin@yahoogroups.com , "dguillett1" <dguillett1@...> wrote:
>
> Once in a while a server gets stuck and you have to keep trying until a DIFFERENT server shows it.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@...
>
> From: colinmmoors
> Sent: Wednesday, July 04, 2012 7:45 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] yahoo history repeating last date with bad data
>
>
> do you notice yahoo history is repeating the latest date and often with bad data? so that rchgetyahoohistory for the most recent date is often returning bad data? is it possible to force it to get the second row of data (which seems to be correct) until yahoo fixes this? or is there another source to use for history on a specific date?
>
> thank you for all your work
>
http://finance.
do you see two rows for the most recent date with different data?
this has been the case now for almost a week
thanks
--- In smf_addin@yahoogrou
>
> Once in a while a server gets stuck and you have to keep trying until a DIFFERENT server shows it.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@.
>
> From: colinmmoors
> Sent: Wednesday, July 04, 2012 7:45 AM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] yahoo history repeating last date with bad data
>
>
> do you notice yahoo history is repeating the latest date and often with bad data? so that rchgetyahoohistory for the most recent date is often returning bad data? is it possible to force it to get the second row of data (which seems to be correct) until yahoo fixes this? or is there another source to use for history on a specific date?
>
> thank you for all your work
>
Thu Jul 5, 2012 4:15 am (PDT) . Posted by: "Randy Harmelink" rharmelink
What was Yahoo's response when you asked them about it?
On Thu, Jul 5, 2012 at 3:59 AM, colinmmoors <colinmmoors@yahoo.com > wrote:
> please go to history for SPY in yahoo finance...
> http://finance.yahoo.com/q/hp?s=SPY+Historical+Prices
>
> do you see two rows for the most recent date with different data?
>
> this has been the case now for almost a week
>
On Thu, Jul 5, 2012 at 3:59 AM, colinmmoors <colinmmoors@
> please go to history for SPY in yahoo finance...
> http://finance.
>
> do you see two rows for the most recent date with different data?
>
> this has been the case now for almost a week
>
Wed Jul 4, 2012 9:12 pm (PDT) . Posted by: "da" dvdadie
clark, would you mind sharing your code with us? i had been using this: =rchgetyahoohistory(B23,B2,B3,B4,B5,B6,B7,B8,B26,B10,B11,B12) in an array format to pull the dow jones industrial average high, low, and close - for 2000 records.
--- In smf_addin@yahoogroups.com , "Clark F. Grain" <cgrain@...> wrote:
>
> I have been able to get DOW historical prices from google, using a web query. The symbol that I had to use was INDEXDJX:DJI. Nothing works with yahoo, although you can still get prices for NASDAQ, using the symbol IXIC.
>
> Clark Grain
> ----- Original Message -----
> From: Marc Smith
> To: smf_addin@yahoogroups.com
> Sent: Tuesday, July 03, 2012 10:33 AM
> Subject: [smf_addin] Re: No price history for Dow Indexes at Yahoo Finance
>
>
>
> I noticed the same problem. On Friday, I was able to use =smfpricesbydates to get historical ^DJI prices, but couldn't get the current day. Today, I can't get any prices with that function. Is there a work around, a formula that pulls prices from google or some other financial website?
>
> --- In smf_addin@yahoogroups.com , "mgbuck55" <mgbuck@> wrote:
> >
> > Last night I noticed that Yahoo Finance was not providing historical prices for ^DJI, ^DJT, or ^DJU. Current quotes were updating but the previous prices were gone. Anyone else notice this problem? If so is this a permanent change?
> >
>
--- In smf_addin@yahoogrou
>
> I have been able to get DOW historical prices from google, using a web query. The symbol that I had to use was INDEXDJX:DJI. Nothing works with yahoo, although you can still get prices for NASDAQ, using the symbol IXIC.
>
> Clark Grain
> ----- Original Message -----
> From: Marc Smith
> To: smf_addin@yahoogrou
> Sent: Tuesday, July 03, 2012 10:33 AM
> Subject: [smf_addin] Re: No price history for Dow Indexes at Yahoo Finance
>
>
>
> I noticed the same problem. On Friday, I was able to use =smfpricesbydates to get historical ^DJI prices, but couldn't get the current day. Today, I can't get any prices with that function. Is there a work around, a formula that pulls prices from google or some other financial website?
>
> --- In smf_addin@yahoogrou
> >
> > Last night I noticed that Yahoo Finance was not providing historical prices for ^DJI, ^DJT, or ^DJU. Current quotes were updating but the previous prices were gone. Anyone else notice this problem? If so is this a permanent change?
> >
>
Tidak ada komentar:
Posting Komentar