Sabtu, 02 November 2019

[smf_addin] Digest Number 4641

9 Messages

Digest #4641
1b
Re: smfGetTagContent on Windows 10 Error by "Randy Harmelink" rharmelink
2a
Yahoo Profile page by joelfp2000
2b
Re: Yahoo Profile page by "Randy Harmelink" rharmelink
2c
3a
groups.io by "George Warriner" georgeawarriner
3b
Re: groups.io by "Randy Harmelink" rharmelink

Messages

Fri Nov 1, 2019 9:09 am (PDT) . Posted by:

tzewei_79

Hi,


I used to be able to do the following on window 7, excel 2013. I just changed to a new machine with windows 10 and excel 2019 and I got the following output. Is there some incompatible issue with excel 2013 or I need to add more stuffs for excel 2013?


=smfGetTagContent("https://www.dividendinvestor.com/dividend-quote/"&A3,"span",1,">Dividend Payout Ratio",,,,1)



Above returns Error now


=smfStrExtr(smfGetTagContent("https://www.dividendinvestor.com/dividend-quote/"&$A3,"span",1,">Consecutive Dividend Increases",,,,1),"~"," ",1)



Above returns #value! now




Fri Nov 1, 2019 10:04 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

There might be some kind of splash screen on your first visit to the
website. Try using the IE object to view a web page on the site. Then use
the smfForceRecalculation macro to force EXCEL and the add-in to grab a
fresh copy of the web page from which to extract data.

On Fri, Nov 1, 2019 at 9:17 AM tzewei_79@... wrote:

> I used to be able to do the following on window 7, excel 2013. I just
> changed to a new machine with windows 10 and excel 2019 and I got the
> following output. Is there some incompatible issue with excel 2013 or I
> need to add more stuffs for excel 2013?
>
> =smfGetTagContent("https://www.dividendinvestor.com/dividend-quote/"&A3,"span",1,">Dividend
> Payout Ratio",,,,1)
>
> Above returns Error now
>
> =smfStrExtr(smfGetTagContent("
> https://www.dividendinvestor.com/dividend-quote/"&$A3,"span",1,">Consecutive
> Dividend Increases",,,,1),"~"," ",1)
>
> Above returns #value! now
>
>
>

Fri Nov 1, 2019 10:17 am (PDT) . Posted by:

tzewei_79

Hi All,

Just in case someone had the same issue. I solved this by latest zip from http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2018.01.24.zip http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2018.01.24.zip

Sat Nov 2, 2019 5:51 am (PDT) . Posted by:

tzewei_79

I did tried IE or Edge on windows 10 but it didn't help before I downloaded the 2018.01.24 zip file. Out of curiosity, I went to compare the 2017.11.30 vs 2018.01.24 folder. The xla didn't seems to have very big changes. Why does 2018 version able to fixed the problem?

How do I use smfForceRecalculation with "=smfGetTagContent("https://www.dividendinvestor.com/dividend-quote/"&A3,"span",1,">Dividend Payout Ratio",,,,1) "and "=smfStrExtr(smfGetTagContent("https://www.dividendinvestor.com/dividend-quote/"&$A3,"span",1,">Consecutive Dividend Increases",,,,1),"~"," ",1)" ? I couldn't find an example from the read-me.html.

Fri Nov 1, 2019 4:41 pm (PDT) . Posted by:

joelfp2000

Randy,


Thanks again for all of your help.


I am having problems with obtaining other data on this page. I use the following formula with success.


=smfGetYahooJSONField($A2,"fundprofile";,"quoteSummary.result.0.fundProfile.family") where A2 is the symbol. I get the fund company name without issue.



I'm trying to get the "inception date" and "holdings turnover" but just can't figure out what Yahoo calls these field.


Any help would be appreciated!


I also need the dang Alpha number too if that is not too much to ask.


Thanks so much!


Joel

Fri Nov 1, 2019 4:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetYahooJSONField($A2,"defaultKeyStatistics","quoteSummary.result.0.defaultKeyStatistics.annualHoldingsTurnover.raw")
=smfGetYahooJSONField($A2,"defaultKeyStatistics","quoteSummary.result.0.defaultKeyStatistics.fundInceptionDate.fmt")
=smfGetYahooJSONField($A2,"fundPerformance","quoteSummary.result.0.fundPerformance.riskOverviewStatistics.riskStatistics.0.alpha.raw")

On Fri, Nov 1, 2019 at 4:42 PM joel.andrews@... wrote:

> I am having problems with obtaining other data on this page. I use the
> following formula with success.
>
> =smfGetYahooJSONField($A2,"fundprofile";,"quoteSummary.result.0.fundProfile.family")
> where A2 is the symbol. I get the fund company name without issue.
>
> I'm trying to get the "inception date" and "holdings turnover" but just
> can't figure out what Yahoo calls these field.
>
> Any help would be appreciated!
>
> I also need the dang Alpha number too if that is not too much to ask.
>
>
>

Fri Nov 1, 2019 9:26 pm (PDT) . Posted by:

joelfp2000

Randy,

Thanks so much!


Joel

Sat Nov 2, 2019 12:00 am (PDT) . Posted by:

"George Warriner" georgeawarriner

Randy, with Yahoo Groups soon to shut down may I suggest you transfer to Groups.io

Groups.IO has both free and paid sections: https://groups.io/static/pricing

Regards…George A Warriner

From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com>
Sent: Saturday, 2 November 2019 12:27 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Yahoo Profile page



Randy,

Thanks so much!

Joel

Sat Nov 2, 2019 2:00 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I've had a free group over there for several years, although it was never
used:

https://groups.io/g/smf-add-in

On Sat, Nov 2, 2019 at 12:00 AM George Warriner georgeawarriner@... wrote:

>
> Randy, with Yahoo Groups soon to shut down may I suggest you transfer to
> Groups.io
>
>
>
> Groups.IO has both free and paid sections:
> https://groups.io/static/pricing
>
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 06.07

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)