3 Messages
Digest #4043
Messages
Tue May 30, 2017 4:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
smfPricesByDates() is using data retrieved by smfGetYahooHistory(), which
only adjusts for dividends and does nothing for splits. All split
adjustments are done by Yahoo. In this case, incorrectly. See:
https://finance.yahoo.com/quote/KNOW/history
Since no dividends are involved, what you're seeing is what Yahoo is
reporting as historical quotes.
On Tue, May 30, 2017 at 2:56 PM, Eric Stats ericstats@
...wrote:
>
> I show that KNOW had a 2/1 stock split at the end of April. The
> smfPricesByDates function returns a non-adjusted price for 4/30 and then an
> adjusted price for 5/1. In the past, all of the prices were adjusted. How
> do I account for the splits in the future? Or will the smfPricesByDates
> function eventually return only adjusted pricing?
>
>
only adjusts for dividends and does nothing for splits. All split
adjustments are done by Yahoo. In this case, incorrectly. See:
https://finance.yahoo.com/quote/KNOW/history
Since no dividends are involved, what you're seeing is what Yahoo is
reporting as historical quotes.
On Tue, May 30, 2017 at 2:56 PM, Eric Stats ericstats@
...wrote:
>
> I show that KNOW had a 2/1 stock split at the end of April. The
> smfPricesByDates function returns a non-adjusted price for 4/30 and then an
> adjusted price for 5/1. In the past, all of the prices were adjusted. How
> do I account for the splits in the future? Or will the smfPricesByDates
> function eventually return only adjusted pricing?
>
>
Tue May 30, 2017 5:58 pm (PDT) . Posted by:
"Jose Jacob" pepecan47
Randy, what would the formulas be using smgGetYahooHistory? I would like to try them.
Regards,Jose L. Jacob
On Tuesday, May 30, 2017 4:52 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
There are additional files with changes, but not related to Yahoo Historical quotes.
On Tue, May 30, 2017 at 1:49 PM, Jose Jacob pepecan47@...wrote:
Randy, is the latest version that I have (May 25) only the .XLA file or there are more files? I downloaded only the .XLA file.
#yiv5499632126 #yiv5499632126 -- #yiv5499632126ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5499632126 #yiv5499632126ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5499632126 #yiv5499632126ygrp-mkp #yiv5499632126hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5499632126 #yiv5499632126ygrp-mkp #yiv5499632126ads {margin-bottom:10px;}#yiv5499632126 #yiv5499632126ygrp-mkp .yiv5499632126ad {padding:0 0;}#yiv5499632126 #yiv5499632126ygrp-mkp .yiv5499632126ad p {margin:0;}#yiv5499632126 #yiv5499632126ygrp-mkp .yiv5499632126ad a {color:#0000ff;text-decoration:none;}#yiv5499632126 #yiv5499632126ygrp-sponsor #yiv5499632126ygrp-lc {font-family:Arial;}#yiv5499632126 #yiv5499632126ygrp-sponsor #yiv5499632126ygrp-lc #yiv5499632126hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5499632126 #yiv5499632126ygrp-sponsor #yiv5499632126ygrp-lc .yiv5499632126ad {margin-bottom:10px;padding:0 0;}#yiv5499632126 #yiv5499632126actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5499632126 #yiv5499632126activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5499632126 #yiv5499632126activity span {font-weight:700;}#yiv5499632126 #yiv5499632126activity span:first-child {text-transform:uppercase;}#yiv5499632126 #yiv5499632126activity span a {color:#5085b6;text-decoration:none;}#yiv5499632126 #yiv5499632126activity span span {color:#ff7900;}#yiv5499632126 #yiv5499632126activity span .yiv5499632126underline {text-decoration:underline;}#yiv5499632126 .yiv5499632126attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5499632126 .yiv5499632126attach div a {text-decoration:none;}#yiv5499632126 .yiv5499632126attach img {border:none;padding-right:5px;}#yiv5499632126 .yiv5499632126attach label {display:block;margin-bottom:5px;}#yiv5499632126 .yiv5499632126attach label a {text-decoration:none;}#yiv5499632126 blockquote {margin:0 0 0 4px;}#yiv5499632126 .yiv5499632126bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5499632126 .yiv5499632126bold a {text-decoration:none;}#yiv5499632126 dd.yiv5499632126last p a {font-family:Verdana;font-weight:700;}#yiv5499632126 dd.yiv5499632126last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5499632126 dd.yiv5499632126last p span.yiv5499632126yshortcuts {margin-right:0;}#yiv5499632126 div.yiv5499632126attach-table div div a {text-decoration:none;}#yiv5499632126 div.yiv5499632126attach-table {width:400px;}#yiv5499632126 div.yiv5499632126file-title a, #yiv5499632126 div.yiv5499632126file-title a:active, #yiv5499632126 div.yiv5499632126file-title a:hover, #yiv5499632126 div.yiv5499632126file-title a:visited {text-decoration:none;}#yiv5499632126 div.yiv5499632126photo-title a, #yiv5499632126 div.yiv5499632126photo-title a:active, #yiv5499632126 div.yiv5499632126photo-title a:hover, #yiv5499632126 div.yiv5499632126photo-title a:visited {text-decoration:none;}#yiv5499632126 div#yiv5499632126ygrp-mlmsg #yiv5499632126ygrp-msg p a span.yiv5499632126yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5499632126 .yiv5499632126green {color:#628c2a;}#yiv5499632126 .yiv5499632126MsoNormal {margin:0 0 0 0;}#yiv5499632126 o {font-size:0;}#yiv5499632126 #yiv5499632126photos div {float:left;width:72px;}#yiv5499632126 #yiv5499632126photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5499632126 #yiv5499632126photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5499632126 #yiv5499632126reco-category {font-size:77%;}#yiv5499632126 #yiv5499632126reco-desc {font-size:77%;}#yiv5499632126 .yiv5499632126replbq {margin:4px;}#yiv5499632126 #yiv5499632126ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5499632126 #yiv5499632126ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5499632126 #yiv5499632126ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5499632126 #yiv5499632126ygrp-mlmsg select, #yiv5499632126 input, #yiv5499632126 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5499632126 #yiv5499632126ygrp-mlmsg pre, #yiv5499632126 code {font:115% monospace;}#yiv5499632126 #yiv5499632126ygrp-mlmsg * {line-height:1.22em;}#yiv5499632126 #yiv5499632126ygrp-mlmsg #yiv5499632126logo {padding-bottom:10px;}#yiv5499632126 #yiv5499632126ygrp-msg p a {font-family:Verdana;}#yiv5499632126 #yiv5499632126ygrp-msg p#yiv5499632126attach-count span {color:#1E66AE;font-weight:700;}#yiv5499632126 #yiv5499632126ygrp-reco #yiv5499632126reco-head {color:#ff7900;font-weight:700;}#yiv5499632126 #yiv5499632126ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5499632126 #yiv5499632126ygrp-sponsor #yiv5499632126ov li a {font-size:130%;text-decoration:none;}#yiv5499632126 #yiv5499632126ygrp-sponsor #yiv5499632126ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5499632126 #yiv5499632126ygrp-sponsor #yiv5499632126ov ul {margin:0;padding:0 0 0 8px;}#yiv5499632126 #yiv5499632126ygrp-text {font-family:Georgia;}#yiv5499632126 #yiv5499632126ygrp-text p {margin:0 0 1em 0;}#yiv5499632126 #yiv5499632126ygrp-text tt {font-size:120%;}#yiv5499632126 #yiv5499632126ygrp-vital ul li:last-child {border-right:none !important;}#yiv5499632126
Regards,Jose L. Jacob
On Tuesday, May 30, 2017 4:52 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
There are additional files with changes, but not related to Yahoo Historical quotes.
On Tue, May 30, 2017 at 1:49 PM, Jose Jacob pepecan47@...wrote:
Randy, is the latest version that I have (May 25) only the .XLA file or there are more files? I downloaded only the .XLA file.
#yiv5499632126 #yiv5499632126 -- #yiv5499632126ygrp-
Tue May 30, 2017 6:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The one to get all three at once would be:
=TRANSPOSE(INDEX(smfGetYahooHistory("MMM",,,"v",,0,,3,2),,2))
...or, as needed for individual row/column extraction:
=INDEX(smfGetYahooHistory("MMM",,,"v",,0,,3,2),3,2)
On Tue, May 30, 2017 at 5:57 PM, Jose Jacob pepecan47@
...wrote:
>
> Randy, what would the formulas be using smgGetYahooHistory? I would like
> to try them.
>
>
>
=TRANSPOSE(INDEX(
...or, as needed for individual row/column extraction:
=INDEX(smfGetYahooH
On Tue, May 30, 2017 at 5:57 PM, Jose Jacob pepecan47@
...wrote:
>
> Randy, what would the formulas be using smgGetYahooHistory? I would like
> to try them.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar