Minggu, 11 November 2012

[smf_addin] Digest Number 2397

6 New Messages

Digest #2397
1a
Industry size... by "oryxius" oryxius
1b
Re: Industry size... by "Randy Harmelink" rharmelink
3a
Unable to pull anything from MSN by "Michael McIntyre" michaelmcintyre2000
3b
Re: Unable to pull anything from MSN by "Randy Harmelink" rharmelink
3c
Re: Unable to pull anything from MSN by "cs.holdings" cs.holdings

Messages

Sat Nov 10, 2012 10:41 am (PST) . Posted by:

"oryxius" oryxius

Does any one knows a good source to extract industry size/capitalization? As when they say: "This is a 4-billion industry..."

Sat Nov 10, 2012 10:49 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Yahoo's Industry Center has it:

http://biz.yahoo.com/p/s_conameu.html

Just drill down by sector...

On Sat, Nov 10, 2012 at 11:41 AM, oryxius <oryxius@yahoo.com> wrote:

> Does any one knows a good source to extract industry size/capitalization?
> As when they say: "This is a 4-billion industry..."
>

Sat Nov 10, 2012 10:42 am (PST) . Posted by:

"oryxius" oryxius

Thank you Randy. You're as always, great and helpful.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The keyboard shortcut alt+t+i brings up the add-in manager, so you could
> uncheck and disable the add-in.
>
> I don't know of a way to selectively disable the add-in for different
> workbooks.
>
> On Sat, Nov 10, 2012 at 2:11 AM, oryxius <oryxius@...> wrote:
>
> > Sometimes when I am working with data, I turn off the add-in by going into
> > FILE>>OPTIONS>>ADD-INS>>GO... and then unchecking the add-in from addins
> > list. My first question: is there a short-cut for this? My second
> > question, when having more than one excel file open, is it possible to
> > disable the add-in for one file and keep it working for the others?
> >
>

Sat Nov 10, 2012 5:42 pm (PST) . Posted by:

"Michael McIntyre" michaelmcintyre2000

I am unable to successfully download any data from MSN.  I am attempting to get the data from the analyst rating page (for example, http://investing.money.msn.com/investments/analyst-ratings?symbol=IBM).  I have tried both the SMF-Template-MSN-Analyst-Opinions.xls template, as well as the individual calls (for example, =RCHGetElementNumber("IBM", 362)).

I am able to successfully access other sites, so I believe the add-in is correctly installed.  No matter what I've tried, the result in the cells always return "Error"  even after manually recalculating.

Any thoughts?

Thanks!

Sat Nov 10, 2012 6:43 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

See: http://finance.groups.yahoo.com/group/smf_addin/message/19858

On Sat, Nov 10, 2012 at 6:42 PM, Michael McIntyre <
michaelmcintyre2000@yahoo.com> wrote:

>
> I am unable to successfully download any data from MSN. I am attempting
> to get the data from the analyst rating page (for example,
> http://investing.money.msn.com/investments/analyst-ratings?symbol=IBM<http://investing.money.msn.com/investments/analyst-ratings?symbol=MSFT>).
> I have tried both the SMF-Template-MSN-Analyst-Opinions.xls template, as
> well as the individual calls (for example, =RCHGetElementNumber("IBM",
> 362)).
>
> I am able to successfully access other sites, so I believe the add-in is
> correctly installed. No matter what I've tried, the result in the cells
> always return "Error" even after manually recalculating.
>
> Any thoughts?
>
>

Sat Nov 10, 2012 10:44 pm (PST) . Posted by:

"cs.holdings" cs.holdings

Im having a similar problem with the ADVN elements. Im guessing weekend maintenance issue

--- In smf_addin@yahoogroups.com, Michael McIntyre <michaelmcintyre2000@...> wrote:
>
> I am unable to successfully download any data from MSN.  I am attempting to get the data from the analyst rating page (for example, http://investing.money.msn.com/investments/analyst-ratings?symbol=IBM).  I have tried both the SMF-Template-MSN-Analyst-Opinions.xls template, as well as the individual calls (for example, =RCHGetElementNumber("IBM", 362)).
>
>
> I am able to successfully access other sites, so I believe the add-in is correctly installed.  No matter what I've tried, the result in the cells always return "Error"  even after manually recalculating.
>
> Any thoughts?
>
> Thanks!
>

Tidak ada komentar:

Posting Komentar