Sabtu, 30 Juli 2016

[smf_addin] Digest Number 3759[2 Attachments]

10 Messages

Digest #3759
2a
Re: Microsoft Excel security message by "Jose Jacob" pepecan47

Messages

Fri Jul 29, 2016 4:17 am (PDT) . Posted by:

holmberg_tommy

Hi Randy,


Can you tell me how I can get the value of EUR/USD currency converter from :


http://www.reuters.com/finance/currencies http://www.reuters.com/finance/currencies


Thanks,


- Tommy


Fri Jul 29, 2016 10:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("http://www.reuters.com/finance/currencies
","td",1,"EUR/USD",,,,1)

On Fri, Jul 29, 2016 at 4:17 AM, holmberg_tommy@
​...wrote:

> Can you tell me how I can get the value of EUR/USD currency converter from
> :
>
> http://www.reuters.com/finance/currencies
>
>

Fri Jul 29, 2016 10:23 am (PDT) . Posted by:

"Jose Jacob" pepecan47

Phiiiuu... my spreadsheets are working again. Curiously including the c:\SMF Add-In\ directory in the trusted locations list didn't solve my problem. Only unblocking the .XLA file made my spreadsheets work again.

A million thanks to Randy and the forum members that posted the problem/fix.

For a moment I thought that the SMF will never work for me again. I went through the mental exercise of calculating the effort that would take doing manually the things that the SMF does by automation, I couldn't live without the SMF Add In. Thank you Randy very much again.

Windows 8.1
Excel 2013

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, 11:14 PM


 



   


     
       
       
       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.
         
             You can unblock
access for individual files you know are safe. To do this:

             
                 Right-click the
file, and choose Properties.
               
                 On the General
tab, click Unblock.
               
                 Click OK.
               
           
             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.
             
                 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). .
               
                 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 
 
   
 
Fixes
or workarounds for recent issues in Excel for Windows -
Excel   Last
updated: July 2016     
   


View on support.office.com
     

Preview by Yahoo   
 




     
     

     
     



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

#yiv5944882130 #yiv5944882130ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5944882130 #yiv5944882130ygrp-mkp #yiv5944882130hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5944882130 #yiv5944882130ygrp-mkp #yiv5944882130ads {
margin-bottom:10px;}

#yiv5944882130 #yiv5944882130ygrp-mkp .yiv5944882130ad {
padding:0 0;}

#yiv5944882130 #yiv5944882130ygrp-mkp .yiv5944882130ad p {
margin:0;}

#yiv5944882130 #yiv5944882130ygrp-mkp .yiv5944882130ad a {
color:#0000ff;text-decoration:none;}
#yiv5944882130 #yiv5944882130ygrp-sponsor
#yiv5944882130ygrp-lc {
font-family:Arial;}

#yiv5944882130 #yiv5944882130ygrp-sponsor
#yiv5944882130ygrp-lc #yiv5944882130hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5944882130 #yiv5944882130ygrp-sponsor
#yiv5944882130ygrp-lc .yiv5944882130ad {
margin-bottom:10px;padding:0 0;}

#yiv5944882130 #yiv5944882130actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv5944882130 #yiv5944882130activity span {
font-weight:700;}

#yiv5944882130 #yiv5944882130activity span:first-child {
text-transform:uppercase;}

#yiv5944882130 #yiv5944882130activity span a {
color:#5085b6;text-decoration:none;}

#yiv5944882130 #yiv5944882130activity span span {
color:#ff7900;}

#yiv5944882130 #yiv5944882130activity span
.yiv5944882130underline {
text-decoration:underline;}

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

#yiv5944882130 .yiv5944882130attach div a {
text-decoration:none;}

#yiv5944882130 .yiv5944882130attach img {
border:none;padding-right:5px;}

#yiv5944882130 .yiv5944882130attach label {
display:block;margin-bottom:5px;}

#yiv5944882130 .yiv5944882130attach label a {
text-decoration:none;}

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

#yiv5944882130 .yiv5944882130bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5944882130 .yiv5944882130bold a {
text-decoration:none;}

#yiv5944882130 dd.yiv5944882130last p a {
font-family:Verdana;font-weight:700;}

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

#yiv5944882130 dd.yiv5944882130last p
span.yiv5944882130yshortcuts {
margin-right:0;}

#yiv5944882130 div.yiv5944882130attach-table div div a {
text-decoration:none;}

#yiv5944882130 div.yiv5944882130attach-table {
width:400px;}

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

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

#yiv5944882130 div#yiv5944882130ygrp-mlmsg
#yiv5944882130ygrp-msg p a span.yiv5944882130yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5944882130 .yiv5944882130green {
color:#628c2a;}

#yiv5944882130 .yiv5944882130MsoNormal {
margin:0 0 0 0;}

#yiv5944882130 o {
font-size:0;}

#yiv5944882130 #yiv5944882130photos div {
float:left;width:72px;}

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

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

#yiv5944882130 #yiv5944882130reco-category {
font-size:77%;}

#yiv5944882130 #yiv5944882130reco-desc {
font-size:77%;}

#yiv5944882130 .yiv5944882130replbq {
margin:4px;}

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

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

#yiv5944882130 #yiv5944882130ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv5944882130 #yiv5944882130ygrp-mlmsg pre, #yiv5944882130
code {
font:115% monospace;}

#yiv5944882130 #yiv5944882130ygrp-mlmsg * {
line-height:1.22em;}

#yiv5944882130 #yiv5944882130ygrp-mlmsg #yiv5944882130logo {
padding-bottom:10px;}


#yiv5944882130 #yiv5944882130ygrp-msg p a {
font-family:Verdana;}

#yiv5944882130 #yiv5944882130ygrp-msg
p#yiv5944882130attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5944882130 #yiv5944882130ygrp-reco
#yiv5944882130reco-head {
color:#ff7900;font-weight:700;}

#yiv5944882130 #yiv5944882130ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5944882130 #yiv5944882130ygrp-sponsor #yiv5944882130ov
li a {
font-size:130%;text-decoration:none;}

#yiv5944882130 #yiv5944882130ygrp-sponsor #yiv5944882130ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5944882130 #yiv5944882130ygrp-sponsor #yiv5944882130ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5944882130 #yiv5944882130ygrp-text {
font-family:Georgia;}

#yiv5944882130 #yiv5944882130ygrp-text p {
margin:0 0 1em 0;}

#yiv5944882130 #yiv5944882130ygrp-text tt {
font-size:120%;}

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

Fri Jul 29, 2016 4:42 pm (PDT) . Posted by:

mokwit

Could be effect from the fact that Yahoo apparently uses different servers with different timestamps and requests are randomly assigned between servers - discussion on this over at elitetrader.com - search under 'Yahoo" should find it.

Fri Jul 29, 2016 8:33 pm (PDT) . Posted by:

perseuslim11

Hmm, interesting.. but how do I solve this?

Fri Jul 29, 2016 8:29 pm (PDT) . Posted by:

perseuslim11

Hi Randy, I've tried posting a complaint on the link above, but till now there's no one replying me there at yahoo..

Meanwhile, is there any function like rchgetyahoohistory function that could pull the history data from google finance instead of yahoo?

Fri Jul 29, 2016 11:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30531

On Fri, Jul 29, 2016 at 8:29 PM, perseuslim11@
​...wrote:

>
> Hi Randy, I've tried posting a complaint on the link above, but till now
> there's no one replying me there at yahoo..
>
> Meanwhile, is there any function like rchgetyahoohistory function that
> could pull the history data from google finance instead of yahoo?
>
>

Sat Jul 30, 2016 12:09 am (PDT) . Posted by:

perseuslim11

Thanks Randy! ^^

Mind if I ask why are you unhappy with the data from morningstar and google? is it because they're inacurrate? or because they didnt adjust?

Sat Jul 30, 2016 12:17 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Mostly because they don't adjust. But both also add in holidays, carrying
forward the previous closing price as O/H/L/C and setting volume to zero.
Screws up things using trading days or averages of any kind. They used to
do that on non-holidays as well, at a random pattern I never figured out.

The limited history is also an issue, as I sometimes do some backtesting on
indexes and ETFs. Market timing type stuff.

The NYSE exchange portal has a CSV file almost exactly like Yahoo, but it's
got some type of security that prevents the add-in from getting at it. But
it might not be a bad way to go if manually exporting the file works.

Otherwise, a good pay service would be best.

On Sat, Jul 30, 2016 at 12:09 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Mind if I ask why are you unhappy with the data from morningstar and
> google? is it because they're inacurrate? or because they didnt adjust?
>

Sat Jul 30, 2016 12:41 am (PDT) . Posted by:

perseuslim11

Hmm, I don't get what you mean by "add in holidays" as I've just went to this link to check on google finance Fiamma Holdings Bhd: KLSE:FIAMMA historical prices – Google Finance http://www.google.co.uk/finance/historical?q=KLSE%3AFIAMMA&ei=FlecV9GXJ8m4ugS02YmoBg&start=0&num=30

http://www.google.co.uk/finance/historical?q=KLSE%3AFIAMMA&ei=FlecV9GXJ8m4ugS02YmoBg&start=0&num=30

Fiamma Holdings Bhd: KLSE:FIAMMA historical pr... http://www.google.co.uk/finance/historical?q=KLSE%3AFIAMMA&ei=FlecV9GXJ8m4ugS02YmoBg&start=0&num=30 Search Images Maps Play YouTube News Gmail Drive More Calendar Translate Mobile Books Wallet Shopping Blogger Finance Photos Videos Docs Even mo...



View on www.google.co.uk http://www.google.co.uk/finance/historical?q=KLSE%3AFIAMMA&ei=FlecV9GXJ8m4ugS02YmoBg&start=0&num=30
Preview by Yahoo





but I see both yahoo and google set the volume to 0 or "-"
though it's weird that on Oct 15 and 16, there are values on yahoo while none on google...


and oct 15 and 16 is not holiday in my country as well... there was a holiday on 14th October 2015 though


so why do they leave 15th and 16th october blank?


Attachment(s) from
2 of 2 Photo(s)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.22

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)