Messages In This Digest (4 Messages)
- 1a.
- getting data from mstar print views From: colobuyer123
- 1b.
- Re: getting data from mstar print views From: Randy Harmelink
- 2a.
- spy data not working properly from Mstar From: colobuyer123
- 2b.
- Re: spy data not working properly from Mstar From: Randy Harmelink
Messages
- 1a.
-
getting data from mstar print views
Posted by: "colobuyer123" keystin@gmail.com colobuyer123
Tue Oct 25, 2011 8:02 am (PDT)
How can I grab the tax cost ratios off of this page? (http://performance.morningstar. )com/fund/ tax-analysis. action?ops= p&t=PRPFX
I've been getting if off of another page using the formula below but I want to get the 1, 3, 5, 10yr, which the below page doesn't contain.
=RCHGetTableCell("http://quicktake. morningstar. "&CONCATENATE(com/fundnet/ printreport. aspx?symbol= $A4),1,"> Tax Cost Ratio")/100< =0,
- 1b.
-
Re: getting data from mstar print views
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Oct 25, 2011 9:57 am (PDT)
Sorry, but that page is dynamically generated, so the data is not within the
source code of the web page where the add-in could extract it.
On Tue, Oct 25, 2011 at 8:02 AM, colobuyer123 <keystin@gmail.com > wrote:
> How can I grab the tax cost ratios off of this page? (
> http://performance.morningstar. )com/fund/ tax-analysis. action?ops= p&t=PRPFX
>
> I've been getting if off of another page using the formula below but I want
> to get the 1, 3, 5, 10yr, which the below page doesn't contain.
>
> =RCHGetTableCell("
> http://quicktake.morningstar. "&CONCATENATE(com/fundnet/ printreport. aspx?symbol= $A4),1,"> Tax
> Cost Ratio")/100<=0,
>
- 2a.
-
spy data not working properly from Mstar
Posted by: "colobuyer123" keystin@gmail.com colobuyer123
Tue Oct 25, 2011 8:03 am (PDT)
Looks like mstar is having issues when working with SPY. it is causing the function below to error out. Other etfs pull data in fine. any ideas? seems like the url below isn't working ONLY with spy, works with other etf's though.
=RCHGetTableCell("http://quicktake. morningstar. "&CONCATENATE(com/fundnet/ printreport. aspx?symbol= A19),1,"> Net Expense Ratio: Annual")/100)
- 2b.
-
Re: spy data not working properly from Mstar
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Oct 25, 2011 10:06 am (PDT)
That web page doesn't exist on Morningstar for SPY -- it redirects to the
main quote page. Try:
=RCHGetTableCell("
http://financials.morningstar. "&A19,1,"Netcom/etfund/ operations. html?t=
Expense Ratio: Prospectus")
I'm actually surprised any ETFs work -- often, Morningstar has different
URLs for stock, fund, and ETF data (i.e. the "fundnet" qualifier of the
URL).
PS: Your CONCATENATE() function is redundant. It's not actually doing
anything.
On Tue, Oct 25, 2011 at 8:03 AM, colobuyer123 <keystin@gmail.com > wrote:
> Looks like mstar is having issues when working with SPY. it is causing the
> function below to error out. Other etfs pull data in fine. any ideas?
> seems like the url below isn't working ONLY with spy, works with other
> etf's though.
>
> =RCHGetTableCell("
> http://quicktake.morningstar. "&CONCATENATE(com/fundnet/ printreport. aspx?symbol= A19),1,"> Net
> Expense Ratio: Annual")/100)
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar