5 Messages
Digest #3713
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
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-
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?
>>
>>
>>
>
>
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
> smfUpdateDownloadTa
>
> 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?
>
>
>
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.
>
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:
Posting Komentar