Sabtu, 01 Juni 2019

[smf_addin] Digest Number 4549

8 Messages

Digest #4549

Messages

Fri May 31, 2019 8:03 am (PDT) . Posted by:

gz_cp



I installed a fresh copy of Windows 7 Pro SP1, but SMF didn't work under the IE 8 that came with it.


I am going to update IE, but the latest IE is very large.


What is the lowest version of IE that can make SMF work? I want to get the smallest package possible because my hard drive is very small.



Thanks.




Fri May 31, 2019 11:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That all depends on the website, not the add-in. Some websites don't
support older versions of IE, so they check the version and give an error
message if you're using an old version. That's completely out of the
add-in's control.

On Fri, May 31, 2019 at 8:18 AM gz_cp@... wrote:

> I installed a fresh copy of Windows 7 Pro SP1, but SMF didn't work under
> the IE 8 that came with it.
>
> I am going to update IE, but the latest IE is very large.
>
> What is the lowest version of IE that can make SMF work? I want to get the
> smallest package possible because my hard drive is very small.
>
>
>

Fri May 31, 2019 11:30 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The data isn't delivered on the web page, but is built dynamically using
JavaScript data within the page, so you need to extract it from there. Same
JavaScript data on both web pages, so the extraction is similar other than
URL:

=smfStrExtr(RCHGetWebData("
https://seekingalpha.com/symbol/AAPL/dividends/scorecard
","""growth_data"""),"""dividend_growth"":",",",1)

=smfStrExtr(RCHGetWebData("
https://seekingalpha.com/symbol/AAPL/dividends/dividend-growth
","""growth_data"""),"""dividend_growth"":",",",1)

On Thu, May 30, 2019 at 11:05 PM tmallen2@... wrote:

> I'm having trouble getting the "Dividend Growth" years from this URL:
>
> https://seekingalpha.com/symbol/AAPL/dividends/scorecard
>
> The answer should be 6 Years.
>
> Or this URL:
>
> https://seekingalpha.com/symbol/AAPL/dividends/dividend-growth
>
> "Years of Growth" should be 6.
>
> Either page would be fine as the data number I am looking for is the same.
>
> Is it possible? I can't figure this one out.
>
>
>

Fri May 31, 2019 2:02 pm (PDT) . Posted by:

ridgebacksexcel

Thanks Randy.


I ran a few queries and about half of them work and half don't.


For example this works fine:


=smfStrExtr(RCHGetWebData("https://seekingalpha.com/symbol/AAPL/dividends/dividend-growth https://seekingalpha.com/symbol/AAPL/dividends/dividend-growth","""growth_data"""),"""dividend_growth"":",",",1)


The answer shows 6.


This shows a blank cell:


=smfStrExtr(RCHGetWebData("https://seekingalpha.com/symbol/JNJ/dividends/dividend-growth https://seekingalpha.com/symbol/AAPL/dividends/dividend-growth","""growth_data";""),"""dividend_growth"":",",",1)



The answer should be 57.


I see where on the source page you are trying to extract the data but playing around with the formula has not worked so far to get JNJ or the other queries to work. Perhaps a small detail is missing.






Fri May 31, 2019 9:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The formula returns 57 for me when I use it...

Try it with just the RCHGetWebData() portion, to see if that is showing up.
Did you do a lot of them? It could be the Seeking Alpha website restricts
usage?

On Fri, May 31, 2019 at 3:45 PM tmallen2@... wrote:

>
> I ran a few queries and about half of them work and half don't.
>
> For example this works fine:
>
> =smfStrExtr(RCHGetWebData("
> https://seekingalpha.com/symbol/AAPL/dividends/dividend-growth
> ","""growth_data"""),"""dividend_growth"":",",",1)
>
> The answer shows 6.
>
> This shows a blank cell:
>
> =smfStrExtr(RCHGetWebData("
> https://seekingalpha.com/symbol/JNJ/dividends/dividend-growth
> <https://seekingalpha.com/symbol/AAPL/dividends/dividend-growth>
> ","""growth_data";""),"""dividend_growth"":",",",1)
>
> The answer should be 57.
>
> I see where on the source page you are trying to extract the data but
> playing around with the formula has not worked so far to get JNJ or the
> other queries to work. Perhaps a small detail is missing.
>
>

Fri May 31, 2019 11:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Check the page that gave you that link, then extract the URL from that web
page. Hopefully, it uses a ticker symbol?

On Thu, May 30, 2019 at 11:29 PM tmallen2@... wrote:

> I'm also trying to extract a Credit Rating from Morningstar.
>
> I can use the RCHGetTableCell function to get the credit rating from this
> URL:
>
>
> https://ratingagency.morningstar.com/MCR/ratings-surveillance/transaction-detail-corporate/d0JvWmRKSTVJU2VKWmZYVHBMJTJiYVA3ZFB6dkJ6U09FVTNkZjNWYVVxck85U2wlMmYwMW53Qm9zdyUzZCUzZA%3d%3d
>
> The problem is I have no way to reference the ticker AAPL that it refers
> to. Maybe its encoded on purpose.
>
> The Credit Rating should be: AA-
>
>
>

Fri May 31, 2019 12:31 pm (PDT) . Posted by:

ridgebacksexcel

I don't think there is any URL on the source code that links to AAPL. It looks like an encoded link.


Thanks. This one may be impossible to get to work.


Do you know any other way to look up a Company credit rating that is a free source and works with the SMF Add-in?

Fri May 31, 2019 9:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't do anything with credit ratings, so not even sure of sources. I do
recall doing a formula before though, which is why I suggested looking
through the group's archives...

On Fri, May 31, 2019 at 1:45 PM tmallen2@... wrote:

>
> I don't think there is any URL on the source code that links to AAPL. It
> looks like an encoded link.
>
> Thanks. This one may be impossible to get to work.
>
> Do you know any other way to look up a Company credit rating that is a
> free source and works with the SMF Add-in?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 06.47

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)