4 Messages
Digest #4383
Messages
Sun Aug 12, 2018 8:36 am (PDT) . Posted by:
sjagers
For the past 3-4 weeks, I've been having intermittent problems getting stock price history with smfpricesbydates, smfgetyahoohistory and smfpricesbetween. One minute they work fine, but an hour later they don't.... or vice versa.
For example: Yesterday morning (Saturday, 8/11/18, around 9:30am), I tried to get 10 different dates of price history for NVDA (Nvidia). All 3 formulas failed; returning blank cells, 0's, or an Error. I ran the smf recalculate worksheet macro, but that didn't help. An hour or two later, I tried the formulas again and this time they worked fine.
The problem seems to occur, the most often, on Friday night and Saturday, but not always.
Does anyone else experience this problem? Could this be a Yahoo day-of-week or time-of-day maintenance issue? Would clearing internet cache files and temp files help? Restarting Excel? Or, a PC restart? I think my internet connection is good.
My PC is running Windows 10 Home, Excel 2007, and smf add-in version 2.1.2018.01.24.
Thanks.
For example: Yesterday morning (Saturday, 8/11/18, around 9:30am), I tried to get 10 different dates of price history for NVDA (Nvidia). All 3 formulas failed; returning blank cells, 0's, or an Error. I ran the smf recalculate worksheet macro, but that didn't help. An hour or two later, I tried the formulas again and this time they worked fine.
The problem seems to occur, the most often, on Friday night and Saturday, but not always.
Does anyone else experience this problem? Could this be a Yahoo day-of-week or time-of-day maintenance issue? Would clearing internet cache files and temp files help? Restarting Excel? Or, a PC restart? I think my internet connection is good.
My PC is running Windows 10 Home, Excel 2007, and smf add-in version 2.1.2018.01.
Thanks.
Sun Aug 12, 2018 8:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Both smfPricesByDates() and smfPricesBetween() call smfGetYahooHistory(),
so if it is having problems, so will they.
Are you doing a large number of requests? It could be that Yahoo is doing
some type of throttling. I've run into it on other websites, where a
captcha starts coming up, to verify it's not a bunch of automated requests.
And the suspension is only in place for a limited time.
But it certainly could be some kind of maintenance cycle issue...
Have you tried doing a request in a browser, to see if it returns data?
On Sun, Aug 12, 2018 at 8:36 AM, sjagers@
....
wrote:
>
> For the past 3-4 weeks, I've been having intermittent problems getting
> stock price history with smfpricesbydates, smfgetyahoohistory and
> smfpricesbetween. One minute they work fine, but an hour later they
> don't.... or vice versa.
>
> For example: Yesterday morning (Saturday, 8/11/18, around 9:30am), I
> tried to get 10 different dates of price history for NVDA (Nvidia). All 3
> formulas failed; returning blank cells, 0's, or an Error. I ran the smf
> recalculate worksheet macro, but that didn't help. An hour or two later, I
> tried the formulas again and this time they worked fine.
>
> The problem seems to occur, the most often, on Friday night and Saturday,
> but not always.
>
> Does anyone else experience this problem? Could this be a Yahoo
> day-of-week or time-of-day maintenance issue? Would clearing internet
> cache files and temp files help? Restarting Excel? Or, a PC restart? I
> think my internet connection is good.
>
> My PC is running Windows 10 Home, Excel 2007, and smf add-in version
> 2.1.2018.01.24.
>
>
so if it is having problems, so will they.
Are you doing a large number of requests? It could be that Yahoo is doing
some type of throttling. I've run into it on other websites, where a
captcha starts coming up, to verify it's not a bunch of automated requests.
And the suspension is only in place for a limited time.
But it certainly could be some kind of maintenance cycle issue...
Have you tried doing a request in a browser, to see if it returns data?
On Sun, Aug 12, 2018 at 8:36 AM, sjagers@
....
wrote:
>
> For the past 3-4 weeks, I've been having intermittent problems getting
> stock price history with smfpricesbydates, smfgetyahoohistory and
> smfpricesbetween. One minute they work fine, but an hour later they
> don't...
>
> For example: Yesterday morning (Saturday, 8/11/18, around 9:30am), I
> tried to get 10 different dates of price history for NVDA (Nvidia). All 3
> formulas failed; returning blank cells, 0's, or an Error. I ran the smf
> recalculate worksheet macro, but that didn't help. An hour or two later, I
> tried the formulas again and this time they worked fine.
>
> The problem seems to occur, the most often, on Friday night and Saturday,
> but not always.
>
> Does anyone else experience this problem? Could this be a Yahoo
> day-of-week or time-of-day maintenance issue? Would clearing internet
> cache files and temp files help? Restarting Excel? Or, a PC restart? I
> think my internet connection is good.
>
> My PC is running Windows 10 Home, Excel 2007, and smf add-in version
> 2.1.2018.01.
>
>
Sun Aug 12, 2018 6:00 pm (PDT) . Posted by:
sjagers
Hi Randy,
Thanks for the quick reply. Yes, I pull price data for a large number of symbols once or twice a week. I've done this for several years and it's never been an issue until now. I force the recalculation with your macro after 150 symbols, thinking that might prevent Yahoo's throttling (if they do that). Sometimes it helps, but sometimes it doesn't. Because most of my requests are made Friday evening and Saturday morning, I have a hunch the problem is a Yahoo maintenance or server issue, but that's just a guess.
Good suggestion about making the request in a browser the next time it happens. Do you suggest I try that with Excel's built-in Web Query, or directly from Yahoo Finance > symbol quote > historical price tab?
Thanks.
Thanks for the quick reply. Yes, I pull price data for a large number of symbols once or twice a week. I've done this for several years and it's never been an issue until now. I force the recalculation with your macro after 150 symbols, thinking that might prevent Yahoo's throttling (if they do that). Sometimes it helps, but sometimes it doesn't. Because most of my requests are made Friday evening and Saturday morning, I have a hunch the problem is a Yahoo maintenance or server issue, but that's just a guess.
Good suggestion about making the request in a browser the next time it happens. Do you suggest I try that with Excel's built-in Web Query, or directly from Yahoo Finance > symbol quote > historical price tab?
Thanks.
Sun Aug 12, 2018 6:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The built-in IE object would be more conclusive. But if it's an issue with
the site, or an IP block, the browser should be sufficient.
The add-in extracts the data from the JSON data within the web page, so it
should be there if the web page displays properly.
On Sun, Aug 12, 2018 at 6:00 PM, sjagers@
....
wrote:
>
> Thanks for the quick reply. Yes, I pull price data for a large number of
> symbols once or twice a week. I've done this for several years and it's
> never been an issue until now. I force the recalculation with your macro
> after 150 symbols, thinking that might prevent Yahoo's throttling (if they
> do that). Sometimes it helps, but sometimes it doesn't. Because most of
> my requests are made Friday evening and Saturday morning, I have a hunch
> the problem is a Yahoo maintenance or server issue, but that's just a guess.
>
> Good suggestion about making the request in a browser the next time it
> happens. Do you suggest I try that with Excel's built-in Web Query, or
> directly from Yahoo Finance > symbol quote > historical price tab?
>
>
the site, or an IP block, the browser should be sufficient.
The add-in extracts the data from the JSON data within the web page, so it
should be there if the web page displays properly.
On Sun, Aug 12, 2018 at 6:00 PM, sjagers@
....
wrote:
>
> Thanks for the quick reply. Yes, I pull price data for a large number of
> symbols once or twice a week. I've done this for several years and it's
> never been an issue until now. I force the recalculation with your macro
> after 150 symbols, thinking that might prevent Yahoo's throttling (if they
> do that). Sometimes it helps, but sometimes it doesn't. Because most of
> my requests are made Friday evening and Saturday morning, I have a hunch
> the problem is a Yahoo maintenance or server issue, but that's just a guess.
>
> Good suggestion about making the request in a browser the next time it
> happens. Do you suggest I try that with Excel's built-in Web Query, or
> directly from Yahoo Finance > symbol quote > historical price tab?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar