Kamis, 28 Juli 2016

[smf_addin] Digest Number 3757

15 Messages

Digest #3757
1a
getyahoohistory by bizmark_ee
1b
Re: getyahoohistory by "Randy Harmelink" rharmelink
1c
Re: getyahoohistory by "Michael Grames" mfgrames
2b
Re: Microsoft Excel security message by "Randy Harmelink" rharmelink
2c
Re: Microsoft Excel security message by "Jose Jacob" pepecan47
2e
Re: Microsoft Excel security message by "Jose Jacob" pepecan47
2h
Re: Microsoft Excel security message by "Randy Harmelink" rharmelink
2j
Re: Microsoft Excel security message by "Randy Harmelink" rharmelink

Messages

Thu Jul 28, 2016 3:07 am (PDT) . Posted by:

bizmark_ee

None of my getyahoohistory formulas are working this working. Anyone else have the same issue?


Thu Jul 28, 2016 7:08 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Appears to be working here. I just tried:

=RCHGetYahooHistory("MMM")

On Thu, Jul 28, 2016 at 3:07 AM, dustinsmoak@
​...wrote:

>
> None of my getyahoohistory formulas are working this working. Anyone else
> have the same issue?
>

Thu Jul 28, 2016 8:48 am (PDT) . Posted by:

"Michael Grames" mfgrames

I am also having this problem, but only under Windows 10. The same Excel workbook in Windows 7 works fine. It is only the history from Yahoo that is not working.

Mike

Sent from my iPhone

> On Jul 28, 2016, at 10:08 AM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Appears to be working here. I just tried:
>
> =RCHGetYahooHistory("MMM")
>
> On Thu, Jul 28, 2016 at 3:07 AM, dustinsmoak@
> ​...wrote:
>>
>> None of my getyahoohistory formulas are working this working. Anyone else have the same issue?
>
>
>
> Spam
> Phish/Fraud
> Not spam
> Forget previous vote

Thu Jul 28, 2016 7:02 am (PDT) . Posted by:

philip_r_small

Hi Randy


Can you remind me where I find the smfFixLinks macro? I am having this problem as well and it is a touch annoying.... thanks Microsoft.




Thu Jul 28, 2016 7:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's in the add-in. You can bring up the macro dialog with alt+F8, then
type it in, and the buttons should go from grayed out to active. I have it
attached to a button on my toolbar so it's easily available. It should also
be on your context menu -- right mouse click, then click "SMF", then click
"Fix Links".

On Thu, Jul 28, 2016 at 3:18 AM, Philip_R_Small@
​...wrote:

> Can you remind me where I find the smfFixLinks macro? I am having this
> problem as well and it is a touch annoying.... thanks Microsoft.
>
>

Thu Jul 28, 2016 7:48 am (PDT) . Posted by:

"Jose Jacob" pepecan47

I don't know if this would help. From FAQ and Tips

16642Re: Excel 2010

Thought I would add my two cents, in regards to compatibility.

After upgrading to Win7 and Excel 2010, I discoverd that all the functions worked (i.e. RCHGetElementNumber).
However, none of the macros would work (i.e SMFForceRecalcution). Yet all my macros from Personal.xls did work. To resolve this I had to click the checkbox "Trust access to VBA project model" under the Trust Center...Macro settings.

Ron

Regards,
Jose L. Jacob

--------------------------------------------
On Thu, 7/28/16, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Re: Microsoft Excel security message
To: smf_addin@yahoogroups.com
Received: Thursday, July 28, 2016, 10:12 AM


 









It's in the add-in. You can
bring up the macro dialog with alt+F8, then type it in, and
the buttons should go from grayed out to active. I have it
attached to a button on my toolbar so it's easily
available. It should also be on your context menu -- right
mouse click, then click "SMF", then click
"Fix Links".

On Thu, Jul 28, 2016 at
3:18 AM, Philip_R_Small@​...wrote:


















Can you remind me where I find the smfFixLinks macro? I
am having this problem as well and it is a touch
annoying.... thanks Microsoft.












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

#yiv5429448047 #yiv5429448047ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5429448047 #yiv5429448047ygrp-mkp #yiv5429448047hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5429448047 #yiv5429448047ygrp-mkp #yiv5429448047ads {
margin-bottom:10px;}

#yiv5429448047 #yiv5429448047ygrp-mkp .yiv5429448047ad {
padding:0 0;}

#yiv5429448047 #yiv5429448047ygrp-mkp .yiv5429448047ad p {
margin:0;}

#yiv5429448047 #yiv5429448047ygrp-mkp .yiv5429448047ad a {
color:#0000ff;text-decoration:none;}
#yiv5429448047 #yiv5429448047ygrp-sponsor
#yiv5429448047ygrp-lc {
font-family:Arial;}

#yiv5429448047 #yiv5429448047ygrp-sponsor
#yiv5429448047ygrp-lc #yiv5429448047hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5429448047 #yiv5429448047ygrp-sponsor
#yiv5429448047ygrp-lc .yiv5429448047ad {
margin-bottom:10px;padding:0 0;}

#yiv5429448047 #yiv5429448047actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv5429448047 #yiv5429448047activity span {
font-weight:700;}

#yiv5429448047 #yiv5429448047activity span:first-child {
text-transform:uppercase;}

#yiv5429448047 #yiv5429448047activity span a {
color:#5085b6;text-decoration:none;}

#yiv5429448047 #yiv5429448047activity span span {
color:#ff7900;}

#yiv5429448047 #yiv5429448047activity span
.yiv5429448047underline {
text-decoration:underline;}

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

#yiv5429448047 .yiv5429448047attach div a {
text-decoration:none;}

#yiv5429448047 .yiv5429448047attach img {
border:none;padding-right:5px;}

#yiv5429448047 .yiv5429448047attach label {
display:block;margin-bottom:5px;}

#yiv5429448047 .yiv5429448047attach label a {
text-decoration:none;}

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

#yiv5429448047 .yiv5429448047bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5429448047 .yiv5429448047bold a {
text-decoration:none;}

#yiv5429448047 dd.yiv5429448047last p a {
font-family:Verdana;font-weight:700;}

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

#yiv5429448047 dd.yiv5429448047last p
span.yiv5429448047yshortcuts {
margin-right:0;}

#yiv5429448047 div.yiv5429448047attach-table div div a {
text-decoration:none;}

#yiv5429448047 div.yiv5429448047attach-table {
width:400px;}

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

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

#yiv5429448047 div#yiv5429448047ygrp-mlmsg
#yiv5429448047ygrp-msg p a span.yiv5429448047yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5429448047 .yiv5429448047green {
color:#628c2a;}

#yiv5429448047 .yiv5429448047MsoNormal {
margin:0 0 0 0;}

#yiv5429448047 o {
font-size:0;}

#yiv5429448047 #yiv5429448047photos div {
float:left;width:72px;}

#yiv5429448047 #yiv5429448047photos div div {
border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}

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

#yiv5429448047 #yiv5429448047reco-category {
font-size:77%;}

#yiv5429448047 #yiv5429448047reco-desc {
font-size:77%;}

#yiv5429448047 .yiv5429448047replbq {
margin:4px;}

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

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

#yiv5429448047 #yiv5429448047ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv5429448047 #yiv5429448047ygrp-mlmsg pre, #yiv5429448047
code {
font:115% monospace;}

#yiv5429448047 #yiv5429448047ygrp-mlmsg * {
line-height:1.22em;}

#yiv5429448047 #yiv5429448047ygrp-mlmsg #yiv5429448047logo {
padding-bottom:10px;}


#yiv5429448047 #yiv5429448047ygrp-msg p a {
font-family:Verdana;}

#yiv5429448047 #yiv5429448047ygrp-msg
p#yiv5429448047attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5429448047 #yiv5429448047ygrp-reco
#yiv5429448047reco-head {
color:#ff7900;font-weight:700;}

#yiv5429448047 #yiv5429448047ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5429448047 #yiv5429448047ygrp-sponsor #yiv5429448047ov
li a {
font-size:130%;text-decoration:none;}

#yiv5429448047 #yiv5429448047ygrp-sponsor #yiv5429448047ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5429448047 #yiv5429448047ygrp-sponsor #yiv5429448047ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5429448047 #yiv5429448047ygrp-text {
font-family:Georgia;}

#yiv5429448047 #yiv5429448047ygrp-text p {
margin:0 0 1em 0;}

#yiv5429448047 #yiv5429448047ygrp-text tt {
font-size:120%;}

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

Thu Jul 28, 2016 7:58 am (PDT) . Posted by:

perseuslim11

Hi Philip, If you're having same problem like me,

you could try what I did to resolve the issue:


Just like Randy suggested, I've added the folder where I extracted my SMF addin files (namely C:\SMF Add-in) to the trusted locations under Trust Center Settings


after that everything worked, I didn't even used the smfFixLink macro at all


hope this helped :)

Thu Jul 28, 2016 8:41 am (PDT) . Posted by:

"Jose Jacob" pepecan47

I have Windows 8.1 and Excel 2013.

I added my c:\SMF Add-In\ folder to the trusted locations under Trust Center Settings. And I un-checked/checked the SMF Add In with no luck.

What I noticed is that when I open a spreadsheet, I am not seeing a flashing message that the Add-in is loading. Before I used to see the message when opening a spreadsheet.

It seems that the add in is not loading.

Regards,
Jose L. Jacob

--------------------------------------------
On Thu, 7/28/16, perseuslim11@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: [smf_addin] Re: Microsoft Excel security message
To: smf_addin@yahoogroups.com
Received: Thursday, July 28, 2016, 10:58 AM


 









Hi Philip, If you're having same problem like
me,
you could try what I
did to resolve the issue:
Just like Randy suggested, I've
added the folder where I extracted my SMF addin files
(namely C:\SMF Add-in) to the trusted locations under
Trust Center Settings
after that everything worked, I
didn't even used the smfFixLink macro at
all 
 hope this
helped :)









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

#yiv7963298512 #yiv7963298512ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv7963298512 #yiv7963298512ygrp-mkp #yiv7963298512hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv7963298512 #yiv7963298512ygrp-mkp #yiv7963298512ads {
margin-bottom:10px;}

#yiv7963298512 #yiv7963298512ygrp-mkp .yiv7963298512ad {
padding:0 0;}

#yiv7963298512 #yiv7963298512ygrp-mkp .yiv7963298512ad p {
margin:0;}

#yiv7963298512 #yiv7963298512ygrp-mkp .yiv7963298512ad a {
color:#0000ff;text-decoration:none;}
#yiv7963298512 #yiv7963298512ygrp-sponsor
#yiv7963298512ygrp-lc {
font-family:Arial;}

#yiv7963298512 #yiv7963298512ygrp-sponsor
#yiv7963298512ygrp-lc #yiv7963298512hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv7963298512 #yiv7963298512ygrp-sponsor
#yiv7963298512ygrp-lc .yiv7963298512ad {
margin-bottom:10px;padding:0 0;}

#yiv7963298512 #yiv7963298512actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv7963298512 #yiv7963298512activity span {
font-weight:700;}

#yiv7963298512 #yiv7963298512activity span:first-child {
text-transform:uppercase;}

#yiv7963298512 #yiv7963298512activity span a {
color:#5085b6;text-decoration:none;}

#yiv7963298512 #yiv7963298512activity span span {
color:#ff7900;}

#yiv7963298512 #yiv7963298512activity span
.yiv7963298512underline {
text-decoration:underline;}

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

#yiv7963298512 .yiv7963298512attach div a {
text-decoration:none;}

#yiv7963298512 .yiv7963298512attach img {
border:none;padding-right:5px;}

#yiv7963298512 .yiv7963298512attach label {
display:block;margin-bottom:5px;}

#yiv7963298512 .yiv7963298512attach label a {
text-decoration:none;}

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

#yiv7963298512 .yiv7963298512bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv7963298512 .yiv7963298512bold a {
text-decoration:none;}

#yiv7963298512 dd.yiv7963298512last p a {
font-family:Verdana;font-weight:700;}

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

#yiv7963298512 dd.yiv7963298512last p
span.yiv7963298512yshortcuts {
margin-right:0;}

#yiv7963298512 div.yiv7963298512attach-table div div a {
text-decoration:none;}

#yiv7963298512 div.yiv7963298512attach-table {
width:400px;}

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

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

#yiv7963298512 div#yiv7963298512ygrp-mlmsg
#yiv7963298512ygrp-msg p a span.yiv7963298512yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv7963298512 .yiv7963298512green {
color:#628c2a;}

#yiv7963298512 .yiv7963298512MsoNormal {
margin:0 0 0 0;}

#yiv7963298512 o {
font-size:0;}

#yiv7963298512 #yiv7963298512photos div {
float:left;width:72px;}

#yiv7963298512 #yiv7963298512photos div div {
border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}

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

#yiv7963298512 #yiv7963298512reco-category {
font-size:77%;}

#yiv7963298512 #yiv7963298512reco-desc {
font-size:77%;}

#yiv7963298512 .yiv7963298512replbq {
margin:4px;}

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

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

#yiv7963298512 #yiv7963298512ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv7963298512 #yiv7963298512ygrp-mlmsg pre, #yiv7963298512
code {
font:115% monospace;}

#yiv7963298512 #yiv7963298512ygrp-mlmsg * {
line-height:1.22em;}

#yiv7963298512 #yiv7963298512ygrp-mlmsg #yiv7963298512logo {
padding-bottom:10px;}


#yiv7963298512 #yiv7963298512ygrp-msg p a {
font-family:Verdana;}

#yiv7963298512 #yiv7963298512ygrp-msg
p#yiv7963298512attach-count span {
color:#1E66AE;font-weight:700;}

#yiv7963298512 #yiv7963298512ygrp-reco
#yiv7963298512reco-head {
color:#ff7900;font-weight:700;}

#yiv7963298512 #yiv7963298512ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv7963298512 #yiv7963298512ygrp-sponsor #yiv7963298512ov
li a {
font-size:130%;text-decoration:none;}

#yiv7963298512 #yiv7963298512ygrp-sponsor #yiv7963298512ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv7963298512 #yiv7963298512ygrp-sponsor #yiv7963298512ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv7963298512 #yiv7963298512ygrp-text {
font-family:Georgia;}

#yiv7963298512 #yiv7963298512ygrp-text p {
margin:0 0 1em 0;}

#yiv7963298512 #yiv7963298512ygrp-text tt {
font-size:120%;}

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

Thu Jul 28, 2016 9:27 am (PDT) . Posted by:

nmalhotr

Randy:

Adding the Trusted Location works perfectly. Maybe add that step to the installation instructions.


Thank for everything you do.


NM

Thu Jul 28, 2016 9:28 am (PDT) . Posted by:

lexstar

I have the same problem. Last week I switched everything from C:\Program Files\SMF Add-In\ to C:\SMF Add-in and everything works. Today, I open up my worksheet and everything just went back to ?NAME again in the cells. I've added C:\SMF Add-In to the Trusted Locations, but nothing works. Switching On/Off the Addin didn't do anything either.

However, if I switch it back to C:\Program Files\SMF Add-In.... everything works again.


This issue occurred after I updated MS OFfice last nite to the latest version. Man, I just hate this! I would hate to see this happen with each MS Office update, it's so annoying and time consuming for me as my worksheet is so big.


Any pointers would be appreciated.

Thu Jul 28, 2016 5:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, since it's not happening here, I can't really do anything to
check things out. It's nearly impossible to work off of what people tell
me, because I'm not sure of all the steps they are doing. And different
people are telling me different things about the same suggestions.

For example, did you exit EXCEL after changing the Trust settings? So that
they would be in place when you try to open a worksheet? Did you then save
a workbook using that location, then exit EXCEL and reopen the workbook to
check for the problem?

If you change the location of the add-in, you WILL get unresolved links
with any workbook opened that was saved when the add-in was in a different
location. BECAUSE EXCEL hard-codes the location of the add-in whenever it
saves a workbook.

On Thu, Jul 28, 2016 at 9:28 AM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have the same problem. Last week I switched everything from C:\Program
> Files\SMF Add-In\ to C:\SMF Add-in and everything works. Today, I open up
> my worksheet and everything just went back to ?NAME again in the cells.
> I've added C:\SMF Add-In to the Trusted Locations, but nothing works.
> Switching On/Off the Addin didn't do anything either.
>
> However, if I switch it back to C:\Program Files\SMF Add-In.... everything
> works again.
>
> This issue occurred after I updated MS OFfice last nite to the latest
> version. Man, I just hate this! I would hate to see this happen with each
> MS Office update, it's so annoying and time consuming for me as my
> worksheet is so big.
>
> Any pointers would be appreciated.
>

Thu Jul 28, 2016 7:19 pm (PDT) . Posted by:

lscottedgar

There is some useful info on the link. Particularly, #1 under "Issues Affecting Excel Features and add-ins". Unblocking the XLA file worked for me.

Fixes or workarounds for recent issues in Excel for Windows - Excel https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093

Fixes or workarounds for recent issues in Excel for Windows - Excel https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093 Last updated: July 2016



View on support.office.com https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093
Preview by Yahoo







Thu Jul 28, 2016 8:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks so much. That certainly sounds like the problem. I've been searching
for something like that since this happened. I just recently suggested
adding the folder to the list of trusted locations, but someone said that
didn't work.

As a "workaround" until they fix the problem, unblocking sound easier and
less risky. But I think it will need to be done every time a new XLA is
loaded. Until they fix the problem themselves.

The details for those of you that are interested:

------------------------------

We have a few options for workarounds. These are in order from safest to
riskiest.
The best option is to move away from using HTML wrapped as .XLS. If you use
native formats (e.g. XLS, XLSX, XLSB) which will open in protected view
when untrusted, this will provide some level of protection from the
documents being opened.

1.

You can unblock access for individual files you know are safe. To do
this:
1.

Right-click the file, and choose *Properties*.
2.

On the General tab, click *Unblock*.
3.

Click *OK*.
2.

You can make use of existing Trusted Locations capabilities in Excel
2010, 2013, and 2016 via *File* > *Options* > *Trust Center* > *Trust
Center Settings* > *Trusted Locations*.
1.

You can save the web html file to a trusted location on the local
machine (Excel comes with a set of default trust locations). If
you do not
see the local folder location you trust for these files, then press "Add
new location…" button and add it in the Trusted Location dialog. If the
HTML document is in a trusted location the KB fix is not applied
(e.g. the
unsafe HTML file is not blocked). .
2.

This approach may unblock you, but it carries some risk as files of
any file type in Trusted Locations are fully trusted. If an attacker can
drop files into the trusted location they can easily exploit
users who open
such documents. Be especially cautious when specifying a custom
folder as a
trusted location.

------------------------------

On Thu, Jul 28, 2016 at 7:19 PM, scottedgar@prodigy.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> There is some useful info on the link. Particularly, #1 under "Issues
> Affecting Excel Features and add-ins". Unblocking the XLA file worked for
> me.
>
> Fixes or workarounds for recent issues in Excel for Windows - Excel
> <https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093>
> Fixes or workarounds for recent issues in Excel for Windows - Excel
> <https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093>
> Last updated: July 2016
> View on support.office.com
> <https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093>
> Preview by Yahoo
>
>

Thu Jul 28, 2016 10:34 pm (PDT) . Posted by:

perseuslim11

Hi Randy, I've just noticed one problem for RCHgetyahoohistory, as the values I get for DHLCV using the rch function is different from what I see by visiting the actual site.


Formula I've used:
=RCHGetYahooHistory(""&'@Input'!$E$2&".KL",'@Input'!$E$81,MONTH('@Input'!$E$7)-5,DAY(1),YEAR(NOW()),MONTH(NOW()),DAY(NOW()),"d","DHLCV",,,1)



Actual yahoohistory link: http://finance.yahoo.com/quote/6939.KL/history?ltr=1 http://finance.yahoo.com/quote/6939.KL/history?ltr=1


And values I get, attached in photos below




Note:
For the closing prices->
around 5 to 6 April 2016 the values I get from Rch function is $1.09 and $0.55 respectively
while looking at the website, the values are $0.70 and and $0.72 respectively


the same is true for high and low price of the day, also different from the values we see from the actual yahoo website..


Second doubt is that:
the chart from another website looks like this (i3 website photo), which I feel is the way the chart should look like, as there is a corporate action EX date on 14th April 2016, which means prices should adjust on that day itself, while the values on yahoohistory doesn't adjust on 14th April.. does this means that the yahoohistory data is wrongly adjusted by their webmasters?


(attached a photo from i3 website for the chart)
link as follows: http://klse.i3investor.com/servlets/stk/chart/6939.jsp http://klse.i3investor.com/servlets/stk/chart/6939.jsp






What causes this data discrepancy and how to fix this? Been thinking and finding solutions online but can't seem to identify the cause..


Thanks!






Thu Jul 28, 2016 10:49 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The ​RCHGetYahooHistory function is just showing the data Yahoo is giving
it. Click on the "Download Data" button on their historical quotes page and
you'll see what the CSV file contains. That CSV file is what the function
uses.

You should let Yahoo know that the data they're displaying and the data
they deliver with the "Download Data" link don't match. Don't mention the
add-in as that would just confuse the situation.

On Thu, Jul 28, 2016 at 10:34 PM, perseuslim11@
​...wrote:

> Hi Randy, I've just noticed one problem for RCHgetyahoohistory, as the
> values I get for DHLCV using the rch function is different from what I see
> by visiting the actual site.
>
> Formula I've used:
>
> =
> RCHGetYahooHistory(""&'@Input'!$E$2&".KL",'@Input'!$E$81,MONTH('@Input'!$E$7)-5,DAY(1),YEAR(NOW()),MONTH(NOW()),DAY(NOW()),"d","DHLCV",,,1)
>
> Actual yahoohistory link:
> http://finance.yahoo.com/quote/6939.KL/history?ltr=1
>
> And values I get, attached in photos below
>
> Note:
>
> For the closing prices->
>
> around 5 to 6 April 2016 the values I get from Rch function is $1.09 and
> $0.55 respectively
>
> while looking at the website, the values are $0.70 and and $0.72
> respectively
>
> the same is true for high and low price of the day, also different from
> the values we see from the actual yahoo website..
>
> Second doubt is that:
>
> the chart from another website looks like this (i3 website photo), which I
> feel is the way the chart should look like, as there is a corporate action
> EX date on 14th April 2016, which means prices should adjust on that day
> itself, while the values on yahoohistory doesn't adjust on 14th April..
> does this means that the yahoohistory data is wrongly adjusted by their
> webmasters?
>
> (attached a photo from i3 website for the chart)
>
> link as follows: http://klse.i3investor.com/servlets/stk/chart/6939.jsp
>
> What causes this data discrepancy and how to fix this? Been thinking and
> finding solutions online but can't seem to identify the cause..
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 22.49

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)