Senin, 16 November 2015

[smf_addin] Digest Number 3559

6 Messages

Digest #3559

Messages

Sun Nov 15, 2015 2:15 pm (PST) . Posted by:

mff2805

Hi,
I can't seen to get the IBD template working, yet the website seems unchanged. Any ideas? does it work for you.?
I'm looged in with a cookie, all that stuff.
thanks,
Mike


Sun Nov 15, 2015 4:45 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I can't update my website (and thus the template) right now, but the change
that needs to be made is in cell B3:

=smfStrExtr(RCHGetWebData("
http://www.investors.com/search/searchresults.aspx?Ntt=
"&B2,"/stock-quotes/"),"/stock-quotes/",".htm")

I just changed both "/quotes/" strings to be "/stock-quotes/"...

Unfortunately, that will mean the element numbers can't be updated, since
many were already at the maximum length the formulas could be. This change
would need them to be 12 bytes longer. I may have to think about it a while.

On Sun, Nov 15, 2015 at 3:15 PM, mff3429@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I can't seen to get the IBD template working, yet the website seems
> unchanged. Any ideas? does it work for you.?
> I'm looged in with a cookie, all that stuff.
>

Sun Nov 15, 2015 8:36 pm (PST) . Posted by:

mff2805

thanks,
it's now working for me.
question. is there a way to pull in to the template the IPO date and a couple of other pieces of info that are on the stock quotes and news page? would that be a different web page lookup?

Mike

Sun Nov 15, 2015 8:55 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Those would be a different web page lookups...

On Sun, Nov 15, 2015 at 9:36 PM, mff3429@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> it's now working for me.
> question. is there a way to pull in to the template the IPO date and a
> couple of other pieces of info that are on the stock quotes and news page?
> would that be a different web page lookup?
>
>

Sun Nov 15, 2015 4:16 pm (PST) . Posted by:

zbgb952


If I want to update a spreadsheet with smf data, how do I do this? I forgot since it has been awhile since I've done this. I vaguely remember clicking on alt-f8...but I forgot the function to type in to do this. Can someone (Randy) remind me how? Thanks.

Sun Nov 15, 2015 4:46 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You need to run the smfForceRecalculation macro. I have it assigned to a
button on my toolbar.

On Sun, Nov 15, 2015 at 5:16 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> If I want to update a spreadsheet with smf data, how do I do this? I
> forgot since it has been awhile since I've done this. I vaguely remember
> clicking on alt-f8...but I forgot the function to type in to do this. Can
> someone (Randy) remind me how? Thanks.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar