[smf_addin] Digest Number 4647

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #4647

1a

GuruFocus Term pages into EXCEL by farris_justin

1b

Re: GuruFocus Term pages into EXCEL by "Randy Harmelink" rharmelink

Messages

1a

GuruFocus Term pages into EXCEL

Wed Nov 20, 2019 12:30 pm (PST) . Posted by:

farris_justin

Is there a way to use a formula to pull the scores from the following webpage sources??


https://www.gurufocus.com/term/zscore/NAS:AAPL/Altman-Z-Score/Apple https://www.gurufocus.com/term/zscore/NAS:AAPL/Altman-Z-Score/Apple



https://www.gurufocus.com/term/fscore/NAS:AAPL/Piotroski-F-Score/Apple https://www.gurufocus.com/term/fscore/NAS:AAPL/Piotroski-F-Score/Apple

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

1b

Re: GuruFocus Term pages into EXCEL

Wed Nov 20, 2019 2:46 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yup. But if you want the current values, it would be more efficient to pull
both from the summary page:

https://www.gurufocus.com/stock/AAPL/summary

For example:

=smfGetTagContent("https://www.gurufocus.com/stock/AAPL/summary
","td",1,">Piotroski",,,,1)
=smfStrExtr(smfGetTagContent("
https://www.gurufocus.com/term/zscore/AAPL/Altman-Z-Score","font",-1,"(As
of Today)"),":","(",1)
=smfStrExtr(smfGetTagContent("
https://www.gurufocus.com/term/fscore/AAPL/Piotroski-F-Score","font",-1,"(As
of Today)"),":","(",1)

On Wed, Nov 20, 2019 at 1:30 PM farris_justin@... wrote:

>
> Is there a way to use a formula to pull the scores from the following
> webpage sources??
>
> https://www.gurufocus.com/term/zscore/NAS:AAPL/Altman-Z-Score/Apple
>
> https://www.gurufocus.com/term/fscore/NAS:AAPL/Piotroski-F-Score/Apple
>
>
>
>

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use