Minggu, 29 Mei 2016

[smf_addin] Digest Number 3713

5 Messages

Digest #3713
2a
Re: Next Earnings Date by "Chuck Grablewski" cgrablew
2b
Re: Next Earnings Date by "Randy Harmelink" rharmelink
3b

Messages

Sat May 28, 2016 4:45 am (PDT) . Posted by:

"Ohad Beno" ohadbeno

Thanks :)

On Saturday, May 28, 2016 12:03 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  Try:

=RCHGetTableCell("http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html",4,">United States of America<")

On Sat, May 28, 2016 at 12:18 AM, ohadbeno@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Is there a way to retrieve data from the table "Country default spreads and risk premiums"?Ex. USD, total equity risk premium = 6% http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html

#yiv5732912495 #yiv5732912495 -- #yiv5732912495ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5732912495 #yiv5732912495ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5732912495 #yiv5732912495ygrp-mkp #yiv5732912495hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5732912495 #yiv5732912495ygrp-mkp #yiv5732912495ads {margin-bottom:10px;}#yiv5732912495 #yiv5732912495ygrp-mkp .yiv5732912495ad {padding:0 0;}#yiv5732912495 #yiv5732912495ygrp-mkp .yiv5732912495ad p {margin:0;}#yiv5732912495 #yiv5732912495ygrp-mkp .yiv5732912495ad a {color:#0000ff;text-decoration:none;}#yiv5732912495 #yiv5732912495ygrp-sponsor #yiv5732912495ygrp-lc {font-family:Arial;}#yiv5732912495 #yiv5732912495ygrp-sponsor #yiv5732912495ygrp-lc #yiv5732912495hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5732912495 #yiv5732912495ygrp-sponsor #yiv5732912495ygrp-lc .yiv5732912495ad {margin-bottom:10px;padding:0 0;}#yiv5732912495 #yiv5732912495actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5732912495 #yiv5732912495activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5732912495 #yiv5732912495activity span {font-weight:700;}#yiv5732912495 #yiv5732912495activity span:first-child {text-transform:uppercase;}#yiv5732912495 #yiv5732912495activity span a {color:#5085b6;text-decoration:none;}#yiv5732912495 #yiv5732912495activity span span {color:#ff7900;}#yiv5732912495 #yiv5732912495activity span .yiv5732912495underline {text-decoration:underline;}#yiv5732912495 .yiv5732912495attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5732912495 .yiv5732912495attach div a {text-decoration:none;}#yiv5732912495 .yiv5732912495attach img {border:none;padding-right:5px;}#yiv5732912495 .yiv5732912495attach label {display:block;margin-bottom:5px;}#yiv5732912495 .yiv5732912495attach label a {text-decoration:none;}#yiv5732912495 blockquote {margin:0 0 0 4px;}#yiv5732912495 .yiv5732912495bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5732912495 .yiv5732912495bold a {text-decoration:none;}#yiv5732912495 dd.yiv5732912495last p a {font-family:Verdana;font-weight:700;}#yiv5732912495 dd.yiv5732912495last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5732912495 dd.yiv5732912495last p span.yiv5732912495yshortcuts {margin-right:0;}#yiv5732912495 div.yiv5732912495attach-table div div a {text-decoration:none;}#yiv5732912495 div.yiv5732912495attach-table {width:400px;}#yiv5732912495 div.yiv5732912495file-title a, #yiv5732912495 div.yiv5732912495file-title a:active, #yiv5732912495 div.yiv5732912495file-title a:hover, #yiv5732912495 div.yiv5732912495file-title a:visited {text-decoration:none;}#yiv5732912495 div.yiv5732912495photo-title a, #yiv5732912495 div.yiv5732912495photo-title a:active, #yiv5732912495 div.yiv5732912495photo-title a:hover, #yiv5732912495 div.yiv5732912495photo-title a:visited {text-decoration:none;}#yiv5732912495 div#yiv5732912495ygrp-mlmsg #yiv5732912495ygrp-msg p a span.yiv5732912495yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5732912495 .yiv5732912495green {color:#628c2a;}#yiv5732912495 .yiv5732912495MsoNormal {margin:0 0 0 0;}#yiv5732912495 o {font-size:0;}#yiv5732912495 #yiv5732912495photos div {float:left;width:72px;}#yiv5732912495 #yiv5732912495photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5732912495 #yiv5732912495photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5732912495 #yiv5732912495reco-category {font-size:77%;}#yiv5732912495 #yiv5732912495reco-desc {font-size:77%;}#yiv5732912495 .yiv5732912495replbq {margin:4px;}#yiv5732912495 #yiv5732912495ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5732912495 #yiv5732912495ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5732912495 #yiv5732912495ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5732912495 #yiv5732912495ygrp-mlmsg select, #yiv5732912495 input, #yiv5732912495 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5732912495 #yiv5732912495ygrp-mlmsg pre, #yiv5732912495 code {font:115% monospace;}#yiv5732912495 #yiv5732912495ygrp-mlmsg * {line-height:1.22em;}#yiv5732912495 #yiv5732912495ygrp-mlmsg #yiv5732912495logo {padding-bottom:10px;}#yiv5732912495 #yiv5732912495ygrp-msg p a {font-family:Verdana;}#yiv5732912495 #yiv5732912495ygrp-msg p#yiv5732912495attach-count span {color:#1E66AE;font-weight:700;}#yiv5732912495 #yiv5732912495ygrp-reco #yiv5732912495reco-head {color:#ff7900;font-weight:700;}#yiv5732912495 #yiv5732912495ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5732912495 #yiv5732912495ygrp-sponsor #yiv5732912495ov li a {font-size:130%;text-decoration:none;}#yiv5732912495 #yiv5732912495ygrp-sponsor #yiv5732912495ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5732912495 #yiv5732912495ygrp-sponsor #yiv5732912495ov ul {margin:0;padding:0 0 0 8px;}#yiv5732912495 #yiv5732912495ygrp-text {font-family:Georgia;}#yiv5732912495 #yiv5732912495ygrp-text p {margin:0 0 1em 0;}#yiv5732912495 #yiv5732912495ygrp-text tt {font-size:120%;}#yiv5732912495 #yiv5732912495ygrp-vital ul li:last-child {border-right:none !important;}#yiv5732912495

Sat May 28, 2016 10:20 am (PDT) . Posted by:

"Chuck Grablewski" cgrablew

Randy

I have Excel 2016 & I don't see your macros assigned to tool bar
buttons. Is there a trick to making them visible?

Also are fields 849 & 13888 no longer available from Zacks?

Thanks,

Chuck Grablewski

On Sun, Apr 17, 2016 at 5:21 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> The keyboard shortcut probably disappeared because I don't use it any
> longer. But you can just reassign that keyboard shortcut to the macro.
>
> I have the macros assigned to toolbar buttons.
>
> Also, if you bring up the context menu with a right mouse click, there is
> an "SMF" section there. One of the options there links to the
> smfUpdateDownloadTable macro.
>
> On Sun, Apr 17, 2016 at 2:53 PM, Chuck Grablewski cgrablew@... wrote:
>
>>
>> I just replaced all the txt files & the xla file with the most current
>> version of the addin. With the new xla file the Table Load macro doesn't
>> work.I used to hit CTL+SHIFT+J to invoke the 2 dimensional table load. If
>> I put back the old xla file, then it works. Any ideas of what is going on?
>>
>>
>>
>
>

Sat May 28, 2016 11:02 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Assigning macros to toolbar buttons would be a manual process you need to
do.

Element #849 is obsolete, since Zacks made it a subscriber only item.
Element #13888 works fine here. Maybe you need the update to Zacks elements
definitions on the smf-elements-6.txt file?

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

Because of a change by Zacks, all of their URLs had to be changed from
"http://" to "https://"...

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

On Sat, May 28, 2016 at 10:20 AM, Chuck Grablewski cgrablew@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
> I have Excel 2016 & I don't see your macros assigned to tool bar
> buttons. Is there a trick to making them visible?
>
> Also are fields 849 & 13888 no longer available from Zacks?
>
>
>

Sat May 28, 2016 10:52 am (PDT) . Posted by:

sjagers

Is RCHgetelement number 850 (zack's website?) not working today? I keep getting an Error in the cell, today, but it worked a week ago.


Sat May 28, 2016 10:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried it with MMM and it's working fine here...

You probably just need the updated element definitions for Zacks, in the
smf-elements-6.txt file. See:

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

I had to change them because the website changed from "http://" to "https://"
URLs.

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

On Sat, May 28, 2016 at 10:52 AM, sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is RCHgetelement number 850 (zack's website?) not working today? I keep
> getting an Error in the cell, today, but it worked a week ago.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar