6 Messages
Digest #4082
Messages
Thu Jul 6, 2017 12:05 am (PDT) . Posted by:
another_investor
Hi Randy,
Since the beginning of the week, the new, beta smfGetYahooHistory function does not appear to be retrieving the array fully when using an end-date greater than the 2nd July - i.e. the Yahoo History array seems to have a break-point at the end of June.
Using your example workbook "smfGetYahooHistory-Example-By-Parameter" as a baseline, with the following parameters works fine (as does any end-date parameter before it).
Ticker: NL Start date: 2017-01-01 End date: 2017-07-02 Period: d Items: dohlcvufgx Names: 1 Resort: 0
However, once the end-date is the 3rd July (first valid July trading date) or higher, the array retrieves data only until the beginning of July .
Ticker: NL Start date: 2017-01-01 End date: 2017-07-06 Period: d Items: dohlcvufgx Names: 1 Resort: 0
Of the 64 stocks I reviewed today, it worked successfully for 24 (ERJ, CBI, STX, AMAG) ... but fails for 40 such as MTL, GFI.
Any comments or thoughts on this would be appreciated greatly.
Thanks for all your hardwork!
Steve
Since the beginning of the week, the new, beta smfGetYahooHistory function does not appear to be retrieving the array fully when using an end-date greater than the 2nd July - i.e. the Yahoo History array seems to have a break-point at the end of June.
Using your example workbook "smfGetYahooHi
Ticker: NL Start date: 2017-01-01 End date: 2017-07-02 Period: d Items: dohlcvufgx Names: 1 Resort: 0
However, once the end-date is the 3rd July (first valid July trading date) or higher, the array retrieves data only until the beginning of July .
Ticker: NL Start date: 2017-01-01 End date: 2017-07-06 Period: d Items: dohlcvufgx Names: 1 Resort: 0
Of the 64 stocks I reviewed today, it worked successfully for 24 (ERJ, CBI, STX, AMAG) ... but fails for 40 such as MTL, GFI.
Any comments or thoughts on this would be appreciated greatly.
Thanks for all your hardwork!
Steve
Thu Jul 6, 2017 2:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried MTL and GFI and am getting data for 7/3 and 7/5. However, the
6/30 data looks bad. It has zero volume and the H/L/O/C are all the
previous day's close. But when I check the web site, that's because
H/L/O/C/V all have zero values for 6/30, so smfGetYahooHistory() is filling
in as I decided to have it do for null or zero values.
I tried ERJ, CBI, STX, and AMAG, as well as my usual MMM -- looks like good
data for 6/30, 7/3 and 7/5 on all of them.
So I suspect those 40 had some problem getting loaded on the Yahoo
databases? And maybe they finally added the 7/3 and 7/5 data, but didn't
get the 6/30 data fixed?
Another possibility is that you need to see the Internet Options to always
get a fresh copy of a web page. It could be you have cached copies of those
40 tickers that had errors?
However, my bet would be on a Yahoo data issue, since the 6/30 data is
still bad for the two you mentioned that weren't loading. You can check to
see if you're seeing what I see now from the function and online -- 7/3 and
7/5 data, but zero volume on 6/30?
Right now when I click the "Download Data" button on the historical quotes
page for MTL, I do get all nulls for 6/30 when it opens up into EXCEL.
On Thu, Jul 6, 2017 at 12:05 AM, steviejacobs@
...
wrote:
>
> Since the beginning of the week, the new, beta smfGetYahooHistory function
> does not appear to be retrieving the array fully when using an end-date
> greater than the 2nd July - i.e. the Yahoo History array seems to have a
> break-point at the end of June.
>
> Using your example workbook "smfGetYahooHistory-Example-By-Parameter" as
> a baseline, with the following parameters works fine (as does any end-date
> parameter before it).
>
> Ticker: NL Start date: 2017-01-01 End date: 2017-07-06 Period: d Items:
> dohlcvufgx Names: 1 Resort: 0
> Of the 64 stocks I reviewed today, it worked successfully for 24 (ERJ,
> CBI, STX, AMAG) ... but fails for 40 such as MTL, GFI.
>
> Any comments or thoughts on this would be appreciated greatly.
>
6/30 data looks bad. It has zero volume and the H/L/O/C are all the
previous day's close. But when I check the web site, that's because
H/L/O/C/V all have zero values for 6/30, so smfGetYahooHistory(
in as I decided to have it do for null or zero values.
I tried ERJ, CBI, STX, and AMAG, as well as my usual MMM -- looks like good
data for 6/30, 7/3 and 7/5 on all of them.
So I suspect those 40 had some problem getting loaded on the Yahoo
databases? And maybe they finally added the 7/3 and 7/5 data, but didn't
get the 6/30 data fixed?
Another possibility is that you need to see the Internet Options to always
get a fresh copy of a web page. It could be you have cached copies of those
40 tickers that had errors?
However, my bet would be on a Yahoo data issue, since the 6/30 data is
still bad for the two you mentioned that weren't loading. You can check to
see if you're seeing what I see now from the function and online -- 7/3 and
7/5 data, but zero volume on 6/30?
Right now when I click the "Download Data" button on the historical quotes
page for MTL, I do get all nulls for 6/30 when it opens up into EXCEL.
On Thu, Jul 6, 2017 at 12:05 AM, steviejacobs@
...
wrote:
>
> Since the beginning of the week, the new, beta smfGetYahooHistory function
> does not appear to be retrieving the array fully when using an end-date
> greater than the 2nd July - i.e. the Yahoo History array seems to have a
> break-point at the end of June.
>
> Using your example workbook "smfGetYahooHi
> a baseline, with the following parameters works fine (as does any end-date
> parameter before it).
>
> Ticker: NL Start date: 2017-01-01 End date: 2017-07-06 Period: d Items:
> dohlcvufgx Names: 1 Resort: 0
> Of the 64 stocks I reviewed today, it worked successfully for 24 (ERJ,
> CBI, STX, AMAG) ... but fails for 40 such as MTL, GFI.
>
> Any comments or thoughts on this would be appreciated greatly.
>
Thu Jul 6, 2017 8:44 am (PDT) . Posted by:
another_investor
Many thanks for checking Randy.
My Internet Options appear to be fine since I have checked the results on multiple PC's and on multiple networks (home, mobile, office etc.)
I agree with your conclusion on it being a data issue on Yahoo Finance. In the case of MTL, you can see the missing entry on the candlestick chart for the 30th June 2017 too.
The data appears to be missing/corrupt for quite a few stocks (only 10 of 37 I looked at today had complete data). Stocks with missing 30th June data from today's quick analysis include CVRR, SND, WRD, COE, ELP, MPO, HCLP, CIG, CMRE, GSS, OZM, CNXC, LCI, OFG, MPAA, SYNT.
Interestingly, ticker RRD is missing data for the 27th Jun rather than the 30th.
Hopefully in time Yahoo will address the corrupt missing data.
Is there anything that can be built into the smfGetYahooHistory function so that it does not stop when it encounters these null rows?
Have a good day! :)
Steve
My Internet Options appear to be fine since I have checked the results on multiple PC's and on multiple networks (home, mobile, office etc.)
I agree with your conclusion on it being a data issue on Yahoo Finance. In the case of MTL, you can see the missing entry on the candlestick chart for the 30th June 2017 too.
The data appears to be missing/corrupt for quite a few stocks (only 10 of 37 I looked at today had complete data). Stocks with missing 30th June data from today's quick analysis include CVRR, SND, WRD, COE, ELP, MPO, HCLP, CIG, CMRE, GSS, OZM, CNXC, LCI, OFG, MPAA, SYNT.
Interestingly, ticker RRD is missing data for the 27th Jun rather than the 30th.
Hopefully in time Yahoo will address the corrupt missing data.
Is there anything that can be built into the smfGetYahooHistory function so that it does not stop when it encounters these null rows?
Have a good day! :)
Steve
Thu Jul 6, 2017 9:02 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Mine doesn't stop when it hits null rows, it does what I programmed
it to do -- fill forward from the previous closing price. That is:
Ticker: MTL *Date* *Open* *High* *Low* *Close* *Volume* *Unadj*
Start date: 2017-01-01 2017-07-06 $4.7900 $4.8300 $4.7200 $4.7800 37145
$4.7800
End date: 2017-07-06 2017-07-03 $4.6500 $4.7400 $4.6400 $4.7200 53000
$4.7200
Period: d 2017-06-30 $4.6000 $4.6000 $4.6000 $4.6000 0 $4.6000
Items: dohlcvufgx 2017-06-29 $4.7400 $4.7400 $4.5000 $4.6000 190400
$4.6000
Names: 1 2017-06-28 $4.6200 $4.7700 $4.5700 $4.7000 114800 $4.7000
Resort: 0 2017-06-27 $4.5500 $4.6400 $4.5300 $4.5600 107800 $4.5600
2017-06-30 is the date with nulls, but the add-in filled in O/H/L/C with
the closing price from 2017-06-29. The only reason I know it carried
forward is the zero for the volume.
Note the 7/5 is missing there. But it's also missing from the historical
quotes when I go to the web page. So another Yahoo glitch.
For me, RRD historical quotes begin with 6/28 (on the web site and with
the add-in). But it does show dividends from earlier dates. So definitely a
Yahoo glitch.
On Thu, Jul 6, 2017 at 8:44 AM, steviejacobs@
...
wrote:
>
>
> Many thanks for checking Randy.
> My Internet Options appear to be fine since I have checked the results on
> multiple PC's and on multiple networks (home, mobile, office etc.)
>
> I agree with your conclusion on it being a data issue on Yahoo Finance. In
> the case of MTL, you can see the missing entry on the candlestick chart for
> the 30th June 2017 too.
> The data appears to be missing/corrupt for quite a few stocks (only 10 of
> 37 I looked at today had complete data). Stocks with missing 30th June data
> from today's quick analysis include CVRR, SND, WRD, COE, ELP, MPO, HCLP,
> CIG, CMRE, GSS, OZM, CNXC, LCI, OFG, MPAA, SYNT.
> Interestingly, ticker RRD is missing data for the 27th Jun rather than the
> 30th.
>
> Hopefully in time Yahoo will address the corrupt missing data.
> Is there anything that can be built into the smfGetYahooHistory function
> so that it does not stop when it encounters these null rows?
>
> Have a good day! :)
>
>
it to do -- fill forward from the previous closing price. That is:
Ticker: MTL *Date* *Open* *High* *Low* *Close* *Volume* *Unadj*
Start date: 2017-01-01 2017-07-06 $4.7900 $4.8300 $4.7200 $4.7800 37145
$4.7800
End date: 2017-07-06 2017-07-03 $4.6500 $4.7400 $4.6400 $4.7200 53000
$4.7200
Period: d 2017-06-30 $4.6000 $4.6000 $4.6000 $4.6000 0 $4.6000
Items: dohlcvufgx 2017-06-29 $4.7400 $4.7400 $4.5000 $4.6000 190400
$4.6000
Names: 1 2017-06-28 $4.6200 $4.7700 $4.5700 $4.7000 114800 $4.7000
Resort: 0 2017-06-27 $4.5500 $4.6400 $4.5300 $4.5600 107800 $4.5600
2017-06-30 is the date with nulls, but the add-in filled in O/H/L/C with
the closing price from 2017-06-29. The only reason I know it carried
forward is the zero for the volume.
Note the 7/5 is missing there. But it's also missing from the historical
quotes when I go to the web page. So another Yahoo glitch.
For me, RRD historical quotes begin with 6/28 (on the web site and with
the add-in). But it does show dividends from earlier dates. So definitely a
Yahoo glitch.
On Thu, Jul 6, 2017 at 8:44 AM, steviejacobs@
...
wrote:
>
>
> Many thanks for checking Randy.
> My Internet Options appear to be fine since I have checked the results on
> multiple PC's and on multiple networks (home, mobile, office etc.)
>
> I agree with your conclusion on it being a data issue on Yahoo Finance. In
> the case of MTL, you can see the missing entry on the candlestick chart for
> the 30th June 2017 too.
> The data appears to be missing/corrupt for quite a few stocks (only 10 of
> 37 I looked at today had complete data). Stocks with missing 30th June data
> from today's quick analysis include CVRR, SND, WRD, COE, ELP, MPO, HCLP,
> CIG, CMRE, GSS, OZM, CNXC, LCI, OFG, MPAA, SYNT.
> Interestingly, ticker RRD is missing data for the 27th Jun rather than the
> 30th.
>
> Hopefully in time Yahoo will address the corrupt missing data.
> Is there anything that can be built into the smfGetYahooHistory function
> so that it does not stop when it encounters these null rows?
>
> Have a good day! :)
>
>
Thu Jul 6, 2017 2:45 pm (PDT) . Posted by:
lapub1
Hi Randy,
I uploaded the beta XLA, Are most yahoo key stats still obsolete as I get errors retrieving 987, and 583. I cant figure it out from the strings on the board; what's current and what isn't.
Thanks.
Elliot.
I uploaded the beta XLA, Are most yahoo key stats still obsolete as I get errors retrieving 987, and 583. I cant figure it out from the strings on the board; what's current and what isn't.
Thanks.
Elliot.
Thu Jul 6, 2017 4:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Elements 583 (not a key statistic) and 987 are both working here.
I tried MMM with these two templates from the web site and got data that
looked good:
RCHGetElementNumber-Template-Yahoo-Key-Statistics.xls
SMF-Template-Yahoo-Analyst-Estimates.xls
There are a few obsolete elements, just because Yahoo no longer has them on
their web pages.
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",583)
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=MMM",3,">No. of
analysts")
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=MMM",0,">No. of
analysts")
=smfGetYahooJSONField("MMM","earningsTrend","quoteSummary.result.0.earningsTrend.trend.2.earningsEstimate.numberOfAnalysts.raw")
On Thu, Jul 6, 2017 at 2:45 PM, lapub1@
...
wrote:
> I uploaded the beta XLA, Are most yahoo key stats still obsolete as I get
> errors retrieving 987, and 583. I cant figure it out from the strings on
> the board; what's current and what isn't.
>
I tried MMM with these two templates from the web site and got data that
looked good:
RCHGetElementNumber-Template-Yahoo-Key-Statistics.xls
SMF-Template-Yahoo-Analyst-Estimates.xls
There are a few obsolete elements, just because Yahoo no longer has them on
their web pages.
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",583)
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=MMM",3,">No. of
analysts")
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=MMM",0,"
analysts"
=smfGetYahooJSONFie
On Thu, Jul 6, 2017 at 2:45 PM, lapub1@
...
wrote:
> I uploaded the beta XLA, Are most yahoo key stats still obsolete as I get
> errors retrieving 987, and 583. I cant figure it out from the strings on
> the board; what's current and what isn't.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar