Minggu, 14 Februari 2016

[smf_addin] Digest Number 3636

2 Messages

Digest #3636
1.1
1.2
Re: Problem with RCHGetYahooHistory by "Randy Harmelink" rharmelink

Messages

Sat Feb 13, 2016 3:34 pm (PST) . Posted by:

"Yahoo!" lewglenn

For some reason or other the RCHGetYahooHistory command was hanging for as long as a minute (the macro used to take only a second or so); after more than a minute it finally successfully completed. I wonder if this is something on Yahoo's end.
Anyway, thanks for the rapid response, Randy.


On Saturday, February 13, 2016 3:19 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  Not sure what to tell you. The code works fine here, as long as "SelPack" is defined as a string variable. I did you a literal of "TLT" instead of the ChuzEquity() array.

On Sat, Feb 13, 2016 at 3:26 PM, lewglenn@... wrote:

I entered the following code:Sheets(SelStr).Select
    SelPack = ChuzEquity(1)
    Range("A1:B20000") = RCHGetYahooHistory(SelPack, , , , , , , , "DA", 1, 1, 1, 20000, 2)
SelStr shows up as "MyData" which is the correct worksheet & SelPack = ChuzEquity(1) shows up as "TLT", which is the correct value. I expected to see the TLT data populated on the worksheet yet nothing happened, i.e., the worksheet remained blank.I have used this macro many times in the past but it suddenly stopped working. Has anything changed?

#yiv7289520338 #yiv7289520338 -- #yiv7289520338ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7289520338 #yiv7289520338ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7289520338 #yiv7289520338ygrp-mkp #yiv7289520338hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7289520338 #yiv7289520338ygrp-mkp #yiv7289520338ads {margin-bottom:10px;}#yiv7289520338 #yiv7289520338ygrp-mkp .yiv7289520338ad {padding:0 0;}#yiv7289520338 #yiv7289520338ygrp-mkp .yiv7289520338ad p {margin:0;}#yiv7289520338 #yiv7289520338ygrp-mkp .yiv7289520338ad a {color:#0000ff;text-decoration:none;}#yiv7289520338 #yiv7289520338ygrp-sponsor #yiv7289520338ygrp-lc {font-family:Arial;}#yiv7289520338 #yiv7289520338ygrp-sponsor #yiv7289520338ygrp-lc #yiv7289520338hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7289520338 #yiv7289520338ygrp-sponsor #yiv7289520338ygrp-lc .yiv7289520338ad {margin-bottom:10px;padding:0 0;}#yiv7289520338 #yiv7289520338actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7289520338 #yiv7289520338activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7289520338 #yiv7289520338activity span {font-weight:700;}#yiv7289520338 #yiv7289520338activity span:first-child {text-transform:uppercase;}#yiv7289520338 #yiv7289520338activity span a {color:#5085b6;text-decoration:none;}#yiv7289520338 #yiv7289520338activity span span {color:#ff7900;}#yiv7289520338 #yiv7289520338activity span .yiv7289520338underline {text-decoration:underline;}#yiv7289520338 .yiv7289520338attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7289520338 .yiv7289520338attach div a {text-decoration:none;}#yiv7289520338 .yiv7289520338attach img {border:none;padding-right:5px;}#yiv7289520338 .yiv7289520338attach label {display:block;margin-bottom:5px;}#yiv7289520338 .yiv7289520338attach label a {text-decoration:none;}#yiv7289520338 blockquote {margin:0 0 0 4px;}#yiv7289520338 .yiv7289520338bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7289520338 .yiv7289520338bold a {text-decoration:none;}#yiv7289520338 dd.yiv7289520338last p a {font-family:Verdana;font-weight:700;}#yiv7289520338 dd.yiv7289520338last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7289520338 dd.yiv7289520338last p span.yiv7289520338yshortcuts {margin-right:0;}#yiv7289520338 div.yiv7289520338attach-table div div a {text-decoration:none;}#yiv7289520338 div.yiv7289520338attach-table {width:400px;}#yiv7289520338 div.yiv7289520338file-title a, #yiv7289520338 div.yiv7289520338file-title a:active, #yiv7289520338 div.yiv7289520338file-title a:hover, #yiv7289520338 div.yiv7289520338file-title a:visited {text-decoration:none;}#yiv7289520338 div.yiv7289520338photo-title a, #yiv7289520338 div.yiv7289520338photo-title a:active, #yiv7289520338 div.yiv7289520338photo-title a:hover, #yiv7289520338 div.yiv7289520338photo-title a:visited {text-decoration:none;}#yiv7289520338 div#yiv7289520338ygrp-mlmsg #yiv7289520338ygrp-msg p a span.yiv7289520338yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7289520338 .yiv7289520338green {color:#628c2a;}#yiv7289520338 .yiv7289520338MsoNormal {margin:0 0 0 0;}#yiv7289520338 o {font-size:0;}#yiv7289520338 #yiv7289520338photos div {float:left;width:72px;}#yiv7289520338 #yiv7289520338photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7289520338 #yiv7289520338photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7289520338 #yiv7289520338reco-category {font-size:77%;}#yiv7289520338 #yiv7289520338reco-desc {font-size:77%;}#yiv7289520338 .yiv7289520338replbq {margin:4px;}#yiv7289520338 #yiv7289520338ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7289520338 #yiv7289520338ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7289520338 #yiv7289520338ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7289520338 #yiv7289520338ygrp-mlmsg select, #yiv7289520338 input, #yiv7289520338 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7289520338 #yiv7289520338ygrp-mlmsg pre, #yiv7289520338 code {font:115% monospace;}#yiv7289520338 #yiv7289520338ygrp-mlmsg * {line-height:1.22em;}#yiv7289520338 #yiv7289520338ygrp-mlmsg #yiv7289520338logo {padding-bottom:10px;}#yiv7289520338 #yiv7289520338ygrp-msg p a {font-family:Verdana;}#yiv7289520338 #yiv7289520338ygrp-msg p#yiv7289520338attach-count span {color:#1E66AE;font-weight:700;}#yiv7289520338 #yiv7289520338ygrp-reco #yiv7289520338reco-head {color:#ff7900;font-weight:700;}#yiv7289520338 #yiv7289520338ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7289520338 #yiv7289520338ygrp-sponsor #yiv7289520338ov li a {font-size:130%;text-decoration:none;}#yiv7289520338 #yiv7289520338ygrp-sponsor #yiv7289520338ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7289520338 #yiv7289520338ygrp-sponsor #yiv7289520338ov ul {margin:0;padding:0 0 0 8px;}#yiv7289520338 #yiv7289520338ygrp-text {font-family:Georgia;}#yiv7289520338 #yiv7289520338ygrp-text p {margin:0 0 1em 0;}#yiv7289520338 #yiv7289520338ygrp-text tt {font-size:120%;}#yiv7289520338 #yiv7289520338ygrp-vital ul li:last-child {border-right:none !important;}#yiv7289520338

Sat Feb 13, 2016 3:50 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

When I tested my code, it ran almost instantaneously. Maybe there's a
temporary issue with whatever local server Yahoo is using to deliver your
requests?

I tried it twice here. According to my logs, the first request took half a
second, the other a third of a second.

On Sat, Feb 13, 2016 at 4:34 PM, Yahoo! lewglenn@... wrote:

>
> For some reason or other the RCHGetYahooHistory command was hanging for as
> long as a minute (the macro used to take only a second or so); after more
> than a minute it finally successfully completed. I wonder if this is
> something on Yahoo's end.
>
> Anyway, thanks for the rapid response, Randy.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar