5 Messages
Digest #4642
Messages
Sat Nov 2, 2019 6:59 am (PDT) . Posted by:
joelfp2000
Randy,
Thanks again for your help over the years. It has proved extremely profitable.
Is there anyway to pick off the "Potential Capital Gains Exposure" off of the new M* website under the Price tab? I know M* has changed their presentation but I can't locate any other website for the information. The old website still works but I can't figure out how to get the data.
https://www.morningstar.com/funds/xnas/wacpx/quote https://www.morningstar..com/funds/xnas/wacpx/quote
I'm also trying to figure out how to capture the "Longest Tenure" off the People tab too.
You've been answering my personal questions for perhaps 10 years and I hope this site (or some equivalent site) will continue. You have been truly kind with all of your help!
Thanks again!
Joel
Thanks again for your help over the years. It has proved extremely profitable.
Is there anyway to pick off the "Potential Capital Gains Exposure" off of the new M* website under the Price tab? I know M* has changed their presentation but I can't locate any other website for the information. The old website still works but I can't figure out how to get the data.
https://www.morningstar.com/funds/xnas/wacpx/quote https://www.morningstar..com/funds/xnas/wacpx/quote
I'm also trying to figure out how to capture the "Longest Tenure" off the People tab too.
You've been answering my personal questions for perhaps 10 years and I hope this site (or some equivalent site) will continue. You have been truly kind with all of your help!
Thanks again!
Joel
Sat Nov 2, 2019 9:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, Morningstar is now generating most of their web pages, after
retrieving data from an API. And that API call requires credentials, so the
add--in, as-is, can no longer get at that data.
On Sat, Nov 2, 2019 at 6:59 AM joel.andrews@... wrote:
> Is there anyway to pick off the "Potential Capital Gains Exposure" off of
> the new M* website under the Price tab? I know M* has changed their
> presentation but I can't locate any other website for the information. The
> old website still works but I can't figure out how to get the data..
>
> https://www.morningstar.com/funds/xnas/wacpx/quote
>
> I'm also trying to figure out how to capture the "Longest Tenure" off the
> People tab too.
>
> You've been answering my personal questions for perhaps 10 years and I
> hope this site (or some equivalent site) will continue. You have been
> truly kind with all of your help!
>
>
>
retrieving data from an API. And that API call requires credentials, so the
add--in, as-is, can no longer get at that data.
On Sat, Nov 2, 2019 at 6:59 AM joel.andrews@... wrote:
> Is there anyway to pick off the "Potential Capital Gains Exposure" off of
> the new M* website under the Price tab? I know M* has changed their
> presentation but I can't locate any other website for the information. The
> old website still works but I can't figure out how to get the data..
>
> https://www.morningstar.com/funds/xnas/wacpx/quote
>
> I'm also trying to figure out how to capture the "Longest Tenure" off the
> People tab too.
>
> You've been answering my personal questions for perhaps 10 years and I
> hope this site (or some equivalent site) will continue. You have been
> truly kind with all of your help!
>
>
>
Sat Nov 2, 2019 7:51 am (PDT) . Posted by:
"Craig Passow" passow
Yahoo Groups is severely curtailing its capabilities, but it is not
shutting down completely. Since add-in downloads haven't used Yahoo
servers for a long time, the fact that email is supposed to keep working
probably means that most Group participants won't even notice anything
different. Having said all that, there is of course no guarantee on
further changes. If there is anything you want in the Files section of
the Group website, make sure you download it by Dec. 14.
Here's the notice on the Group website and a link to additional
information:/
/
/Attention: Starting December 14, 2019 Yahoo Groups will no longer host
user created content on its sites. New content can no longer be uploaded
after October 28, 2019. Sending/Receiving email functionality is not
going away, you can continue to communicate via any email client with
your group members./
/Understand what's changing in Yahoo Groups
<https://help.yahoo.com/kb/groups/SLN31010.html?impressions=true>/
On 11/2/2019 3:59 AM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
>
> 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
>
>
>
>
>
shutting down completely. Since add-in downloads haven't used Yahoo
servers for a long time, the fact that email is supposed to keep working
probably means that most Group participants won't even notice anything
different. Having said all that, there is of course no guarantee on
further changes. If there is anything you want in the Files section of
the Group website, make sure you download it by Dec. 14.
Here's the notice on the Group website and a link to additional
information:/
/
/Attention: Starting December 14, 2019 Yahoo Groups will no longer host
user created content on its sites. New content can no longer be uploaded
after October 28, 2019. Sending/Receiving email functionality is not
going away, you can continue to communicate via any email client with
your group members./
/Understand what's changing in Yahoo Groups
<https://help.yahoo.com/kb/groups/SLN31010.html?impressions=true>/
On 11/2/2019 3:59 AM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
>
> 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
>
>
>
>
>
Sat Nov 2, 2019 9:03 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo groups will be an email delivery system, but they won't be saving
copies of the emails in any kind of archives like we currently have.
On Sat, Nov 2, 2019 at 7:51 AM Craig Passow passow@... wrote:
> Yahoo Groups is severely curtailing its capabilities, but it is not
> shutting down completely. Since add-in downloads haven't used Yahoo servers
> for a long time, the fact that email is supposed to keep working probably
> means that most Group participants won't even notice anything different.
> Having said all that, there is of course no guarantee on further changes.
> If there is anything you want in the Files section of the Group website,
> make sure you download it by Dec. 14.
>
> Here's the notice on the Group website and a link to additional
> information:
>
> *Attention: Starting December 14, 2019 Yahoo Groups will no longer host
> user created content on its sites. New content can no longer be uploaded
> after October 28, 2019. Sending/Receiving email functionality is not going
> away, you can continue to communicate via any email client with your group
> members.*
>
> *Understand what's changing in Yahoo Groups
> <https://help.yahoo.com/kb/groups/SLN31010.html?impressions=true>*
>
>
>
copies of the emails in any kind of archives like we currently have.
On Sat, Nov 2, 2019 at 7:51 AM Craig Passow passow@... wrote:
> Yahoo Groups is severely curtailing its capabilities, but it is not
> shutting down completely. Since add-in downloads haven't used Yahoo servers
> for a long time, the fact that email is supposed to keep working probably
> means that most Group participants won't even notice anything different.
> Having said all that, there is of course no guarantee on further changes.
> If there is anything you want in the Files section of the Group website,
> make sure you download it by Dec. 14.
>
> Here's the notice on the Group website and a link to additional
> information:
>
> *Attention: Starting December 14, 2019 Yahoo Groups will no longer host
> user created content on its sites. New content can no longer be uploaded
> after October 28, 2019. Sending/Receiving email functionality is not going
> away, you can continue to communicate via any email client with your group
> members.*
>
> *Understand what's changing in Yahoo Groups
> <https://help.yahoo.com/kb/groups/SLN31010.html?impressions=true>*
>
>
>
Sat Nov 2, 2019 8:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
To run a macro from the add-in, just bring up the macro dialog (alt+F8) and
type in the name of the macro.
There's a link on the Tips and FAQs web page discussing this macro.
The best place to test web page is within EXCEL, because it uses a
different browser object than the stand-alone products. It's the "From Web
(Legacy)" tool in EXCEL.
In all likelihood, installing the new version of the add-in was a
roundabout way of resetting the VBA environment within EXCEL, so it ended
up needing to retrieve a new copy of the web page (which is what
smfForceRecalculation does without all that work). Simple exiting and
restarting EXCEL would also reset the VBA environment.
On Sat, Nov 2, 2019 at 5:51 AM tzewei_79@... wrote:
>
> 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.
>
>
>
type in the name of the macro.
There's a link on the Tips and FAQs web page discussing this macro.
The best place to test web page is within EXCEL, because it uses a
different browser object than the stand-alone products. It's the "From Web
(Legacy)" tool in EXCEL.
In all likelihood, installing the new version of the add-in was a
roundabout way of resetting the VBA environment within EXCEL, so it ended
up needing to retrieve a new copy of the web page (which is what
smfForceRecalculation does without all that work). Simple exiting and
restarting EXCEL would also reset the VBA environment.
On Sat, Nov 2, 2019 at 5:51 AM tzewei_79@... wrote:
>
> 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,"
> Dividend Increases"
> read-me.html.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar