Selasa, 02 Mei 2017

[smf_addin] Digest Number 3992

15 Messages

Digest #3992
1.2
2c
Re: Excel 2013 Update 15.0.4919.1002 by "Randy Harmelink" rharmelink
2e
Re: Excel 2013 Update 15.0.4919.1002 by "Randy Harmelink" rharmelink
2f
Re: Excel 2013 Update 15.0.4919.1002 by "Randy Harmelink" rharmelink
3b
Re: smfGetYahooPortfolioView Also Broken by "Randy Harmelink" rharmelink
3c
4
RCHGetYahooHistory Not Working by fierro.gaspar@ymail.com

Messages

Tue May 2, 2017 4:28 am (PDT) . Posted by:

"Archie Roa" bleushin19

Hi Randy,

About the new update, I keep having error saying " Office has detected a problem with this file. To help protect your computer this file cannot be opened."
when pressing the help button, it shows "The Office File Validation feature has blocked this file from opening as it may contain harmful content."

Any suggestion/advice on what to do?

Thanks,
--------------------------------------------
On Tue, 5/2/17, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Recent File updates on the SMF Add-in Website
To: smf_addin@yahoogroups.com
Date: Tuesday, May 2, 2017, 3:27 AM


 









More Yahoo changes

Hopefully, the latest change will
fix all of the "Error" responses in Yahoo data
retrievals.

DateRoutineDescription2017-05-01(Many)Modified routine to retrieve web
pages
2017-04-27smfGetYahooJSONFieldNew experimental function to
extract data by field name from JSON file

Check these website
pages for updates:

-- http://ogres-crypt.com/SMF/
-- http://ogres-crypt.com/SMF/
Documentation/​

New/updated files:

-- RCH_Stock_Market_Functions-2.
1.2017.05.01.zip​

--
​Change-Log.html
--
smfGetYahooJSONField-Function. html

Best practice is to close EXCEL before
updating file in the SMF folder.










#yiv4030744032 #yiv4030744032 --
#yiv4030744032ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv4030744032 #yiv4030744032ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv4030744032 #yiv4030744032ygrp-mkp #yiv4030744032hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv4030744032 #yiv4030744032ygrp-mkp #yiv4030744032ads {
margin-bottom:10px;}

#yiv4030744032 #yiv4030744032ygrp-mkp .yiv4030744032ad {
padding:0 0;}

#yiv4030744032 #yiv4030744032ygrp-mkp .yiv4030744032ad p {
margin:0;}

#yiv4030744032 #yiv4030744032ygrp-mkp .yiv4030744032ad a {
color:#0000ff;text-decoration:none;}
#yiv4030744032 #yiv4030744032ygrp-sponsor
#yiv4030744032ygrp-lc {
font-family:Arial;}

#yiv4030744032 #yiv4030744032ygrp-sponsor
#yiv4030744032ygrp-lc #yiv4030744032hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv4030744032 #yiv4030744032ygrp-sponsor
#yiv4030744032ygrp-lc .yiv4030744032ad {
margin-bottom:10px;padding:0 0;}

#yiv4030744032 #yiv4030744032actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv4030744032 #yiv4030744032activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv4030744032 #yiv4030744032activity span {
font-weight:700;}

#yiv4030744032 #yiv4030744032activity span:first-child {
text-transform:uppercase;}

#yiv4030744032 #yiv4030744032activity span a {
color:#5085b6;text-decoration:none;}

#yiv4030744032 #yiv4030744032activity span span {
color:#ff7900;}

#yiv4030744032 #yiv4030744032activity span
.yiv4030744032underline {
text-decoration:underline;}

#yiv4030744032 .yiv4030744032attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv4030744032 .yiv4030744032attach div a {
text-decoration:none;}

#yiv4030744032 .yiv4030744032attach img {
border:none;padding-right:5px;}

#yiv4030744032 .yiv4030744032attach label {
display:block;margin-bottom:5px;}

#yiv4030744032 .yiv4030744032attach label a {
text-decoration:none;}

#yiv4030744032 blockquote {
margin:0 0 0 4px;}

#yiv4030744032 .yiv4030744032bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv4030744032 .yiv4030744032bold a {
text-decoration:none;}

#yiv4030744032 dd.yiv4030744032last p a {
font-family:Verdana;font-weight:700;}

#yiv4030744032 dd.yiv4030744032last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv4030744032 dd.yiv4030744032last p
span.yiv4030744032yshortcuts {
margin-right:0;}

#yiv4030744032 div.yiv4030744032attach-table div div a {
text-decoration:none;}

#yiv4030744032 div.yiv4030744032attach-table {
width:400px;}

#yiv4030744032 div.yiv4030744032file-title a, #yiv4030744032
div.yiv4030744032file-title a:active, #yiv4030744032
div.yiv4030744032file-title a:hover, #yiv4030744032
div.yiv4030744032file-title a:visited {
text-decoration:none;}

#yiv4030744032 div.yiv4030744032photo-title a,
#yiv4030744032 div.yiv4030744032photo-title a:active,
#yiv4030744032 div.yiv4030744032photo-title a:hover,
#yiv4030744032 div.yiv4030744032photo-title a:visited {
text-decoration:none;}

#yiv4030744032 div#yiv4030744032ygrp-mlmsg
#yiv4030744032ygrp-msg p a span.yiv4030744032yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv4030744032 .yiv4030744032green {
color:#628c2a;}

#yiv4030744032 .yiv4030744032MsoNormal {
margin:0 0 0 0;}

#yiv4030744032 o {
font-size:0;}

#yiv4030744032 #yiv4030744032photos div {
float:left;width:72px;}

#yiv4030744032 #yiv4030744032photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv4030744032 #yiv4030744032photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv4030744032 #yiv4030744032reco-category {
font-size:77%;}

#yiv4030744032 #yiv4030744032reco-desc {
font-size:77%;}

#yiv4030744032 .yiv4030744032replbq {
margin:4px;}

#yiv4030744032 #yiv4030744032ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv4030744032 #yiv4030744032ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv4030744032 #yiv4030744032ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv4030744032 #yiv4030744032ygrp-mlmsg select,
#yiv4030744032 input, #yiv4030744032 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv4030744032 #yiv4030744032ygrp-mlmsg pre, #yiv4030744032
code {
font:115% monospace;}

#yiv4030744032 #yiv4030744032ygrp-mlmsg * {
line-height:1.22em;}

#yiv4030744032 #yiv4030744032ygrp-mlmsg #yiv4030744032logo {
padding-bottom:10px;}


#yiv4030744032 #yiv4030744032ygrp-msg p a {
font-family:Verdana;}

#yiv4030744032 #yiv4030744032ygrp-msg
p#yiv4030744032attach-count span {
color:#1E66AE;font-weight:700;}

#yiv4030744032 #yiv4030744032ygrp-reco
#yiv4030744032reco-head {
color:#ff7900;font-weight:700;}

#yiv4030744032 #yiv4030744032ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv4030744032 #yiv4030744032ygrp-sponsor #yiv4030744032ov
li a {
font-size:130%;text-decoration:none;}

#yiv4030744032 #yiv4030744032ygrp-sponsor #yiv4030744032ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv4030744032 #yiv4030744032ygrp-sponsor #yiv4030744032ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv4030744032 #yiv4030744032ygrp-text {
font-family:Georgia;}

#yiv4030744032 #yiv4030744032ygrp-text p {
margin:0 0 1em 0;}

#yiv4030744032 #yiv4030744032ygrp-text tt {
font-size:120%;}

#yiv4030744032 #yiv4030744032ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv4030744032


Tue May 2, 2017 9:25 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This may be the issue that started in July of last year because MicroSoft
issued some security updates. For a workaround suggested by Microsoft,
until they fix the issue, see:

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

When I search Google on your message, I found a similar work-around:

https://support.microsoft.com/en-us/help/973736/error-message-in-microsoft-office-2010-office-has-detected-a-problem-with-this-file

On Tue, May 2, 2017 at 4:24 AM, Archie Roa bleushin19@
​...wrote:

>
> About the new update, I keep having error saying " Office has detected a
> problem with this file. To help protect your computer this file cannot be
> opened."
> when pressing the help button, it shows "The Office File Validation
> feature has blocked this file from opening as it may contain harmful
> content."
>
> Any suggestion/advice on what to do?
>

Tue May 2, 2017 7:33 am (PDT) . Posted by:

tom835720

Hello Randy,

I "unblocked&quot; the ".XLA" file, and the =RCHGetElementNumber("Version&quot;) formula now returns the correct answer, so the add-in is now active. However, my spreadsheet makes use of elements that apparently need to be updated, elements 554 to 600, which are on the YahooAE page. The cells that contain the =RCHGetElementNumber formula referencing those element numbers return the dreaded "error." So sorry to be the bearer of ill-tidings, but it may be necessary to update the Elements yet again to fix this.


Warm regards,
Tom



Tue May 2, 2017 9:17 am (PDT) . Posted by:

mark_knipping

Randy,

I'm seeing the same message #NAME? No issues with Excel blocking the file. Just the new add-in version isn't working.


Any ideas?


Thanks, Mark

Tue May 2, 2017 9:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The SMF-Template-Yahoo-Analyst-Estimates.xls appears to be working fine for
me. I tried several different tickers, including MMM, IBM, and INTC.

What do you get with:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",554)
=RCHGetElementNumber("Definition",554)
=RCHGetTableCell("https://finance.yahoo.com/q/ae?s=MMM",2,">EPS Trend",">")

On Tue, May 2, 2017 at 7:33 AM, tomoesterle@
​...wrote:

>
> I "unblocked&quot; the ".XLA" file, and the =RCHGetElementNumber("Version&quot;)
> formula now returns the correct answer, so the add-in is now active.
> However, my spreadsheet makes use of elements that apparently need to be
> updated, elements 554 to 600, which are on the YahooAE page. The cells
> that contain the =RCHGetElementNumber formula referencing those element
> numbers return the dreaded "error." So sorry to be the bearer of
> ill-tidings, but it may be necessary to update the Elements yet again to
> fix this.
>
>

Tue May 2, 2017 9:41 am (PDT) . Posted by:

tom835720

Interesting .... this is what I get for those 4 formulas


=RCHGetElementNumber("Version")
Stock Market Functions add-in, Version 2.1.2017.04.26 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 15.0; www; Local; 1)

=RCHGetElementNumber("MMM",554)
Error

=RCHGetElementNumber("Definition",554)
YahooAE;Consensus EPS Trend -- Date -- FQ2;https://finance.yahoo.com/q/ae?s=~~~~~;2;>EPS Trend;>; ; ;0;0;0;0

RCHGetTableCell("https://finance.yahoo.com/q/ae?s=MMM https://finance.yahoo.com/q/ae?s=MMM",2,">EPS Trend",">")
Error https://finance.yahoo.com/q/ae?s=MMM




T



Tue May 2, 2017 9:47 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You're getting #NAME? on this?

=RCHGetElementNumber("Version&quot;)

That invocation doesn't even access the Internet, so I would think it has
to mean the add-in isn't active. Close EXCEL, restart it, and try again. If
you get the same error, then be sure to check the add-in manager and make
sure the SMF add-in is there and is checked.

On Tue, May 2, 2017 at 6:23 AM, mark_knipping@
​...wrote:

>
> I'm seeing the same message #NAME? No issues with Excel blocking the
> file. Just the new add-in version isn't working.
>
> Any ideas?
>
>

Tue May 2, 2017 9:48 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You're using the 2017-04-26 version of the add-in. You need the most recent
release, 2017-05-01, which fixed another issue that popped up with Yahoo.

On Tue, May 2, 2017 at 9:41 AM, tomoesterle@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Interesting .... this is what I get for those 4 formulas
>
> =RCHGetElementNumber("Version")
> Stock Market Functions add-in, Version 2.1.2017.04.26 (C:\SMF Add-In;
> Windows (32-bit) NT 6.01; 15.0; www; Local; 1)
>
> =RCHGetElementNumber("MMM",554)
> Error
>
> =RCHGetElementNumber("Definition",554)
> YahooAE;Consensus EPS Trend -- Date -- FQ2;https://finance.yahoo.com/
> q/ae?s=~~~~~;2;>EPS Trend;>; ; ;0;0;0;0
>
> RCHGetTableCell("https://finance.yahoo.com/q/ae?s=MMM",2,">EPS Trend",">")
> Error <https://finance.yahoo.com/q/ae?s=MMM>
>
>
>

Tue May 2, 2017 10:15 am (PDT) . Posted by:

jimmymc00

Randy. Just a short note to say "Thanks" for all the help and the tireless commitment you are giving us users of the SMF Add In. I've been using the 2014 version up to this point with good results until the recent Yahoo changes finally found me. Yep, I've been lucky to make it this far without upgrading which has been a big fear for me due to my lack of expertise in this area and fear of screwing up a good thing. After a few hours of trying to upgrade last night I finally got things working again with my Win 10 and 2013 Excel system and couldn't be happier. I'm a daily user who manages several portfolios so this is a big deal for me.

Sorry to ramble on, the whole point of writing this was to say Thank You and to let you know how much I, and I'm sure many other users, appreciate what you do for us. Best regards. Jim

-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, May 2, 2017 12:47 pm
Subject: Re: [smf_addin] Excel 2013 Update 15.0.4919.1002

You're getting #NAME? on this?

=RCHGetElementNumber("Version&quot;)

That invocation doesn't even access the Internet, so I would think it has to mean the add-in isn't active. Close EXCEL, restart it, and try again. If you get the same error, then be sure to check the add-in manager and make sure the SMF add-in is there and is checked.

On Tue, May 2, 2017 at 6:23 AM, mark_knipping@
​...wrote:

I'm seeing the same message #NAME? No issues with Excel blocking the file. Just the new add-in version isn't working.

Any ideas?

Tue May 2, 2017 11:05 am (PDT) . Posted by:

tom835720

Thanks. Don't know why but http://ogres-crypt.com/SMF/ http://ogres-crypt.com/SMF/ had the 4-26 version, but it has now updated with the 5-1-17 version.

The 5-1-17 version seems to be working fine. Thank you very much.


I echo what so many others have said, that you provide an invaluable service to us all, to which I am deeply grateful.


Tom


Tue May 2, 2017 7:34 am (PDT) . Posted by:

ddockstader

Randy,
I've updated with the new file, but my smfGetYahooPortfolioView is still not working. I don't get an error message, just no information. Don't tell me they put that in a JSON file too! And many thanks for all your support. I don't know how you find time to do it, but it is greatly appreciated.
Dave

Tue May 2, 2017 11:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You got it. Moved to a JSON file. I will be obsoleting the function. The
nature of the JSON file makes it difficult to automate as a similar
function.

On Tue, May 2, 2017 at 7:34 AM, ddockstader@
​...wrote:

> I've updated with the new file, but my smfGetYahooPortfolioView is still
> not working. I don't get an error message, just no information. Don't
> tell me they put that in a JSON file too! And many thanks for all your
> support. I don't know how you find time to do it, but it is greatly
> appreciated.
>

Tue May 2, 2017 11:46 am (PDT) . Posted by:

"Charles Young" cyy001

smfGetYahooPortfolioView() is NOT working for me also. In addition, if I
use view "v2" instead of "v1", I got "Invalid view parameter:v2"

<Stock Market Functions add-in, Version 2.1.2017.05.01 (C:\SMF Add-In;
Windows (64-bit) NT :.00; 16.0; ; Local; 1)>

Randy,
The recent changes in Yahoo must have caused you a lot of issues. Just want
to say a big "THANK YOU" for all your tireless and timely effort. I really
appreciate your effort.

Thanks
Charles

On Tue, May 2, 2017 at 7:34 AM ddockstader@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Randy,
>
> I've updated with the new file, but my smfGetYahooPortfolioView is still
> not working. I don't get an error message, just no information. Don't
> tell me they put that in a JSON file too! And many thanks for all your
> support. I don't know how you find time to do it, but it is greatly
> appreciated.
>
> Dave
>
>
>

Tue May 2, 2017 9:18 am (PDT) . Posted by:

fierro.gaspar@ymail.com

Hi, I've been using SMF for years now and just yesterday the "RCHGetYahooHistory" function stopped working.


Every cell in the array is blank.


All other functions are working OK.


Does anyone have a solution for this?


Thanks

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 11.46

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)