Sabtu, 07 November 2015

[smf_addin] Digest Number 3552

8 Messages

Digest #3552
1a
Re: Excel 2016 by "Dean Sawyer" buzzsawyer@rocketmail.com
1b
Re: Excel 2016 by "Frank kirk" nautilustech
1c
Re: Excel 2016 by "Barry Rosman" bnr0sman
2a
2b
Re: Yahoo Options broken by "Randy Harmelink" rharmelink
2c
Re: Yahoo Options broken by "Barry Rosman" bnr0sman
3a
smfGetOptionQuotes by alankc_mok
3b
Re: smfGetOptionQuotes by "Randy Harmelink" rharmelink

Messages

Fri Nov 6, 2015 6:58 am (PST) . Posted by:

"Dean Sawyer" buzzsawyer@rocketmail.com

Doesn't sound like an excel problem as much as an overall system configuration problem that can occur over time with changes.

Sent from my iPhone

> On Nov 6, 2015, at 03:07, Frank kirk nautilustech@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> #NAME? in that situation usually means the add-in hasn't been activated through the add-in manager...
>
> I can assure you that it has been activated. However, the problems I'm having with Excel 2016 extend much further than the SMF Add In. Examples:
>
> 1. Double click on a file doesn't open the file.
> 2. Right click on the file opens 2 copies of Excel, both blank - empty.
> 3. Open a copy of an SMF file to find nothing but #NAME in all cells. Open the exact same file 5 minutes later & all's OK.
>
> I could go on...
>
>
>

Fri Nov 6, 2015 8:33 am (PST) . Posted by:

"Frank kirk" nautilustech



Doesn't sound like an excel problem as much as an overall system configuration problem that can occur over time with changes. 
     I won't deny that.  However, since I've only owned this brand new laptop for less than 60 days, I don't think that it's a "system configuration problem over time". However, I could be wrong, in which case I need further enlightenment. 

Fri Nov 6, 2015 12:44 pm (PST) . Posted by:

"Barry Rosman" bnr0sman

works fine. However options with Yahoo stopped working today.
  From: "Pete A optionzz@outlook.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, November 6, 2015 2:52 AM
Subject: [smf_addin] Re: Excel 2016

 
Re:

Excel 2016

Wed Nov 4, 2015 6:31 pm (PST) . Posted by:

gregory_christy
I am contemplating taking the plunge. Has anyone experienced any issues with SMF after having done so?  Works fine for me!  But I also use 2010 sometimes for the MDI which is missing from 2013 and uu.Pete ATtP-S Investing   #yiv9602994789 #yiv9602994789 -- #yiv9602994789ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9602994789 #yiv9602994789ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9602994789 #yiv9602994789ygrp-mkp #yiv9602994789hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9602994789 #yiv9602994789ygrp-mkp #yiv9602994789ads {margin-bottom:10px;}#yiv9602994789 #yiv9602994789ygrp-mkp .yiv9602994789ad {padding:0 0;}#yiv9602994789 #yiv9602994789ygrp-mkp .yiv9602994789ad p {margin:0;}#yiv9602994789 #yiv9602994789ygrp-mkp .yiv9602994789ad a {color:#0000ff;text-decoration:none;}#yiv9602994789 #yiv9602994789ygrp-sponsor #yiv9602994789ygrp-lc {font-family:Arial;}#yiv9602994789 #yiv9602994789ygrp-sponsor #yiv9602994789ygrp-lc #yiv9602994789hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9602994789 #yiv9602994789ygrp-sponsor #yiv9602994789ygrp-lc .yiv9602994789ad {margin-bottom:10px;padding:0 0;}#yiv9602994789 #yiv9602994789actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9602994789 #yiv9602994789activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9602994789 #yiv9602994789activity span {font-weight:700;}#yiv9602994789 #yiv9602994789activity span:first-child {text-transform:uppercase;}#yiv9602994789 #yiv9602994789activity span a {color:#5085b6;text-decoration:none;}#yiv9602994789 #yiv9602994789activity span span {color:#ff7900;}#yiv9602994789 #yiv9602994789activity span .yiv9602994789underline {text-decoration:underline;}#yiv9602994789 .yiv9602994789attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9602994789 .yiv9602994789attach div a {text-decoration:none;}#yiv9602994789 .yiv9602994789attach img {border:none;padding-right:5px;}#yiv9602994789 .yiv9602994789attach label {display:block;margin-bottom:5px;}#yiv9602994789 .yiv9602994789attach label a {text-decoration:none;}#yiv9602994789 blockquote {margin:0 0 0 4px;}#yiv9602994789 .yiv9602994789bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9602994789 .yiv9602994789bold a {text-decoration:none;}#yiv9602994789 dd.yiv9602994789last p a {font-family:Verdana;font-weight:700;}#yiv9602994789 dd.yiv9602994789last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9602994789 dd.yiv9602994789last p span.yiv9602994789yshortcuts {margin-right:0;}#yiv9602994789 div.yiv9602994789attach-table div div a {text-decoration:none;}#yiv9602994789 div.yiv9602994789attach-table {width:400px;}#yiv9602994789 div.yiv9602994789file-title a, #yiv9602994789 div.yiv9602994789file-title a:active, #yiv9602994789 div.yiv9602994789file-title a:hover, #yiv9602994789 div.yiv9602994789file-title a:visited {text-decoration:none;}#yiv9602994789 div.yiv9602994789photo-title a, #yiv9602994789 div.yiv9602994789photo-title a:active, #yiv9602994789 div.yiv9602994789photo-title a:hover, #yiv9602994789 div.yiv9602994789photo-title a:visited {text-decoration:none;}#yiv9602994789 div#yiv9602994789ygrp-mlmsg #yiv9602994789ygrp-msg p a span.yiv9602994789yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9602994789 .yiv9602994789green {color:#628c2a;}#yiv9602994789 .yiv9602994789MsoNormal {margin:0 0 0 0;}#yiv9602994789 o {font-size:0;}#yiv9602994789 #yiv9602994789photos div {float:left;width:72px;}#yiv9602994789 #yiv9602994789photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9602994789 #yiv9602994789photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9602994789 #yiv9602994789reco-category {font-size:77%;}#yiv9602994789 #yiv9602994789reco-desc {font-size:77%;}#yiv9602994789 .yiv9602994789replbq {margin:4px;}#yiv9602994789 #yiv9602994789ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9602994789 #yiv9602994789ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9602994789 #yiv9602994789ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9602994789 #yiv9602994789ygrp-mlmsg select, #yiv9602994789 input, #yiv9602994789 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9602994789 #yiv9602994789ygrp-mlmsg pre, #yiv9602994789 code {font:115% monospace;}#yiv9602994789 #yiv9602994789ygrp-mlmsg * {line-height:1.22em;}#yiv9602994789 #yiv9602994789ygrp-mlmsg #yiv9602994789logo {padding-bottom:10px;}#yiv9602994789 #yiv9602994789ygrp-msg p a {font-family:Verdana;}#yiv9602994789 #yiv9602994789ygrp-msg p#yiv9602994789attach-count span {color:#1E66AE;font-weight:700;}#yiv9602994789 #yiv9602994789ygrp-reco #yiv9602994789reco-head {color:#ff7900;font-weight:700;}#yiv9602994789 #yiv9602994789ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9602994789 #yiv9602994789ygrp-sponsor #yiv9602994789ov li a {font-size:130%;text-decoration:none;}#yiv9602994789 #yiv9602994789ygrp-sponsor #yiv9602994789ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9602994789 #yiv9602994789ygrp-sponsor #yiv9602994789ov ul {margin:0;padding:0 0 0 8px;}#yiv9602994789 #yiv9602994789ygrp-text {font-family:Georgia;}#yiv9602994789 #yiv9602994789ygrp-text p {margin:0 0 1em 0;}#yiv9602994789 #yiv9602994789ygrp-text tt {font-size:120%;}#yiv9602994789 #yiv9602994789ygrp-vital ul li:last-child {border-right:none !important;}#yiv9602994789

Fri Nov 6, 2015 2:05 pm (PST) . Posted by:

wiscobez

It was mentioned in the Excel 2016 thread, but I wanted to give this issue it's own header...

Yahoo options stopped working as of today. Mine won't return anything.


thx
Dave


Fri Nov 6, 2015 2:08 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I looked at the source code of a few options web pages. The tables are
there, but only have headers. No rows with option quotes...

Someone mentioned they weren't working for a short time on Tuesday as
well...

On Fri, Nov 6, 2015 at 2:48 PM, wiscobez@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> It was mentioned in the Excel 2016 thread, but I wanted to give this issue
> it's own header...
>
> Yahoo options stopped working as of today. Mine won't return anything.
>

Fri Nov 6, 2015 6:40 pm (PST) . Posted by:

"Barry Rosman" bnr0sman

I used :smfGetNasdaqOptionQuote and it worked fine. It found weekly and monthly options. The percent change is  negative.The Nasdaq option is undocumented, but is a valid function.
Google was not returning weekly options.
  Barry Rosman From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, November 6, 2015 5:08 PM
Subject: Re: [smf_addin] Yahoo Options broken

  I looked at the source code of a few options web pages. The tables are there, but only have headers. No rows with option quotes...

Someone mentioned they weren't working for a short time on Tuesday as well...

On Fri, Nov 6, 2015 at 2:48 PM, wiscobez@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

It was mentioned in the Excel 2016 thread, but I wanted to give this issue it's own header...

Yahoo options stopped working as of today.   Mine won't return anything.

#yiv2716054280 #yiv2716054280 -- #yiv2716054280ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2716054280 #yiv2716054280ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2716054280 #yiv2716054280ygrp-mkp #yiv2716054280hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2716054280 #yiv2716054280ygrp-mkp #yiv2716054280ads {margin-bottom:10px;}#yiv2716054280 #yiv2716054280ygrp-mkp .yiv2716054280ad {padding:0 0;}#yiv2716054280 #yiv2716054280ygrp-mkp .yiv2716054280ad p {margin:0;}#yiv2716054280 #yiv2716054280ygrp-mkp .yiv2716054280ad a {color:#0000ff;text-decoration:none;}#yiv2716054280 #yiv2716054280ygrp-sponsor #yiv2716054280ygrp-lc {font-family:Arial;}#yiv2716054280 #yiv2716054280ygrp-sponsor #yiv2716054280ygrp-lc #yiv2716054280hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2716054280 #yiv2716054280ygrp-sponsor #yiv2716054280ygrp-lc .yiv2716054280ad {margin-bottom:10px;padding:0 0;}#yiv2716054280 #yiv2716054280actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2716054280 #yiv2716054280activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2716054280 #yiv2716054280activity span {font-weight:700;}#yiv2716054280 #yiv2716054280activity span:first-child {text-transform:uppercase;}#yiv2716054280 #yiv2716054280activity span a {color:#5085b6;text-decoration:none;}#yiv2716054280 #yiv2716054280activity span span {color:#ff7900;}#yiv2716054280 #yiv2716054280activity span .yiv2716054280underline {text-decoration:underline;}#yiv2716054280 .yiv2716054280attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2716054280 .yiv2716054280attach div a {text-decoration:none;}#yiv2716054280 .yiv2716054280attach img {border:none;padding-right:5px;}#yiv2716054280 .yiv2716054280attach label {display:block;margin-bottom:5px;}#yiv2716054280 .yiv2716054280attach label a {text-decoration:none;}#yiv2716054280 blockquote {margin:0 0 0 4px;}#yiv2716054280 .yiv2716054280bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2716054280 .yiv2716054280bold a {text-decoration:none;}#yiv2716054280 dd.yiv2716054280last p a {font-family:Verdana;font-weight:700;}#yiv2716054280 dd.yiv2716054280last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2716054280 dd.yiv2716054280last p span.yiv2716054280yshortcuts {margin-right:0;}#yiv2716054280 div.yiv2716054280attach-table div div a {text-decoration:none;}#yiv2716054280 div.yiv2716054280attach-table {width:400px;}#yiv2716054280 div.yiv2716054280file-title a, #yiv2716054280 div.yiv2716054280file-title a:active, #yiv2716054280 div.yiv2716054280file-title a:hover, #yiv2716054280 div.yiv2716054280file-title a:visited {text-decoration:none;}#yiv2716054280 div.yiv2716054280photo-title a, #yiv2716054280 div.yiv2716054280photo-title a:active, #yiv2716054280 div.yiv2716054280photo-title a:hover, #yiv2716054280 div.yiv2716054280photo-title a:visited {text-decoration:none;}#yiv2716054280 div#yiv2716054280ygrp-mlmsg #yiv2716054280ygrp-msg p a span.yiv2716054280yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2716054280 .yiv2716054280green {color:#628c2a;}#yiv2716054280 .yiv2716054280MsoNormal {margin:0 0 0 0;}#yiv2716054280 o {font-size:0;}#yiv2716054280 #yiv2716054280photos div {float:left;width:72px;}#yiv2716054280 #yiv2716054280photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2716054280 #yiv2716054280photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2716054280 #yiv2716054280reco-category {font-size:77%;}#yiv2716054280 #yiv2716054280reco-desc {font-size:77%;}#yiv2716054280 .yiv2716054280replbq {margin:4px;}#yiv2716054280 #yiv2716054280ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2716054280 #yiv2716054280ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2716054280 #yiv2716054280ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2716054280 #yiv2716054280ygrp-mlmsg select, #yiv2716054280 input, #yiv2716054280 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2716054280 #yiv2716054280ygrp-mlmsg pre, #yiv2716054280 code {font:115% monospace;}#yiv2716054280 #yiv2716054280ygrp-mlmsg * {line-height:1.22em;}#yiv2716054280 #yiv2716054280ygrp-mlmsg #yiv2716054280logo {padding-bottom:10px;}#yiv2716054280 #yiv2716054280ygrp-msg p a {font-family:Verdana;}#yiv2716054280 #yiv2716054280ygrp-msg p#yiv2716054280attach-count span {color:#1E66AE;font-weight:700;}#yiv2716054280 #yiv2716054280ygrp-reco #yiv2716054280reco-head {color:#ff7900;font-weight:700;}#yiv2716054280 #yiv2716054280ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2716054280 #yiv2716054280ygrp-sponsor #yiv2716054280ov li a {font-size:130%;text-decoration:none;}#yiv2716054280 #yiv2716054280ygrp-sponsor #yiv2716054280ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2716054280 #yiv2716054280ygrp-sponsor #yiv2716054280ov ul {margin:0;padding:0 0 0 8px;}#yiv2716054280 #yiv2716054280ygrp-text {font-family:Georgia;}#yiv2716054280 #yiv2716054280ygrp-text p {margin:0 0 1em 0;}#yiv2716054280 #yiv2716054280ygrp-text tt {font-size:120%;}#yiv2716054280 #yiv2716054280ygrp-vital ul li:last-child {border-right:none !important;}#yiv2716054280

Fri Nov 6, 2015 4:33 pm (PST) . Posted by:

alankc_mok

Randy,

Been using this macro for years to get weekly options quote from Yahoo, symbol included AAPL, BABA, IWM, NFLX.

Lately, only BABA will work. I used array entry and when I plug the symbol in the BABA column it gets no data , but when I enter BABA symbol it can display data. For example I will have column entry such as AAPL, BABA, IWM, NFLX.

Will it be the problem of Yahoo ?

By the way, I use the latest version of smf.

Thanks

Alan


Fri Nov 6, 2015 5:01 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I only looked at a few ticker symbols earlier today. All the web pages had
the Put and Call tables, but only headers in the tables. No rows of quotes
data for the calls and puts. Hopefully, a temporary glitch from Yahoo...

On Fri, Nov 6, 2015 at 5:33 PM, alankc_mok@... wrote:

>
> Randy,
>
> Been using this macro for years to get weekly options quote from Yahoo,
> symbol included AAPL, BABA, IWM, NFLX.
>
> Lately, only BABA will work. I used array entry and when I plug the symbol
> in the BABA column it gets no data , but when I enter BABA symbol it can
> display data. For example I will have column entry such as AAPL, BABA, IWM,
> NFLX.
>
> Will it be the problem of Yahoo ?
>
> By the way, I use the latest version of smf.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar