Jumat, 12 Juni 2015

[smf_addin] Digest Number 3431

8 Messages

Digest #3431

Messages

Thu Jun 11, 2015 8:11 am (PDT) . Posted by:

nelsonmuntz1000

Hi Randy,


I'm struggling to extract Morningstar star ratings for Canadian mutual funds using =smfStrExtr(RCHGetWebData and =smfConvertData(smfStrExtr(smfGetTagContent( formulas and haven't been successful. Web pages I'm looking at are as follows, including a fund code example:


http://quote.morningstar.ca/QuickTakes/fund/f_ca.aspx?t=TDB900®ion=CAN&culture=en-CA http://quote.morningstar.ca/QuickTakes/fund/f_ca.aspx?t=TDB900®ion=CAN&culture=en-CA

http://quote.morningstar.ca/QuickTakes/fund/Performance/f_Perf.aspx?t=TDB900®ion=CAN&culture=en-CA http://quote.morningstar.ca/QuickTakes/fund/Performance/f_Perf.aspx?t=TDB900®ion=CAN&culture=en-CA

http://quote.morningstar.ca/QuickTakes/fund/PortfolioOverviewNew.aspx?t=TDB900®ion=CAN&culture=en-CA http://quote.morningstar.ca/QuickTakes/fund/PortfolioOverviewNew.aspx?t=TDB900®ion=CAN&culture=en-CA


Any help you could give would be greatly appreciated. Thanks for the great add-in.




Thu Jun 11, 2015 8:47 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This is a tricky one. The star rating is actually found here:

=smfConvertData(smfstrExtr(smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?t=F0CAN05NJO®ion=CAN&culture=en-CA&cur=CAD&productCode=CAN
","div",-1,"r_star"),"r_star","'"))

Does the F0CAN05NJO ticker symbol there mean anything to you? I can extract
it from the original webpage you gave me with:

=smfstrExtr(RCHGetWebData("
http://quote.morningstar.ca/QuickTakes/fund/f_ca.aspx?t=TDB900®ion=CAN&culture=en-CA
","ticker=",20),"ticker=","/")

So if you have that in a cell, say D8, you could refer back to it with:

=smfConvertData(smfstrExtr(smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?region=CAN&culture=en-CA&cur=CAD&productCode=CAN&t=
"&D8,"div",-1,"r_star"),"r_star","'"))

However, I'm not sure how consistent that will be from equity to equity?

The web page:

http://quote.morningstar.ca/QuickTakes/fund/f_ca.aspx?t=TDB900®ion=CAN&culture=en-CA

...is built from a number of different web pages using the F0CAN05NJO
ticker symbol. And, these two web pages appear to have the same data on
them:

http://quote.morningstar.ca/QuickTakes/fund/f_ca.aspx?t=F0CAN05NJO®ion=CAN&culture=en-CA
http://quote.morningstar.ca/QuickTakes/fund/f_ca.aspx?t=TDB900®ion=CAN&culture=en-CA

Should you be using the F0CAN05NJO ticker symbol? Color me confused.

On Thu, Jun 11, 2015 at 8:11 AM, ccoupe300@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I'm struggling to extract Morningstar star ratings for Canadian mutual
> funds using =smfStrExtr(RCHGetWebData and
> =smfConvertData(smfStrExtr(smfGetTagContent( formulas and haven't been
> successful. Web pages I'm looking at are as follows, including a fund code
> example:
>
>
> http://quote.morningstar.ca/QuickTakes/fund/f_ca.aspx?t=TDB900®ion=CAN&culture=en-CA
>
>
> http://quote.morningstar.ca/QuickTakes/fund/Performance/f_Perf.aspx?t=TDB900®ion=CAN&culture=en-CA
>
>
> http://quote.morningstar.ca/QuickTakes/fund/PortfolioOverviewNew.aspx?t=TDB900®ion=CAN&culture=en-CA
>
> Any help you could give would be greatly appreciated. Thanks for the great
> add-in.
>

Thu Jun 11, 2015 10:04 am (PDT) . Posted by:

nelsonmuntz1000

Thanks for replying so quickly. It is a tricky one. Canadian stock and fund quotes never cease to be a challenge. The tickers you found are used by Morningstar.ca and Yahoo, I use them to extract asset allocation data as follows: =RCHGetTableCell("http://quote.morningstar.ca/QuickTakes/fund/PortfolioOverviewNew.aspx?t=F0CAN05NJO®ion=CAN&culture=en-CA",1,">Consumer Cyclical")/100. I'll give your formula a try and let you know how it works out. Thanks again.

Thu Jun 11, 2015 7:13 pm (PDT) . Posted by:

ppasha1129

Is the yahoo SMF compatible with windows 8.1?

Thu Jun 11, 2015 8:00 pm (PDT) . Posted by:

"Betty & Bob" bgauer

I have no trouble using it with Excel2003 in Windows8.1. My
Excel2010 license only covers one computer, which is running
Windows 7.Betty G On 06/11/15, ppasha1129@yahoo.com
[smf_addin]<smf_addin@yahoogroups.com> wrote:
Is the yahoo SMF compatible with windows 8.1?

Thu Jun 11, 2015 9:02 pm (PDT) . Posted by:

jimmymc00


I'm also using it with Windows 8.1 and Excel 2013 without any trouble. Jim

-----Original Message-----
From: Betty & Bob b_bgauer.56@verizon.net [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Thu, Jun 11, 2015 11:00 pm
Subject: Re: [smf_addin] Windows 8.1 Compatibility

I have no trouble using it with Excel2003 in Windows8.1. My Excel2010 license only covers one computer, which is running Windows 7.

Betty G





On 06/11/15, ppasha1129@yahoo.com [smf_addin]<smf_addin@yahoogroups.com> wrote:






Is the yahoo SMF compatible with windows 8.1?












Thu Jun 11, 2015 11:17 pm (PDT) . Posted by:

tzewei_79

Hi,


It seems that they revamp their website. Just want to confirm if it was their website that caused cell error. Could someone try to see if you can get data from =RCHGetTableCell("https://www.dividata.com/stock/STX",1,"Industry") https://www.dividata.com/stock/STX





Fri Jun 12, 2015 1:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yah. They've done something to their website. See this thread:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28511

On Thu, Jun 11, 2015 at 11:17 PM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> It seems that they revamp their website. Just want to confirm if it was
> their website that caused cell error. Could someone try to see if you can
> get data from
> =RCHGetTableCell("https://www.dividata.com/stock/STX",1,"Industry")
> <https://www.dividata.com/stock/STX>
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar