Minggu, 22 Mei 2016

[smf_addin] Digest Number 3705

2 Messages

Digest #3705

Messages

Sat May 21, 2016 5:35 pm (PDT) . Posted by:

"Vlad Klenikov" vkleniko

Randy - where is the CSV file supposed to be saved in after one runs
=smfGetCSVFile as array function? It is not opening in the current Excel session.
the cell with the formula says
| Downloaded from http://www.GuruFocus.com on 2016-05-21 at 19:24(CST) |

but i don't see the data Vlad Klenikov
+1(917)650 4198

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 20, 2016 2:01 PM
Subject: Re: [smf_addin] Guru financials VBA download fail in Excel 2016

  I often say it's preferred to log into sites using the EXCEL Web Query Dialog. That's because sometimes the IE object that EXCEL (and the add-in) use may not be the same version of IE that the browser is. I don't know how they get out of sync. It may or may not apply to your situation?

BTW, I now use this to grab the full financials instead of downloading the XLS file:

=smfGetCSVFile("http://www.gurufocus.com/download_financials_in_CSV.php?symbol="&B2)

It has more data and is much faster and cleaner in getting the data. For MMM, that gets me 20 annual periods, 80 quarterly periods, and TTM, as well as some current values of different ratios.

On Fri, May 20, 2016 at 11:34 AM, vkleniko@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

On my new Win10/Office 2016 PC  Randy's VBA code I use in my models (listed at bottom) to call for Guru financials download now hits back with this error:
<meta http-equiv="refresh" content="0; URL=http://www.gurufocus.com/membership/upgrade.php?redir=/download_dataset.php?symbol=AA"> (as an example for ticker AA). This says that i need to register for Guru Premium or provide credentials. I am a premium member and have saved my logins in all possible installed browsers on my new machine (IE, Edge, Firefox)

I double checked that the VBA code works fine on my Office 2010 and Office 2007 equipped machines.

Is this an Excel 2016 glitch? Did anyone else encounter this issue or have a solution?

Any help would be appreciated?

Vlad

SAMPLE VBA Code

​​Set wb1 = ActiveWorkbook
        sTicker = [TICKER].Value
        If sTicker = "" Then MsgBox ("ENTER TICKER")
        Workbooks.Open FileName:="http://www.gurufocus.com/download_dataset.php?symbol=" & sTicker ' downloads and opens GuruFocus Dataset for the ticker selected
        Sheets("Historical Financial").Name = sTicker & "-Financial&quot;
        Sheets(sTicker & "-Financial&quot;).Copy Before:=wb1.Sheets(1)

#yiv7067439655 #yiv7067439655 -- #yiv7067439655ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7067439655 #yiv7067439655ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7067439655 #yiv7067439655ygrp-mkp #yiv7067439655hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7067439655 #yiv7067439655ygrp-mkp #yiv7067439655ads {margin-bottom:10px;}#yiv7067439655 #yiv7067439655ygrp-mkp .yiv7067439655ad {padding:0 0;}#yiv7067439655 #yiv7067439655ygrp-mkp .yiv7067439655ad p {margin:0;}#yiv7067439655 #yiv7067439655ygrp-mkp .yiv7067439655ad a {color:#0000ff;text-decoration:none;}#yiv7067439655 #yiv7067439655ygrp-sponsor #yiv7067439655ygrp-lc {font-family:Arial;}#yiv7067439655 #yiv7067439655ygrp-sponsor #yiv7067439655ygrp-lc #yiv7067439655hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7067439655 #yiv7067439655ygrp-sponsor #yiv7067439655ygrp-lc .yiv7067439655ad {margin-bottom:10px;padding:0 0;}#yiv7067439655 #yiv7067439655actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7067439655 #yiv7067439655activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7067439655 #yiv7067439655activity span {font-weight:700;}#yiv7067439655 #yiv7067439655activity span:first-child {text-transform:uppercase;}#yiv7067439655 #yiv7067439655activity span a {color:#5085b6;text-decoration:none;}#yiv7067439655 #yiv7067439655activity span span {color:#ff7900;}#yiv7067439655 #yiv7067439655activity span .yiv7067439655underline {text-decoration:underline;}#yiv7067439655 .yiv7067439655attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7067439655 .yiv7067439655attach div a {text-decoration:none;}#yiv7067439655 .yiv7067439655attach img {border:none;padding-right:5px;}#yiv7067439655 .yiv7067439655attach label {display:block;margin-bottom:5px;}#yiv7067439655 .yiv7067439655attach label a {text-decoration:none;}#yiv7067439655 blockquote {margin:0 0 0 4px;}#yiv7067439655 .yiv7067439655bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7067439655 .yiv7067439655bold a {text-decoration:none;}#yiv7067439655 dd.yiv7067439655last p a {font-family:Verdana;font-weight:700;}#yiv7067439655 dd.yiv7067439655last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7067439655 dd.yiv7067439655last p span.yiv7067439655yshortcuts {margin-right:0;}#yiv7067439655 div.yiv7067439655attach-table div div a {text-decoration:none;}#yiv7067439655 div.yiv7067439655attach-table {width:400px;}#yiv7067439655 div.yiv7067439655file-title a, #yiv7067439655 div.yiv7067439655file-title a:active, #yiv7067439655 div.yiv7067439655file-title a:hover, #yiv7067439655 div.yiv7067439655file-title a:visited {text-decoration:none;}#yiv7067439655 div.yiv7067439655photo-title a, #yiv7067439655 div.yiv7067439655photo-title a:active, #yiv7067439655 div.yiv7067439655photo-title a:hover, #yiv7067439655 div.yiv7067439655photo-title a:visited {text-decoration:none;}#yiv7067439655 div#yiv7067439655ygrp-mlmsg #yiv7067439655ygrp-msg p a span.yiv7067439655yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7067439655 .yiv7067439655green {color:#628c2a;}#yiv7067439655 .yiv7067439655MsoNormal {margin:0 0 0 0;}#yiv7067439655 o {font-size:0;}#yiv7067439655 #yiv7067439655photos div {float:left;width:72px;}#yiv7067439655 #yiv7067439655photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7067439655 #yiv7067439655photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7067439655 #yiv7067439655reco-category {font-size:77%;}#yiv7067439655 #yiv7067439655reco-desc {font-size:77%;}#yiv7067439655 .yiv7067439655replbq {margin:4px;}#yiv7067439655 #yiv7067439655ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7067439655 #yiv7067439655ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7067439655 #yiv7067439655ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7067439655 #yiv7067439655ygrp-mlmsg select, #yiv7067439655 input, #yiv7067439655 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7067439655 #yiv7067439655ygrp-mlmsg pre, #yiv7067439655 code {font:115% monospace;}#yiv7067439655 #yiv7067439655ygrp-mlmsg * {line-height:1.22em;}#yiv7067439655 #yiv7067439655ygrp-mlmsg #yiv7067439655logo {padding-bottom:10px;}#yiv7067439655 #yiv7067439655ygrp-msg p a {font-family:Verdana;}#yiv7067439655 #yiv7067439655ygrp-msg p#yiv7067439655attach-count span {color:#1E66AE;font-weight:700;}#yiv7067439655 #yiv7067439655ygrp-reco #yiv7067439655reco-head {color:#ff7900;font-weight:700;}#yiv7067439655 #yiv7067439655ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7067439655 #yiv7067439655ygrp-sponsor #yiv7067439655ov li a {font-size:130%;text-decoration:none;}#yiv7067439655 #yiv7067439655ygrp-sponsor #yiv7067439655ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7067439655 #yiv7067439655ygrp-sponsor #yiv7067439655ov ul {margin:0;padding:0 0 0 8px;}#yiv7067439655 #yiv7067439655ygrp-text {font-family:Georgia;}#yiv7067439655 #yiv7067439655ygrp-text p {margin:0 0 1em 0;}#yiv7067439655 #yiv7067439655ygrp-text tt {font-size:120%;}#yiv7067439655 #yiv7067439655ygrp-vital ul li:last-child {border-right:none !important;}#yiv7067439655

Sat May 21, 2016 5:38 pm (PDT) . Posted by:

"Vlad Klenikov" vkleniko

Never mind. Reread the documentation. I got it now. Awesome tool
 Vlad Klenikov
+1(917)650 4198

From: "Vlad Klenikov vkleniko@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Saturday, May 21, 2016 7:35 PM
Subject: Re: [smf_addin] Guru financials VBA download fail in Excel 2016

  Randy - where is the CSV file supposed to be saved in after one runs
=smfGetCSVFile as array function? It is not opening in the current Excel session.
the cell with the formula says
| Downloaded from http://www.GuruFocus.com on 2016-05-21 at 19:24(CST) |

but i don't see the data Vlad Klenikov
+1(917)650 4198

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 20, 2016 2:01 PM
Subject: Re: [smf_addin] Guru financials VBA download fail in Excel 2016

  I often say it's preferred to log into sites using the EXCEL Web Query Dialog. That's because sometimes the IE object that EXCEL (and the add-in) use may not be the same version of IE that the browser is. I don't know how they get out of sync. It may or may not apply to your situation?

BTW, I now use this to grab the full financials instead of downloading the XLS file:

=smfGetCSVFile("http://www.gurufocus.com/download_financials_in_CSV.php?symbol="&B2)

It has more data and is much faster and cleaner in getting the data. For MMM, that gets me 20 annual periods, 80 quarterly periods, and TTM, as well as some current values of different ratios.

On Fri, May 20, 2016 at 11:34 AM, vkleniko@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

On my new Win10/Office 2016 PC  Randy's VBA code I use in my models (listed at bottom) to call for Guru financials download now hits back with this error:
<meta http-equiv="refresh" content="0; URL=http://www.gurufocus.com/membership/upgrade.php?redir=/download_dataset.php?symbol=AA"> (as an example for ticker AA). This says that i need to register for Guru Premium or provide credentials. I am a premium member and have saved my logins in all possible installed browsers on my new machine (IE, Edge, Firefox)

I double checked that the VBA code works fine on my Office 2010 and Office 2007 equipped machines.

Is this an Excel 2016 glitch? Did anyone else encounter this issue or have a solution?

Any help would be appreciated?

Vlad

SAMPLE VBA Code

​​Set wb1 = ActiveWorkbook
        sTicker = [TICKER].Value
        If sTicker = "" Then MsgBox ("ENTER TICKER")
        Workbooks.Open FileName:="http://www.gurufocus.com/download_dataset.php?symbol=" & sTicker ' downloads and opens GuruFocus Dataset for the ticker selected
        Sheets("Historical Financial").Name = sTicker & "-Financial&quot;
        Sheets(sTicker & "-Financial&quot;).Copy Before:=wb1.Sheets(1)

#yiv8887146410 #yiv8887146410 -- #yiv8887146410ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8887146410 #yiv8887146410ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8887146410 #yiv8887146410ygrp-mkp #yiv8887146410hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8887146410 #yiv8887146410ygrp-mkp #yiv8887146410ads {margin-bottom:10px;}#yiv8887146410 #yiv8887146410ygrp-mkp .yiv8887146410ad {padding:0 0;}#yiv8887146410 #yiv8887146410ygrp-mkp .yiv8887146410ad p {margin:0;}#yiv8887146410 #yiv8887146410ygrp-mkp .yiv8887146410ad a {color:#0000ff;text-decoration:none;}#yiv8887146410 #yiv8887146410ygrp-sponsor #yiv8887146410ygrp-lc {font-family:Arial;}#yiv8887146410 #yiv8887146410ygrp-sponsor #yiv8887146410ygrp-lc #yiv8887146410hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8887146410 #yiv8887146410ygrp-sponsor #yiv8887146410ygrp-lc .yiv8887146410ad {margin-bottom:10px;padding:0 0;}#yiv8887146410 #yiv8887146410actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8887146410 #yiv8887146410activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8887146410 #yiv8887146410activity span {font-weight:700;}#yiv8887146410 #yiv8887146410activity span:first-child {text-transform:uppercase;}#yiv8887146410 #yiv8887146410activity span a {color:#5085b6;text-decoration:none;}#yiv8887146410 #yiv8887146410activity span span {color:#ff7900;}#yiv8887146410 #yiv8887146410activity span .yiv8887146410underline {text-decoration:underline;}#yiv8887146410 .yiv8887146410attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8887146410 .yiv8887146410attach div a {text-decoration:none;}#yiv8887146410 .yiv8887146410attach img {border:none;padding-right:5px;}#yiv8887146410 .yiv8887146410attach label {display:block;margin-bottom:5px;}#yiv8887146410 .yiv8887146410attach label a {text-decoration:none;}#yiv8887146410 blockquote {margin:0 0 0 4px;}#yiv8887146410 .yiv8887146410bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8887146410 .yiv8887146410bold a {text-decoration:none;}#yiv8887146410 dd.yiv8887146410last p a {font-family:Verdana;font-weight:700;}#yiv8887146410 dd.yiv8887146410last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8887146410 dd.yiv8887146410last p span.yiv8887146410yshortcuts {margin-right:0;}#yiv8887146410 div.yiv8887146410attach-table div div a {text-decoration:none;}#yiv8887146410 div.yiv8887146410attach-table {width:400px;}#yiv8887146410 div.yiv8887146410file-title a, #yiv8887146410 div.yiv8887146410file-title a:active, #yiv8887146410 div.yiv8887146410file-title a:hover, #yiv8887146410 div.yiv8887146410file-title a:visited {text-decoration:none;}#yiv8887146410 div.yiv8887146410photo-title a, #yiv8887146410 div.yiv8887146410photo-title a:active, #yiv8887146410 div.yiv8887146410photo-title a:hover, #yiv8887146410 div.yiv8887146410photo-title a:visited {text-decoration:none;}#yiv8887146410 div#yiv8887146410ygrp-mlmsg #yiv8887146410ygrp-msg p a span.yiv8887146410yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8887146410 .yiv8887146410green {color:#628c2a;}#yiv8887146410 .yiv8887146410MsoNormal {margin:0 0 0 0;}#yiv8887146410 o {font-size:0;}#yiv8887146410 #yiv8887146410photos div {float:left;width:72px;}#yiv8887146410 #yiv8887146410photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8887146410 #yiv8887146410photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8887146410 #yiv8887146410reco-category {font-size:77%;}#yiv8887146410 #yiv8887146410reco-desc {font-size:77%;}#yiv8887146410 .yiv8887146410replbq {margin:4px;}#yiv8887146410 #yiv8887146410ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8887146410 #yiv8887146410ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8887146410 #yiv8887146410ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8887146410 #yiv8887146410ygrp-mlmsg select, #yiv8887146410 input, #yiv8887146410 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8887146410 #yiv8887146410ygrp-mlmsg pre, #yiv8887146410 code {font:115% monospace;}#yiv8887146410 #yiv8887146410ygrp-mlmsg * {line-height:1.22em;}#yiv8887146410 #yiv8887146410ygrp-mlmsg #yiv8887146410logo {padding-bottom:10px;}#yiv8887146410 #yiv8887146410ygrp-msg p a {font-family:Verdana;}#yiv8887146410 #yiv8887146410ygrp-msg p#yiv8887146410attach-count span {color:#1E66AE;font-weight:700;}#yiv8887146410 #yiv8887146410ygrp-reco #yiv8887146410reco-head {color:#ff7900;font-weight:700;}#yiv8887146410 #yiv8887146410ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8887146410 #yiv8887146410ygrp-sponsor #yiv8887146410ov li a {font-size:130%;text-decoration:none;}#yiv8887146410 #yiv8887146410ygrp-sponsor #yiv8887146410ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8887146410 #yiv8887146410ygrp-sponsor #yiv8887146410ov ul {margin:0;padding:0 0 0 8px;}#yiv8887146410 #yiv8887146410ygrp-text {font-family:Georgia;}#yiv8887146410 #yiv8887146410ygrp-text p {margin:0 0 1em 0;}#yiv8887146410 #yiv8887146410ygrp-text tt {font-size:120%;}#yiv8887146410 #yiv8887146410ygrp-vital ul li:last-child {border-right:none !important;}#yiv8887146410

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

Tidak ada komentar:

Posting Komentar