[smf_addin] Digest Number 4088

EXCEL Stock Market Functions Add-in Group

10 Messages

Digest #4088

1.1

Re: smfPricesByDates not working by "Kermit W. Prather" kermitpra

1.2

Re: smfPricesByDates not working by "Mike" mikewa_68

1.3

Re: smfPricesByDates not working by "Mike" mikewa_68

1.4

Re: smfPricesByDates not working by "Randy Harmelink" rharmelink

1.5

Re: smfPricesByDates not working by "Mike" mikewa_68

1.6

Re: smfPricesByDates not working by "Randy Harmelink" rharmelink

2a

Element # 13863 Get Company Name not working by globalinkus

2b

Re: Element # 13863 Get Company Name not working by "Randy Harmelink" rharmelink

2c

Re: Element # 13863 Get Company Name not working by globalinkus

2d

Re: Element # 13863 Get Company Name not working by "Randy Harmelink" rharmelink

Messages

1.1

Re: smfPricesByDates not working

Tue Jul 11, 2017 8:35 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Mike is this suppose to be an EYE TEST.

How about using text we can read. thanks

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 10, 2017 11:31 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: smfPricesByDates not working


Thanks Randy,.

=RCHGetElementNumber("Version") returns the below..


Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in; Windows (32-bit) NT 6.01; 15.0; ; Local; 1)

When I put in -

=smfPricesByDates("IBM", DATE(2007,1,1))
or
=smfPricesByDates("IBM", "1/1/2007")

I get #N/A on both cells..

Am running Office 2013, if that makes a difference..

As stated, all other APIs appear to work without an issue. Only the date related ones seem to fault out on me..

Thanks!



On Saturday, July 8, 2017 6:14 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


These two examples from the documentation currently work for me:

=smfPricesByDates("IBM", DATE(2007,1,1))
=smfPricesByDates("IBM", "1/1/2007";)

First, check the version of the add-in you're running:

=RCHGetElementNumber("Version&quot;)

-- #NAME? would mean the function is not available.
-- #NA being returned would mean the date isn't valid.
-- "Error" can be any variety of things, as could the blanks.

On Sat, Jul 8, 2017 at 12:51 PM, Mike mikewa_68@
​...
wrote:

I feel like the odd man out here, so I suspect I'm missing something simple..

I've pulled in the latest Beta version of the XLA, and all the APIs work well for me except for the ones that pull info by date.
The samples don't work, much less any simple ones I try..

When I open the RCHGetYahooHistory or smfPricesByDates samples off the site, open and update them, I get either empty cells, #NAME?, #NA or Error

All the other APIs work without an issue..

I have the Add-In located at C:\SMF Add-In
I've got the Add-In installed properly, as other APIs (RCHGetYahooQuotes, RCHGetElementNumber) work without issue..

In the samples, where both RCHGetYahooQuotes and smfPricesByDates exist, RCHGetYahooQuotes works great, but smfPricesByDates fails..

Any insight?

Reply to sender . Reply to group . Reply via Web Post . All Messages (27) . Top ^

1.2

Re: smfPricesByDates not working

Tue Jul 11, 2017 9:19 am (PDT) . Posted by:

"Mike" mikewa_68

Sure Kermit.. Does this work better for you?

Consider getting help for your passive aggressive disorder. 
Not helping anyone with nonsense like that. 

On Tuesday, July 11, 2017 11:36 AM, "'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  Mike is this suppose to be an EYE TEST.  How about using text we can read. thanks  From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 10, 2017 11:31 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: smfPricesByDates not working  

Thanks Randy,.  =RCHGetElementNumber("Version") returns the below..   
| Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in; Windows (32-bit) NT 6.01; 15.0; ; Local; 1) |

 When I put in -       =smfPricesByDates("IBM", DATE(2007,1,1))
or 
   =smfPricesByDates("IBM", "1/1/2007")  I get #N/A on both cells..   Am running Office 2013, if that makes a difference..   As stated, all other APIs appear to work without an issue. Only the date related ones seem to fault out on me..   Thanks!      On Saturday, July 8, 2017 6:14 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:    These two examples from the documentation currently work for me:  =smfPricesByDates("IBM", DATE(2007,1,1))=smfPricesByDates("IBM", "1/1/2007";)  First, check the version of the add-in you're running:  =RCHGetElementNumber("Version&quot;)  -- #NAME? would mean the function is not available. -- #NA being returned would mean the date isn't valid.-- "Error" can be any variety of things, as could the blanks.  On Sat, Jul 8, 2017 at 12:51 PM, Mike mikewa_68@​... wrote:

 I feel like the odd man out here, so I suspect I'm missing something simple.. 

I've pulled in the latest Beta version of the XLA, and all the APIs work well for me except for the ones that pull info by date.The samples don't work, much less any simple ones I try.. 
When I open the RCHGetYahooHistory or smfPricesByDates samples off the site, open and update them, I get either empty cells, #NAME?, #NA or Error

All the other APIs work without an issue.. 

I have the Add-In located at C:\SMF Add-In
I've got the Add-In installed properly, as other APIs (RCHGetYahooQuotes,  RCHGetElementNumber) work without issue.. 

In the samples, where both RCHGetYahooQuotes and smfPricesByDates exist, RCHGetYahooQuotes works great, but smfPricesByDates fails..   Any insight?    

#yiv0002072914 #yiv0002072914 -- #yiv0002072914ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0002072914 #yiv0002072914ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0002072914 #yiv0002072914ygrp-mkp #yiv0002072914hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0002072914 #yiv0002072914ygrp-mkp #yiv0002072914ads {margin-bottom:10px;}#yiv0002072914 #yiv0002072914ygrp-mkp .yiv0002072914ad {padding:0 0;}#yiv0002072914 #yiv0002072914ygrp-mkp .yiv0002072914ad p {margin:0;}#yiv0002072914 #yiv0002072914ygrp-mkp .yiv0002072914ad a {color:#0000ff;text-decoration:none;}#yiv0002072914 #yiv0002072914ygrp-sponsor #yiv0002072914ygrp-lc {font-family:Arial;}#yiv0002072914 #yiv0002072914ygrp-sponsor #yiv0002072914ygrp-lc #yiv0002072914hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0002072914 #yiv0002072914ygrp-sponsor #yiv0002072914ygrp-lc .yiv0002072914ad {margin-bottom:10px;padding:0 0;}#yiv0002072914 #yiv0002072914actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0002072914 #yiv0002072914activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0002072914 #yiv0002072914activity span {font-weight:700;}#yiv0002072914 #yiv0002072914activity span:first-child {text-transform:uppercase;}#yiv0002072914 #yiv0002072914activity span a {color:#5085b6;text-decoration:none;}#yiv0002072914 #yiv0002072914activity span span {color:#ff7900;}#yiv0002072914 #yiv0002072914activity span .yiv0002072914underline {text-decoration:underline;}#yiv0002072914 .yiv0002072914attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0002072914 .yiv0002072914attach div a {text-decoration:none;}#yiv0002072914 .yiv0002072914attach img {border:none;padding-right:5px;}#yiv0002072914 .yiv0002072914attach label {display:block;margin-bottom:5px;}#yiv0002072914 .yiv0002072914attach label a {text-decoration:none;}#yiv0002072914 blockquote {margin:0 0 0 4px;}#yiv0002072914 .yiv0002072914bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0002072914 .yiv0002072914bold a {text-decoration:none;}#yiv0002072914 dd.yiv0002072914last p a {font-family:Verdana;font-weight:700;}#yiv0002072914 dd.yiv0002072914last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0002072914 dd.yiv0002072914last p span.yiv0002072914yshortcuts {margin-right:0;}#yiv0002072914 div.yiv0002072914attach-table div div a {text-decoration:none;}#yiv0002072914 div.yiv0002072914attach-table {width:400px;}#yiv0002072914 div.yiv0002072914file-title a, #yiv0002072914 div.yiv0002072914file-title a:active, #yiv0002072914 div.yiv0002072914file-title a:hover, #yiv0002072914 div.yiv0002072914file-title a:visited {text-decoration:none;}#yiv0002072914 div.yiv0002072914photo-title a, #yiv0002072914 div.yiv0002072914photo-title a:active, #yiv0002072914 div.yiv0002072914photo-title a:hover, #yiv0002072914 div.yiv0002072914photo-title a:visited {text-decoration:none;}#yiv0002072914 div#yiv0002072914ygrp-mlmsg #yiv0002072914ygrp-msg p a span.yiv0002072914yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0002072914 .yiv0002072914green {color:#628c2a;}#yiv0002072914 .yiv0002072914MsoNormal {margin:0 0 0 0;}#yiv0002072914 o {font-size:0;}#yiv0002072914 #yiv0002072914photos div {float:left;width:72px;}#yiv0002072914 #yiv0002072914photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0002072914 #yiv0002072914photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0002072914 #yiv0002072914reco-category {font-size:77%;}#yiv0002072914 #yiv0002072914reco-desc {font-size:77%;}#yiv0002072914 .yiv0002072914replbq {margin:4px;}#yiv0002072914 #yiv0002072914ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0002072914 #yiv0002072914ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0002072914 #yiv0002072914ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0002072914 #yiv0002072914ygrp-mlmsg select, #yiv0002072914 input, #yiv0002072914 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0002072914 #yiv0002072914ygrp-mlmsg pre, #yiv0002072914 code {font:115% monospace;}#yiv0002072914 #yiv0002072914ygrp-mlmsg * {line-height:1.22em;}#yiv0002072914 #yiv0002072914ygrp-mlmsg #yiv0002072914logo {padding-bottom:10px;}#yiv0002072914 #yiv0002072914ygrp-msg p a {font-family:Verdana;}#yiv0002072914 #yiv0002072914ygrp-msg p#yiv0002072914attach-count span {color:#1E66AE;font-weight:700;}#yiv0002072914 #yiv0002072914ygrp-reco #yiv0002072914reco-head {color:#ff7900;font-weight:700;}#yiv0002072914 #yiv0002072914ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0002072914 #yiv0002072914ygrp-sponsor #yiv0002072914ov li a {font-size:130%;text-decoration:none;}#yiv0002072914 #yiv0002072914ygrp-sponsor #yiv0002072914ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0002072914 #yiv0002072914ygrp-sponsor #yiv0002072914ov ul {margin:0;padding:0 0 0 8px;}#yiv0002072914 #yiv0002072914ygrp-text {font-family:Georgia;}#yiv0002072914 #yiv0002072914ygrp-text p {margin:0 0 1em 0;}#yiv0002072914 #yiv0002072914ygrp-text tt {font-size:120%;}#yiv0002072914 #yiv0002072914ygrp-vital ul li:last-child {border-right:none !important;}#yiv0002072914

Reply to sender . Reply to group . Reply via Web Post . All Messages (27) . Top ^

1.3

Re: smfPricesByDates not working

Tue Jul 11, 2017 10:14 am (PDT) . Posted by:

"Mike" mikewa_68

I see whats going on here.
When I make the call, the API call, Excel tries to make a CONNECT call to https://ichart.finance.yahoo.com, and that fails.  

ichart.finance.yahoo.com doesn't appear to be a DNS resolvable name. 
Do the date APIs rely on connectivity to ichart.finance.yahoo.com, and if so, is that working for others?
According to Is Yahoo! Finance API broken?, this feature has been discontinued. 

|
| |
Is Yahoo! Finance API broken?
I was trying to use R quantmod to get historical stock price from Yahoo but get the error saying cannot open URL... | |

|

If this is working properly for others, I'd love to understand whether there are differences in how this is being performed.
Is the newer Beta version supposed to be using a different URL for this data?
Thanks!


On Tuesday, July 11, 2017 12:19 PM, "Mike mikewa_68@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  Sure Kermit.. Does this work better for you?

Consider getting help for your passive aggressive disorder. 
Not helping anyone with nonsense like that. 

On Tuesday, July 11, 2017 11:36 AM, "'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  Mike is this suppose to be an EYE TEST.  How about using text we can read. thanks  From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 10, 2017 11:31 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: smfPricesByDates not working  

Thanks Randy,.  =RCHGetElementNumber("Version") returns the below..   
| Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in; Windows (32-bit) NT 6.01; 15.0; ; Local; 1) |

 When I put in -       =smfPricesByDates("IBM", DATE(2007,1,1))
or 
   =smfPricesByDates("IBM", "1/1/2007")  I get #N/A on both cells..   Am running Office 2013, if that makes a difference..   As stated, all other APIs appear to work without an issue. Only the date related ones seem to fault out on me..   Thanks!      On Saturday, July 8, 2017 6:14 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:    These two examples from the documentation currently work for me:  =smfPricesByDates("IBM", DATE(2007,1,1))=smfPricesByDates("IBM", "1/1/2007";)  First, check the version of the add-in you're running:  =RCHGetElementNumber("Version&quot;)  -- #NAME? would mean the function is not available. -- #NA being returned would mean the date isn't valid.-- "Error" can be any variety of things, as could the blanks.  On Sat, Jul 8, 2017 at 12:51 PM, Mike mikewa_68@​... wrote:

 I feel like the odd man out here, so I suspect I'm missing something simple.. 

I've pulled in the latest Beta version of the XLA, and all the APIs work well for me except for the ones that pull info by date.The samples don't work, much less any simple ones I try.. 
When I open the RCHGetYahooHistory or smfPricesByDates samples off the site, open and update them, I get either empty cells, #NAME?, #NA or Error

All the other APIs work without an issue.. 

I have the Add-In located at C:\SMF Add-In
I've got the Add-In installed properly, as other APIs (RCHGetYahooQuotes,  RCHGetElementNumber) work without issue.. 

In the samples, where both RCHGetYahooQuotes and smfPricesByDates exist, RCHGetYahooQuotes works great, but smfPricesByDates fails..   Any insight?    

#yiv1528885151 #yiv1528885151 -- #yiv1528885151ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1528885151 #yiv1528885151ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1528885151 #yiv1528885151ygrp-mkp #yiv1528885151hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1528885151 #yiv1528885151ygrp-mkp #yiv1528885151ads {margin-bottom:10px;}#yiv1528885151 #yiv1528885151ygrp-mkp .yiv1528885151ad {padding:0 0;}#yiv1528885151 #yiv1528885151ygrp-mkp .yiv1528885151ad p {margin:0;}#yiv1528885151 #yiv1528885151ygrp-mkp .yiv1528885151ad a {color:#0000ff;text-decoration:none;}#yiv1528885151 #yiv1528885151ygrp-sponsor #yiv1528885151ygrp-lc {font-family:Arial;}#yiv1528885151 #yiv1528885151ygrp-sponsor #yiv1528885151ygrp-lc #yiv1528885151hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1528885151 #yiv1528885151ygrp-sponsor #yiv1528885151ygrp-lc .yiv1528885151ad {margin-bottom:10px;padding:0 0;}#yiv1528885151 #yiv1528885151actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1528885151 #yiv1528885151activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1528885151 #yiv1528885151activity span {font-weight:700;}#yiv1528885151 #yiv1528885151activity span:first-child {text-transform:uppercase;}#yiv1528885151 #yiv1528885151activity span a {color:#5085b6;text-decoration:none;}#yiv1528885151 #yiv1528885151activity span span {color:#ff7900;}#yiv1528885151 #yiv1528885151activity span .yiv1528885151underline {text-decoration:underline;}#yiv1528885151 .yiv1528885151attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1528885151 .yiv1528885151attach div a {text-decoration:none;}#yiv1528885151 .yiv1528885151attach img {border:none;padding-right:5px;}#yiv1528885151 .yiv1528885151attach label {display:block;margin-bottom:5px;}#yiv1528885151 .yiv1528885151attach label a {text-decoration:none;}#yiv1528885151 blockquote {margin:0 0 0 4px;}#yiv1528885151 .yiv1528885151bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1528885151 .yiv1528885151bold a {text-decoration:none;}#yiv1528885151 dd.yiv1528885151last p a {font-family:Verdana;font-weight:700;}#yiv1528885151 dd.yiv1528885151last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1528885151 dd.yiv1528885151last p span.yiv1528885151yshortcuts {margin-right:0;}#yiv1528885151 div.yiv1528885151attach-table div div a {text-decoration:none;}#yiv1528885151 div.yiv1528885151attach-table {width:400px;}#yiv1528885151 div.yiv1528885151file-title a, #yiv1528885151 div.yiv1528885151file-title a:active, #yiv1528885151 div.yiv1528885151file-title a:hover, #yiv1528885151 div.yiv1528885151file-title a:visited {text-decoration:none;}#yiv1528885151 div.yiv1528885151photo-title a, #yiv1528885151 div.yiv1528885151photo-title a:active, #yiv1528885151 div.yiv1528885151photo-title a:hover, #yiv1528885151 div.yiv1528885151photo-title a:visited {text-decoration:none;}#yiv1528885151 div#yiv1528885151ygrp-mlmsg #yiv1528885151ygrp-msg p a span.yiv1528885151yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1528885151 .yiv1528885151green {color:#628c2a;}#yiv1528885151 .yiv1528885151MsoNormal {margin:0 0 0 0;}#yiv1528885151 o {font-size:0;}#yiv1528885151 #yiv1528885151photos div {float:left;width:72px;}#yiv1528885151 #yiv1528885151photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1528885151 #yiv1528885151photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1528885151 #yiv1528885151reco-category {font-size:77%;}#yiv1528885151 #yiv1528885151reco-desc {font-size:77%;}#yiv1528885151 .yiv1528885151replbq {margin:4px;}#yiv1528885151 #yiv1528885151ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1528885151 #yiv1528885151ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1528885151 #yiv1528885151ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1528885151 #yiv1528885151ygrp-mlmsg select, #yiv1528885151 input, #yiv1528885151 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1528885151 #yiv1528885151ygrp-mlmsg pre, #yiv1528885151 code {font:115% monospace;}#yiv1528885151 #yiv1528885151ygrp-mlmsg * {line-height:1.22em;}#yiv1528885151 #yiv1528885151ygrp-mlmsg #yiv1528885151logo {padding-bottom:10px;}#yiv1528885151 #yiv1528885151ygrp-msg p a {font-family:Verdana;}#yiv1528885151 #yiv1528885151ygrp-msg p#yiv1528885151attach-count span {color:#1E66AE;font-weight:700;}#yiv1528885151 #yiv1528885151ygrp-reco #yiv1528885151reco-head {color:#ff7900;font-weight:700;}#yiv1528885151 #yiv1528885151ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1528885151 #yiv1528885151ygrp-sponsor #yiv1528885151ov li a {font-size:130%;text-decoration:none;}#yiv1528885151 #yiv1528885151ygrp-sponsor #yiv1528885151ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1528885151 #yiv1528885151ygrp-sponsor #yiv1528885151ov ul {margin:0;padding:0 0 0 8px;}#yiv1528885151 #yiv1528885151ygrp-text {font-family:Georgia;}#yiv1528885151 #yiv1528885151ygrp-text p {margin:0 0 1em 0;}#yiv1528885151 #yiv1528885151ygrp-text tt {font-size:120%;}#yiv1528885151 #yiv1528885151ygrp-vital ul li:last-child {border-right:none !important;}#yiv1528885151

Reply to sender . Reply to group . Reply via Web Post . All Messages (27) . Top ^

1.4

Re: smfPricesByDates not working

Tue Jul 11, 2017 10:24 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yes, the new function grabs the data from a different source, because the
old API was discontinued. smfGetYahooHistory() uses the JSON data that is
within the normal historical quotes web page.

On Tue, Jul 11, 2017 at 10:10 AM, Mike mikewa_68@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I see whats going on here.
> When I make the call, the API call, Excel tries to make a CONNECT call to
> https://ichart.finance.yahoo.com, and that fails.
>
> ichart.finance.yahoo.com doesn't appear to be a DNS resolvable name.
> Do the date APIs rely on connectivity to ichart.finance.yahoo.com, and if
> so, is that working for others?
>
> According to Is Yahoo! Finance API broken?
> <https://forums.yahoo.net/t5/Yahoo-Finance-help/Is-Yahoo-Finance-API-broken/td-p/250503?soc_src=mail&soc_trk=ma>,
> this feature has been discontinued.
>
> Is Yahoo! Finance API broken?
> I was trying to use R quantmod to get historical stock price from Yahoo
> but get the error saying cannot open URL...
>
> <https://forums.yahoo.net/t5/Yahoo-Finance-help/Is-Yahoo-Finance-API-broken/td-p/250503?soc_src=mail&soc_trk=ma>
>
>
> If this is working properly for others, I'd love to understand whether
> there are differences in how this is being performed.
>
> Is the newer Beta version supposed to be using a different URL for this
> data?
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (27) . Top ^

1.5

Re: smfPricesByDates not working

Tue Jul 11, 2017 10:38 am (PDT) . Posted by:

"Mike" mikewa_68

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?

On Tuesday, July 11, 2017 1:24 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  Yes, the new function grabs the data from a different source, because the old API was discontinued. smfGetYahooHistory() uses the JSON data that is within the normal historical quotes web page.
On Tue, Jul 11, 2017 at 10:10 AM, Mike mikewa_68@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

I see whats going on here.
When I make the call, the API call, Excel tries to make a CONNECT call to https://ichart.finance.yahoo. com, and that fails.  

ichart.finance.yahoo.com  doesn't appear to be a DNS resolvable name. 
Do the date APIs rely on connectivity to ichart.finance.yahoo.com, a nd if so, is that working for others?
According to Is Yahoo! Finance API broken?, this feature has been discontinued. 

|
| |
Is Yahoo! Finance API broken?
I was trying to use R quantmod to get historical stock price from Yahoo but get the error saying cannot open URL... | |

|

If this is working properly for others, I'd love to understand whether there are differences in how this is being performed.
Is the newer Beta version supposed to be using a different URL for this data?

#yiv1570901872 #yiv1570901872 -- #yiv1570901872ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1570901872 #yiv1570901872ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1570901872 #yiv1570901872ygrp-mkp #yiv1570901872hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1570901872 #yiv1570901872ygrp-mkp #yiv1570901872ads {margin-bottom:10px;}#yiv1570901872 #yiv1570901872ygrp-mkp .yiv1570901872ad {padding:0 0;}#yiv1570901872 #yiv1570901872ygrp-mkp .yiv1570901872ad p {margin:0;}#yiv1570901872 #yiv1570901872ygrp-mkp .yiv1570901872ad a {color:#0000ff;text-decoration:none;}#yiv1570901872 #yiv1570901872ygrp-sponsor #yiv1570901872ygrp-lc {font-family:Arial;}#yiv1570901872 #yiv1570901872ygrp-sponsor #yiv1570901872ygrp-lc #yiv1570901872hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1570901872 #yiv1570901872ygrp-sponsor #yiv1570901872ygrp-lc .yiv1570901872ad {margin-bottom:10px;padding:0 0;}#yiv1570901872 #yiv1570901872actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1570901872 #yiv1570901872activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1570901872 #yiv1570901872activity span {font-weight:700;}#yiv1570901872 #yiv1570901872activity span:first-child {text-transform:uppercase;}#yiv1570901872 #yiv1570901872activity span a {color:#5085b6;text-decoration:none;}#yiv1570901872 #yiv1570901872activity span span {color:#ff7900;}#yiv1570901872 #yiv1570901872activity span .yiv1570901872underline {text-decoration:underline;}#yiv1570901872 .yiv1570901872attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1570901872 .yiv1570901872attach div a {text-decoration:none;}#yiv1570901872 .yiv1570901872attach img {border:none;padding-right:5px;}#yiv1570901872 .yiv1570901872attach label {display:block;margin-bottom:5px;}#yiv1570901872 .yiv1570901872attach label a {text-decoration:none;}#yiv1570901872 blockquote {margin:0 0 0 4px;}#yiv1570901872 .yiv1570901872bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1570901872 .yiv1570901872bold a {text-decoration:none;}#yiv1570901872 dd.yiv1570901872last p a {font-family:Verdana;font-weight:700;}#yiv1570901872 dd.yiv1570901872last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1570901872 dd.yiv1570901872last p span.yiv1570901872yshortcuts {margin-right:0;}#yiv1570901872 div.yiv1570901872attach-table div div a {text-decoration:none;}#yiv1570901872 div.yiv1570901872attach-table {width:400px;}#yiv1570901872 div.yiv1570901872file-title a, #yiv1570901872 div.yiv1570901872file-title a:active, #yiv1570901872 div.yiv1570901872file-title a:hover, #yiv1570901872 div.yiv1570901872file-title a:visited {text-decoration:none;}#yiv1570901872 div.yiv1570901872photo-title a, #yiv1570901872 div.yiv1570901872photo-title a:active, #yiv1570901872 div.yiv1570901872photo-title a:hover, #yiv1570901872 div.yiv1570901872photo-title a:visited {text-decoration:none;}#yiv1570901872 div#yiv1570901872ygrp-mlmsg #yiv1570901872ygrp-msg p a span.yiv1570901872yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1570901872 .yiv1570901872green {color:#628c2a;}#yiv1570901872 .yiv1570901872MsoNormal {margin:0 0 0 0;}#yiv1570901872 o {font-size:0;}#yiv1570901872 #yiv1570901872photos div {float:left;width:72px;}#yiv1570901872 #yiv1570901872photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1570901872 #yiv1570901872photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1570901872 #yiv1570901872reco-category {font-size:77%;}#yiv1570901872 #yiv1570901872reco-desc {font-size:77%;}#yiv1570901872 .yiv1570901872replbq {margin:4px;}#yiv1570901872 #yiv1570901872ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1570901872 #yiv1570901872ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1570901872 #yiv1570901872ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1570901872 #yiv1570901872ygrp-mlmsg select, #yiv1570901872 input, #yiv1570901872 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1570901872 #yiv1570901872ygrp-mlmsg pre, #yiv1570901872 code {font:115% monospace;}#yiv1570901872 #yiv1570901872ygrp-mlmsg * {line-height:1.22em;}#yiv1570901872 #yiv1570901872ygrp-mlmsg #yiv1570901872logo {padding-bottom:10px;}#yiv1570901872 #yiv1570901872ygrp-msg p a {font-family:Verdana;}#yiv1570901872 #yiv1570901872ygrp-msg p#yiv1570901872attach-count span {color:#1E66AE;font-weight:700;}#yiv1570901872 #yiv1570901872ygrp-reco #yiv1570901872reco-head {color:#ff7900;font-weight:700;}#yiv1570901872 #yiv1570901872ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1570901872 #yiv1570901872ygrp-sponsor #yiv1570901872ov li a {font-size:130%;text-decoration:none;}#yiv1570901872 #yiv1570901872ygrp-sponsor #yiv1570901872ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1570901872 #yiv1570901872ygrp-sponsor #yiv1570901872ov ul {margin:0;padding:0 0 0 8px;}#yiv1570901872 #yiv1570901872ygrp-text {font-family:Georgia;}#yiv1570901872 #yiv1570901872ygrp-text p {margin:0 0 1em 0;}#yiv1570901872 #yiv1570901872ygrp-text tt {font-size:120%;}#yiv1570901872 #yiv1570901872ygrp-vital ul li:last-child {border-right:none !important;}#yiv1570901872

Reply to sender . Reply to group . Reply via Web Post . All Messages (27) . Top ^

1.6

Re: smfPricesByDates not working

Tue Jul 11, 2017 11:00 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

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?
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (27) . Top ^

2a

Element # 13863 Get Company Name not working

Tue Jul 11, 2017 1:18 pm (PDT) . Posted by:

globalinkus

Hello!

Element 13863 stopped working a few weeks or may be months ago - I guess it is related to the "language"; changes at Yahoo

is there a replacement for that function?

Your help is appreciated

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2b

Re: Element # 13863 Get Company Name not working

Tue Jul 11, 2017 2:25 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's working here. It's redirecting the URL under the new Yahoo setup. This
Internet Explorer option may fix the problem:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/10464

Let me know?

On Tue, Jul 11, 2017 at 1:18 PM, adelgado@
​...
wrote:

>
> Element 13863 stopped working a few weeks or may be months ago - I guess
> it is related to the "language"; changes at Yahoo
>
> is there a replacement for that function?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2c

Re: Element # 13863 Get Company Name not working

Tue Jul 11, 2017 3:56 pm (PDT) . Posted by:

globalinkus

Sorry, Randy but I am lost..... I use Firefox, not IE.

I don´t understand how IE affects Excel retrieving the info - I get all other elements on my spread, but for the Company Name... and you talk about a "redirect";: did Yahoo change the page names and that is causing my issue?

Thanks for your help!

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2d

Re: Element # 13863 Get Company Name not working

Tue Jul 11, 2017 4:25 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

What browser you use is irrelevant. I use a combination of FireFox, Chrome,
and Edge, depending on the machine and what I'm doing.

The add-in uses Microsoft DLLs. They are the same routines used by EXCEL
and Internet Explorer to access the Internet, so they use IE's cookies and
settings.

The web page used in the element definition no longer exists, so it
redirects the request to the new Yahoo web page. Sometimes the "across
domains" setting fixes that so it works without an issue. But not always.

Eventually, the elements will be redefined, but with all of the recent
Yahoo changes, it is a low priority.

You can always use:

=RCHGetYahooQuotes("MMM","n")

On Tue, Jul 11, 2017 at 3:56 PM, adelgado@
​...
wrote:

>
> Sorry, Randy but I am lost..... I use Firefox, not IE.
>
> I don´t understand how IE affects Excel retrieving the info - I get all
> other elements on my spread, but for the Company Name... and you talk about
> a "redirect";: did Yahoo change the page names and that is causing my issue?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

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

Visit Your Group

• New Members 8

• Privacy • Unsubscribe • Terms of Use