[smf_addin] Digest Number 3616

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3616

1a

Investors.com Website Revamp by yolande_tulasse

1b

Re: Investors.com Website Revamp by yolande_tulasse

1c

Re: Investors.com Website Revamp by "Randy Harmelink" rharmelink

Messages

1a

Investors.com Website Revamp

Sun Jan 24, 2016 5:49 pm (PST) . Posted by:

yolande_tulasse

Looks like IBD have revamped their website. Can't get the stock checkup results anymore.

Thank you.

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1b

Re: Investors.com Website Revamp

Sun Jan 24, 2016 6:13 pm (PST) . Posted by:

yolande_tulasse

Looks like all there was to change was too replace "www.investors.com" by "myibd.investors.com" in the following:

=smfstrExtr(RCHGetWebData("http://www.investors.com/search/searchresults.aspx?Ntt="&A7,"/stock-quotes/"),"/stock-quotes/","'")

=>

=smfstrExtr(RCHGetWebData("http://myibd.investors.com/search/searchresults.aspx?Ntt="&A7,"/stock-quotes/"),"/stock-quotes/","'")

Working like a charm now :-)

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1c

Re: Investors.com Website Revamp

Sun Jan 24, 2016 6:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Both templates are still working fine, because that portion of the formulas
was removed...

It gets the stock exchange for the URL to get to the company data, but I
discovered the exchange was irrelevant and just replaced it with a
hard-coded "xxxx".

On Sun, Jan 24, 2016 at 7:13 PM, yolande_tulasse@... wrote:

>
> Looks like all there was to change was too replace "www.investors.com" by
> "myibd.investors.com" in the following:
>
> =smfstrExtr(RCHGetWebData("
> http://www.investors.com/search/searchresults.aspx?Ntt=
> "&A7,"/stock-quotes/"),"/stock-quotes/","'")
>
> =>
>
> =smfstrExtr(RCHGetWebData("
> http://myibd.investors.com/search/searchresults.aspx?Ntt=
> "&A7,"/stock-quotes/"),"/stock-quotes/","'")
>
> Working like a charm now :-)
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

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

Visit Your Group

• New Members 20

• Privacy • Unsubscribe • Terms of Use