8 Messages
Digest #4133
Messages
Mon Aug 28, 2017 8:52 pm (PDT) . Posted by:
joelfp2000
Randy,
Thanks for all of your help in the past. What a great service you are to all of us!
When you have a minute would you mind helping me extract the "Net Expense Ratio: Category Average" from the M* ETF - Fees & Expenses page? I've tried fiddling with the report but can't get that data.
Thanks for your help!
Joel
Thanks for all of your help in the past. What a great service you are to all of us!
When you have a minute would you mind helping me extract the "Net Expense Ratio: Category Average" from the M* ETF - Fees & Expenses page? I've tried fiddling with the report but can't get that data.
Thanks for your help!
Joel
Tue Aug 29, 2017 1:03 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try something like:
=smfConvertData(smfStrExtr(SUBSTITUTE(smfGetTagContent("
http://srt.morningstar.com/oprn/etf/c-feesandexpense.html?t=SPHD","td",1,"Net
Expense Ratio: Category Average"),"\t",""),"\n","%"))
On Mon, Aug 28, 2017 at 8:52 PM, joel.andrews@lpl.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> When you have a minute would you mind helping me extract the "Net Expense
> Ratio: Category Average" from the M* ETF - Fees & Expenses page? I've
> tried fiddling with the report but can't get that data.
>
>
>
=smfConvertData(smfStrExtr(SUBSTITUTE(smfGetTagContent("
http://srt.morningstar.com/oprn/etf/c-feesandexpense.html?t=SPHD","td",1,"Net
Expense Ratio: Category Average"),"\t",""),"\n","%"))
On Mon, Aug 28, 2017 at 8:52 PM, joel.andrews@lpl.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> When you have a minute would you mind helping me extract the "Net Expense
> Ratio: Category Average" from the M* ETF - Fees & Expenses page? I've
> tried fiddling with the report but can't get that data.
>
>
>
Mon Aug 28, 2017 9:43 pm (PDT) . Posted by:
nelsonmuntz1000
Hi Randy:
FYI: Stockscores elements 800-836 are showing errors. These were working on Aug 25.
I have updated to the latest version.
Sample link: http://www.stockscores.com/charts/charts/?ticker=XYL http://www.stockscores.com/charts/charts/?ticker=XYL
Any ideas? Thanks.
FYI: Stockscores elements 800-836 are showing errors. These were working on Aug 25.
I have updated to the latest version.
Sample link: http://www.stockscores.com/charts/charts/?ticker=XYL http://www.stockscores.com/charts/charts/?ticker=XYL
Any ideas? Thanks.
Tue Aug 29, 2017 1:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the heads up. Looks like they've redesigned their web page
structure, so all of the elements will need to be redefined.
Later...I just uploaded the new smf-elements-9.txt file to the web site:
http://ogres-crypt.com/SMF/Elements/
Best practice is to exit EXCEL before updating add-in files.
For the most part, it was a simple URL change for all element definitions.
On Mon, Aug 28, 2017 at 9:43 PM, ccoupe300@
...
wrote:
>
>
> FYI: Stockscores elements 800-836 are showing errors. These were working
> on Aug 25.
>
> I have updated to the latest version.
>
> Sample link: http://www.stockscores.com/charts/charts/?ticker=XYL
>
> Any ideas? Thanks.
>
structure, so all of the elements will need to be redefined.
Later...I just uploaded the new smf-elements-9.txt file to the web site:
http://ogres-crypt.com/SMF/Elements/
Best practice is to exit EXCEL before updating add-in files.
For the most part, it was a simple URL change for all element definitions.
On Mon, Aug 28, 2017 at 9:43 PM, ccoupe300@
...
wrote:
>
>
> FYI: Stockscores elements 800-836 are showing errors. These were working
> on Aug 25.
>
> I have updated to the latest version.
>
> Sample link: http://www.stockscores.com/charts/charts/?ticker=XYL
>
> Any ideas? Thanks.
>
Tue Aug 29, 2017 12:11 pm (PDT) . Posted by:
a.bereziuk
Hello,
from this page:
https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676 https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676 (in cell O65)
I try to extract price:
=RCHGetTableCell($O65;1;"Frankfurt</a>")
and I get Error. But it worked before!
I also tried:
=smfGetTagContent($O65;"td";1;">Frankfurt";;;;1)
also Error.
Any ideas?
from this page:
https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676 https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676 (in cell O65)
I try to extract price:
=RCHGetTableCell(
and I get Error. But it worked before!
I also tried:
=smfGetTagContent(
also Error.
Any ideas?
Tue Aug 29, 2017 12:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
My regional version of both formulas work fine here:
=RCHGetTableCell(C4,1,"Frankfurt</a>")
=smfGetTagContent(C4,"td",1,">Frankfurt",,,,1)
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetWebData("https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676
",">Frankfurt",100)
Could you have had a temporary glitch and not retrieved the web page
properly? You could try either exiting and restarting EXCEL, or running the
smfForceRecalculation macro to force the add-in to get a new copy of the
web page.
Also, you should make sure your Internet Options are set to always get a
fresh copy of a web page. Otherwise, you could be using cached copies of
web pages.
On Tue, Aug 29, 2017 at 12:11 PM, a.bereziuk@
...
wrote:
>
> from this page:
> https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676 (in cell O65)
> I try to extract price:
> =RCHGetTableCell($O65;1;"Frankfurt</a>")
> and I get Error. But it worked before!
> I also tried:
> =smfGetTagContent($O65;"td";1;">Frankfurt";;;;1)
> also Error.
> Any ideas?
>
>
>
=RCHGetTableCell(C4,1,"Frankfurt</a>")
=smfGetTagContent(C4,"td",1,">Frankfurt",,,,1)
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetWebData("https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676
",">Frankfurt",100)
Could you have had a temporary glitch and not retrieved the web page
properly? You could try either exiting and restarting EXCEL, or running the
smfForceRecalculation macro to force the add-in to get a new copy of the
web page.
Also, you should make sure your Internet Options are set to always get a
fresh copy of a web page. Otherwise, you could be using cached copies of
web pages.
On Tue, Aug 29, 2017 at 12:11 PM, a.bereziuk@
...
wrote:
>
> from this page:
> https://www.onvista.de/anleihen/kurse.html?ISIN=GR0128010676 (in cell O65)
> I try to extract price:
> =RCHGetTableCell(
> and I get Error. But it worked before!
> I also tried:
> =smfGetTagContent(
> also Error.
> Any ideas?
>
>
>
Tue Aug 29, 2017 1:27 pm (PDT) . Posted by:
danzig_36526
Anyone else having trouble with these elements for company data (i.e. element #13682)?
Tue Aug 29, 2017 2:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The URL has changed, but it looks like all of the company data is populated
as "--" right now:
http://www.reuters.com/finance/stocks/financial-highlights/MMM
So it appears to be a Reuters problem, not an add-in problem...?
On Tue, Aug 29, 2017 at 1:27 PM, danzig_36526@
...
wrote:
> Anyone else having trouble with these elements for company data (i.e.
> element #13682)?
>
as "--" right now:
http://www.reuters.com/finance/stocks/financial-highlights/MMM
So it appears to be a Reuters problem, not an add-in problem...?
On Tue, Aug 29, 2017 at 1:27 PM, danzig_36526@
...
wrote:
> Anyone else having trouble with these elements for company data (i.e.
> element #13682)?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar