15 Messages
Digest #4016
Messages
Fri May 19, 2017 5:37 pm (PDT) . Posted by:
nelsonmuntz1000
Typically I'll periodically grab Zacks Rank element 848 for a group of tickers, last update was May 7. I can't even open their home page from my desktop. Can't get in from my laptop either, getting a message: This site can't provide a secure connection ERR_SSL_PROTOCOL_ERROR. Not sure what's going on. Will search further. Thanks.
Fri May 19, 2017 6:24 pm (PDT) . Posted by:
garyhartling
Randy,
All I want to do is get the closing price for a stock for one day. From the example in your code I would infer I need to enter =smfGetYahooHistory("IBM","3/1/2017","3/1/2017","d") but that gives me "Date". How do I get the closing price for IBM on 3/1/2017?
Thx,
Gary
All I want to do is get the closing price for a stock for one day. From the example in your code I would infer I need to enter =smfGetYahooHistory
Thx,
Gary
Fri May 19, 2017 6:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetYahooHistory("IBM","3/1/2017","3/1/2017","d","c",0)
...or:
=smfPricesByDates("IBM","3/1/2017")
They will give different answers, because the Yahoo Historical quotes are
unadjusted for dividends. When you just ask Yahoo for a single date,
there's no way to adjust it for dividends. The unadjusted close of the
first function can also be retrieved with:
=smfGetYahooHistory("IBM","3/1/2017","3/1/2017","d","u",0)
On Fri, May 19, 2017 at 6:24 PM, Gary.Hartling@
...wrote:
> All I want to do is get the closing price for a stock for one day. From
> the example in your code I would infer I need to enter =smfGetYahooHistory("
> IBM","3/1/2017","3/1/2017","d") but that gives me "Date". How do I get
> the closing price for IBM on 3/1/2017?
>
>
=smfGetYahooHistory
...or:
=smfPricesByDates(
They will give different answers, because the Yahoo Historical quotes are
unadjusted for dividends. When you just ask Yahoo for a single date,
there's no way to adjust it for dividends. The unadjusted close of the
first function can also be retrieved with:
=smfGetYahooHistory
On Fri, May 19, 2017 at 6:24 PM, Gary.Hartling@
...wrote:
> All I want to do is get the closing price for a stock for one day. From
> the example in your code I would infer I need to enter =smfGetYahooHistory
> IBM","
> the closing price for IBM on 3/1/2017?
>
>
Fri May 19, 2017 8:51 pm (PDT) . Posted by:
kitiany
Randy,
I loaded your newest Add-In and tried the example but I get an error. I don't see smfGetYahooHistory on my list of functions. I do see RCHGetYahooHistory function, but that also gives an error when I use your example.
By the way, thanks for keeping this group going for so many years.
Regards,
Kit
I loaded your newest Add-In and tried the example but I get an error. I don't see smfGetYahooHistory on my list of functions. I do see RCHGetYahooHistory function, but that also gives an error when I use your example.
By the way, thanks for keeping this group going for so many years.
Regards,
Kit
Fri May 19, 2017 9:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It should be listed? Make sure you have the new version loaded:
=RCHGetElementNumber("Version")
Which example did you try?
On Fri, May 19, 2017 at 8:51 PM, Kitiany@
...wrote:
> I loaded your newest Add-In and tried the example but I get an error. I
> don't see smfGetYahooHistory on my list of functions. I do see
> RCHGetYahooHistory function, but that also gives an error when I use your
> example.
>
> By the way, thanks for keeping this group going for so many years.
>
>
=RCHGetElementNumbe
Which example did you try?
On Fri, May 19, 2017 at 8:51 PM, Kitiany@
...wrote:
> I loaded your newest Add-In and tried the example but I get an error. I
> don't see smfGetYahooHistory on my list of functions. I do see
> RCHGetYahooHistory function, but that also gives an error when I use your
> example.
>
> By the way, thanks for keeping this group going for so many years.
>
>
Sat May 20, 2017 7:47 am (PDT) . Posted by:
garyhartling
That works. How about the same thing with a VBA statement. This produces a "Type Mismatch" error for me:
ActiveCell.Value = smfGetYahooHistory(gTicker, Cells(iRow, 1), Cells(iRow, 1), "d", "c", 0)
where:
gTicker = "COP"
Cells(iRow,1) = "3/17/2017"
ActiveCell.Value = smfGetYahooHistory(
where:
gTicker = "COP"
Cells(iRow,1) = "3/17/2017&quo
Fri May 19, 2017 6:26 pm (PDT) . Posted by:
raig002
I am using =smfGetOptionExpirations() function to retrieve option expiration dates,
and I am having trouble to retrieve the correct exp. dates, for exmple for JNJ
I get the wrong exp. date, in this case, I get 6/16/2017(June,16 2017),
instead of 5/19/2017 (May 19, 2017), which is the correct one.
I am trying to automate options but I am having hard time retrieving free data from Yahoo, because
it is not reliable or wrong data.
Is there a different function to retrieve option exp. dates?
Or, Somebody knows where can I get real time data for options, and retrieve Options data to EXCEL
similar to SMF add-in?. I can pay for monthly subscription.
Thanks
Rod
and I am having trouble to retrieve the correct exp. dates, for exmple for JNJ
I get the wrong exp. date, in this case, I get 6/16/2017(June,
instead of 5/19/2017 (May 19, 2017), which is the correct one.
I am trying to automate options but I am having hard time retrieving free data from Yahoo, because
it is not reliable or wrong data.
Is there a different function to retrieve option exp. dates?
Or, Somebody knows where can I get real time data for options, and retrieve Options data to EXCEL
similar to SMF add-in?. I can pay for monthly subscription.
Thanks
Rod
Fri May 19, 2017 6:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Is there a reason you asked this again? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32127
On Fri, May 19, 2017 at 6:26 PM, raig002@
...wrote:
> I am using =smfGetOptionExpirations() function to retrieve option
> expiration dates,
>
> and I am having trouble to retrieve the correct exp. dates, for exmple for
> JNJ
>
> I get the wrong exp. date, in this case, I get 6/16/2017(June,16 2017),
>
> instead of 5/19/2017 (May 19, 2017), which is the correct one.
>
> I am trying to automate options but I am having hard time retrieving free
> data from Yahoo, because
>
> it is not reliable or wrong data.
>
> Is there a different function to retrieve option exp. dates?
>
> Or, Somebody knows where can I get real time data for options, and
> retrieve Options data to EXCEL
>
> similar to SMF add-in?. I can pay for monthly subscription.
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32127
On Fri, May 19, 2017 at 6:26 PM, raig002@
...wrote:
> I am using =smfGetOptionExpira
> expiration dates,
>
> and I am having trouble to retrieve the correct exp. dates, for exmple for
> JNJ
>
> I get the wrong exp. date, in this case, I get 6/16/2017(June,
>
> instead of 5/19/2017 (May 19, 2017), which is the correct one.
>
> I am trying to automate options but I am having hard time retrieving free
> data from Yahoo, because
>
> it is not reliable or wrong data.
>
> Is there a different function to retrieve option exp. dates?
>
> Or, Somebody knows where can I get real time data for options, and
> retrieve Options data to EXCEL
>
> similar to SMF add-in?. I can pay for monthly subscription.
>
>
Fri May 19, 2017 11:23 pm (PDT) . Posted by:
mark_g_donnell
Randy,
First, can I pass on a huge thanks for your work.
Second, I've downloaded your latest xla file and started playing with the smfGetYahooHistory() function but I have two questions:
1. Am I right in thinking the new function only fetches the last year's worth of data? Or, perhaps more accurately, that Yahoo only supplies the last year's worth of data as a first-level response? If so, do you have any thoughts on how we might fetch longer time-series?
2. I'm trying to sort the data to have the oldest dates at the top, and newest at the bottom. I have pResort set to 1, but it still seems to be newest-at-top. Can you please confirm the right choices for that pResort switch?
Thanks again,
First, can I pass on a huge thanks for your work.
Second, I've downloaded your latest xla file and started playing with the smfGetYahooHistory(
1. Am I right in thinking the new function only fetches the last year's worth of data? Or, perhaps more accurately, that Yahoo only supplies the last year's worth of data as a first-level response? If so, do you have any thoughts on how we might fetch longer time-series?
2. I'm trying to sort the data to have the oldest dates at the top, and newest at the bottom. I have pResort set to 1, but it still seems to be newest-at-top. Can you please confirm the right choices for that pResort switch?
Thanks again,
Sat May 20, 2017 12:19 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
(1) Without any parameters, it defaults to one year of data. But this
returns nearly 12,000 rows of data, back to 1/2/70:
=smfGetYahooHistory("MMM","1/1/70","12/31/2020")
(2) This gives me 1/2/70 at the top of that 12,000 rows of data:
=smfGetYahooHistory("MMM","1/1/70","12/31/2020",,,,1)
On Fri, May 19, 2017 at 10:38 PM, mark_donnell@
...wrote:
>
> First, can I pass on a huge thanks for your work.
>
> Second, I've downloaded your latest xla file and started playing with the
> smfGetYahooHistory() function but I have two questions:
>
> 1. Am I right in thinking the new function only fetches the last year's
> worth of data? Or, perhaps more accurately, that Yahoo only supplies the
> last year's worth of data as a first-level response? If so, do you have
> any thoughts on how we might fetch longer time-series?
>
> 2. I'm trying to sort the data to have the oldest dates at the top, and
> newest at the bottom. I have pResort set to 1, but it still seems to be
> newest-at-top. Can you please confirm the right choices for that pResort
> switch?
>
>
>
returns nearly 12,000 rows of data, back to 1/2/70:
=smfGetYahooHistory
(2) This gives me 1/2/70 at the top of that 12,000 rows of data:
=smfGetYahooHistory
On Fri, May 19, 2017 at 10:38 PM, mark_donnell@
...wrote:
>
> First, can I pass on a huge thanks for your work.
>
> Second, I've downloaded your latest xla file and started playing with the
> smfGetYahooHistory(
>
> 1. Am I right in thinking the new function only fetches the last year's
> worth of data? Or, perhaps more accurately, that Yahoo only supplies the
> last year's worth of data as a first-level response? If so, do you have
> any thoughts on how we might fetch longer time-series?
>
> 2. I'm trying to sort the data to have the oldest dates at the top, and
> newest at the bottom. I have pResort set to 1, but it still seems to be
> newest-at-top. Can you please confirm the right choices for that pResort
> switch?
>
>
>
Sat May 20, 2017 1:05 am (PDT) . Posted by:
mark_g_donnell
With further testing, I can see that it works as you intend with standard tickers. But it struggles with tickers for indexes, which start with a "^".
I was trying to use it to get time-histories of the Nasdaq (^IXIC) and S&P500 (^GSPC). It seems that if the ticker starts with a caret (^) then it trips up.
I was trying to use it to get time-histories of the Nasdaq (^IXIC) and S&P500 (^GSPC). It seems that if the ticker starts with a caret (^) then it trips up.
Sat May 20, 2017 1:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yeah. As noted earlier in the thread, many indexes and ETFs seem to have a
lot of bad data -- zeroes and null values. So when the add-in tries to do
math on them, it errors out. I'll need to do some type of scrubbing.
On Sat, May 20, 2017 at 1:05 AM, mark_donnell@
...wrote:
>
> With further testing, I can see that it works as you intend with standard
> tickers. But it struggles with tickers for indexes, which start with a
> "^".
>
> I was trying to use it to get time-histories of the Nasdaq (^IXIC) and
> S&P500 (^GSPC). It seems that if the ticker starts with a caret (^) then
> it trips up.
>
>
>
lot of bad data -- zeroes and null values. So when the add-in tries to do
math on them, it errors out. I'll need to do some type of scrubbing.
On Sat, May 20, 2017 at 1:05 AM, mark_donnell@
...wrote:
>
> With further testing, I can see that it works as you intend with standard
> tickers. But it struggles with tickers for indexes, which start with a
> "^"
>
> I was trying to use it to get time-histories of the Nasdaq (^IXIC) and
> S&P500 (^GSPC). It seems that if the ticker starts with a caret (^) then
> it trips up.
>
>
>
Sat May 20, 2017 8:00 am (PDT) . Posted by:
"V A" viewasia
Even if I specify a 'start date' (say, 2012-01-1), daily data limits itself to begin from 2016-03-03. However, 'weekly' & 'monthly' data fetch seem to fetch correctly?Could I be missing something?
Thanks for your help!
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, May 20, 2017 12:19 AM
Subject: Re: [smf_addin] Re: Update on Yahoo Historical Quotes
(1) Without any parameters, it defaults to one year of data. But this returns nearly 12,000 rows of data, back to 1/2/70:
=smfGetYahooHistory("MMM","1/1/70","12/31/2020")
(2) This gives me 1/2/70 at the top of that 12,000 rows of data:
=smfGetYahooHistory("MMM","1/1/70","12/31/2020",,,,1)
On Fri, May 19, 2017 at 10:38 PM, mark_donnell@...wrote:
First, can I pass on a huge thanks for your work.
Second, I've downloaded your latest xla file and started playing with the smfGetYahooHistory() function but I have two questions:
1. Am I right in thinking the new function only fetches the last year's worth of data? Or, perhaps more accurately, that Yahoo only supplies the last year's worth of data as a first-level response? If so, do you have any thoughts on how we might fetch longer time-series?
2. I'm trying to sort the data to have the oldest dates at the top, and newest at the bottom. I have pResort set to 1, but it still seems to be newest-at-top. Can you please confirm the right choices for that pResort switch?
#yiv2539961474 #yiv2539961474 -- #yiv2539961474ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2539961474 #yiv2539961474ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2539961474 #yiv2539961474ygrp-mkp #yiv2539961474hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2539961474 #yiv2539961474ygrp-mkp #yiv2539961474ads {margin-bottom:10px;}#yiv2539961474 #yiv2539961474ygrp-mkp .yiv2539961474ad {padding:0 0;}#yiv2539961474 #yiv2539961474ygrp-mkp .yiv2539961474ad p {margin:0;}#yiv2539961474 #yiv2539961474ygrp-mkp .yiv2539961474ad a {color:#0000ff;text-decoration:none;}#yiv2539961474 #yiv2539961474ygrp-sponsor #yiv2539961474ygrp-lc {font-family:Arial;}#yiv2539961474 #yiv2539961474ygrp-sponsor #yiv2539961474ygrp-lc #yiv2539961474hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2539961474 #yiv2539961474ygrp-sponsor #yiv2539961474ygrp-lc .yiv2539961474ad {margin-bottom:10px;padding:0 0;}#yiv2539961474 #yiv2539961474actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2539961474 #yiv2539961474activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2539961474 #yiv2539961474activity span {font-weight:700;}#yiv2539961474 #yiv2539961474activity span:first-child {text-transform:uppercase;}#yiv2539961474 #yiv2539961474activity span a {color:#5085b6;text-decoration:none;}#yiv2539961474 #yiv2539961474activity span span {color:#ff7900;}#yiv2539961474 #yiv2539961474activity span .yiv2539961474underline {text-decoration:underline;}#yiv2539961474 .yiv2539961474attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2539961474 .yiv2539961474attach div a {text-decoration:none;}#yiv2539961474 .yiv2539961474attach img {border:none;padding-right:5px;}#yiv2539961474 .yiv2539961474attach label {display:block;margin-bottom:5px;}#yiv2539961474 .yiv2539961474attach label a {text-decoration:none;}#yiv2539961474 blockquote {margin:0 0 0 4px;}#yiv2539961474 .yiv2539961474bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2539961474 .yiv2539961474bold a {text-decoration:none;}#yiv2539961474 dd.yiv2539961474last p a {font-family:Verdana;font-weight:700;}#yiv2539961474 dd.yiv2539961474last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2539961474 dd.yiv2539961474last p span.yiv2539961474yshortcuts {margin-right:0;}#yiv2539961474 div.yiv2539961474attach-table div div a {text-decoration:none;}#yiv2539961474 div.yiv2539961474attach-table {width:400px;}#yiv2539961474 div.yiv2539961474file-title a, #yiv2539961474 div.yiv2539961474file-title a:active, #yiv2539961474 div.yiv2539961474file-title a:hover, #yiv2539961474 div.yiv2539961474file-title a:visited {text-decoration:none;}#yiv2539961474 div.yiv2539961474photo-title a, #yiv2539961474 div.yiv2539961474photo-title a:active, #yiv2539961474 div.yiv2539961474photo-title a:hover, #yiv2539961474 div.yiv2539961474photo-title a:visited {text-decoration:none;}#yiv2539961474 div#yiv2539961474ygrp-mlmsg #yiv2539961474ygrp-msg p a span.yiv2539961474yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2539961474 .yiv2539961474green {color:#628c2a;}#yiv2539961474 .yiv2539961474MsoNormal {margin:0 0 0 0;}#yiv2539961474 o {font-size:0;}#yiv2539961474 #yiv2539961474photos div {float:left;width:72px;}#yiv2539961474 #yiv2539961474photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2539961474 #yiv2539961474photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2539961474 #yiv2539961474reco-category {font-size:77%;}#yiv2539961474 #yiv2539961474reco-desc {font-size:77%;}#yiv2539961474 .yiv2539961474replbq {margin:4px;}#yiv2539961474 #yiv2539961474ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2539961474 #yiv2539961474ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2539961474 #yiv2539961474ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2539961474 #yiv2539961474ygrp-mlmsg select, #yiv2539961474 input, #yiv2539961474 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2539961474 #yiv2539961474ygrp-mlmsg pre, #yiv2539961474 code {font:115% monospace;}#yiv2539961474 #yiv2539961474ygrp-mlmsg * {line-height:1.22em;}#yiv2539961474 #yiv2539961474ygrp-mlmsg #yiv2539961474logo {padding-bottom:10px;}#yiv2539961474 #yiv2539961474ygrp-msg p a {font-family:Verdana;}#yiv2539961474 #yiv2539961474ygrp-msg p#yiv2539961474attach-count span {color:#1E66AE;font-weight:700;}#yiv2539961474 #yiv2539961474ygrp-reco #yiv2539961474reco-head {color:#ff7900;font-weight:700;}#yiv2539961474 #yiv2539961474ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2539961474 #yiv2539961474ygrp-sponsor #yiv2539961474ov li a {font-size:130%;text-decoration:none;}#yiv2539961474 #yiv2539961474ygrp-sponsor #yiv2539961474ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2539961474 #yiv2539961474ygrp-sponsor #yiv2539961474ov ul {margin:0;padding:0 0 0 8px;}#yiv2539961474 #yiv2539961474ygrp-text {font-family:Georgia;}#yiv2539961474 #yiv2539961474ygrp-text p {margin:0 0 1em 0;}#yiv2539961474 #yiv2539961474ygrp-text tt {font-size:120%;}#yiv2539961474 #yiv2539961474ygrp-vital ul li:last-child {border-right:none !important;}#yiv2539961474
Thanks for your help!
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, May 20, 2017 12:19 AM
Subject: Re: [smf_addin] Re: Update on Yahoo Historical Quotes
(1) Without any parameters, it defaults to one year of data. But this returns nearly 12,000 rows of data, back to 1/2/70:
=smfGetYahooHistory
(2) This gives me 1/2/70 at the top of that 12,000 rows of data:
=smfGetYahooHistory
On Fri, May 19, 2017 at 10:38 PM, mark_donnell@...wrote:
First, can I pass on a huge thanks for your work.
Second, I've downloaded your latest xla file and started playing with the smfGetYahooHistory(
1. Am I right in thinking the new function only fetches the last year's worth of data? Or, perhaps more accurately, that Yahoo only supplies the last year's worth of data as a first-level response? If so, do you have any thoughts on how we might fetch longer time-series?
2. I'm trying to sort the data to have the oldest dates at the top, and newest at the bottom. I have pResort set to 1, but it still seems to be newest-at-top. Can you please confirm the right choices for that pResort switch?
#yiv2539961474 #yiv2539961474 -- #yiv2539961474ygrp-
Sat May 20, 2017 8:05 am (PDT) . Posted by:
eremon9
Add my thanks to those of all the others, Randy. I've been relying on your add-in for many years.
By way of additional debugging feedback, I notice that splits for RSP and BRK-B aren't handled. RSP a 4 for 1 split on on 4/27/06, and BRK-B a 50 for 1 split on 1/21/10.
Also, no data returned for WFC series L preferred stock.
Tom
By way of additional debugging feedback, I notice that splits for RSP and BRK-B aren't handled. RSP a 4 for 1 split on on 4/27/06, and BRK-B a 50 for 1 split on 1/21/10.
Also, no data returned for WFC series L preferred stock.
Tom
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar