Minggu, 21 Februari 2016

[smf_addin] Digest Number 3644

9 Messages

Digest #3644
1a
1b
Re: M&A analysis? by "Randy Harmelink" rharmelink
1c
2a
Re: Excel 2010 by cancerfixer
2b
Re: Excel 2010 by cancerfixer
2c
Re: Excel 2010 by "Randy Harmelink" rharmelink
2d
Re: Excel 2010 by cancerfixer
3.1
3.2
Re: Problem with RCHGetYahooHistory by "Craig Passow" passow

Messages

Fri Feb 19, 2016 6:49 am (PST) . Posted by:

jharlan

Thanks Randy. What about a corporate analysis template then? Thanks,

Fri Feb 19, 2016 10:18 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I pretty much just make templates that are examples of using the add-in
functions.

For that type of thing, you could browse through what's in the "Uploaded by
Members" folder in the FILES area of the Yahoo Group.

On Fri, Feb 19, 2016 at 7:49 AM, jharlan@... wrote:

>
> Thanks Randy. What about a corporate analysis template then? Thanks,
>
>

Fri Feb 19, 2016 12:07 pm (PST) . Posted by:

jharlan

great starting point. thank you sir,

Fri Feb 19, 2016 12:27 pm (PST) . Posted by:

cancerfixer

Randy:

I hate to bug you with this. I have been re-writing macros to incorporate your smf's, which run MUCH faster than my old api routines. But the data does not refresh as desired when the macros run on a schedule (about once an hour). Data is correct if I force recalculation manually by exiting & re-entering, or running smfForceRecalculation, but I am unable to get the smfForceRecalculation macro to run inside my VBA code.


I am able to see the macro inside the RCH_Stock_Market_Functions in the VBA project window (it's in the "modutilities" module). By clicking inside this subroutine and pressing F5 I can get it to run without incident, and it works. But if I try to Call it from within my project with the command line "Call smfForceRecalculation", I get an error ("Compile Error: Sub of function not defined"). Similarly, it won't run if I assign it as a macro attached to an object on the spreadsheet.


I have set the trust center to "Trust access to VBA project model". This setting is consistently correct.


I am running Excel 2010 on a Dell XPS machine under Windows 10. I use Chrome. I have tried to get the internet options to "check for newer versions of stored pages" every time I visit the webpage - but every time I set it this way and "apply" it, it returns to "automatically" the next time I look at it. This setting just refuses to stick for me. Don't know why.



Any suggestions on how I can get the sub to run from within my VBA code?

Fri Feb 19, 2016 1:23 pm (PST) . Posted by:

cancerfixer

Correction: When I assign "smfForceRecalculation" as a macro to run when clicking on a chart or shape it DOES execute properly. The problem is that i want it to run within a VBA macro without the need for user intervention.

Fri Feb 19, 2016 3:37 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It works fine here. Just take a look at the example workbook on the website:

RCHGetYahooQuotes-Example-Timed-Update.xls

It has native VBA code that uses the add-in, and it does a "Call
smfForceRecalculation" right in it. That's what is doing the "timed update"
in the workbook.

You do have the add-in set up as a reference library in your VBA project,
right?

On Fri, Feb 19, 2016 at 1:27 PM, cancerfixer@... wrote:

>
> I hate to bug you with this. I have been re-writing macros to incorporate
> your smf's, which run MUCH faster than my old api routines. But the data
> does not refresh as desired when the macros run on a schedule (about once
> an hour). Data is correct if I force recalculation manually by exiting &
> re-entering, or running smfForceRecalculation, but I am unable to get the
> smfForceRecalculation macro to run inside my VBA code.
>
> I am able to see the macro inside the RCH_Stock_Market_Functions in the
> VBA project window (it's in the "modutilities" module). By clicking inside
> this subroutine and pressing F5 I can get it to run without incident, and
> it works. But if I try to Call it from within my project with the command
> line "Call smfForceRecalculation", I get an error ("Compile Error: Sub of
> function not defined"). Similarly, it won't run if I assign it as a macro
> attached to an object on the spreadsheet.
>
> I have set the trust center to "Trust access to VBA project model". This
> setting is consistently correct.
>
> I am running Excel 2010 on a Dell XPS machine under Windows 10. I use
> Chrome. I have tried to get the internet options to "check for newer
> versions of stored pages" every time I visit the webpage - but every time I
> set it this way and "apply" it, it returns to "automatically" the next time
> I look at it. This setting just refuses to stick for me. Don't know why.
>
> Any suggestions on how I can get the sub to run from within my VBA code?
>
>

On Fri, Feb 19, 2016 at 2:23 PM, cancerfixer@... wrote:

>
> Correction: When I assign "smfForceRecalculation" as a macro to run when
> clicking on a chart or shape it DOES execute properly. The problem is that
> i want it to run within a VBA macro without the need for user intervention.
>
>

Fri Feb 19, 2016 5:10 pm (PST) . Posted by:

cancerfixer

Ooops. NOT set up as a reference library! Thanks. I figured it out. Yes, you MUST set up the RCH-Stock_Market_Functions add-in as a reference library. This somehow had been overlooked during initial setup many months ago. For those having this problem, here is a link:

http://excel-macro.tutorialhorizon.com/vba-excel-reference-libraries-in-excel-workbook/

1) open to the VBA Editor in Excel (Alt-F11)
2) click on the Tools menu at the top and select "References..."
3) the Ref­er­ences– VBAPro­ject" dia­log will appear
4) Search for the RCH stock market functions in the list and check the box in front of it
5) click OK and you are good to go


any invocation of a macro within the RCH VBA modules can now be called within your VBA code like any other subroutine.


I already have timed routines set up in my spreadsheet that runs my updates every hour (or a user configurable interval within a time range). When these price updates run, I run the smfForceRecalculation macro first so I always get a fresh quote and not something from the page memory.

Sat Feb 20, 2016 3:17 pm (PST) . Posted by:

"Yahoo!" lewglenn

Did this but it didn't seem to help, but thanks anyway.
One odd thing though. On the namebench output there are a number of comments: "www.google.com is hijacked,...". (see the url: file:///c:/users/lewglenn/appdata/local/temp/namebench_2016-02-20_1452.html). Any idea what that means?


On Sunday, February 14, 2016 8:16 AM, "peterscottcook@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  You might also want to try changing your router's DNS settings. I switched from my ISP's default DNS server to a much faster one, and some of my lookups (and most of my web browsing) sped up significantly.
You can run Namebench to find the fastest DNS servers. https://code.google.com/archive/p/namebench/  #yiv0240150202 #yiv0240150202 -- #yiv0240150202ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0240150202 #yiv0240150202ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0240150202 #yiv0240150202ygrp-mkp #yiv0240150202hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0240150202 #yiv0240150202ygrp-mkp #yiv0240150202ads {margin-bottom:10px;}#yiv0240150202 #yiv0240150202ygrp-mkp .yiv0240150202ad {padding:0 0;}#yiv0240150202 #yiv0240150202ygrp-mkp .yiv0240150202ad p {margin:0;}#yiv0240150202 #yiv0240150202ygrp-mkp .yiv0240150202ad a {color:#0000ff;text-decoration:none;}#yiv0240150202 #yiv0240150202ygrp-sponsor #yiv0240150202ygrp-lc {font-family:Arial;}#yiv0240150202 #yiv0240150202ygrp-sponsor #yiv0240150202ygrp-lc #yiv0240150202hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0240150202 #yiv0240150202ygrp-sponsor #yiv0240150202ygrp-lc .yiv0240150202ad {margin-bottom:10px;padding:0 0;}#yiv0240150202 #yiv0240150202actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0240150202 #yiv0240150202activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0240150202 #yiv0240150202activity span {font-weight:700;}#yiv0240150202 #yiv0240150202activity span:first-child {text-transform:uppercase;}#yiv0240150202 #yiv0240150202activity span a {color:#5085b6;text-decoration:none;}#yiv0240150202 #yiv0240150202activity span span {color:#ff7900;}#yiv0240150202 #yiv0240150202activity span .yiv0240150202underline {text-decoration:underline;}#yiv0240150202 .yiv0240150202attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0240150202 .yiv0240150202attach div a {text-decoration:none;}#yiv0240150202 .yiv0240150202attach img {border:none;padding-right:5px;}#yiv0240150202 .yiv0240150202attach label {display:block;margin-bottom:5px;}#yiv0240150202 .yiv0240150202attach label a {text-decoration:none;}#yiv0240150202 blockquote {margin:0 0 0 4px;}#yiv0240150202 .yiv0240150202bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0240150202 .yiv0240150202bold a {text-decoration:none;}#yiv0240150202 dd.yiv0240150202last p a {font-family:Verdana;font-weight:700;}#yiv0240150202 dd.yiv0240150202last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0240150202 dd.yiv0240150202last p span.yiv0240150202yshortcuts {margin-right:0;}#yiv0240150202 div.yiv0240150202attach-table div div a {text-decoration:none;}#yiv0240150202 div.yiv0240150202attach-table {width:400px;}#yiv0240150202 div.yiv0240150202file-title a, #yiv0240150202 div.yiv0240150202file-title a:active, #yiv0240150202 div.yiv0240150202file-title a:hover, #yiv0240150202 div.yiv0240150202file-title a:visited {text-decoration:none;}#yiv0240150202 div.yiv0240150202photo-title a, #yiv0240150202 div.yiv0240150202photo-title a:active, #yiv0240150202 div.yiv0240150202photo-title a:hover, #yiv0240150202 div.yiv0240150202photo-title a:visited {text-decoration:none;}#yiv0240150202 div#yiv0240150202ygrp-mlmsg #yiv0240150202ygrp-msg p a span.yiv0240150202yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0240150202 .yiv0240150202green {color:#628c2a;}#yiv0240150202 .yiv0240150202MsoNormal {margin:0 0 0 0;}#yiv0240150202 o {font-size:0;}#yiv0240150202 #yiv0240150202photos div {float:left;width:72px;}#yiv0240150202 #yiv0240150202photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0240150202 #yiv0240150202photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0240150202 #yiv0240150202reco-category {font-size:77%;}#yiv0240150202 #yiv0240150202reco-desc {font-size:77%;}#yiv0240150202 .yiv0240150202replbq {margin:4px;}#yiv0240150202 #yiv0240150202ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0240150202 #yiv0240150202ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0240150202 #yiv0240150202ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0240150202 #yiv0240150202ygrp-mlmsg select, #yiv0240150202 input, #yiv0240150202 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0240150202 #yiv0240150202ygrp-mlmsg pre, #yiv0240150202 code {font:115% monospace;}#yiv0240150202 #yiv0240150202ygrp-mlmsg * {line-height:1.22em;}#yiv0240150202 #yiv0240150202ygrp-mlmsg #yiv0240150202logo {padding-bottom:10px;}#yiv0240150202 #yiv0240150202ygrp-msg p a {font-family:Verdana;}#yiv0240150202 #yiv0240150202ygrp-msg p#yiv0240150202attach-count span {color:#1E66AE;font-weight:700;}#yiv0240150202 #yiv0240150202ygrp-reco #yiv0240150202reco-head {color:#ff7900;font-weight:700;}#yiv0240150202 #yiv0240150202ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0240150202 #yiv0240150202ygrp-sponsor #yiv0240150202ov li a {font-size:130%;text-decoration:none;}#yiv0240150202 #yiv0240150202ygrp-sponsor #yiv0240150202ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0240150202 #yiv0240150202ygrp-sponsor #yiv0240150202ov ul {margin:0;padding:0 0 0 8px;}#yiv0240150202 #yiv0240150202ygrp-text {font-family:Georgia;}#yiv0240150202 #yiv0240150202ygrp-text p {margin:0 0 1em 0;}#yiv0240150202 #yiv0240150202ygrp-text tt {font-size:120%;}#yiv0240150202 #yiv0240150202ygrp-vital ul li:last-child {border-right:none !important;}#yiv0240150202

Sat Feb 20, 2016 3:36 pm (PST) . Posted by:

"Craig Passow" passow

Click on the link in the report for the explanation:

*What does "NXDOMAIN hijacking" mean?*

It means that the DNS server falsifies the
result when a non-existent host is requested.
This is usually used so that the DNS provider
can place advertising when you make a typo when
typing in a URL.

On 2/20/2016 5:17 PM, Yahoo! lewglenn@yahoo.com [smf_addin] wrote:
> Did this but it didn't seem to help, but thanks anyway.
>
> One odd thing though. On the namebench output there are a number of
> comments: "www.google.com is hijacked,...". (see the url:
> file:///c:/users/lewglenn/appdata/local/temp/namebench_2016-02-20_1452.html).
> Any idea what that means?
>
>
> On Sunday, February 14, 2016 8:16 AM, "peterscottcook@gmail.com
> [smf_addin]" <smf_addin@yahoogroups.com> wrote:
>
>
> You might also want to try changing your router's DNS settings. I
> switched from my ISP's default DNS server to a much faster one, and
> some of my lookups (and most of my web browsing) sped up significantly.
>
> You can run Namebench to find the fastest DNS servers.
> https://code.google.com/archive/p/namebench/
>
>
>

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

Tidak ada komentar:

Poskan Komentar