[smf_addin] Digest Number 4568

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #4568

1a

Re: Marketscreener by "Randy Harmelink" rharmelink

1b

Re: Marketscreener by lawrence.leesh

2a

Marketscreener Company Page by lawrence.leesh

2b

Re: Marketscreener Company Page by "Randy Harmelink" rharmelink

2c

Re: Marketscreener Company Page by lawrence.leesh

Messages

1a

Re: Marketscreener

Tue Jul 2, 2019 11:26 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("
https://www.marketscreener.com/BAJAJ-AUTO-9059975/financials/","td",1,
"Fiscal Period",,,,1)

On Tue, Jul 2, 2019 at 3:24 AM lawrence.leesh@... wrote:

> Could you pls help me with the formula to extract "2017" from this page
>
> https://www.marketscreener.com/BAJAJ-AUTO-9059975/financials/
>
> after "Fiscal Period March"?
>
>
>

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

1b

Re: Marketscreener

Tue Jul 2, 2019 1:23 pm (PDT) . Posted by:

lawrence.leesh

Thanks Randy.

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

2a

Marketscreener Company Page

Tue Jul 2, 2019 4:22 pm (PDT) . Posted by:

lawrence.leesh

Hi Randy


Could you pls help me with the formula to get "Online stores" in https://www.marketscreener.com/AMAZON-COM-12864605/company/ https://www.marketscreener.com/AMAZON-COM-12864605/company/


thanks

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

2b

Re: Marketscreener Company Page

Tue Jul 2, 2019 4:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You mean this?

=RCHGetTableCell("
https://www.marketscreener.com/AMAZON-COM-12864605/company/
",1,">Delta",,,,2)

.... or you could get the whole table by array-entering this over a range:

=RCHGetHTMLTable("
https://www.marketscreener.com/AMAZON-COM-12864605/company/",">Delta")

....or get a particular row and column of that table with:

=INDEX(RCHGetHTMLTable("
https://www.marketscreener.com/AMAZON-COM-12864605/company/
",">Delta",,,,,10,10),3,1)

On Tue, Jul 2, 2019 at 4:22 PM lawrence.leesh@... wrote:

> Could you pls help me with the formula to get "Online stores" in
> https://www.marketscreener.com/AMAZON-COM-12864605/company/
>

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

2c

Re: Marketscreener Company Page

Tue Jul 2, 2019 6:05 pm (PDT) . Posted by:

lawrence.leesh

Yes, thanks a lot.

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

• Privacy • Unsubscribe • Terms of Use