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?
>
>
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 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
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-
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?
>
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@
>
> 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")
=smfGetOptionStrike
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" 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")
>
>
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&quo
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
> 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"
> Thanks, Mark
>
> =smfGetOptionStrike
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar