Minggu, 31 Juli 2016

[belajar-excel] Digest Number 3925

2 Messages

Digest #3925
2a
Re: Lookup ke Dynamic Range Pivot [1 Attachment] by "Mr. Kid" nmkid.family@ymail.com

Messages

Sat Jul 30, 2016 6:02 pm (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Kesi,

Autofilter bekerja berdasar definisi *sebuah area range* autofilter. Tidak
ada penjelasan detil tentang bagaimana cara Autofilter membentuk sebuah
area dan bagaimana autofiter memperluas area tersebut.

Dengan batasan di atas, bila autofilter tidak bekerja dengan baik, penyebab
utamanya adalah ada area data yang tidak masuk ke dalam area range
autofilter karena autofilter tidak mampu memperluas atau mendefinisikan
ulang area rangenya.

Andai dirunut kembali setiap kejadian sejak dipasang autofilter sampai pada
penambahan records terakhirnya (kejadian proses paste records baru, copy
formula, ubah formula, dsb), besar kemungkinan akan dapat diketahui
penyebab autofilter tidak mampu memperluas definisi area rangenya.

btw,
cara berikut bisa memperbaikinya : (mendefinisikan ulang area range
autofilter)
turn-off autofilternya, blok seluruh data yang akan difilter, aktifkan
kembali autofilter

menjaga tabel data tidak memiliki baris kosong (bukan sekedar sebuah kolom
kosong atau sekedar di sebuah kolom ada cells yang kosong), sehingga
autofiter bisa di-nonaktifkan atau diaktifkan dengan segala cara. Andai hal
tersebut tidak dapat dilakukan, maka autofilter diaktifkan setelah memblok
seluruh kolom Excel yang berisi data (misal data di kolom B1:G17, maka blok
kolom B:G). Bila data tidak dimulai dari baris 1, maka blok data mulai
baris header di kolom yang berisi data sampai baris terakhir Excel di kolom
terkanan data (bukan kolom terkanan Excel) dan dilanjutkan dengan
mengaktifkan autofilter.

fyi,
fitur Excel bernama Excel Table (lihat di ribbon Home -> group Styles ->
Format as Table) bisa menghindarkan dari kegagalan autofilter dalam
mendefinisikan area rangenya, karena area range autofilter dalam sebuah
Excel Table (fitur) sudah didefinisikan oleh si fitur Excel Table.

Regards,
Kid

2016-07-29 14:37 GMT+07:00 KESI VIZZIANTI kesi.vizzianti@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Selamat Sore Sahabat Excel
> Fungsi filter pada excel biasanya akan berhenti pada kolom yang kosong
> (blank), di file saya (terlampir) kolom masih terisi tapi filter berhenti
> sehingga hasil tidak sesuai yg di inginkan
>
> Apakah ada yang salah ..Mohon bantuannya
>
>
>

Sat Jul 30, 2016 6:27 pm (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Nico,

Formula :
=Index($1:$1048576,Match(c3,$a:$a,0),Match("zzz",$7:$7))

Regards,
Kid

2016-07-29 15:00 GMT+07:00 Nicodemus Rusdiyanto tjahdjokja234@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> dear Suhu(s),
>
> Mohon pencerahan, untuk case berikut;
>
>
> - Cerita-nya file terlampir adalah pivot dari sebuah data.
> - di kolom yang ane block abu-abu/gelap data yang saya perlukan dengan
> memperhatikan "sifat" si pivot yang bisa berubah2
> - bisa tambah ke kanan atau ke kiri apabila ada update
> - bisa tambah ke bawah atau naik lagi apabila di update
> - yang ane perlu data total per kriteria, seperti file terlampir.
>
>
> --
> Thanks in advance,
> Nico
>
>
>
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....

[smf_addin] Digest Number 3760

4 Messages

Digest #3760

Messages

Sat Jul 30, 2016 5:54 am (PDT) . Posted by:

marcnyc11

A big thank you to Randy! This problem just started for me last Friday afternoon and I was freaking out. Really appreciate you figuring it out and posting a solution. Like Jose, it didn't work for me just by adding C/smf as trusted. I had to unblock the .XLA file as well. Thanks again!


Marc

Sat Jul 30, 2016 7:11 am (PDT) . Posted by:

"Jose Jacob" pepecan47

I removed the c\SMF from the trusted list. According to the MS description is to big of a security exposure. Only unblocking the file worked for me.

Regards,
Jose L. Jacob

--------------------------------------------
On Sat, 7/30/16, Marcnyc11@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: [smf_addin] Re: Microsoft Excel security message
To: smf_addin@yahoogroups.com
Received: Saturday, July 30, 2016, 8:54 AM


 









A big thank you to Randy! This problem
just started for me last Friday afternoon and I was freaking
out. Really appreciate you figuring it out and posting a
solution. Like Jose, it didn't work for me just by
adding C/smf as trusted. I had to unblock the .XLA file as
well. Thanks again!
Marc










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

#yiv4598231418 #yiv4598231418ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv4598231418 #yiv4598231418ygrp-mkp #yiv4598231418hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv4598231418 #yiv4598231418ygrp-mkp #yiv4598231418ads {
margin-bottom:10px;}

#yiv4598231418 #yiv4598231418ygrp-mkp .yiv4598231418ad {
padding:0 0;}

#yiv4598231418 #yiv4598231418ygrp-mkp .yiv4598231418ad p {
margin:0;}

#yiv4598231418 #yiv4598231418ygrp-mkp .yiv4598231418ad a {
color:#0000ff;text-decoration:none;}
#yiv4598231418 #yiv4598231418ygrp-sponsor
#yiv4598231418ygrp-lc {
font-family:Arial;}

#yiv4598231418 #yiv4598231418ygrp-sponsor
#yiv4598231418ygrp-lc #yiv4598231418hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv4598231418 #yiv4598231418ygrp-sponsor
#yiv4598231418ygrp-lc .yiv4598231418ad {
margin-bottom:10px;padding:0 0;}

#yiv4598231418 #yiv4598231418actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv4598231418 #yiv4598231418activity span {
font-weight:700;}

#yiv4598231418 #yiv4598231418activity span:first-child {
text-transform:uppercase;}

#yiv4598231418 #yiv4598231418activity span a {
color:#5085b6;text-decoration:none;}

#yiv4598231418 #yiv4598231418activity span span {
color:#ff7900;}

#yiv4598231418 #yiv4598231418activity span
.yiv4598231418underline {
text-decoration:underline;}

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

#yiv4598231418 .yiv4598231418attach div a {
text-decoration:none;}

#yiv4598231418 .yiv4598231418attach img {
border:none;padding-right:5px;}

#yiv4598231418 .yiv4598231418attach label {
display:block;margin-bottom:5px;}

#yiv4598231418 .yiv4598231418attach label a {
text-decoration:none;}

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

#yiv4598231418 .yiv4598231418bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv4598231418 .yiv4598231418bold a {
text-decoration:none;}

#yiv4598231418 dd.yiv4598231418last p a {
font-family:Verdana;font-weight:700;}

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

#yiv4598231418 dd.yiv4598231418last p
span.yiv4598231418yshortcuts {
margin-right:0;}

#yiv4598231418 div.yiv4598231418attach-table div div a {
text-decoration:none;}

#yiv4598231418 div.yiv4598231418attach-table {
width:400px;}

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

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

#yiv4598231418 div#yiv4598231418ygrp-mlmsg
#yiv4598231418ygrp-msg p a span.yiv4598231418yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv4598231418 .yiv4598231418green {
color:#628c2a;}

#yiv4598231418 .yiv4598231418MsoNormal {
margin:0 0 0 0;}

#yiv4598231418 o {
font-size:0;}

#yiv4598231418 #yiv4598231418photos div {
float:left;width:72px;}

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

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

#yiv4598231418 #yiv4598231418reco-category {
font-size:77%;}

#yiv4598231418 #yiv4598231418reco-desc {
font-size:77%;}

#yiv4598231418 .yiv4598231418replbq {
margin:4px;}

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

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

#yiv4598231418 #yiv4598231418ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv4598231418 #yiv4598231418ygrp-mlmsg pre, #yiv4598231418
code {
font:115% monospace;}

#yiv4598231418 #yiv4598231418ygrp-mlmsg * {
line-height:1.22em;}

#yiv4598231418 #yiv4598231418ygrp-mlmsg #yiv4598231418logo {
padding-bottom:10px;}


#yiv4598231418 #yiv4598231418ygrp-msg p a {
font-family:Verdana;}

#yiv4598231418 #yiv4598231418ygrp-msg
p#yiv4598231418attach-count span {
color:#1E66AE;font-weight:700;}

#yiv4598231418 #yiv4598231418ygrp-reco
#yiv4598231418reco-head {
color:#ff7900;font-weight:700;}

#yiv4598231418 #yiv4598231418ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv4598231418 #yiv4598231418ygrp-sponsor #yiv4598231418ov
li a {
font-size:130%;text-decoration:none;}

#yiv4598231418 #yiv4598231418ygrp-sponsor #yiv4598231418ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv4598231418 #yiv4598231418ygrp-sponsor #yiv4598231418ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv4598231418 #yiv4598231418ygrp-text {
font-family:Georgia;}

#yiv4598231418 #yiv4598231418ygrp-text p {
margin:0 0 1em 0;}

#yiv4598231418 #yiv4598231418ygrp-text tt {
font-size:120%;}

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

Sat Jul 30, 2016 10:27 am (PDT) . Posted by:

jaja3279

The only thing you may need to do to resolve this issue is to "unblock" the RCH_Stock_Market_Functions.xla file.

How do you do that? Go to the SMF Add-in folder, right click on the file, then under Properties > General tab, check the Unblock box. You will need admin privileges or login as admin to do this.


Apparently, after the security update, some file types including xla and xls that were downloaded from the internet are blocked by default from opening.


In my case, nothing else and no other combination of things worked. It is not necessary to add the SMF Add-in folder to the trusted locations list.


I have Windows 10 and Excel 2010.


Hope that clarifies and helps. Good luck.





Sat Jul 30, 2016 9:38 pm (PDT) . Posted by:

silsanders

Thanks. Unblock indeed fixes it.

---In smf_addin@yahoogroups.com, <karerat@...> wrote :

The only thing you may need to do to resolve this issue is to "unblock" the RCH_Stock_Market_Functions.xla file.

How do you do that? Go to the SMF Add-in folder, right click on the file, then under Properties > General tab, check the Unblock box. You will need admin privileges or login as admin to do this.


Apparently, after the security update, some file types including xla and xls that were downloaded from the internet are blocked by default from opening.


In my case, nothing else and no other combination of things worked. It is not necessary to add the SMF Add-in folder to the trusted locations list.


I have Windows 10 and Excel 2010.


Hope that clarifies and helps. Good luck.







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

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
READ MORE....