[smf_addin] Digest Number 4346

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #4346

1a

Randy, what SMF formulae do I use to get these values shown? by zbgb952

1b

Re: Randy, what SMF formulae do I use to get these values shown? by "Randy Harmelink" rharmelink

1c

Re: Randy, what SMF formulae do I use to get these values shown? by zbgb952

1d

Re: Randy, what SMF formulae do I use to get these values shown? by "Randy Harmelink" rharmelink

Messages

1a

Randy, what SMF formulae do I use to get these values shown?

Mon Jun 25, 2018 2:27 pm (PDT) . Posted by:

zbgb952

Hello Randy, it has been awhile since I've used SMF.


Can you please show me the formulae I need to put into Excel to get the following values


At the website? :


https://quotes.freerealtime.com/stock-scouter?title=AAPL https://quotes.freerealtime.com/stock-scouter?title=AAPL




1. Stockscouter Score which is currently 7 as I send this but it may change in a few days


2. The CORE Model Grades at the bottom right side of the webpage including, Fundamental, Ownership, Valuation and Technical.


Thanks Randy

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

1b

Re: Randy, what SMF formulae do I use to get these values shown?

Mon Jun 25, 2018 3:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("https://quotes.freerealtime.com/stock-scouter?title=AAPL
","div",-1,"class=""final-score""",,,,1)
=smfGetTagContent("https://quotes.freerealtime.com/stock-scouter?title=AAPL
","div",1,">Fundamental")
=smfGetTagContent("https://quotes.freerealtime.com/stock-scouter?title=AAPL
","div",1,">Ownership")
=smfGetTagContent("https://quotes.freerealtime.com/stock-scouter?title=AAPL
","div",1,">Valuation")
=smfGetTagContent("https://quotes.freerealtime.com/stock-scouter?title=AAPL
","div",1,">Technical")

Those data items are now also available using the RCHGetElementNumber()
function. See:

https://smf-add-in.blogspot.com/2018/06/alert-restored-stockscouter-element..html

On Mon, Jun 25, 2018 at 2:27 PM, mb0329@
​...
wrote:

>
> Hello Randy, it has been awhile since I've used SMF.
>
> Can you please show me the formulae I need to put into Excel to get the
> following values
>
> At the website? :
>
> https://quotes.freerealtime.com/stock-scouter?title=AAPL
>
> 1. Stockscouter Score which is currently 7 as I send this but it may
> change in a few days
>
> 2. The CORE Model Grades at the bottom right side of the webpage
> including, Fundamental, Ownership, Valuation and Technical.
>
>
>

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

1c

Re: Randy, what SMF formulae do I use to get these values shown?

Mon Jun 25, 2018 9:36 pm (PDT) . Posted by:

zbgb952

Thank you Randy.


Randy, I tried using =RCHGetElementNumber("aapl", 543) in my spreadsheet which you suggest and which would work great if I could get it to work but I got back "Obsolete";. Why is this? Do I need to change/update anything on my end and if so, where, how? Thanks.

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

1d

Re: Randy, what SMF formulae do I use to get these values shown?

Tue Jun 26, 2018 12:15 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You would replace your current smf-elements-1.txt file with the new one I
put up on the add-in website.

You should exit EXCEL before doing so.

You can check the element definition with:

=RCHGetElementNumber("definition", 543)

Mine is:

Scouter;StockScouter Rating -- Current;=smfGetTagContent("
https://quotes.freerealtime.com/stock-scouter?title=~~~~~
","div",-1,"class=""final-score""",,,,1)

On Mon, Jun 25, 2018 at 9:36 PM, mb0329@
​...
wrote:

>
> Randy, I tried using =
> ​​
> RCHGetElementNumber("aapl";, 543) in my spreadsheet which you suggest and
> which would work great if I could get it to work but I got back
> "Obsolete";. Why is this? Do I need to change/update anything on my end and
> if so, where, how? Thanks.
>
>

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 4

• Privacy • Unsubscribe • Terms of Use