EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3758

RCHgetYahooHistory Data Discrepancy by perseuslim11

Re: RCHgetYahooHistory returns values that doesn't tally with the on by perseuslim11

Excel Workbooks may not open after installing MS16-088 by "Greg Farber" greg_in_marin

Re: Microsoft Excel security message by msdalt

Messages

1 RCHgetYahooHistory Data Discrepancy

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

perseuslim11

Hi Randy, I've encountered this discrepancy problem this morning and search the net but no solutions found..

First, is that the values I get from rchgetyahoohistory is different from the value I see when I visit the actual yahoohistory website

rch.png > shows the values I get from the rch function
seen on website png > shows the actual values on yahoo website

The formula 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)

Note: (for closing price)
on 5th and 6th April 2016, the values from RCH is $1.09 and $0.55 respectively,
while on the yahoohistory site it is $0.72 and $0.73 respectively

what's causing this data discrepancy?

Thanks in advance ^_^

Attachment(s) from

3 of 3 Photo(s)

rch.png

i3 website.png

seen on website.png

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

2a

Re: RCHgetYahooHistory returns values that doesn't tally with the on

Thu Jul 28, 2016 11:15 pm (PDT) . Posted by:

perseuslim11

I see, thanks for the advise ^^

Will try posting here:
https://yahoo.uservoice.com/forums/170326-finance?query=Yahoohistory%20downloaded%20data%20(CSV)%20doesn%27t%20match%20the%20data%20shown%20on%20the%20website https://yahoo.uservoice.com/forums/170326-finance?query=Yahoohistory%20downloaded%20data%20(CSV)%20doesn%27t%20match%20the%20data%20shown%20on%20the%20website
...

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

3 Excel Workbooks may not open after installing MS16-088

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

"Greg Farber" greg_in_marin

Hi Guys, I belong to a windows update/patch news list, and I saw this
article. Perhaps this has something to do with your errors? I will paste
another thread on this topic far below.

Good luck, ~Greg

---------- Forwarded message ----------
From: Susan Bradley <sbradcpa@pacbell.net>
Date: Tue, Jul 26, 2016 at 8:56 PM
Subject: [patchmanagement] Excel Workbooks may not open after installing
MS16-088
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2016/07/22/excel-workbooks-may-not-open-after-installing-ms16-088/

The Excel team has made a change in the behavior of certain file types to
increase security. This change came in the security updates KB3115262,
KB3170008, and KB3115322. Previously, when you tried to open an HTML or XLA
file with an .XLS file extension from an untrusted location, Excel would
warn about the mismatch between the file extension and content, but would
still open the workbook without Protected View security. After the security
updates Excel no longer will open the workbook because these files are not
compatible with Protected View and there is no warning or other indication
it was not opened. We apologize that Excel is showing a blank screen
instead of a more helpful error message with information about what to do
next.

We have a few options for workarounds. These are in order from safest to
riskiest. While some people in the forums have suggested rolling back the
security patch, we do not recommend that option as it can leave you open to
other current and future threats.

1. 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.
2. You can unblock access for individual files you know are safe. To do
this:
1. Right click on the file and choose Properties
2. On the General tab, click Unblock
3. Click OK
3. 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.

We are also investigating a more permanent solution that allows our users
to remain secure as well as minimize disruption to existing user
experience. We'll provide updates on this in the coming days.
~~~~~~~~~~~~~~~~~~~~~~~~

Forwarded conversation

Subject: [patchmanagement] Anyone have issues with Excel 2013 update
(MS16-088 / 3115262)
------------------------

From: *D'Angelo, Michael L.* <mdangelo@pace.edu>
Date: Mon, Jul 18, 2016 at 1:34 PM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

We have two web applications that invoke Excel which are no longer working
after installing this month's updates. It looks like only an issue with
Excel 2013. I don't use the web apps in question so I'm not sure exactly
what they're doing. Just wondering if anyone else has come across this.

Thanks,

Michael D'Angelo

----------
From: *David Corkill* <David.Corkill@tafesa.edu.au>
Date: Mon, Jul 18, 2016 at 11:14 PM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

There is some discussion here:

https://social.technet.microsoft.com/Forums/en-US/d2d84793-9920-45e3-baef-5027a4ac1ae0/kb3170008-for-office-2016-breaks-functionality-ms16088?forum=officeitpro

*From:* D'Angelo, Michael L. [mailto:mdangelo@pace.edu]
*Sent:* Tuesday, 19 July 2016 6:04 AM
*To:* Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>
*Subject:* [patchmanagement] Anyone have issues with Excel 2013 update
(MS16-088 / 3115262)

We have two web applications that invoke Excel which are no longer working
after installing this month's updates. It looks like only an issue with
Excel 2013. I don't use the web apps in question so I'm not sure exactly
what they're doing. Just wondering if anyone else has come across this.

Thanks,

Michael D'Angelo

----------
From: *Julian Harper* <Julian.Harper@laytons.co.uk>
Date: Tue, Jul 19, 2016 at 12:46 AM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

"invoke Excel"

What do you mean by that exactly? That they try to open Excel directly from
the website? How do they do it exactly, and does it not work in all

browsers?

*Julian HarperIT ManagerLaytons Wine Services Ltd*

*From:* D'Angelo, Michael L. [mailto:mdangelo@pace.edu]
*Sent:* 18 July 2016 21:34
*To:* Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>
*Subject:* [patchmanagement] Anyone have issues with Excel 2013 update
(MS16-088 / 3115262)

We have two web applications that invoke Excel which are no longer working
after installing this month's updates. It looks like only an issue with
Excel 2013. I don't use the web apps in question so I'm not sure exactly
what they're doing. Just wondering if anyone else has come across this.

Thanks,

Michael D'Angelo

----------
From: *Stephen Gestwicki* <sgestwicki@isi.org>
Date: Tue, Jul 19, 2016 at 6:25 AM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

Salesforce is also having a problem with this patch:

http://salesforce.stackexchange.com/questions/131404/end-user-cannot-open-a-xls-report-exported-from-salesforce

There are two workarounds that I have been able to identify.

1. Add the necessary URLs to your trusted sites in all supported
browsers.

2. Have users download the file > right click > Properties > Unblock
> OK > then open the file.

- Stephen

*From:* David Corkill [mailto:David.Corkill@tafesa.edu.au]
*Sent:* Tuesday, July 19, 2016 2:15 AM
*To:* Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>
*Subject:* RE:[patchmanagement] Anyone have issues with Excel 2013 update
(MS16-088 / 3115262)

----------
From: *Emin* <emin.atac@gmail.com>
Date: Tue, Jul 19, 2016 at 6:49 AM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

Hi,

I've encountered the same symptom with Excel 2010.
[image: Inline image 1]
If you click yes, the file opens.
The .xls content is actually HTML
[image: Inline image 2]

----------
From: *D'Angelo, Michael L.* <mdangelo@pace.edu>
Date: Tue, Jul 19, 2016 at 8:22 AM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

Yes this appears to be the issue in my case. In my opinion, the fact that
an application is trying to pass of HTML as an Excel file is the problem.
But try telling your developers that…

Thanks,

Michael D'Angelo

*From:* Emin [mailto:emin.atac@gmail.com]
*Sent:* Tuesday, July 19, 2016 9:49 AM
*To:* Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>
*Subject:* Re: [patchmanagement] Anyone have issues with Excel 2013 update
(MS16-088 / 3115262)

----------
From: *Renda, Brian - Technology & Product Engineering
<Brian.Renda@timeinc.com <Brian.Renda@timeinc.com>>* <
Brian.Renda@timeinc.com>
Date: Thu, Jul 21, 2016 at 11:56 AM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

Stephen,

Do you mind to explain how and where you added the URL's to trusted sites?

*From:* Stephen Gestwicki [mailto:sgestwicki@isi.org]
*Sent:* Tuesday, July 19, 2016 9:26 AM
*To:* Patch Management Mailing List
*Subject:* RE:[patchmanagement] Anyone have issues with Excel 2013 update
(MS16-088 / 3115262)

Salesforce is also having a problem with this patch:

http://salesforce.stackexchange.com/questions/131404/end-user-cannot-open-a-xls-report-exported-from-salesforce

There are two workarounds that I have been able to identify.

1. Add the necessary URLs to your trusted sites in all supported
browsers.

2. Have users download the file > right click > Properties > Unblock
> OK > then open the file.

- Stephen

*From:* David Corkill [mailto:David.Corkill@tafesa.edu.au
<David.Corkill@tafesa.edu.au>]
*Sent:* Tuesday, July 19, 2016 2:15 AM
*To:* Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>
*Subject:* RE:[patchmanagement] Anyone have issues with Excel 2013 update
(MS16-088 / 3115262)

There is some discussion here:

https://social.technet.microsoft.com/Forums/en-US/d2d84793-9920-45e3-baef-5027a4ac1ae0/kb3170008-for-office-2016-breaks-functionality-ms16088?forum=officeitpro

*From:* D'Angelo, Michael L. [mailto:mdangelo@pace.edu <mdangelo@pace.edu>]
*Sent:* Tuesday, 19 July 2016 6:04 AM
*To:* Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>
*Subject:* [patchmanagement] Anyone have issues with Excel 2013 update
(MS16-088 / 3115262)

We have two web applications that invoke Excel which are no longer working
after installing this month's updates. It looks like only an issue with
Excel 2013. I don't use the web apps in question so I'm not sure exactly
what they're doing. Just wondering if anyone else has come across this.

Thanks,

Michael D'Angelo

Please be alert for any emails that may ask you for login information or
directs you to login via a link. If you believe this message is a phish or
aren't sure whether this message is trustworthy, please send the original
message as an attachment to 'phishing@timeinc.com'.

----------
From: *Stephen Gestwicki* <sgestwicki@isi.org>
Date: Fri, Jul 22, 2016 at 6:41 AM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

I am currently using workaround #2 and asking Salesforce to fix their XLS
export but I would use Group Policy to add the URL's to trusted sites.

· IE already has Group Policy built in.

o Computer Configuration > Policies > Administrative Templates > Windows
Components > Internet Explorer > Internet Control Panel > Security Page >
Site to Zone Assignment List

§ Add the URL (including the https://) in the "Value name" and enter "2"
for the "Value" which places it in the "Trusted Sites zone".

o FYI: this will disable the user's ability to add Trusted Sites on their
ow (which could be a good thing).

· Chrome has the ability to work with Group Policy.

o https://support.google.com/chrome/a/answer/187202?hl=en

· The FrontMotion Firefox Community Edition can work with Group
Policy.

o http://www.frontmotion.com/fmfirefoxce/

o I stopped using FrontMotion's MSI installer years ago because it was

taking them up to 2 weeks to get the new version out.

- Stephen

*From:* Renda, Brian - Technology & Product Engineering <
Brian.Renda@timeinc.com> [mailto:Brian.Renda@timeinc.com]
*Sent:* Thursday, July 21, 2016 2:56 PM

----------
From: *Renda, Brian - Technology & Product Engineering
<Brian.Renda@timeinc.com <Brian.Renda@timeinc.com>>* <
Brian.Renda@timeinc.com>
Date: Fri, Jul 22, 2016 at 7:02 AM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

Thanks for the reply. That is what I thought and just wanted to verify
that is what you meant. That makes it crystal clear. Much appreciated.

*From:* Stephen Gestwicki [mailto:sgestwicki@isi.org]
*Sent:* Friday, July 22, 2016 9:42 AM

----------
From: *Caleb* <Caleb.Posey@outlook.com>
Date: Fri, Jul 22, 2016 at 10:09 AM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

You can also add URL's to trusted sites via the user group policy
preferences registry extension and it won't disable the user's ability to
modify the trusted sites list.

Examples:

*HKCU\Software\Microsoft\Windows\CurrentVersion\Internet
Settings\ZoneMap\Domains\example.com <http://example.com/>*

*HKCU\Software\Microsoft\Windows\CurrentVersion\Internet
Settings\ZoneMap\Domains\example.com <http://example.com/>\www*

*HKCU\Software\Microsoft\Windows\CurrentVersion\Internet
Settings\ZoneMap\Domains\example.com <http://example.com/>\west*

Value name of "HTTP" or "HTTPS" and selected the Value Type as "REG_DWORD"
and set the value data as "00000002" (for Trusted Sites Zone).

Other values.

Value Setting

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

0 My Computer

1 Local Intranet Zone

2 Trusted Sites Zone

3 Internet Zone

4 Restricted Sites Zone

-Caleb

*From:* Stephen Gestwicki [mailto:sgestwicki@isi.org]
*Sent:* Friday, July 22, 2016 5:42 AM

----------
From: *John Bailey* <rekkanoryo@rekkanoryo.org>
Date: Fri, Jul 22, 2016 at 12:39 PM
To: Patch Management Mailing List <
patchmanagement@listserv.patchmanagement.org>

On Fri, Jul 22, 2016 at 1:09 PM, Caleb <Caleb.Posey@outlook.com> wrote:
> You can also add URL's to trusted sites via the user group policy
> preferences registry extension and it won't disable the user's ability to
> modify the trusted sites list.

This feature is a godsend. So was figuring out how to deploy IE
Favorites using Group Policy Preferences shortcuts. Now if only the

IE compatibility mode list was like the zonemap stuff instead of an
ugly hex blob...

John

---
PatchManagement.org is hosted by Shavlik

The content on the email list is intended for assisting administrators. If
you would like to use any of this content in a blog or media publication,
please contact the owners of the list for approval.

To unsubscribe send a blank email to
leave-patchmanagement@patchmanagement.org
If you are unable to unsubscribe via this email address, please email
owner-patchmanagement@patchmanagement.org

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

4a

Re: Microsoft Excel security message

Fri Jul 29, 2016 12:21 am (PDT) . Posted by:

msdalt

Last night I was encountering the problem described in this thread. This morning I followed the steps highlighted in Randy's message #14. I opened Excel and my quotes file opened and updated just as it had before. Thank you for everything!
Michael