15 Messages
Digest #3990
Messages
Mon May 1, 2017 7:08 am (PDT) . Posted by:
bungyman2000
A big thanks from me too. I can't imagine what you have to keep up with. Been using this for years, and you continue to amaze.
Mon May 1, 2017 7:31 am (PDT) . Posted by:
yolande_tulasse
Updated to the last version.
Today though, many Yahoo elements are returning "Error" (elements from 941ish to 990ish).
Anyone having the same issue today?
Today though, many Yahoo elements are returning "Error" (elements from 941ish to 990ish).
Anyone having the same issue today?
Mon May 1, 2017 8:50 am (PDT) . Posted by:
another_investor
Same issue - as of today. Was working fine over the weekend.
Mon May 1, 2017 12:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
More Yahoo changes
Hopefully, the latest change will fix all of the "Error" responses in Yahoo
data retrievals.
*Date* *Routine* *Description*
2017-05-01 (Many) Modified routine to retrieve web pages
2017-04-27 smfGetYahooJSONField New experimental function to extract data
by field name from JSON file
Check these website pages for updates:
-- http://ogres-crypt.com/SMF/
-- http://ogres-crypt.com/SMF/Documentation/
New/updated files:
-- RCH_Stock_Market_Functions-2.1.2017.05.01.zip
-- Change-Log.html
-- smfGetYahooJSONField-Function.html
Best practice is to close EXCEL before updating file in the SMF folder.
Hopefully, the latest change will fix all of the "Error" responses in Yahoo
data retrievals.
*Date* *Routine* *Description*
2017-05-01 (Many) Modified routine to retrieve web pages
2017-04-27 smfGetYahooJSONField New experimental function to extract data
by field name from JSON file
Check these website pages for updates:
-- http://ogres-crypt.com/SMF/
-- http://ogres-crypt.com/SMF/Documentation/
New/updated files:
-- RCH_Stock_Market_
-- Change-Log.html
-- smfGetYahooJSONFiel
Best practice is to close EXCEL before updating file in the SMF folder.
Mon May 1, 2017 7:50 am (PDT) . Posted by:
rr76012
Monday 5-1-2017
Re: RchGetElementNumber 621 = Yahoo eps growth rate
Is anyone else getting an error for rchgetelementnumber 621, Yahoo eps estimate growth rate?
Can anyone recommend an rchelelementnumber for eps growth rate?
Thank You.
rr76012
Re: RchGetElementNumber 621 = Yahoo eps growth rate
Is anyone else getting an error for rchgetelementnumber 621, Yahoo eps estimate growth rate?
Can anyone recommend an rchelelementnumber for eps growth rate?
Thank You.
rr76012
Mon May 1, 2017 8:49 am (PDT) . Posted by:
another_investor
Same problem. It was working fine over the weekend (Saturday I think) but stopped working again today.
Basic elements such as the one below (where A1 is ticker symbol) for AAPL, BAC etc. all return error while the Yahoo page contains estimates data.
=RCHGetElementNumber(A1,560)
Basic elements such as the one below (where A1 is ticker symbol) for AAPL, BAC etc. all return error while the Yahoo page contains estimates data.
=RCHGetElementNumbe
Mon May 1, 2017 10:28 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmm. Doesn't work for me today either. Try this:
=smfGetTagContent("https://finance.yahoo.com/quote/
^DJI","span",1,">Dow",,,,1)
On Mon, May 1, 2017 at 8:25 AM, gshell422@
...wrote:
>
> Still results in 'Error'
>
>
=smfGetTagContent("https://finance.yahoo.com/quote/
^DJI","
On Mon, May 1, 2017 at 8:25 AM, gshell422@
...wrote:
>
> Still results in 'Error&#
>
>
Mon May 1, 2017 11:45 am (PDT) . Posted by:
gshell422
Nope. Still returns Error
When I click on the 'Error' in Excel I get the following message:
Unable to open https://finance/yahoo.com/quote/ https://finance/yahoo.com/quote/. The internet site reports that the item you requested could not be found. (HTTP 1.0/ 404)
When I click on the 'Error' in Excel I get the following message:
Unable to open https://finance/yahoo.com/quote/ https://finance/yahoo.com/quote/. The internet site reports that the item you requested could not be found. (HTTP 1.0/ 404)
Mon May 1, 2017 12:35 pm (PDT) . Posted by:
codyklein
yahoo pages that I could download with the Excel web query no longer work so I'm guessing Yahoo is making changes that the web query will not work with. Doesn't the add-in use this method? Yes/No?
The good news is the API still comes in.
The good news is the API still comes in.
Mon May 1, 2017 1:11 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hopefully, this update fixes things:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31909
On Mon, May 1, 2017 at 12:35 PM, codyklein@
...wrote:
>
> yahoo pages that I could download with the Excel web query no longer work
> so I'm guessing Yahoo is making changes that the web query will not work
> with. Doesn't the add-in use this method? Yes/No?
>
> The good news is the API still comes in.
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31909
On Mon, May 1, 2017 at 12:35 PM, codyklein@
...wrote:
>
> yahoo pages that I could download with the Excel web query no longer work
> so I'm guessing Yahoo is making changes that the web query will not work
> with. Doesn't the add-in use this method? Yes/No?
>
> The good news is the API still comes in.
>
>
Mon May 1, 2017 1:11 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hopefully, this update fixes things:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31909
On Mon, May 1, 2017 at 11:45 AM, gshell422@
...wrote:
>
> Nope. Still returns Error
>
> When I click on the 'Error' in Excel I get the following message:
>
> Unable to open https://finance/yahoo.com/quote/. The internet site
> reports that the item you requested could not be found. (HTTP 1.0/ 404)
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31909
On Mon, May 1, 2017 at 11:45 AM, gshell422@
...wrote:
>
> Nope. Still returns Error
>
> When I click on the 'Error' in Excel I get the following message:
>
> Unable to open https://finance/yahoo.com/quote/. The internet site
> reports that the item you requested could not be found. (HTTP 1.0/ 404)
>
>
Mon May 1, 2017 9:41 am (PDT) . Posted by:
"Barry Rosman" bnr0sman
The smfGetYahooOptionQuote has stopped working. It last worked on Friday.
=smfGetYahooOptionQuote(Y2,AB2,Z2,AA2,"l") it returns #NAME?
=smfGetYahooOptionQ
Mon May 1, 2017 12:37 pm (PDT) . Posted by:
wiscobez
Today's update has fixed everything for me. Thanks so much for issuing this latest version !!!!
Mon May 1, 2017 1:13 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
#NAME? usually means the function can't be found. Are you sure the add-in
is activated in the add-in manager?
On Mon, May 1, 2017 at 9:37 AM, Barry Rosman bnr0sman@
...wrote:
>
> The smfGetYahooOptionQuote has stopped working. It last worked on Friday.
>
> =smfGetYahooOptionQuote(Y2,AB2,Z2,AA2,"l") it returns #NAME?
>
>
>
is activated in the add-in manager?
On Mon, May 1, 2017 at 9:37 AM, Barry Rosman bnr0sman@
...wrote:
>
> The smfGetYahooOptionQu
>
> =smfGetYahooOptionQ
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar