3 Messages
Digest #4084
2a
Re: A Google Historical Price function to get around Yahoo fails? by "Randy Harmelink" rharmelink
Messages
Fri Jul 7, 2017 4:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your formula is not getting data from Yahoo, so its not any kind of issue
with Yahoo blocking an IP address.
Your error looks like EXCEL flagged it as an unresolved link, because you
have a folder path in front of your function invocation. You can run the
smfFixLinks macro to remove those unresolved links, and then the function
invocation will use the function it can find it the list of add-ins from
the add-in manager.
Such unresolved links usually occur either because the add-in isn't active
in add-in manager, or the add-in manager is pointing to the add-in in a
different folder location.
On Fri, Jul 7, 2017 at 2:30 PM, eabartsch@
...
wrote:
> Yeah, that is an unfortunate problem. Is there a substitute source for
> the information or a workaround? For example, figure out a way to build
> backwards into the data using a different resource, using a formula
> technique similar to this approach (here, it pulls the 14 Day RSI with an
> HTML call and read):
>
> ='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!smfConvertData('C:\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetWebData("
> https://www.barchart.com/stocks/quotes/" & C31 & "/cheat-sheet","14 Day
> RSI at 30%",200),"""rawValue"":","}"))
>
> This is out of my league. But, Randy may have some ideas. Looks like
> Yahoo is shutting people out.
>
with Yahoo blocking an IP address.
Your error looks like EXCEL flagged it as an unresolved link, because you
have a folder path in front of your function invocation. You can run the
smfFixLinks macro to remove those unresolved links, and then the function
invocation will use the function it can find it the list of add-ins from
the add-in manager.
Such unresolved links usually occur either because the add-in isn't active
in add-in manager, or the add-in manager is pointing to the add-in in a
different folder location.
On Fri, Jul 7, 2017 at 2:30 PM, eabartsch@
...
wrote:
> Yeah, that is an unfortunate problem. Is there a substitute source for
> the information or a workaround? For example, figure out a way to build
> backwards into the data using a different resource, using a formula
> technique similar to this approach (here, it pulls the 14 Day RSI with an
> HTML call and read):
>
> ='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!smfConvertData('C:\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetWebData("
> https://www.barchart.com/stocks/quotes/" & C31 & "/cheat-
> RSI at 30%",200)
>
> This is out of my league. But, Randy may have some ideas. Looks like
> Yahoo is shutting people out.
>
Fri Jul 7, 2017 4:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/32050
On Fri, Jul 7, 2017 at 7:00 AM, tonyestep@
...
wrote:
> Today the Yahoo historical prices are correctly updated for some series
> (QQQ, for example) but not others (SPY, for example). This is true whether
> you get the prices via the SMF function or simply go to the Yahoo Finance
> website and fetch them by hand.
>
>
> Meanwhile, the Google historical prices are correct. I believe that Google
> doesn't allow large automated hits to their data, but perhaps there could
> be an SMF function to grab some Google historical data that could save the
> day when Yahoo fails. I spent some anxious moments this morning manually
> patching a bunch of data......
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/32050
On Fri, Jul 7, 2017 at 7:00 AM, tonyestep@
...
wrote:
> Today the Yahoo historical prices are correctly updated for some series
> (QQQ, for example) but not others (SPY, for example). This is true whether
> you get the prices via the SMF function or simply go to the Yahoo Finance
> website and fetch them by hand.
>
>
> Meanwhile, the Google historical prices are correct. I believe that Google
> doesn't allow large automated hits to their data, but perhaps there could
> be an SMF function to grab some Google historical data that could save the
> day when Yahoo fails. I spent some anxious moments this morning manually
> patching a bunch of data......
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar