[smf_addin] Digest Number 4461

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #4461

1a

Re: How to get mutual fund MER value by crollalanzaws

2a

somethin worked, now it doesn't.  same compter, etc.  any thoughts by mff2805

2b

Re: somethin worked, now it doesn't. same compter, etc. any thoughts by "Randy Harmelink" rharmelink

2c

Re: somethin worked, now it doesn't. same compter, etc. any thoughts by mff2805

2d

Re: somethin worked, now it doesn't. same compter, etc. any thoughts by "Randy Harmelink" rharmelink

Messages

1a

Re: How to get mutual fund MER value

Tue Jan 15, 2019 5:48 pm (PST) . Posted by:

crollalanzaws

Thank you. Yes, that worked.

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

2a

somethin worked, now it doesn't.  same compter, etc.  any thoughts

Tue Jan 15, 2019 7:24 pm (PST) . Posted by:

mff2805

Hello Randy,
I used to be able to get stock names and recommendations with these two functions.


smfstrExtr(smfGetTagContent("https://navelliergrowth.com/portfolio-grader/stock-report.html?q=~~~~~&submit=submit&type=site","h3",-1,"Recent News:")&"|", " News: ", "|")



and
smfstrExtr(smfGetTagContent("https://navelliergrowth.com/portfolio-grader/stock-report.html?q=~~~~~&submit=submit&type=site","tr",-1,"Rating:")&"|", "Rating:</strong> ", "</td>")



but now they are not working.


i even canged navelliergrowth.com to navelliergrowth.investorplace.com.


Any thoughts on how to b=get this workingagain?




thanks, Mike

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

2b

Re: somethin worked, now it doesn't. same compter, etc. any thoughts

Tue Jan 15, 2019 9:58 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Are you logged in via the EXCEL IE object (alt+d+d+w)? I can't look at the
web page because it requires a login.

On Tue, Jan 15, 2019 at 8:27 PM mff3429@... wrote:

> I used to be able to get stock names and recommendations with these two
> functions.
>
> smfstrExtr(smfGetTagContent("
> https://navelliergrowth.com/portfolio-grader/stock-report.html?q=~~~~~&submit=submit&type=site","h3",-1,"Recent
> News:")&"|", " News: ", "|")
>
> and
>
> smfstrExtr(smfGetTagContent("
> https://navelliergrowth.com/portfolio-grader/stock-report.html?q=~~~~~&submit=submit&type=site","tr",-1,"Rating:")&"|",
> "Rating:</strong> ", "</td>")
>
> but now they are not working.
>
> i even canged navelliergrowth.com to navelliergrowth.investorplace.com.
>
> Any thoughts on how to b=get this workingagain?
>
>
>

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

2c

Re: somethin worked, now it doesn't. same compter, etc. any thoughts

Tue Jan 15, 2019 10:11 pm (PST) . Posted by:

mff2805

yes, i logged in, but right after i got a page, excel froze and i had to end task. typically, i thought that was good enough to get a cookie. i use excel 2010.

sthe service is free, so perhaps you could create yourself an account :)

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

2d

Re: somethin worked, now it doesn't. same compter, etc. any thoughts

Tue Jan 15, 2019 11:30 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

That's one of the worst registration processes I've ever been through. Ugh.

In any case, this works fine for me:

=smfstrExtr(smfGetTagContent("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report?q=MMM
","h2",1,"class=""company_box";""),"~","(")

On Tue, Jan 15, 2019 at 11:11 PM mff3429@... wrote:

>
> yes, i logged in, but right after i got a page, excel froze and i had to
> end task. typically, i thought that was good enough to get a cookie. i use
> excel 2010.
>
> sthe service is free, so perhaps you could create yourself an account :)
>
>
>

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

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

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use