7 Messages
Digest #3764
1b
Re: Good news for option quotes users ... possible smfGetYahooPortfo by "Randy Harmelink" rharmelink
Messages
Mon Aug 8, 2016 11:49 am (PDT) . Posted by:
garyhartling
This sounds pretty good to me. When will it be available to try?
Mon Aug 8, 2016 12:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Soon. I'm still finding out things each time I try something new with it.
And I've been finding issues with normal retrieval of Yahoo option quotes
as well, because Yahoo has changed things since the recent change. *sigh*
On Mon, Aug 8, 2016 at 11:49 AM, Gary.Hartling@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> This sounds pretty good to me. When will it be available to try?
>
And I've been finding issues with normal retrieval of Yahoo option quotes
as well, because Yahoo has changed things since the recent change. *sigh*
On Mon, Aug 8, 2016 at 11:49 AM, Gary.Hartling@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> This sounds pretty good to me. When will it be available to try?
>
Mon Aug 8, 2016 11:55 am (PDT) . Posted by:
markknutson2005
I'm trying to get the Earning Growth Rate for next Quarter for a company and the S&P 500. Im trying to use elements 605 and 608. These are still listed in the sheet with all the elements in the add in folder. Are these obsolete? If not can you give an example of their use? I might have their syntax wrong.
Thanks, Mark
Thanks, Mark
Mon Aug 8, 2016 12:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They're working fine here:
=RCHGetElementNumber("MMM",605)
=RCHGetElementNumber("MMM",608)
However, I note the element definitions uses this URL:
http://finance.yahoo.com/q/ae?s=MMM
...which in my browser gets redirected to this URL:
http://finance.yahoo.com/quote/MMM/analysts?ltr=1
...and that latter page doesn't have a number for S&P 500 growth, but I am
getting a value returned. Weird.
Seem when we've had redirection issues in the past, the AdvFN cross-domains
setting seemed to fix it, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/10464
On Mon, Aug 8, 2016 at 11:55 AM, mknu@juno.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I'm trying to get the Earning Growth Rate for next Quarter for a company
> and the S&P 500. Im trying to use elements 605 and 608. These are still
> listed in the sheet with all the elements in the add in folder. Are these
> obsolete? If not can you give an example of their use? I might have their
> syntax wrong.
>
>
=RCHGetElementNumber("MMM",605)
=RCHGetElementNumber("MMM",608)
However, I note the element definitions uses this URL:
http://finance.yahoo.com/q/ae?s=MMM
...which in my browser gets redirected to this URL:
http://finance.yahoo.com/quote/MMM/analysts?ltr=1
...and that latter page doesn't have a number for S&P 500 growth, but I am
getting a value returned. Weird.
Seem when we've had redirection issues in the past, the AdvFN cross-domains
setting seemed to fix it, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/10464
On Mon, Aug 8, 2016 at 11:55 AM, mknu@juno.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I'm trying to get the Earning Growth Rate for next Quarter for a company
> and the S&P 500. Im trying to use elements 605 and 608. These are still
> listed in the sheet with all the elements in the add in folder. Are these
> obsolete? If not can you give an example of their use? I might have their
> syntax wrong.
>
>
Mon Aug 8, 2016 1:41 pm (PDT) . Posted by:
dnunn0
Thanks for the quick reply, Randy! The odd characters don't show up for me for some reason...
I found that my trouble is that for VBA I had "Break on All Errors" set. Changing this to "Break on Unhandled Errors" (Tools, Options, General) fixed things.
I also don't need to change the Trusted Locations setting, just unblocking appears to do the trick.
The error that is causing the break is trying to convert "AAPL" into a Decimal. The URL is
http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=ssl1d1t1c1ohgv&e=.ignore
RCHGetYahooQuotes fails when it calls smfConvertData with s2="AAPL" (and the double s doesn't matter since it just fails twice before finding the price).
It's a wonderful tool--thank you for creating and maintaining it!
I found that my trouble is that for VBA I had "Break on All Errors" set. Changing this to "Break on Unhandled Errors" (Tools, Options, General) fixed things.
I also don't need to change the Trusted Locations setting, just unblocking appears to do the trick.
The error that is causing the break is trying to convert "AAPL" into a Decimal. The URL is
http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=ssl1d1t1c1ohgv&e=.ignore
RCHGetYahooQuotes fails when it calls smfConvertData with s2="AAPL" (and the double s doesn't matter since it just fails twice before finding the price).
It's a wonderful tool--thank you for creating and maintaining it!
Mon Aug 8, 2016 3:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's why the code says to "Resume next" if there is an error. If there's
an error tying to convert it to a number, it just leaves the string alone
and returns it as it was passed.
On Mon, Aug 8, 2016 at 1:40 PM, dnunn0@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The error that is causing the break is trying to convert "AAPL" into a
> Decimal. The URL is
> http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=ssl1
> d1t1c1ohgv&e=.ignore
> RCHGetYahooQuotes fails when it calls smfConvertData with s2="AAPL" (and
> the double s doesn't matter since it just fails twice before finding the
> price).
>
an error tying to convert it to a number, it just leaves the string alone
and returns it as it was passed.
On Mon, Aug 8, 2016 at 1:40 PM, dnunn0@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The error that is causing the break is trying to convert "AAPL" into a
> Decimal. The URL is
> http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=ssl1
> d1t1c1ohgv&e=
> RCHGetYahooQuotes fails when it calls smfConvertData with s2="AAPL" (and
> the double s doesn't matter since it just fails twice before finding the
> price).
>
Tue Aug 9, 2016 2:01 am (PDT) . Posted by:
beatnut8827
H,
I had some weird prblem with the pkug and had to remove and add the addin back in. in the process I Lost the SMF menu item from the context-menu in Excel - the one with that allosw you to select whether to recalculate the selection workbook etc.
Looking for help in getting back.
Thanks
Neil in Sydney
I had some weird prblem with the pkug and had to remove and add the addin back in. in the process I Lost the SMF menu item from the context-menu in Excel - the one with that allosw you to select whether to recalculate the selection workbook etc.
Looking for help in getting back.
Thanks
Neil in Sydney
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar