15 Messages
Digest #4015
Messages
Fri May 19, 2017 12:17 pm (PDT) . Posted by:
websurfer1717@gmail.com
Thanks! The workaround will meet my needs. I tried using Index before, but it didn't work until I added the pRows & pCols parameters.
I see what you mean about the funky results for the "a" parameter. I am getting inconsistent results with the "a" parameter for monthly prices. The value for the same month will be different for a one month period and a multi-month period. Something to look at later...
Regards,
Randy C
I see what you mean about the funky results for the "a" parameter. I am getting inconsistent results with the "a" parameter for monthly prices. The value for the same month will be different for a one month period and a multi-month period. Something to look at later...
Regards,
Randy C
Fri May 19, 2017 12:31 pm (PDT) . Posted by:
"Gerard Trofub" trofub
Hello and thank you again for all this work.I have tested matrix{=smfGetYahooHistory(C2;C3;C4;C5;C6;C7;C8)}
Nothing at all result is for any sticker, I could require. No error, No message, In case I do a mistake on ticker no date is indicated.In case Ticker is correct, just the last date is indicated.
Without matrix, same type of "curious" concern.
The new function doesn't work for my computer (Excel2016+W10)I get the correct message for the xla file smf dated May 18th 2017.
A another comment that I don't understand, il always use ";" and never "," in your exemples.
Thank you again.
Le Vendredi 19 mai 2017 20h59, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> a écrit :
Yeah. "null" and "0" values are causing issues. I'll have to handle them, because I don't think we can rely on Yahoo fixing them any time soon... (
I suppose I could plug the zero/null values in as zero values, set a switch, then at the end, scrub the whole array if the switch was set, carrying forward the data from the last valid date. Then there's no scrubbing overhead for things that don't need it.
On Fri, May 19, 2017 at 11:52 AM, earladamy@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I intended to investigate SHY before hitting send.
I just downloaded data for SHY back to 12/17/2014 and I'd estimate that at least half the records are null. The first occurs on 6/29/16 but there are few valid data rows prior to 10/23/15.
This indicates that the nulls could be a massive problem. You may need to consider a setting to handles nulls with option to carry previous day forward and throw up and error after n occurrences. I know I could live with 1 or 2 in a large download but dozens, especially on consecutive days.
#yiv7075489928 -- #yiv7075489928ygrp-
Fri May 19, 2017 1:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yeah. The more I think about it, the more I'm thinking the "w"/"m"/"q"/"a"
options should not be available, at least until Yahoo is adjusting for
dividends on the daily data. Or maybe just a strong warning in the
documentation I write up?
It really wouldn't take much effort to create a weekly/monthly/quarterly/annual
series of dates and use the smfPricesByDates() function to extract the
daily results for those dates from smfGetYahooHistory().
Maybe if I added the pItems parameter to smfPricesByDates() so that all (or
any) of the items can be retrieved? I know people have asked for the
unadjusted close in the past, because the function defaults to the adjusted
close.
On Fri, May 19, 2017 at 12:17 PM, websurfer1717@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks! The workaround will meet my needs. I tried using Index before, but
> it didn't work until I added the pRows & pCols parameters.
>
> I see what you mean about the funky results for the "a" parameter. I am
> getting inconsistent results with the "a" parameter for monthly prices. The
> value for the same month will be different for a one month period and a
> multi-month period. Something to look at later...
>
>
>
options should not be available, at least until Yahoo is adjusting for
dividends on the daily data. Or maybe just a strong warning in the
documentation I write up?
It really wouldn't take much effort to create a weekly/monthly/quarterly/annual
series of dates and use the smfPricesByDates() function to extract the
daily results for those dates from smfGetYahooHistory().
Maybe if I added the pItems parameter to smfPricesByDates() so that all (or
any) of the items can be retrieved? I know people have asked for the
unadjusted close in the past, because the function defaults to the adjusted
close.
On Fri, May 19, 2017 at 12:17 PM, websurfer1717@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks! The workaround will meet my needs. I tried using Index before, but
> it didn't work until I added the pRows & pCols parameters.
>
> I see what you mean about the funky results for the "a" parameter. I am
> getting inconsistent results with the "a" parameter for monthly prices. The
> value for the same month will be different for a one month period and a
> multi-month period. Something to look at later...
>
>
>
Fri May 19, 2017 1:16 pm (PDT) . Posted by:
griffinms
Randy,
By renaming the function RCHGetYahooHistory() to smfGetYahooHistory(), won't that mean that we'll have to redo the arrays we have in saved spreadsheets using the old version?
I only ask because I have some spreadsheets that download a year's worth of data for the S&P 400, 500, and 600, so I think I would basically have to completely redo those SS.
Thanks
Mike G
By renaming the function RCHGetYahooHistory(
I only ask because I have some spreadsheets that download a year's worth of data for the S&P 400, 500, and 600, so I think I would basically have to completely redo those SS.
Thanks
Mike G
Fri May 19, 2017 1:16 pm (PDT) . Posted by:
"Michael Thomas" thomas91112
If it is only the "a" parameter that has a problem, deal with that issue and don't touch "w"/"m"/"q" so long as they are valid. Many of us use "m" a lot.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 19, 2017 1:04 PM
Subject: Re: [smf_addin] Re: Update on Yahoo Historical Quotes
Yeah. The more I think about it, the more I'm thinking the "w"/"m"/"q"/"a" options should not be available, at least until Yahoo is adjusting for dividends on the daily data. Or maybe just a strong warning in the documentation I write up?
It really wouldn't take much effort to create a weekly/monthly/quarterly/ annual series of dates and use the smfPricesByDates() function to extract the daily results for those dates from smfGetYahooHistory().
Maybe if I added the pItems parameter to smfPricesByDates() so that all (or any) of the items can be retrieved? I know people have asked for the unadjusted close in the past, because the function defaults to the adjusted close.
On Fri, May 19, 2017 at 12:17 PM, websurfer1717@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Thanks! The workaround will meet my needs. I tried using Index before, but it didn't work until I added the pRows & pCols parameters.
I see what you mean about the funky results for the "a" parameter. I am getting inconsistent results with the "a" parameter for monthly prices. The value for the same month will be different for a one month period and a multi-month period. Something to look at later...
#yiv6151873707 #yiv6151873707 -- #yiv6151873707ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6151873707 #yiv6151873707ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6151873707 #yiv6151873707ygrp-mkp #yiv6151873707hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6151873707 #yiv6151873707ygrp-mkp #yiv6151873707ads {margin-bottom:10px;}#yiv6151873707 #yiv6151873707ygrp-mkp .yiv6151873707ad {padding:0 0;}#yiv6151873707 #yiv6151873707ygrp-mkp .yiv6151873707ad p {margin:0;}#yiv6151873707 #yiv6151873707ygrp-mkp .yiv6151873707ad a {color:#0000ff;text-decoration:none;}#yiv6151873707 #yiv6151873707ygrp-sponsor #yiv6151873707ygrp-lc {font-family:Arial;}#yiv6151873707 #yiv6151873707ygrp-sponsor #yiv6151873707ygrp-lc #yiv6151873707hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6151873707 #yiv6151873707ygrp-sponsor #yiv6151873707ygrp-lc .yiv6151873707ad {margin-bottom:10px;padding:0 0;}#yiv6151873707 #yiv6151873707actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6151873707 #yiv6151873707activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6151873707 #yiv6151873707activity span {font-weight:700;}#yiv6151873707 #yiv6151873707activity span:first-child {text-transform:uppercase;}#yiv6151873707 #yiv6151873707activity span a {color:#5085b6;text-decoration:none;}#yiv6151873707 #yiv6151873707activity span span {color:#ff7900;}#yiv6151873707 #yiv6151873707activity span .yiv6151873707underline {text-decoration:underline;}#yiv6151873707 .yiv6151873707attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6151873707 .yiv6151873707attach div a {text-decoration:none;}#yiv6151873707 .yiv6151873707attach img {border:none;padding-right:5px;}#yiv6151873707 .yiv6151873707attach label {display:block;margin-bottom:5px;}#yiv6151873707 .yiv6151873707attach label a {text-decoration:none;}#yiv6151873707 blockquote {margin:0 0 0 4px;}#yiv6151873707 .yiv6151873707bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6151873707 .yiv6151873707bold a {text-decoration:none;}#yiv6151873707 dd.yiv6151873707last p a {font-family:Verdana;font-weight:700;}#yiv6151873707 dd.yiv6151873707last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6151873707 dd.yiv6151873707last p span.yiv6151873707yshortcuts {margin-right:0;}#yiv6151873707 div.yiv6151873707attach-table div div a {text-decoration:none;}#yiv6151873707 div.yiv6151873707attach-table {width:400px;}#yiv6151873707 div.yiv6151873707file-title a, #yiv6151873707 div.yiv6151873707file-title a:active, #yiv6151873707 div.yiv6151873707file-title a:hover, #yiv6151873707 div.yiv6151873707file-title a:visited {text-decoration:none;}#yiv6151873707 div.yiv6151873707photo-title a, #yiv6151873707 div.yiv6151873707photo-title a:active, #yiv6151873707 div.yiv6151873707photo-title a:hover, #yiv6151873707 div.yiv6151873707photo-title a:visited {text-decoration:none;}#yiv6151873707 div#yiv6151873707ygrp-mlmsg #yiv6151873707ygrp-msg p a span.yiv6151873707yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6151873707 .yiv6151873707green {color:#628c2a;}#yiv6151873707 .yiv6151873707MsoNormal {margin:0 0 0 0;}#yiv6151873707 o {font-size:0;}#yiv6151873707 #yiv6151873707photos div {float:left;width:72px;}#yiv6151873707 #yiv6151873707photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6151873707 #yiv6151873707photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6151873707 #yiv6151873707reco-category {font-size:77%;}#yiv6151873707 #yiv6151873707reco-desc {font-size:77%;}#yiv6151873707 .yiv6151873707replbq {margin:4px;}#yiv6151873707 #yiv6151873707ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6151873707 #yiv6151873707ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6151873707 #yiv6151873707ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6151873707 #yiv6151873707ygrp-mlmsg select, #yiv6151873707 input, #yiv6151873707 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6151873707 #yiv6151873707ygrp-mlmsg pre, #yiv6151873707 code {font:115% monospace;}#yiv6151873707 #yiv6151873707ygrp-mlmsg * {line-height:1.22em;}#yiv6151873707 #yiv6151873707ygrp-mlmsg #yiv6151873707logo {padding-bottom:10px;}#yiv6151873707 #yiv6151873707ygrp-msg p a {font-family:Verdana;}#yiv6151873707 #yiv6151873707ygrp-msg p#yiv6151873707attach-count span {color:#1E66AE;font-weight:700;}#yiv6151873707 #yiv6151873707ygrp-reco #yiv6151873707reco-head {color:#ff7900;font-weight:700;}#yiv6151873707 #yiv6151873707ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6151873707 #yiv6151873707ygrp-sponsor #yiv6151873707ov li a {font-size:130%;text-decoration:none;}#yiv6151873707 #yiv6151873707ygrp-sponsor #yiv6151873707ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6151873707 #yiv6151873707ygrp-sponsor #yiv6151873707ov ul {margin:0;padding:0 0 0 8px;}#yiv6151873707 #yiv6151873707ygrp-text {font-family:Georgia;}#yiv6151873707 #yiv6151873707ygrp-text p {margin:0 0 1em 0;}#yiv6151873707 #yiv6151873707ygrp-text tt {font-size:120%;}#yiv6151873707 #yiv6151873707ygrp-vital ul li:last-child {border-right:none !important;}#yiv6151873707
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 19, 2017 1:04 PM
Subject: Re: [smf_addin] Re: Update on Yahoo Historical Quotes
Yeah. The more I think about it, the more I'm thinking the "w"/"m"/"q"/"a" options should not be available, at least until Yahoo is adjusting for dividends on the daily data. Or maybe just a strong warning in the documentation I write up?
It really wouldn't take much effort to create a weekly/monthly/quarterly/ annual series of dates and use the smfPricesByDates() function to extract the daily results for those dates from smfGetYahooHistory().
Maybe if I added the pItems parameter to smfPricesByDates() so that all (or any) of the items can be retrieved? I know people have asked for the unadjusted close in the past, because the function defaults to the adjusted close.
On Fri, May 19, 2017 at 12:17 PM, websurfer1717@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Thanks! The workaround will meet my needs. I tried using Index before, but it didn't work until I added the pRows & pCols parameters.
I see what you mean about the funky results for the "a" parameter. I am getting inconsistent results with the "a" parameter for monthly prices. The value for the same month will be different for a one month period and a multi-month period. Something to look at later...
#yiv6151873707 #yiv6151873707 -- #yiv6151873707ygrp-
Fri May 19, 2017 2:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What do you get with just:
=smfGetYahooHistory("MMM")
It could be the UNIX dates are an issue. I'm not sure if they are the same
for everyone, or timezone adjusted? Did the old RCHGetYahooHistory() work
for you in the past? It could be a date conversion issue of some type. I
just don't know what kind of web pages Yahoo is serving up to you (France,
I assume)? Do you use regional settings for your computer? That's been an
issue in the past for date and amount conversions.
On Fri, May 19, 2017 at 12:27 PM, Gerard Trofub trofub@
...wrote:
>
> Hello and thank you again for all this work.
> I have tested matrix
> {=smfGetYahooHistory(C2;C3;C4;C5;C6;C7;C8)}
>
> Nothing at all result is for any sticker, I could require. No error, No
> message,
> In case I do a mistake on ticker no date is indicated.
> In case Ticker is correct, just the last date is indicated.
>
> Without matrix, same type of "curious" concern.
>
> The new function doesn't work for my computer (Excel2016+W10)
> I get the correct message for the xla file smf dated May 18th 2017.
>
> A another comment that I don't understand, il always use ";" and never ","
> in your exemples.
>
>
>
=smfGetYahooHistory
It could be the UNIX dates are an issue. I'm not sure if they are the same
for everyone, or timezone adjusted? Did the old RCHGetYahooHistory(
for you in the past? It could be a date conversion issue of some type. I
just don't know what kind of web pages Yahoo is serving up to you (France,
I assume)? Do you use regional settings for your computer? That's been an
issue in the past for date and amount conversions.
On Fri, May 19, 2017 at 12:27 PM, Gerard Trofub trofub@
...wrote:
>
> Hello and thank you again for all this work.
> I have tested matrix
> {=smfGetYahooHistor
>
> Nothing at all result is for any sticker, I could require. No error, No
> message,
> In case I do a mistake on ticker no date is indicated.
> In case Ticker is correct, just the last date is indicated.
>
> Without matrix, same type of "curious" concern.
>
> The new function doesn't work for my computer (Excel2016+W10)
> I get the correct message for the xla file smf dated May 18th 2017.
>
> A another comment that I don't understand, il always use ";" and never ","
> in your exemples.
>
>
>
Fri May 19, 2017 2:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I've been trying to decide how to handle it. At this point,
smfGetYahooHistory() is the future. It might be possible to add a parameter
to return a CSV file, in which case, I could call smfGetYahooHistory() from
RCHGetYahooHistory() instead of the old URL call. But that's nothing I
would do in the short term.
But please tell me you're not downloading history for 1500 stocks! That's
not the type of processing the add-in was designed for, nor is it fair to
use a free data source like Yahoo for something like that. You should be
using a paid service if that is the type of data you need to get. It just
gives Yahoo (and other data sources) more motivation to unplug access to
their data. It's a reason I almost decided not to share the add-in.
If you are doing that, what are you using the data for? Are there better
ways to get what you're deriving from the history?
BTW, it would not be possible to get historical quotes for 1500 stocks at
this point. There isn't enough room in the add-in to hold the data for 1500
web page. Especially since these new Yahoo historical quotes web pages can
be half a megabyte in size.
On Fri, May 19, 2017 at 1:16 PM, griffinms@
...wrote:
>
> By renaming the function RCHGetYahooHistory() to smfGetYahooHistory(),
> won't that mean that we'll have to redo the arrays we have in saved
> spreadsheets using the old version?
>
> I only ask because I have some spreadsheets that download a year's worth
> of data for the S&P 400, 500, and 600, so I think I would basically have to
> completely redo those SS.
>
smfGetYahooHistory(
to return a CSV file, in which case, I could call smfGetYahooHistory(
RCHGetYahooHistory(
would do in the short term.
But please tell me you're not downloading history for 1500 stocks! That's
not the type of processing the add-in was designed for, nor is it fair to
use a free data source like Yahoo for something like that. You should be
using a paid service if that is the type of data you need to get. It just
gives Yahoo (and other data sources) more motivation to unplug access to
their data. It's a reason I almost decided not to share the add-in.
If you are doing that, what are you using the data for? Are there better
ways to get what you're deriving from the history?
BTW, it would not be possible to get historical quotes for 1500 stocks at
this point. There isn't enough room in the add-in to hold the data for 1500
web page. Especially since these new Yahoo historical quotes web pages can
be half a megabyte in size.
On Fri, May 19, 2017 at 1:16 PM, griffinms@
...wrote:
>
> By renaming the function RCHGetYahooHistory(
> won't that mean that we'll have to redo the arrays we have in saved
> spreadsheets using the old version?
>
> I only ask because I have some spreadsheets that download a year's worth
> of data for the S&P 400, 500, and 600, so I think I would basically have to
> completely redo those SS.
>
Fri May 19, 2017 2:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
But the issue is that adjusted quotes for w/m/q/a are not going to be
accurate, because dividend adjustments need to be made on a daily basis.
What are you retrieving? Can smfPricesByDates() get what you need?
On Fri, May 19, 2017 at 1:12 PM, Michael Thomas thomas91112@
... wrote:
>
> If it is only the "a" parameter that has a problem, deal with that issue
> and don't touch "w"/"m"/"q" so long as they are valid. Many of us use "m"
> a lot.
>
> ------------------------------
> *From:* "Randy Harmelink rharmelink@gmail.com [smf_addin]" <
> smf_addin@yahoogroups.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Friday, May 19, 2017 1:04 PM
> *Subject:* Re: [smf_addin] Re: Update on Yahoo Historical Quotes
>
>
> Yeah. The more I think about it, the more I'm thinking the "w"/"m"/"q"/"a"
> options should not be available, at least until Yahoo is adjusting for
> dividends on the daily data. Or maybe just a strong warning in the
> documentation I write up?
>
> It really wouldn't take much effort to create a weekly/monthly/quarterly/
> annual series of dates and use the smfPricesByDates() function to extract
> the daily results for those dates from smfGetYahooHistory().
>
> Maybe if I added the pItems parameter to smfPricesByDates() so that all
> (or any) of the items can be retrieved? I know people have asked for the
> unadjusted close in the past, because the function defaults to the adjusted
> close.
>
accurate, because dividend adjustments need to be made on a daily basis.
What are you retrieving? Can smfPricesByDates() get what you need?
On Fri, May 19, 2017 at 1:12 PM, Michael Thomas thomas91112@
... wrote:
>
> If it is only the "a" parameter that has a problem, deal with that issue
> and don't touch "w"/"m"/"q" so long as they are valid. Many of us use "m"
> a lot.
>
> ------------------------------
> *From:* "Randy Harmelink rharmelink@gmail.com [smf_addin]" <
> smf_addin@yahoogroups.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Friday, May 19, 2017 1:04 PM
> *Subject:* Re: [smf_addin] Re: Update on Yahoo Historical Quotes
>
>
> Yeah. The more I think about it, the more I'm thinking the "w"
> options should not be available, at least until Yahoo is adjusting for
> dividends on the daily data. Or maybe just a strong warning in the
> documentation I write up?
>
> It really wouldn't take much effort to create a weekly/monthly/
> annual series of dates and use the smfPricesByDates(
> the daily results for those dates from smfGetYahooHistory(
>
> Maybe if I added the pItems parameter to smfPricesByDates(
> (or any) of the items can be retrieved? I know people have asked for the
> unadjusted close in the past, because the function defaults to the adjusted
> close.
>
Fri May 19, 2017 2:35 pm (PDT) . Posted by:
"Gerard Trofub" trofub
Randy,
1/ This function is not accepted (excel window is opened with error, not executed)
2/ i never use this 'old function', so i can't answer you'
Many thks again,
Envoyé de mon iPad
> Le 19 mai 2017 à 23:08, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> a écrit :
>
> What do you get with just:
>
> =3DsmfGetYahooHistory("MMM")
>
> It could be the UNIX dates are an issue. I'm not sure if they are the same
> for everyone, or timezone adjusted? Did the old RCHGetYahooHistory() work
> for you in the past? It could be a date conversion issue of some type. I
> just don't know what kind of web pages Ya
1/ This function is not accepted (excel window is opened with error, not executed)
2/ i never use this 'old function', so i can't answer you'
Many thks again,
Envoyé de mon iPad
> Le 19 mai 2017 à 23:08, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> a écrit :
>
> What do you get with just:
>
> =3DsmfGetYahooHisto
>
> It could be the UNIX dates are an issue. I'm not sure if they are the same
> for everyone, or timezone adjusted? Did the old RCHGetYahooHistory(
> for you in the past? It could be a date conversion issue of some type. I
> just don't know what kind of web pages Ya
Fri May 19, 2017 3:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure why you have a "3D" in front of the function on your cited
message. I don't see that in my sent message or on Yahoo groups.
On Fri, May 19, 2017 at 2:35 PM, Gerard Trofub trofub@
...wrote:
>
> 1/ This function is not accepted (excel window is opened with error, not
> executed)
> 2/ i never use this 'old function', so i can't answer you'
>
> Many thks again,
>
> Envoyé de mon iPad
>
> > Le 19 mai 2017 à 23:08, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> a écrit :
> >
> > What do you get with just:
> >
> > =3DsmfGetYahooHistory("MMM")
> >
> > It could be the UNIX dates are an issue. I'm not sure if they are the
> same
> > for everyone, or timezone adjusted? Did the old RCHGetYahooHistory() work
> > for you in the past? It could be a date conversion issue of some type. I
> > just don't know what kind of web pages Ya
>
>
>
message. I don't see that in my sent message or on Yahoo groups.
On Fri, May 19, 2017 at 2:35 PM, Gerard Trofub trofub@
...wrote:
>
> 1/ This function is not accepted (excel window is opened with error, not
> executed)
> 2/ i never use this 'old function', so i can't answer you'
>
> Many thks again,
>
> Envoyé de mon iPad
>
> > Le 19 mai 2017 à 23:08, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> a écrit :
> >
> > What do you get with just:
> >
> > =3DsmfGetYahooHisto
> >
> > It could be the UNIX dates are an issue. I'm not sure if they are the
> same
> > for everyone, or timezone adjusted? Did the old RCHGetYahooHistory(
> > for you in the past? It could be a date conversion issue of some type. I
> > just don't know what kind of web pages Ya
>
>
>
Fri May 19, 2017 1:01 pm (PDT) . Posted by:
alb998
How do I find the 'Module Name' and 'Field Name' for use with the smfGetYahooJSONData() function, e.g., on the 'Statistics' page of a stock, the 'Forward Annual Dividend Rate'?
Fri May 19, 2017 2:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I uploaded these to the website a few days ago, but hadn't decided if I
wanted to make them widely known. I'm still using them as tools in the
development process, so things can change.
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Mutual-Fund-Keyname-Database.xls
My "works in progress" toolbar has eight workbooks in it.
None of them minor. :(
On Fri, May 19, 2017 at 12:48 PM, al.b@
...wrote:
>
> How do I find the 'Module Name' and 'Field Name' for use with the
> smfGetYahooJSONData() function, e.g., on the 'Statistics' page of a stock,
> the 'Forward Annual Dividend Rate'?
>
wanted to make them widely known. I'm still using them as tools in the
development process, so things can change.
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Mutual-Fund-Keyname-Database.xls
My "works in progress" toolbar has eight workbooks in it.
None of them minor. :(
On Fri, May 19, 2017 at 12:48 PM, al.b@
...wrote:
>
> How do I find the 'Module Name' and 'Field Name' for use with the
> smfGetYahooJSONData
> the 'Forward Annual Dividend Rate'?
>
Fri May 19, 2017 1:53 pm (PDT) . Posted by:
nelsonmuntz1000
Anyone else having trouble retrieving data from Zacks? RCHGetElementNumber() 844-876. When I try to reach the website https://www.zacks.com/ https://www.zacks.com/ I get the following error message:
Secure Connection Failed
An error occurred during a connection to www.zacks.com. SSL received a record with an incorrect Message Authentication Code. Error code: SSL_ERROR_BAD_MAC_READ
Same in Chrome, IE, Firefox, 2 days now.
Randy, great work on Yahoo formulas. It's much appreciated.
Secure Connection Failed
An error occurred during a connection to www.zacks.com. SSL received a record with an incorrect Message Authentication Code. Error code: SSL_ERROR_BAD_
Same in Chrome, IE, Firefox, 2 days now.
Randy, great work on Yahoo formulas. It's much appreciated.
Fri May 19, 2017 2:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This (and the Zacks web site) work fine for me:
=RCHGetElementNumber("MMM",844)
Were you retrieving a lot of data from them? IIRC, someone else had an
access problem that MIGHT have been a "lockout" by IP address. I think it
cleared up after a couple weeks?
Check Google. I see a lot of search results concerning the error messages
you're citing.
On Fri, May 19, 2017 at 1:53 PM, ccoupe300@
...wrote:
>
> Anyone else having trouble retrieving data from Zacks?
> RCHGetElementNumber() 844-876. When I try to reach the website
> https://www.zacks.com/ I get the following error message:
>
> Secure Connection Failed
>
> An error occurred during a connection to www.zacks.com. SSL received a
> record with an incorrect Message Authentication Code. Error code:
> SSL_ERROR_BAD_MAC_READ
>
> Same in Chrome, IE, Firefox, 2 days now.
>
> Randy, great work on Yahoo formulas. It's much appreciated.
>
>
=RCHGetElementNumber("MMM",844)
Were you retrieving a lot of data from them? IIRC, someone else had an
access problem that MIGHT have been a "lockout" by IP address. I think it
cleared up after a couple weeks?
Check Google. I see a lot of search results concerning the error messages
you're citing.
On Fri, May 19, 2017 at 1:53 PM, ccoupe300@
...wrote:
>
> Anyone else having trouble retrieving data from Zacks?
> RCHGetElementNumber() 844-876. When I try to reach the website
> https://www.zacks.com/ I get the following error message:
>
> Secure Connection Failed
>
> An error occurred during a connection to www.zacks.com. SSL received a
> record with an incorrect Message Authentication Code. Error code:
> SSL_ERROR_BAD_
>
> Same in Chrome, IE, Firefox, 2 days now.
>
> Randy, great work on Yahoo formulas. It's much appreciated.
>
>
Fri May 19, 2017 3:30 pm (PDT) . Posted by:
eadamy
Yahoo has a place to report data errors if you have a Yahoo account. This is the link:
https://yahoo.uservoice.com/forums/382977-finance/category/173418-data-accuracy? https://yahoo.uservoice.com/forums/382977-finance/category/173418-data-accuracy?
One of the major impediments to using the "new" Yahoo Finance downloader is the number of symbols which contain null values. 6/29/16 seems to be a common date for a row of null data. Some symbols have massive numbers of null rows beginning roughly two years back.
I suggest that all of us report the errors we find. Over time is it likely to yield some benefit to all of us in getting the files cleaned up. I have just reported errors in two ETFs: MDY and SHY.
Earl Adamy
https://yahoo.uservoice.com/forums/382977-finance/category/173418-data-accuracy? https://yahoo.uservoice.com/forums/382977-finance/category/173418-data-accuracy?
One of the major impediments to using the "new" Yahoo Finance downloader is the number of symbols which contain null values. 6/29/16 seems to be a common date for a row of null data. Some symbols have massive numbers of null rows beginning roughly two years back.
I suggest that all of us report the errors we find. Over time is it likely to yield some benefit to all of us in getting the files cleaned up. I have just reported errors in two ETFs: MDY and SHY.
Earl Adamy
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar