Sabtu, 10 Januari 2015

[smf_addin] Digest Number 3292

14 Messages

Digest #3292
1a
Re: StockGrader? by nelsonmuntz1000
1b
Re: StockGrader? by "Randy Harmelink" rharmelink
1c
Re: StockGrader? by nelsonmuntz1000
2a
Re: IMF Global GDP by zacharycal
3b
Re: Alternative Source for Quotes? by "Randy Harmelink" rharmelink
4b
Re: Yahoo Finance Analyst Estimates? by "Randy Harmelink" rharmelink
4d
Re: Yahoo Finance Analyst Estimates? by "Randy Harmelink" rharmelink

Messages

Fri Jan 9, 2015 7:01 am (PST) . Posted by:

nelsonmuntz1000

Randy:

Thanks for the formula. It works great for US and Canadian stocks.


Is there a way to retrieve MarketGrader ratings for US and Canadian ETF's? I know MarketGrader generates ratings for both as my Canadian brokerage account shows them.


The SPY ETF link is: https://www.marketgrader.com/MGMainWeb/etfgrader/snapshot.jsp?id=SPY https://www.marketgrader.com/MGMainWeb/etfgrader/snapshot.jsp?id=SPY but I'm not sure how to retrieve the rating.


I couldn't find any Canadian ETFs, for example XIC.CA through the MarketGrader site. Any ideas?


Any help would be greatly appreciated. Thank you for providing this great service.

Fri Jan 9, 2015 7:15 am (PST) . Posted by:

"Randy Harmelink" rharmelink

For the average grade of SPY, try:

=smfConvertData(smfstrExtr(smfGetTagContent("
https://www.marketgrader.com/MGMainWeb/etfgrader/snapshot.jsp?id=SPY","span",1,"Avg.
Grade"),">","~"))

Sorry, but I have no ideas for Canadian ETFs. I don't do anything with
them, or MarketGrader.

On Fri, Jan 9, 2015 at 8:01 AM, ccoupe300@... wrote:

>
> Thanks for the formula. It works great for US and Canadian stocks.
>
> Is there a way to retrieve MarketGrader ratings for US and Canadian ETF's?
> I know MarketGrader generates ratings for both as my Canadian brokerage
> account shows them.
>
> The SPY ETF link is:
> https://www.marketgrader.com/MGMainWeb/etfgrader/snapshot.jsp?id=SPY but
> I'm not sure how to retrieve the rating.
>
> I couldn't find any Canadian ETFs, for example XIC.CA through the
> MarketGrader site. Any ideas?
>
> Any help would be greatly appreciated. Thank you for providing this great
> service.
>

Fri Jan 9, 2015 11:06 am (PST) . Posted by:

db11507

Hello, I've been using smf for a couple of years and it has been working fantastically. However, my company's new web security is interfering with getting Yahoo quotes. (It asks for my user ID and password for first visits to any site. Supposedly, after that it should be fine, but it isn't.) In fact, the only table I'm getting Yahoo data for is Market Statistics. The RCHGetElements still works for some elements, mostly Morningstar info.


What I need is a way to resume getting the basic current quotes perhaps from Morningstar. If I could modify my add-in, how would you advise me to proceed. Otherwise, do you have other elements that provide the same information.


Fri Jan 9, 2015 11:58 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Take a look at the RCHGetWebData-Google-API-Quotes.xls template in the
FILES area of the Yahoo group.

I hesitate to do a page-by-page scraping for quotes info from MorningStar.
This appears to work for a table of info, but only sporadically:

=RCHGetHTMLTable("
http://quicktake.morningstar.com/fundfamily/Quote-Summary?ticker=
"&smfJoin(B9:B25,","),">G/L",-1,"",1)

...where the ticker symbols are in cells B9:B25

On Fri, Jan 9, 2015 at 11:51 AM, db11507@... wrote:

> Hello, I've been using smf for a couple of years and it has been working
> fantastically. However, my company's new web security is interfering with
> getting Yahoo quotes. (It asks for my user ID and password for first
> visits to any site. Supposedly, after that it should be fine, but it
> isn't.) In fact, the only table I'm getting Yahoo data for is Market
> Statistics. The RCHGetElements still works for some elements, mostly
> Morningstar info.
>
> What I need is a way to resume getting the basic current quotes perhaps
> from Morningstar. If I could modify my add-in, how would you advise me to
> proceed. Otherwise, do you have other elements that provide the same
> information.
>

Fri Jan 9, 2015 11:06 am (PST) . Posted by:

hcathree

Anyone know what is going on with Yahoo Finance the last few days. Most of the Analyst Earnings Estimates are showing "N/A" on their website and thus "N/A" on my spreadsheets (examples: HPQ, MSFT, INTC, IBM.) Is there any alternative data source for earnings estimates? The Zacks numbers aren't accurate. Do we have access to MarketWatch? Thanks

Fri Jan 9, 2015 11:57 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Probably just a temporary thing on Yahoo.

Why do you say the Zacks numbers aren't accurate?

But, yes, you could get the data from MarketWatch. For example:

=RCHGetTableCell("
http://www.marketwatch.com/investing/stock/AAPL/analystestimates",1,"Average
Recommendation:")

On Fri, Jan 9, 2015 at 12:01 PM, hamptona@... wrote:

> Anyone know what is going on with Yahoo Finance the last few days. Most
> of the Analyst Earnings Estimates are showing "N/A" on their website and
> thus "N/A" on my spreadsheets (examples: HPQ, MSFT, INTC, IBM.) Is there
> any alternative data source for earnings estimates? The Zacks numbers
> aren't accurate. Do we have access to MarketWatch? Thanks
>

Fri Jan 9, 2015 1:00 pm (PST) . Posted by:

hcathree

Thanks for the quick reply. Not sure why the Zacks numbers are inaccurate. Maybe a smaller sample size but many are not in the same range as yahoo finance, marketwatch, reuters etc. One final question: the formula you sent works great except that I have to type in the ticker (in this case AAPL) inside the formula. Is there a way to refer to a different cell in the spreadsheet for the ticker? I want to copy and paste the same formula across the entire spreadsheet. Thanks again.

Fri Jan 9, 2015 1:17 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Just use the normal EXCEL concatenation operation to refer to the ticker
symbol:

=RCHGetTableCell("http://www.marketwatch.com/investing/stock/" & C5 &
"/analystestimates",1,"Average Recommendation:")

Zack's numbers are different because they collect the analyst estimates
themselves. The others probably all use the same data service (Thomson
Financial Network?). They're just collections of estimates, so I wouldn't
call either set "accurate". A sample size of one might be the most accurate
you could get. :)

On Fri, Jan 9, 2015 at 2:00 PM, hamptona@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks for the quick reply. Not sure why the Zacks numbers are inaccurate.
> Maybe a smaller sample size but many are not in the same range as yahoo
> finance, marketwatch, reuters etc. One final question: the formula you sent
> works great except that I have to type in the ticker (in this case AAPL)
> inside the formula. Is there a way to refer to a different cell in the
> spreadsheet for the ticker? I want to copy and paste the same formula
> across the entire spreadsheet. Thanks again.
>

Fri Jan 9, 2015 1:51 pm (PST) . Posted by:

hcathree

That's perfect. Thanks again for your help. Have a good weekend.

Sat Jan 10, 2015 12:00 am (PST) . Posted by:

g_oudreva

I was using this formula, but it no longer works (it has been returning an error for several weeks):
RCHGetElementNumber(Ticker,3)


Does anyone have a different formula for excel that works with SMF add-in or one that works by pulling info from online?


Thanks :)

Sat Jan 10, 2015 12:26 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I'd recommend using the RCHGetYahooQuotes() function, since you can get
data on up to 200 ticker symbols in a single Internet access, instead of
retrieving the data a single web page at a time for each ticker symbol.

PS: All MSN data elements are obsolete at this point. They did a major
update of their website back in September and removed most of the data.

On Sat, Jan 10, 2015 at 12:59 AM, lottidottigigliotti@... wrote:

> I was using this formula, but it no longer works (it has been returning
> an error for several weeks):
> RCHGetElementNumber(Ticker,3)
>
> Does anyone have a different formula for excel that works with SMF add-in
> or one that works by pulling info from online?
>

Sat Jan 10, 2015 1:56 am (PST) . Posted by:

g_oudreva

Thanks Randy, I used this formula to find the stock exchange and it worked great. Thanks for your help :)
=RCHGetYahooQuotes("IBM","X")
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar