Are you using the latest element definitions? I recently updated all of the
Yahoo URLs from the "http://" protocols to "https://". It may be Yahoo's
change of protocol that stopped your extractions from working.

On Fri, Apr 28, 2017 at 7:53 PM, thomas.strouse@
...wrote:

>
> I tried MMM, AAPL, COH. No ticker works. However, if I change the call
> to =RCHGetElementNumber(Ticker, 13865), (i.e., sector name), it works
> fine!!??
>
> On Fri, Apr 28, 2017 at 8:18 PM, thomas.strouse@
...wrote:

>
>
> The response I get is, "Error"
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2a

=smfGetOptionExpirations()

Fri Apr 28, 2017 9:30 pm (PDT) . Posted by:

cyy001

Sorry to keep bothering you. I wish I can debug this myself.

=smfGetOptionExpirations("EBAY","Y") returns 5/5/2017 properly

But
=smfGetOptionExpirations("SBUX","Y") returns blank. If I put the formula in an Excel array, it has "None" in the very bottom of the array (the 20th row)

I checked Yahoo
The https://finance.yahoo.com/quote/SBUX/options?p=SBUX https://finance.yahoo.com/quote/SBUX/options?p=SBUX page shows the list of option expiry dates and info properly.

Thanks for all your help.

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2b

Re: =smfGetOptionExpirations()

Fri Apr 28, 2017 10:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Odd. I tried EBAY. It worked. Then I tried SBUX. It did not. When I
followed it through the VBA code, it worked fine.

The add-in actually uses this JSON file:

https://query2.finance.yahoo.com/v7/finance/options/SBUX

...which has the list of expiration dates.

Hmm. Just checked my log file. When SBUX didn't work, it apparently timed
out. So maybe Yahoo is having issues tonight? When you got the "None"
result, did it take a while to have it returned? Normally, the JSON file is
retrieved in less than half a second.

On Fri, Apr 28, 2017 at 9:30 PM, cyy001@ wrote:

> Sorry to keep bothering you. I wish I can debug this myself.
>
> =smfGetOptionExpirations("EBAY","Y") returns 5/5/2017 properly
>
> But
>
> =smfGetOptionExpirations("SBUX","Y") returns blank. If I put the formula
> in an Excel array, it has "None" in the very bottom of the array (the 20th
> row)
>
> I checked Yahoo
>
> The https://finance.yahoo.com/quote/SBUX/options?p=SBUX page shows the
> list of option expiry dates and info properly.
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2c

Re: =smfGetOptionExpirations()

Fri Apr 28, 2017 10:37 pm (PDT) . Posted by:

"Charles Young" cyy001

The excel array executed and returns None almost instantaneously. So, it
looks like the json query was returned. Can it be that the json was
malformed?
Thanks

On Fri, Apr 28, 2017 at 10:22 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Odd. I tried EBAY. It worked. Then I tried SBUX. It did not. When I
> followed it through the VBA code, it worked fine.
>
> The add-in actually uses this JSON file:
>
> https://query2.finance.yahoo.com/v7/finance/options/SBUX
>
> ...which has the list of expiration dates.
>
> Hmm. Just checked my log file. When SBUX didn't work, it apparently timed
> out. So maybe Yahoo is having issues tonight? When you got the "None"
> result, did it take a while to have it returned? Normally, the JSON file is
> retrieved in less than half a second.
>
>
> On Fri, Apr 28, 2017 at 9:30 PM, cyy001@ wrote:
>
>> Sorry to keep bothering you. I wish I can debug this myself.
>>
>> =smfGetOptionExpirations("EBAY","Y") returns 5/5/2017 properly
>>
>> But
>>
>> =smfGetOptionExpirations("SBUX","Y") returns blank. If I put the formula
>> in an Excel array, it has "None" in the very bottom of the array (the 20th
>> row)
>>
>> I checked Yahoo
>>
>> The https://finance.yahoo.com/quote/SBUX/options?p=SBUX page shows the
>> list of option expiry dates and info properly.
>>
>>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2d

Re: =smfGetOptionExpirations()

Fri Apr 28, 2017 10:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Did you use the smfForceRecalculation function? Otherwise, it just
re-extracts from the errored out page it already retrieved...which would
occur very quickly. It's why the add-in saves web pages before extracting
data. So multiple extractions don't get bogged down with continually
re-retrieving web pages for each function invocation.

On Fri, Apr 28, 2017 at 10:36 PM, Charles Young cyy001@
...wrote:

>
> The excel array executed and returns None almost instantaneously. So, it
> looks like the json query was returned. Can it be that the json was
> malformed?
> Thanks
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2e

Re: =smfGetOptionExpirations()

Fri Apr 28, 2017 11:47 pm (PDT) . Posted by:

"Charles Young" cyy001

When it wasn't working, the first thing I did was to use the
smfForceRecalculation() and it didn't fix anything.

I just tried it again and it is now working. So, it must be a glitch on
Yahoo's site.

How often do I have to use smfForceRecalcuation()? Do I need to do it every
time I want to update the option prices? Hopefully not since it makes all
my Excel SS unresponsive and takes a minute or two for the Excel to finish.

Thank you for your quick responses and have a good weekend.

On Fri, Apr 28, 2017 at 10:54 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Did you use the smfForceRecalculation function? Otherwise, it just
> re-extracts from the errored out page it already retrieved...which would
> occur very quickly. It's why the add-in saves web pages before extracting
> data. So multiple extractions don't get bogged down with continually
> re-retrieving web pages for each function invocation.
>
> On Fri, Apr 28, 2017 at 10:36 PM, Charles Young cyy001@
> ...wrote:
>
>
>> The excel array executed and returns None almost instantaneously. So, it
>> looks like the json query was returned. Can it be that the json was
>> malformed?
>> Thanks
>>
>>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2f

Re: =smfGetOptionExpirations()

Sat Apr 29, 2017 12:13 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You should only NEED to use the smfForceRecalculation macro when you WANT
to refresh things. However, if the data sources or communications are
spotty, all bets are off...

These days, I'm usually adding a cell that allows me to change the data
source. That way, if a site gets flaky, I can change easily. For example, a
while back barchart.com was giving me problems and I found out their site
was down. So I just changed the cell with my data source over to Yahoo
instead of Barchart. Doesn't help if I want the greeks, but I could get the
quotes...

If I have a worksheet I use often, I will go through the log file to see if
I can remove a bunch of web page retrievals. For example, my "covered call
log" only needs a single Internet call, because it uses the
smfGetYahooPortfolioView() function. It can be a flaky function, and I need
to log in every few days, but it speeds up the day-to-day processing.

But I have noticed Yahoo seems to be a bit spotty these days. Maybe because
of all the JSON calls? :(

On Fri, Apr 28, 2017 at 11:47 PM, Charles Young cyy001@
...wrote:

>
> When it wasn't working, the first thing I did was to use the
> smfForceRecalculation() and it didn't fix anything.
>
> I just tried it again and it is now working. So, it must be a glitch on
> Yahoo's site.
>
> How often do I have to use smfForceRecalcuation()? Do I need to do it
> every time I want to update the option prices? Hopefully not since it makes
> all my Excel SS unresponsive and takes a minute or two for the Excel to
> finish.
>
> Thank you for your quick responses and have a good weekend.
>
>