Jumat, 16 September 2016

[smf_addin] Digest Number 3797

3 Messages

Digest #3797
1a
Re: Sent from Snipping Tool by "Dennis Sesar" dennis@zis.com
2a
2b
Re: smfGetOptionExpirations by "Randy Harmelink" rharmelink

Messages

Thu Sep 15, 2016 1:39 pm (PDT) . Posted by:

"Dennis Sesar" dennis@zis.com

Thanks Randy, Worked like a charm :)

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, September 08, 2016 3:57 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Sent from Snipping Tool

The only file you need to unblock is the XLA file.

On Thu, Sep 8, 2016 at 3:20 PM, 'Dennis Sesar' dennis@zis.com <mailto:dennis@zis.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

I unblocked all of these and experienced no difference

Thu Sep 15, 2016 1:56 pm (PDT) . Posted by:

johnross999

I am using the =smfGetOptionExpirations("AAPL","Y") function to find all the available options expiration for Apple for from Yahoo. On one spreadsheet the output is:
23-09-16
30-09-16
07-10-16
14-10-16
21-10-16
28-10-16
18-11-16
16-12-16
20-01-17
17-02-17
17-03-17
21-04-17
16-06-17
17-11-17
19-01-18
18-01-19
While on the other the 28-10-16 is missing.

I restarted excel and the computer too. Nothing changed.
I also tried using Google and OX. Different results but when returning to Yahoo still the same - the 28-10-16 is missing. Tried in third spreadsheet - same like in the first - all fine.

I am wondering if there is a way to "refresh" the other excel spreadsheet so it will re-fetch the data properly.


Fri Sep 16, 2016 12:52 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Do you have your IE options set up to always get a new copy of the web
page? I could be that IE is the one caching the web pages.

On the machine where you're missing the date, check this page in your
browser:

http://finance.yahoo.com/quote/AAPL/options

...and see if the drop-down box has the date in it. That's where the add-in
is grabbing the dates from.

On Thu, Sep 15, 2016 at 1:56 PM, johnrr9@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am using the =smfGetOptionExpirations("AAPL","Y") function to find all
> the available options expiration for Apple for from Yahoo. On one
> spreadsheet the output is:
> 23-09-16
> 30-09-16
> 07-10-16
> 14-10-16
> 21-10-16
> 28-10-16
> 18-11-16
> 16-12-16
> 20-01-17
> 17-02-17
> 17-03-17
> 21-04-17
> 16-06-17
> 17-11-17
> 19-01-18
> 18-01-19
> While on the other the 28-10-16 is missing.
>
> I restarted excel and the computer too. Nothing changed.
> I also tried using Google and OX. Different results but when returning to
> Yahoo still the same - the 28-10-16 is missing. Tried in third spreadsheet
> - same like in the first - all fine.
>
> I am wondering if there is a way to "refresh" the other excel spreadsheet
> so it will re-fetch the data properly.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar