5 New Messages
Digest #2502
2b
Re: Is it possible to reference stock symbol in =RCHGetElementNumber by "Randy Harmelink" rharmelink
Messages
Fri Feb 8, 2013 4:30 pm (PST) . Posted by:
"PLA" option2z
All,
I've been running some simulations that require downloading daily adjusted
close data for each stock. I also download the same period for the SPY.
It's worked well for many months. Recently, though, MANY stocks have a
single day missing out of 11 years of daily data. The SPY downloads
perfectly and is complete.
I'd suspect my code, except that that the same called routine downloads both
the SPY and the others. It has persisted across a couple of days now, and
not all stocks. Here's a list of a few of them: WR, UIL, WBK, WDR, WEC, WM.
12/21/2001 - 12/21/2012. 2/1/2002 is a date that has a SPY value, but not
for any of these stocks. It is a Friday according to DR Google.
If anyone has an idea, I'd certainly appreciate it. I can patch the
download to insert a dummy value, but SHEESH, that seems improper to me J
Thanks!
Thanks,
Pete A
http://www.sundognorth.com/TtP-S/ >
I've been running some simulations that require downloading daily adjusted
close data for each stock. I also download the same period for the SPY.
It's worked well for many months. Recently, though, MANY stocks have a
single day missing out of 11 years of daily data. The SPY downloads
perfectly and is complete.
I'd suspect my code, except that that the same called routine downloads both
the SPY and the others. It has persisted across a couple of days now, and
not all stocks. Here's a list of a few of them: WR, UIL, WBK, WDR, WEC, WM.
12/21/2001 - 12/21/2012. 2/1/2002 is a date that has a SPY value, but not
for any of these stocks. It is a Friday according to DR Google.
If anyone has an idea, I'd certainly appreciate it. I can patch the
download to insert a dummy value, but SHEESH, that seems improper to me J
Thanks!
Thanks,
Pete A
http://www.sundogno
Fri Feb 8, 2013 5:58 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Years ago, this used to be a common issue -- there would be a lot of "date
missing" in Yahoo historical data, because they didn't use to post an entry
for a day with zero volume (is that a "trading" day?).
It could be they just had an issue with the update process on that
particular day, and some stocks didn't get updated. Note that many of the
ones you listed are late in the alphabet.
My suggestion would be to mention it to Yahoo.
On Fri, Feb 8, 2013 at 5:29 PM, PLA optionzz@gmail.com > wrote:
>
> All,****
>
> I've been running some simulations that require downloading daily adjusted
> close data for each stock. I also download the same period for the SPY. It's
> worked well for many months. Recently, though, MANY stocks have a single
> day missing out of 11 years of daily data. The SPY downloads perfectly
> and is complete. ****
>
> ** **
>
> I'd suspect my code, except that that the same called routine downloads
> both the SPY and the others. It has persisted across a couple of days
> now, and not all stocks. Here's a list of a few of them: WR, UIL, WBK,
> WDR, WEC, WM. 12/21/2001 - 12/21/2012. 2/1/2002 is a date that has a
> SPY value, but not for any of these stocks. It is a Friday according to DR
> Google. ****
>
> ** **
>
> If anyone has an idea, I'd certainly appreciate it. I can patch the
> download to insert a dummy value, but SHEESH, that seems improper to me J
> Thanks!****
>
> * Thanks, *
>
> * Pete A*
>
> http://www.sundognorth.com/TtP-S/ >****
>
> ****
>
> ** **
>
>
missing" in Yahoo historical data, because they didn't use to post an entry
for a day with zero volume (is that a "trading" day?).
It could be they just had an issue with the update process on that
particular day, and some stocks didn't get updated. Note that many of the
ones you listed are late in the alphabet.
My suggestion would be to mention it to Yahoo.
On Fri, Feb 8, 2013 at 5:29 PM, PLA optionzz@gmail.
>
> All,****
>
> I've been running some simulations that require downloading daily adjusted
> close data for each stock. I also download the same period for the SPY. It's
> worked well for many months. Recently, though, MANY stocks have a single
> day missing out of 11 years of daily data. The SPY downloads perfectly
> and is complete. ****
>
> ** **
>
> I'd suspect my code, except that that the same called routine downloads
> both the SPY and the others. It has persisted across a couple of days
> now, and not all stocks. Here's a list of a few of them: WR, UIL, WBK,
> WDR, WEC, WM. 12/21/2001 - 12/21/2012. 2/1/2002 is a date that has a
> SPY value, but not for any of these stocks. It is a Friday according to DR
> Google. ****
>
> ** **
>
> If anyone has an idea, I'd certainly appreciate it. I can patch the
> download to insert a dummy value, but SHEESH, that seems improper to me J
> Thanks!****
>
> * Thanks, *
>
> * Pete A*
>
> http://www.sundogno
>
> ****
>
> ** **
>
>
Fri Feb 8, 2013 6:56 pm (PST) . Posted by:
"Tze Wei," tzewei_79
Hi,
Is there a way to let =RCHGetElementNumber("IBM";, 941) reference the stock symbol to another cell so that we don't need to edit the symbols one by one for different data that we wanted to extract?
Example
Cell A1 = IBM
Cell B1 = =RCHGetElementNumber("IBM";, 941)
I tried the above, and excel always shows error.
I'm using Excel 2007 with Win XP.
Is there a way to let =RCHGetElementNumbe
Example
Cell A1 = IBM
Cell B1 = =RCHGetElementNumbe
I tried the above, and excel always shows error.
I'm using Excel 2007 with Win XP.
Fri Feb 8, 2013 7:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just like in any EXCEL function:
=RCHGetElementNumber(A1, 941)
In your description, I'm not sure what is showing error?
On Fri, Feb 8, 2013 at 7:56 PM, Tze Wei, tzewei_79@yahoo.com.sg > wrote:
>
> Is there a way to let =RCHGetElementNumber("IBM";, 941) reference the stock
> symbol to another cell so that we don't need to edit the symbols one by one
> for different data that we wanted to extract?
>
> Example
>
> Cell A1 = IBM
> Cell B1 = =RCHGetElementNumber("IBM";, 941)
>
> I tried the above, and excel always shows error.
> I'm using Excel 2007 with Win XP.
>
=RCHGetElementNumbe
In your description, I'm not sure what is showing error?
On Fri, Feb 8, 2013 at 7:56 PM, Tze Wei, tzewei_79@yahoo.
>
> Is there a way to let =RCHGetElementNumbe
> symbol to another cell so that we don't need to edit the symbols one by one
> for different data that we wanted to extract?
>
> Example
>
> Cell A1 = IBM
> Cell B1 = =RCHGetElementNumbe
>
> I tried the above, and excel always shows error.
> I'm using Excel 2007 with Win XP.
>
Fri Feb 8, 2013 8:45 pm (PST) . Posted by:
"PLA" option2z
Mysterious, but as I began experimenting, it fixed itself! Probably a YAHOO
problem that they found.
Thanks,
Pete A
http://www.sundognorth.com/TtP-S/ >
From: PLA [mailto:optionzz@gmail.com ]
Sent: Friday, February 08, 2013 4:30 PM
To: smf_addin@yahoogroups.com '
Subject: Wierd Problem with History Download
All,
I've been running some simulations that require downloading daily adjusted
close data for each stock. I also download the same period for the SPY.
It's worked well for many months. Recently, though, MANY stocks have a
single day missing out of 11 years of daily data. The SPY downloads
perfectly and is complete.
I'd suspect my code, except that that the same called routine downloads both
the SPY and the others. It has persisted across a couple of days now, and
not all stocks. Here's a list of a few of them: WR, UIL, WBK, WDR, WEC, WM.
12/21/2001 - 12/21/2012. 2/1/2002 is a date that has a SPY value, but not
for any of these stocks. It is a Friday according to DR Google.
If anyone has an idea, I'd certainly appreciate it. I can patch the
download to insert a dummy value, but SHEESH, that seems improper to me J
Thanks!
Thanks,
Pete A
http://www.sundognorth.com/TtP-S/ >
problem that they found.
Thanks,
Pete A
http://www.sundogno
From: PLA [mailto:optionzz@gmail.
Sent: Friday, February 08, 2013 4:30 PM
To: smf_addin@yahoogro
Subject: Wierd Problem with History Download
All,
I've been running some simulations that require downloading daily adjusted
close data for each stock. I also download the same period for the SPY.
It's worked well for many months. Recently, though, MANY stocks have a
single day missing out of 11 years of daily data. The SPY downloads
perfectly and is complete.
I'd suspect my code, except that that the same called routine downloads both
the SPY and the others. It has persisted across a couple of days now, and
not all stocks. Here's a list of a few of them: WR, UIL, WBK, WDR, WEC, WM.
12/21/2001 - 12/21/2012. 2/1/2002 is a date that has a SPY value, but not
for any of these stocks. It is a Friday according to DR Google.
If anyone has an idea, I'd certainly appreciate it. I can patch the
download to insert a dummy value, but SHEESH, that seems improper to me J
Thanks!
Thanks,
Pete A
http://www.sundogno
Tidak ada komentar:
Posting Komentar