Selasa, 11 Agustus 2015

[smf_addin] Digest Number 3483

8 Messages

Digest #3483

Messages

Mon Aug 10, 2015 5:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It may only be the servers in one location...

On Mon, Aug 10, 2015 at 5:11 PM, rr76012@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> gdett2,
>
>
> I too am using windows 8.1 and excel 2010.
>
>
> I am a little worried it might not be Yahoo because Randy says his
> template is working.
>
>
> Why would Yahoo Server be working for Randy and not ours.
>
>
> I hope it works tomorrow morning if not I am going to ask Lyndal Homewood
> how she uses google to do the same thing?
>
>

Mon Aug 10, 2015 6:54 pm (PDT) . Posted by:

richqw

as of approx 9 pm, the functions are working.

Mon Aug 10, 2015 8:07 pm (PDT) . Posted by:

"V. Shankar" tarakayan

yes...rchgetyahooquotes not working

On Tuesday, August 11, 2015 7:24 AM, "richqw@aol.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  as of approx 9 pm, the functions are working. #yiv0416802195 #yiv0416802195 -- #yiv0416802195ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0416802195 #yiv0416802195ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0416802195 #yiv0416802195ygrp-mkp #yiv0416802195hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0416802195 #yiv0416802195ygrp-mkp #yiv0416802195ads {margin-bottom:10px;}#yiv0416802195 #yiv0416802195ygrp-mkp .yiv0416802195ad {padding:0 0;}#yiv0416802195 #yiv0416802195ygrp-mkp .yiv0416802195ad p {margin:0;}#yiv0416802195 #yiv0416802195ygrp-mkp .yiv0416802195ad a {color:#0000ff;text-decoration:none;}#yiv0416802195 #yiv0416802195ygrp-sponsor #yiv0416802195ygrp-lc {font-family:Arial;}#yiv0416802195 #yiv0416802195ygrp-sponsor #yiv0416802195ygrp-lc #yiv0416802195hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0416802195 #yiv0416802195ygrp-sponsor #yiv0416802195ygrp-lc .yiv0416802195ad {margin-bottom:10px;padding:0 0;}#yiv0416802195 #yiv0416802195actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0416802195 #yiv0416802195activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0416802195 #yiv0416802195activity span {font-weight:700;}#yiv0416802195 #yiv0416802195activity span:first-child {text-transform:uppercase;}#yiv0416802195 #yiv0416802195activity span a {color:#5085b6;text-decoration:none;}#yiv0416802195 #yiv0416802195activity span span {color:#ff7900;}#yiv0416802195 #yiv0416802195activity span .yiv0416802195underline {text-decoration:underline;}#yiv0416802195 .yiv0416802195attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0416802195 .yiv0416802195attach div a {text-decoration:none;}#yiv0416802195 .yiv0416802195attach img {border:none;padding-right:5px;}#yiv0416802195 .yiv0416802195attach label {display:block;margin-bottom:5px;}#yiv0416802195 .yiv0416802195attach label a {text-decoration:none;}#yiv0416802195 blockquote {margin:0 0 0 4px;}#yiv0416802195 .yiv0416802195bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0416802195 .yiv0416802195bold a {text-decoration:none;}#yiv0416802195 dd.yiv0416802195last p a {font-family:Verdana;font-weight:700;}#yiv0416802195 dd.yiv0416802195last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0416802195 dd.yiv0416802195last p span.yiv0416802195yshortcuts {margin-right:0;}#yiv0416802195 div.yiv0416802195attach-table div div a {text-decoration:none;}#yiv0416802195 div.yiv0416802195attach-table {width:400px;}#yiv0416802195 div.yiv0416802195file-title a, #yiv0416802195 div.yiv0416802195file-title a:active, #yiv0416802195 div.yiv0416802195file-title a:hover, #yiv0416802195 div.yiv0416802195file-title a:visited {text-decoration:none;}#yiv0416802195 div.yiv0416802195photo-title a, #yiv0416802195 div.yiv0416802195photo-title a:active, #yiv0416802195 div.yiv0416802195photo-title a:hover, #yiv0416802195 div.yiv0416802195photo-title a:visited {text-decoration:none;}#yiv0416802195 div#yiv0416802195ygrp-mlmsg #yiv0416802195ygrp-msg p a span.yiv0416802195yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0416802195 .yiv0416802195green {color:#628c2a;}#yiv0416802195 .yiv0416802195MsoNormal {margin:0 0 0 0;}#yiv0416802195 o {font-size:0;}#yiv0416802195 #yiv0416802195photos div {float:left;width:72px;}#yiv0416802195 #yiv0416802195photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0416802195 #yiv0416802195photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0416802195 #yiv0416802195reco-category {font-size:77%;}#yiv0416802195 #yiv0416802195reco-desc {font-size:77%;}#yiv0416802195 .yiv0416802195replbq {margin:4px;}#yiv0416802195 #yiv0416802195ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0416802195 #yiv0416802195ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0416802195 #yiv0416802195ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0416802195 #yiv0416802195ygrp-mlmsg select, #yiv0416802195 input, #yiv0416802195 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0416802195 #yiv0416802195ygrp-mlmsg pre, #yiv0416802195 code {font:115% monospace;}#yiv0416802195 #yiv0416802195ygrp-mlmsg * {line-height:1.22em;}#yiv0416802195 #yiv0416802195ygrp-mlmsg #yiv0416802195logo {padding-bottom:10px;}#yiv0416802195 #yiv0416802195ygrp-msg p a {font-family:Verdana;}#yiv0416802195 #yiv0416802195ygrp-msg p#yiv0416802195attach-count span {color:#1E66AE;font-weight:700;}#yiv0416802195 #yiv0416802195ygrp-reco #yiv0416802195reco-head {color:#ff7900;font-weight:700;}#yiv0416802195 #yiv0416802195ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0416802195 #yiv0416802195ygrp-sponsor #yiv0416802195ov li a {font-size:130%;text-decoration:none;}#yiv0416802195 #yiv0416802195ygrp-sponsor #yiv0416802195ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0416802195 #yiv0416802195ygrp-sponsor #yiv0416802195ov ul {margin:0;padding:0 0 0 8px;}#yiv0416802195 #yiv0416802195ygrp-text {font-family:Georgia;}#yiv0416802195 #yiv0416802195ygrp-text p {margin:0 0 1em 0;}#yiv0416802195 #yiv0416802195ygrp-text tt {font-size:120%;}#yiv0416802195 #yiv0416802195ygrp-vital ul li:last-child {border-right:none !important;}#yiv0416802195

Mon Aug 10, 2015 10:45 pm (PDT) . Posted by:

sharn.spartner

Getyahooquotes is still not working. Anybody else?

Mon Aug 10, 2015 11:38 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It would be more helpful to know whether Yahoo's download data link on
their web page is working.

Also, I'd be curious of location. Maybe those of you with problems are in a
common region and using a particular set of Yahoo servers? Or maybe have
some other commonality?

On Mon, Aug 10, 2015 at 10:45 PM, sharn.spartner@... wrote:

>
> Getyahooquotes is still not working. Anybody else?
>

Mon Aug 10, 2015 5:33 pm (PDT) . Posted by:

sushiwaitress

Thanks Randy, that worked perfectly -- thanks so much for your speedy support!!

Mon Aug 10, 2015 11:39 pm (PDT) . Posted by:

markknutson2005

Randy, I am trying to get the example that was in the documentation to work for the function smfgetoptionStrikes. I highlighted four rows at a single column wide. Then I entered the formula below similiar to the documented example into the formula bar. Followed by a shift - control - enter. The formula was copied into all four rows, but the top row of the array says "None".The three cells below are blank. Am I missing something? Thanks, Mark


=smfGetOptionStrikes("MMM";,"8/21/2015","C","OX")



Tue Aug 11, 2015 12:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. I just cut and pasted your formula into a 4 row by 1 column range and
array-entered it. It works fine here. The "None" value is what the array is
set to at the very beginning of the routine. Getting that returned means it
either found nothing for you (maybe a temporary glitch from OX?) or an
unanticipated error occurred sometime during the processing.

Does your system have a non-US regional setting, where mm/dd/yyyy is not a
normal was of expressing a date? If so, VBA might have coughed up at trying
to convert the "8/21/2015&quot; date string.

On Mon, Aug 10, 2015 at 11:39 PM, mknu@... wrote:

> Randy, I am trying to get the example that was in the documentation to
> work for the function smfgetoptionStrikes. I highlighted four rows at a
> single column wide. Then I entered the formula below similiar to the
> documented example into the formula bar. Followed by a shift - control -
> enter. The formula was copied into all four rows, but the top row of the
> array says "None".The three cells below are blank. Am I missing something?
> Thanks, Mark
>
> =smfGetOptionStrikes("MMM";,"8/21/2015","C","OX")
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar