Minggu, 22 Juli 2018

[smf_addin] Digest Number 4364

6 Messages

Digest #4364

Messages

Sat Jul 21, 2018 2:58 pm (PDT) . Posted by:

lewglenn

Hi Randy,


I have the site for the RCHGetYahooQuotes function but not for smfGetYahooHistory. Could you please provide the url for the documentation for this function?


Thanks.



Sat Jul 21, 2018 3:59 pm (PDT) . Posted by:

"Craig Passow" passow

All of the available documentation on the various functions can be found
at the URL included at the bottom of every message:

For the Add-in, Documentation, Templates, Tips and FAQs, visit
http://ogres-crypt.com/SMF

On 7/21/2018 4:58 PM, lewglenn@yahoo.com [smf_addin] wrote:
>  
> Hi Randy,
>
>  I have the site for the RCHGetYahooQuotes function but not for
> smfGetYahooHistory. Could you please provide the url for the
> documentation for this function?
>
> Thanks.
>
>
>

Sat Jul 21, 2018 5:50 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmm. It appears I never created the documentation.

I just created a document and uploaded it to the site:

http://ogres-crypt.com/SMF/Documentation/viewer.php?name=smfGetYahooHistory-Function.html

Sorry about that. I think I have it on the "To do" list I never get to. :(

On Sat, Jul 21, 2018 at 2:58 PM, lewglenn@
​...
wrote:

>
> I have the site for the RCHGetYahooQuotes function but not for
> smfGetYahooHistory. Could you please provide the url for the documentation
> for this function?
>
>
>

Sat Jul 21, 2018 5:53 pm (PDT) . Posted by:

"Yahoo!" lewglenn

Many thanks, Randy.

On Saturday, July 21, 2018, 5:51:12 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

Hmm. It appears I never created the documentation. 
I just created a document and uploaded it to the site:
http://ogres-crypt.com/SMF/Documentation/viewer.php?name=smfGetYahooHistory-Function.html

Sorry about that. I think I have it on the "To do" list I never get to. :(

On Sat, Jul 21, 2018 at 2:58 PM, lewglenn@​... wrote:

 I have the site for the RCHGetYahooQuotes function but not for smfGetYahooHistory. Could you please provide the url for the documentation for this function?

#yiv2221391082 #yiv2221391082 -- #yiv2221391082ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2221391082 #yiv2221391082ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2221391082 #yiv2221391082ygrp-mkp #yiv2221391082hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2221391082 #yiv2221391082ygrp-mkp #yiv2221391082ads {margin-bottom:10px;}#yiv2221391082 #yiv2221391082ygrp-mkp .yiv2221391082ad {padding:0 0;}#yiv2221391082 #yiv2221391082ygrp-mkp .yiv2221391082ad p {margin:0;}#yiv2221391082 #yiv2221391082ygrp-mkp .yiv2221391082ad a {color:#0000ff;text-decoration:none;}#yiv2221391082 #yiv2221391082ygrp-sponsor #yiv2221391082ygrp-lc {font-family:Arial;}#yiv2221391082 #yiv2221391082ygrp-sponsor #yiv2221391082ygrp-lc #yiv2221391082hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2221391082 #yiv2221391082ygrp-sponsor #yiv2221391082ygrp-lc .yiv2221391082ad {margin-bottom:10px;padding:0 0;}#yiv2221391082 #yiv2221391082actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2221391082 #yiv2221391082activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2221391082 #yiv2221391082activity span {font-weight:700;}#yiv2221391082 #yiv2221391082activity span:first-child {text-transform:uppercase;}#yiv2221391082 #yiv2221391082activity span a {color:#5085b6;text-decoration:none;}#yiv2221391082 #yiv2221391082activity span span {color:#ff7900;}#yiv2221391082 #yiv2221391082activity span .yiv2221391082underline {text-decoration:underline;}#yiv2221391082 .yiv2221391082attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2221391082 .yiv2221391082attach div a {text-decoration:none;}#yiv2221391082 .yiv2221391082attach img {border:none;padding-right:5px;}#yiv2221391082 .yiv2221391082attach label {display:block;margin-bottom:5px;}#yiv2221391082 .yiv2221391082attach label a {text-decoration:none;}#yiv2221391082 blockquote {margin:0 0 0 4px;}#yiv2221391082 .yiv2221391082bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2221391082 .yiv2221391082bold a {text-decoration:none;}#yiv2221391082 dd.yiv2221391082last p a {font-family:Verdana;font-weight:700;}#yiv2221391082 dd.yiv2221391082last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2221391082 dd.yiv2221391082last p span.yiv2221391082yshortcuts {margin-right:0;}#yiv2221391082 div.yiv2221391082attach-table div div a {text-decoration:none;}#yiv2221391082 div.yiv2221391082attach-table {width:400px;}#yiv2221391082 div.yiv2221391082file-title a, #yiv2221391082 div.yiv2221391082file-title a:active, #yiv2221391082 div.yiv2221391082file-title a:hover, #yiv2221391082 div.yiv2221391082file-title a:visited {text-decoration:none;}#yiv2221391082 div.yiv2221391082photo-title a, #yiv2221391082 div.yiv2221391082photo-title a:active, #yiv2221391082 div.yiv2221391082photo-title a:hover, #yiv2221391082 div.yiv2221391082photo-title a:visited {text-decoration:none;}#yiv2221391082 div#yiv2221391082ygrp-mlmsg #yiv2221391082ygrp-msg p a span.yiv2221391082yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2221391082 .yiv2221391082green {color:#628c2a;}#yiv2221391082 .yiv2221391082MsoNormal {margin:0 0 0 0;}#yiv2221391082 o {font-size:0;}#yiv2221391082 #yiv2221391082photos div {float:left;width:72px;}#yiv2221391082 #yiv2221391082photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2221391082 #yiv2221391082photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2221391082 #yiv2221391082reco-category {font-size:77%;}#yiv2221391082 #yiv2221391082reco-desc {font-size:77%;}#yiv2221391082 .yiv2221391082replbq {margin:4px;}#yiv2221391082 #yiv2221391082ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2221391082 #yiv2221391082ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2221391082 #yiv2221391082ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2221391082 #yiv2221391082ygrp-mlmsg select, #yiv2221391082 input, #yiv2221391082 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2221391082 #yiv2221391082ygrp-mlmsg pre, #yiv2221391082 code {font:115% monospace;}#yiv2221391082 #yiv2221391082ygrp-mlmsg * {line-height:1.22em;}#yiv2221391082 #yiv2221391082ygrp-mlmsg #yiv2221391082logo {padding-bottom:10px;}#yiv2221391082 #yiv2221391082ygrp-msg p a {font-family:Verdana;}#yiv2221391082 #yiv2221391082ygrp-msg p#yiv2221391082attach-count span {color:#1E66AE;font-weight:700;}#yiv2221391082 #yiv2221391082ygrp-reco #yiv2221391082reco-head {color:#ff7900;font-weight:700;}#yiv2221391082 #yiv2221391082ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2221391082 #yiv2221391082ygrp-sponsor #yiv2221391082ov li a {font-size:130%;text-decoration:none;}#yiv2221391082 #yiv2221391082ygrp-sponsor #yiv2221391082ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2221391082 #yiv2221391082ygrp-sponsor #yiv2221391082ov ul {margin:0;padding:0 0 0 8px;}#yiv2221391082 #yiv2221391082ygrp-text {font-family:Georgia;}#yiv2221391082 #yiv2221391082ygrp-text p {margin:0 0 1em 0;}#yiv2221391082 #yiv2221391082ygrp-text tt {font-size:120%;}#yiv2221391082 #yiv2221391082ygrp-vital ul li:last-child {border-right:none !important;}#yiv2221391082

Sat Jul 21, 2018 3:11 pm (PDT) . Posted by:

lewglenn

When I use:


Range("A2:B3") = smfGetYahooHistory("SPY", StartDate, EndDate, "d", "dc", , 0, 20000, 2)


with StartDate = EndDate = 7/20/02


I get the correct values for date and adjusted close in cells(1,3) and (2.3) and the header in cells(1,2) and (2,2). How do I modify the command to omit the header and get the data in cells(1,2) and (2,2) instead?



Sat Jul 21, 2018 5:58 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just use the "pNames" (i.e. "Headers") parameter to tell it you don't want
the names of the column headers:

Range("A2:B2") = smfGetYahooHistory("SPY", StartDate, EndDate, "d", "dc",
0, 0, 1, 2)

On Sat, Jul 21, 2018 at 3:11 PM, lewglenn@
​...
wrote:

>
> When I use:
>
> Range("A2:B3") = smfGetYahooHistory("SPY", StartDate, EndDate, "d", "dc",
> , 0, 20000, 2)
>
> with StartDate = EndDate = 7/20/02
>
> I get the correct values for date and adjusted close in cells(1,3) and
> (2.3) and the header in cells(1,2) and (2,2). How do I modify the command
> to omit the header and get the data in cells(1,2) and (2,2) instead?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar