Selasa, 24 Mei 2016

[smf_addin] Digest Number 3707

6 Messages

Digest #3707
1a
earnings date (13893) by pete_cook2001
1b
Re: earnings date (13893) by "Randy Harmelink" rharmelink
3a
Detailed Compensation by nicolaslee1992
3b
Re: Detailed Compensation by "Randy Harmelink" rharmelink

Messages

Mon May 23, 2016 8:38 am (PDT) . Posted by:

pete_cook2001

I use RCHGetElementNumber(ticker,"13893") to get the next earnings date, but sometime recently it began returning an error. Any ideas?



I'm using the latest SMF update.


Many thanks!
Peter


Mon May 23, 2016 10:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. Zacks changed all their URLs from "http://" to
"https://, so I had to update all the element definitions for Zacks.

I uploaded the new smf-element-6.txt and smf-element-8.txt element
definition files to the add-in web site:

http://ogres-crypt.com/SMF/Elements/

Best practice is to exit EXCEL before updating the files.

On Mon, May 23, 2016 at 8:38 AM, peterscottcook@
​...wrote:

> I use RCHGetElementNumber(ticker,"13893") to get the next earnings date,
> but sometime recently it began returning an error. Any ideas?
>
> I'm using the latest SMF update.
>
> Many thanks!
>
> Peter
>
>

Mon May 23, 2016 10:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

​Some updated files on the "Elements" web page (
http://ogres-crypt.com/SMF/Elements
<http://ogres-crypt.com/SMF/Works-In-Progress/>):

FilenameSizeLast ModifiedDescription
RCHGetElementNumber-Element-Definitions.xls
<http://ogres-crypt.com/SMF/Elements/RCHGetElementNumber-Element-Definitions.xls>
3028480
2016-05-23 10:00 AM
Documentation of element definitions, as of 2016-05-23
smf-elements-6.txt <http://ogres-crypt.com/SMF/Elements/smf-elements-6.txt>
8028
2016-05-23 10:00 AM
Zacks data elements
2016-05-23: Change Zacks URLs to https://
smf-elements-8.txt <http://ogres-crypt.com/SMF/Elements/smf-elements-8.txt>
53309
2016-05-23 10:00 AM
Earnings.com data elements
2016-01-13: #1286-#1400 (Zacks Earnings)
2016-05-23: Change Zacks URLs to https://
All Zacks element definitions were changed to reflect a Zacks change in
their URLs, from "http://" to "https://"...

Best practice is to exit EXCEL before updating add-in files.

Mon May 23, 2016 1:54 pm (PDT) . Posted by:

nicolaslee1992

Randy,

I was wondering how I could go about getting detailed compensation information pulled into excel. Morningstar has this table for example but there is also detailed summary compensation tables in their definitive proxies. IDT IDT Corp Class B Executive Compensation http://insiders.morningstar.com/trading/executive-compensation.action?t=IDT®ion=usa&culture=en-US


IDT IDT Corp Class B Executive Compensation http://insiders.morningstar.com/trading/executive-compensation.action?t=IDT®ion=usa&culture=en-US Get executive compensation information for IDT Corp Class B executives



View on insiders.morningstar.com http://insiders.morningstar.com/trading/executive-compensation.action?t=IDT®ion=usa&culture=en-US
Preview by Yahoo



Mon May 23, 2016 4:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The web page you cited is a dynamic web page generated by MorningStar, so
the data you want is not on that page. However, MorningStar does have the
data on a static web page, from which it builds that web page. So:

To get all the data, array-enter this over a range:

=RCHGetHTMLTable("
http://insiders.morningstar.com/trading/executive-compensation-list.action?t=IDT
","",1,"<script>",-1)

To get just the summary data:

=RCHGetHTMLTable("
http://insiders.morningstar.com/trading/executive-compensation-list.action?t=IDT
","",1,"",3)

Then just do groups of two for each executive:

=RCHGetHTMLTable("
http://insiders.morningstar.com/trading/executive-compensation-list.action?t=IDT
","",4,"",5)
=RCHGetHTMLTable("
http://insiders.morningstar.com/trading/executive-compensation-list.action?t=IDT
","",6,"",7)

...and so forth.

On Mon, May 23, 2016 at 1:54 PM, nicolaslee1992@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Randy,
>
> I was wondering how I could go about getting detailed compensation
> information pulled into excel. Morningstar has this table for example but
> there is also detailed summary compensation tables in their definitive
> proxies. IDT IDT Corp Class B Executive Compensation
> <http://insiders.morningstar.com/trading/executive-compensation.action?t=IDT®ion=usa&culture=en-US>
>
> IDT IDT Corp Class B Executive Compensation
> <http://insiders.morningstar.com/trading/executive-compensation.action?t=IDT®ion=usa&culture=en-US>
> Get executive compensation information for IDT Corp Class B executives
> View on insiders.morningstar.com
> <http://insiders.morningstar.com/trading/executive-compensation.action?t=IDT®ion=usa&culture=en-US>
> Preview by Yahoo
>
>
>

Mon May 23, 2016 2:35 pm (PDT) . Posted by:

"Vlad Klenikov" vkleniko

To the extent others encounter the Win10 issue I described below with Guru financials update, both with VBA and with smfGetCSVFile function, it appears I found a solution. Please see below:- Be sure to open IE, not the Edge or any other browser on your Win10 machine. IE comes pre-installed with Win10, but does not show up on the app list. You need to type "internet" in Start/Search string and it will pop up
- Open IE Options, select Security tab- Add http://www.gurufocus.com/ to the Trusted Sites list
- Deselect Enable Protected Mode checkbox, hit ok and close the Options Dialog- Close and reopen IE again. Then go to www.gurufocus.com and reenter your premium account credentials. Be sure to save the password
This resolved the issue for me
 Vlad

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)

#yiv2723894390 #yiv2723894390 -- #yiv2723894390ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2723894390 #yiv2723894390ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2723894390 #yiv2723894390ygrp-mkp #yiv2723894390hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2723894390 #yiv2723894390ygrp-mkp #yiv2723894390ads {margin-bottom:10px;}#yiv2723894390 #yiv2723894390ygrp-mkp .yiv2723894390ad {padding:0 0;}#yiv2723894390 #yiv2723894390ygrp-mkp .yiv2723894390ad p {margin:0;}#yiv2723894390 #yiv2723894390ygrp-mkp .yiv2723894390ad a {color:#0000ff;text-decoration:none;}#yiv2723894390 #yiv2723894390ygrp-sponsor #yiv2723894390ygrp-lc {font-family:Arial;}#yiv2723894390 #yiv2723894390ygrp-sponsor #yiv2723894390ygrp-lc #yiv2723894390hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2723894390 #yiv2723894390ygrp-sponsor #yiv2723894390ygrp-lc .yiv2723894390ad {margin-bottom:10px;padding:0 0;}#yiv2723894390 #yiv2723894390actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2723894390 #yiv2723894390activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2723894390 #yiv2723894390activity span {font-weight:700;}#yiv2723894390 #yiv2723894390activity span:first-child {text-transform:uppercase;}#yiv2723894390 #yiv2723894390activity span a {color:#5085b6;text-decoration:none;}#yiv2723894390 #yiv2723894390activity span span {color:#ff7900;}#yiv2723894390 #yiv2723894390activity span .yiv2723894390underline {text-decoration:underline;}#yiv2723894390 .yiv2723894390attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2723894390 .yiv2723894390attach div a {text-decoration:none;}#yiv2723894390 .yiv2723894390attach img {border:none;padding-right:5px;}#yiv2723894390 .yiv2723894390attach label {display:block;margin-bottom:5px;}#yiv2723894390 .yiv2723894390attach label a {text-decoration:none;}#yiv2723894390 blockquote {margin:0 0 0 4px;}#yiv2723894390 .yiv2723894390bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2723894390 .yiv2723894390bold a {text-decoration:none;}#yiv2723894390 dd.yiv2723894390last p a {font-family:Verdana;font-weight:700;}#yiv2723894390 dd.yiv2723894390last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2723894390 dd.yiv2723894390last p span.yiv2723894390yshortcuts {margin-right:0;}#yiv2723894390 div.yiv2723894390attach-table div div a {text-decoration:none;}#yiv2723894390 div.yiv2723894390attach-table {width:400px;}#yiv2723894390 div.yiv2723894390file-title a, #yiv2723894390 div.yiv2723894390file-title a:active, #yiv2723894390 div.yiv2723894390file-title a:hover, #yiv2723894390 div.yiv2723894390file-title a:visited {text-decoration:none;}#yiv2723894390 div.yiv2723894390photo-title a, #yiv2723894390 div.yiv2723894390photo-title a:active, #yiv2723894390 div.yiv2723894390photo-title a:hover, #yiv2723894390 div.yiv2723894390photo-title a:visited {text-decoration:none;}#yiv2723894390 div#yiv2723894390ygrp-mlmsg #yiv2723894390ygrp-msg p a span.yiv2723894390yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2723894390 .yiv2723894390green {color:#628c2a;}#yiv2723894390 .yiv2723894390MsoNormal {margin:0 0 0 0;}#yiv2723894390 o {font-size:0;}#yiv2723894390 #yiv2723894390photos div {float:left;width:72px;}#yiv2723894390 #yiv2723894390photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2723894390 #yiv2723894390photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2723894390 #yiv2723894390reco-category {font-size:77%;}#yiv2723894390 #yiv2723894390reco-desc {font-size:77%;}#yiv2723894390 .yiv2723894390replbq {margin:4px;}#yiv2723894390 #yiv2723894390ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2723894390 #yiv2723894390ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2723894390 #yiv2723894390ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2723894390 #yiv2723894390ygrp-mlmsg select, #yiv2723894390 input, #yiv2723894390 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2723894390 #yiv2723894390ygrp-mlmsg pre, #yiv2723894390 code {font:115% monospace;}#yiv2723894390 #yiv2723894390ygrp-mlmsg * {line-height:1.22em;}#yiv2723894390 #yiv2723894390ygrp-mlmsg #yiv2723894390logo {padding-bottom:10px;}#yiv2723894390 #yiv2723894390ygrp-msg p a {font-family:Verdana;}#yiv2723894390 #yiv2723894390ygrp-msg p#yiv2723894390attach-count span {color:#1E66AE;font-weight:700;}#yiv2723894390 #yiv2723894390ygrp-reco #yiv2723894390reco-head {color:#ff7900;font-weight:700;}#yiv2723894390 #yiv2723894390ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2723894390 #yiv2723894390ygrp-sponsor #yiv2723894390ov li a {font-size:130%;text-decoration:none;}#yiv2723894390 #yiv2723894390ygrp-sponsor #yiv2723894390ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2723894390 #yiv2723894390ygrp-sponsor #yiv2723894390ov ul {margin:0;padding:0 0 0 8px;}#yiv2723894390 #yiv2723894390ygrp-text {font-family:Georgia;}#yiv2723894390 #yiv2723894390ygrp-text p {margin:0 0 1em 0;}#yiv2723894390 #yiv2723894390ygrp-text tt {font-size:120%;}#yiv2723894390 #yiv2723894390ygrp-vital ul li:last-child {border-right:none !important;}#yiv2723894390

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

Tidak ada komentar:

Poskan Komentar