6 Messages
Digest #3559
2b
Re: how do I refresh/update a spreadsheet with smf data..I forgot ho by "Randy Harmelink" rharmelink
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
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.
>
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
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?
>
>
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.
>
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:
Posting Komentar