7 Messages
Digest #4089
1b
Re: Array entered smfGetYahooHistory($A1), more changes from Yahoo? by "Randy Harmelink" rharmelink
Messages
Wed Jul 12, 2017 12:38 am (PDT) . Posted by:
nelsonmuntz1000
Hi Randy:
Just a brief question re: array entered =smfGetYahooHistory($A30). I've been using the formula to extract OHLC, volume, dividends and splits for individual tickers.
When updating, all column headers continue to appear in the array:
Date Open High Low Close Volume Unadj Div Adj Split Adj Dividend Split
Using AAPL as an example, zeroing in on Jun 6 and Jun 9, 2014 (Apple did a 7/1 split at the time), in a file update done earlier today, it looks like OHL were adjusted for splits only, C was adjusted for splits and dividends and Unadj appears to show the actual closing value.
Updating the same file this evening, it looks like Close has been changed to adjust for splits only and no data appears in the Unadj column.
I checked for several other tickers (SPY, AQN.TO), looks like this same data thing. These changes have affected my data manipulation and charts, not a big deal as I can modify my formulas but a bit of a nuisance.
Is Yahoo still messing around with their data?
Thanks for your great work.
Just a brief question re: array entered =smfGetYahooHistory
When updating, all column headers continue to appear in the array:
Date Open High Low Close Volume Unadj Div Adj Split Adj Dividend Split
Using AAPL as an example, zeroing in on Jun 6 and Jun 9, 2014 (Apple did a 7/1 split at the time), in a file update done earlier today, it looks like OHL were adjusted for splits only, C was adjusted for splits and dividends and Unadj appears to show the actual closing value.
Updating the same file this evening, it looks like Close has been changed to adjust for splits only and no data appears in the Unadj column.
I checked for several other tickers (SPY, AQN.TO), looks like this same data thing. These changes have affected my data manipulation and charts, not a big deal as I can modify my formulas but a bit of a nuisance.
Is Yahoo still messing around with their data?
Thanks for your great work.
Wed Jul 12, 2017 12:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
*sigh*
It looks they are back to carrying unadjusted O/H/L/C with an adjusted
close...so they dropped the unadjusted close field (using the close field
for it instead) and added an adjusted close field.
On Wed, Jul 12, 2017 at 12:38 AM, ccoupe300@
...
wrote:
>
> Just a brief question re: array entered =smfGetYahooHistory($A30). I've
> been using the formula to extract OHLC, volume, dividends and splits for
> individual tickers.
>
> When updating, all column headers continue to appear in the array:
>
> Date Open High Low Close Volume Unadj Div Adj Split Adj Dividend
> Split
>
> Using AAPL as an example, zeroing in on Jun 6 and Jun 9, 2014 (Apple did a
> 7/1 split at the time), in a file update done earlier today, it looks like
> OHL were adjusted for splits only, C was adjusted for splits and dividends
> and Unadj appears to show the actual closing value.
>
> Updating the same file this evening, it looks like Close has been changed
> to adjust for splits only and no data appears in the Unadj column.
>
> I checked for several other tickers (SPY, AQN.TO), looks like this same
> data thing. These changes have affected my data manipulation and charts,
> not a big deal as I can modify my formulas but a bit of a nuisance.
>
> Is Yahoo still messing around with their data?
>
> Thanks for your great work.
>
It looks they are back to carrying unadjusted O/H/L/C with an adjusted
close...so they dropped the unadjusted close field (using the close field
for it instead) and added an adjusted close field.
On Wed, Jul 12, 2017 at 12:38 AM, ccoupe300@
...
wrote:
>
> Just a brief question re: array entered =smfGetYahooHistory
> been using the formula to extract OHLC, volume, dividends and splits for
> individual tickers.
>
> When updating, all column headers continue to appear in the array:
>
> Date Open High Low Close Volume Unadj Div Adj Split Adj Dividend
> Split
>
> Using AAPL as an example, zeroing in on Jun 6 and Jun 9, 2014 (Apple did a
> 7/1 split at the time), in a file update done earlier today, it looks like
> OHL were adjusted for splits only, C was adjusted for splits and dividends
> and Unadj appears to show the actual closing value.
>
> Updating the same file this evening, it looks like Close has been changed
> to adjust for splits only and no data appears in the Unadj column.
>
> I checked for several other tickers (SPY, AQN.TO), looks like this same
> data thing. These changes have affected my data manipulation and charts,
> not a big deal as I can modify my formulas but a bit of a nuisance.
>
> Is Yahoo still messing around with their data?
>
> Thanks for your great work.
>
Wed Jul 12, 2017 1:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, it appears Yahoo has made another change. This one looks like a
positive change, so I decided to publish a new ZIP file.
I uploaded the 2017-07-12 *beta* version of the *ZIP *file to the top-level
page of the web site, and it is listed as part of the page contents. I
think the new norm will be to have both the latest official and beta
releases on the top-level page. That should prevent a few questions about
what is available. So the change log should contain all updates, up through
the latest beta release.
http://ogres-crypt.com/SMF/Documentation/viewer.php?name=Change-Log.html
http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2017.07.12.zip
The latest update was to pick up Yahoo's changes to unadjusted close and
adjusted close and to adjust the unadjusted O/H/L for dividends. Note that
Yahoo's unadjusted data *is* adjusted for splits, just not for dividends.
positive change, so I decided to publish a new ZIP file.
I uploaded the 2017-07-12 *beta* version of the *ZIP *file to the top-level
page of the web site, and it is listed as part of the page contents. I
think the new norm will be to have both the latest official and beta
releases on the top-level page. That should prevent a few questions about
what is available. So the change log should contain all updates, up through
the latest beta release.
http://ogres-crypt.com/SMF/Documentation/viewer.php?name=Change-Log.html
http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2017.07.12.zip
The latest update was to pick up Yahoo's changes to unadjusted close and
adjusted close and to adjust the unadjusted O/H/L for dividends. Note that
Yahoo's unadjusted data *is* adjusted for splits, just not for dividends.
Wed Jul 12, 2017 5:56 am (PDT) . Posted by:
ehstats
What are some other historical quote services that can be paid for in case Yahoo continues to mess things up? I've looked at Morningstar and others, but they don't appear to have links to Excel for ad hoc queries of historical pricing - particularly adjusted for distributions and splits. Thanks
Wed Jul 12, 2017 3:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This may help:
http://www.amibroker.com/guide/h_quotes.html
On Wed, Jul 12, 2017 at 5:56 AM, ericstats@
...
wrote:
> What are some other historical quote services that can be paid for in case
> Yahoo continues to mess things up? I've looked at Morningstar and others,
> but they don't appear to have links to Excel for ad hoc queries of
> historical pricing - particularly adjusted for distributions and splits.
> Thanks
>
http://www.amibroker.com/guide/h_quotes.html
On Wed, Jul 12, 2017 at 5:56 AM, ericstats@
...
wrote:
> What are some other historical quote services that can be paid for in case
> Yahoo continues to mess things up? I've looked at Morningstar and others,
> but they don't appear to have links to Excel for ad hoc queries of
> historical pricing - particularly adjusted for distributions and splits.
> Thanks
>
Wed Jul 12, 2017 7:55 am (PDT) . Posted by:
globalinkus
...and miraculously, today it is working again! and I did not do any changes!
Wed Jul 12, 2017 9:06 am (PDT) . Posted by:
"Mike" mikewa_68
Thank Randy,
Alot to keep up with so appreciate the context and the clarity.
You'd mentioned this worked for you, so I assumed it was something I was doing incorrectly.
Just have to hold till Yahoo makes a call or we find an alternate source for historical data.
Thanks again!
On Tuesday, July 11, 2017 2:01 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
The related links where in the message where I said Yahoo was in a state of flux...which you replied to.
On Tue, Jul 11, 2017 at 10:34 AM, Mike mikewa_68@... wrote:
Thank Randy,
I'm running the build downloaded from http://ogres-crypt.com/ SMF/RCH_Stock_Market_ Functions-2.1.2017.05.03.zip
and still see these calls going to ichart.finance.yahoo.com.
Is there something I'm missing in how I make the call, or update the XLA in Excel?
#yiv8180165624 #yiv8180165624 -- #yiv8180165624ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8180165624 #yiv8180165624ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8180165624 #yiv8180165624ygrp-mkp #yiv8180165624hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8180165624 #yiv8180165624ygrp-mkp #yiv8180165624ads {margin-bottom:10px;}#yiv8180165624 #yiv8180165624ygrp-mkp .yiv8180165624ad {padding:0 0;}#yiv8180165624 #yiv8180165624ygrp-mkp .yiv8180165624ad p {margin:0;}#yiv8180165624 #yiv8180165624ygrp-mkp .yiv8180165624ad a {color:#0000ff;text-decoration:none;}#yiv8180165624 #yiv8180165624ygrp-sponsor #yiv8180165624ygrp-lc {font-family:Arial;}#yiv8180165624 #yiv8180165624ygrp-sponsor #yiv8180165624ygrp-lc #yiv8180165624hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8180165624 #yiv8180165624ygrp-sponsor #yiv8180165624ygrp-lc .yiv8180165624ad {margin-bottom:10px;padding:0 0;}#yiv8180165624 #yiv8180165624actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8180165624 #yiv8180165624activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8180165624 #yiv8180165624activity span {font-weight:700;}#yiv8180165624 #yiv8180165624activity span:first-child {text-transform:uppercase;}#yiv8180165624 #yiv8180165624activity span a {color:#5085b6;text-decoration:none;}#yiv8180165624 #yiv8180165624activity span span {color:#ff7900;}#yiv8180165624 #yiv8180165624activity span .yiv8180165624underline {text-decoration:underline;}#yiv8180165624 .yiv8180165624attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8180165624 .yiv8180165624attach div a {text-decoration:none;}#yiv8180165624 .yiv8180165624attach img {border:none;padding-right:5px;}#yiv8180165624 .yiv8180165624attach label {display:block;margin-bottom:5px;}#yiv8180165624 .yiv8180165624attach label a {text-decoration:none;}#yiv8180165624 blockquote {margin:0 0 0 4px;}#yiv8180165624 .yiv8180165624bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8180165624 .yiv8180165624bold a {text-decoration:none;}#yiv8180165624 dd.yiv8180165624last p a {font-family:Verdana;font-weight:700;}#yiv8180165624 dd.yiv8180165624last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8180165624 dd.yiv8180165624last p span.yiv8180165624yshortcuts {margin-right:0;}#yiv8180165624 div.yiv8180165624attach-table div div a {text-decoration:none;}#yiv8180165624 div.yiv8180165624attach-table {width:400px;}#yiv8180165624 div.yiv8180165624file-title a, #yiv8180165624 div.yiv8180165624file-title a:active, #yiv8180165624 div.yiv8180165624file-title a:hover, #yiv8180165624 div.yiv8180165624file-title a:visited {text-decoration:none;}#yiv8180165624 div.yiv8180165624photo-title a, #yiv8180165624 div.yiv8180165624photo-title a:active, #yiv8180165624 div.yiv8180165624photo-title a:hover, #yiv8180165624 div.yiv8180165624photo-title a:visited {text-decoration:none;}#yiv8180165624 div#yiv8180165624ygrp-mlmsg #yiv8180165624ygrp-msg p a span.yiv8180165624yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8180165624 .yiv8180165624green {color:#628c2a;}#yiv8180165624 .yiv8180165624MsoNormal {margin:0 0 0 0;}#yiv8180165624 o {font-size:0;}#yiv8180165624 #yiv8180165624photos div {float:left;width:72px;}#yiv8180165624 #yiv8180165624photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8180165624 #yiv8180165624photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8180165624 #yiv8180165624reco-category {font-size:77%;}#yiv8180165624 #yiv8180165624reco-desc {font-size:77%;}#yiv8180165624 .yiv8180165624replbq {margin:4px;}#yiv8180165624 #yiv8180165624ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8180165624 #yiv8180165624ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8180165624 #yiv8180165624ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8180165624 #yiv8180165624ygrp-mlmsg select, #yiv8180165624 input, #yiv8180165624 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8180165624 #yiv8180165624ygrp-mlmsg pre, #yiv8180165624 code {font:115% monospace;}#yiv8180165624 #yiv8180165624ygrp-mlmsg * {line-height:1.22em;}#yiv8180165624 #yiv8180165624ygrp-mlmsg #yiv8180165624logo {padding-bottom:10px;}#yiv8180165624 #yiv8180165624ygrp-msg p a {font-family:Verdana;}#yiv8180165624 #yiv8180165624ygrp-msg p#yiv8180165624attach-count span {color:#1E66AE;font-weight:700;}#yiv8180165624 #yiv8180165624ygrp-reco #yiv8180165624reco-head {color:#ff7900;font-weight:700;}#yiv8180165624 #yiv8180165624ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8180165624 #yiv8180165624ygrp-sponsor #yiv8180165624ov li a {font-size:130%;text-decoration:none;}#yiv8180165624 #yiv8180165624ygrp-sponsor #yiv8180165624ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8180165624 #yiv8180165624ygrp-sponsor #yiv8180165624ov ul {margin:0;padding:0 0 0 8px;}#yiv8180165624 #yiv8180165624ygrp-text {font-family:Georgia;}#yiv8180165624 #yiv8180165624ygrp-text p {margin:0 0 1em 0;}#yiv8180165624 #yiv8180165624ygrp-text tt {font-size:120%;}#yiv8180165624 #yiv8180165624ygrp-vital ul li:last-child {border-right:none !important;}#yiv8180165624
Alot to keep up with so appreciate the context and the clarity.
You'd mentioned this worked for you, so I assumed it was something I was doing incorrectly.
Just have to hold till Yahoo makes a call or we find an alternate source for historical data.
Thanks again!
On Tuesday, July 11, 2017 2:01 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
The related links where in the message where I said Yahoo was in a state of flux...which you replied to.
On Tue, Jul 11, 2017 at 10:34 AM, Mike mikewa_68@... wrote:
Thank Randy,
I'm running the build downloaded from http://ogres-crypt.com/ SMF/RCH_Stock_
and still see these calls going to ichart.finance.
Is there something I'm missing in how I make the call, or update the XLA in Excel?
#yiv8180165624 #yiv8180165624 -- #yiv8180165624ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar