14 Messages
Digest #3292
5b
Re: How to display the correct stock exchange (eg. NYSE, NAS, etc.)? 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.
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.
>
=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.
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.
>
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(
...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'
> 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
>
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,"
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.
>
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 :)
RCHGetElementNumber
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?
>
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
> I was using this formula, but it no longer works (it has been returning
> an error for several weeks):
> RCHGetElementNumber
>
> 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")
=RCHGetYahooQuotes(
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar