3 Messages
Digest #3797
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
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.
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.
>
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 =smfGetOptionExpira
> 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:
Posting Komentar