Selasa, 04 Oktober 2011

[smf_addin] Digest Number 1974

Messages In This Digest (14 Messages)

Messages

1a.

Re: List of All Companies from Yahoo

Posted by: "jcarlosd" jcdelrio@procesando.com   jcarlosd

Mon Oct 3, 2011 4:44 am (PDT)



It works, not exactly with an empty search. You need to enter a double asterisk.

You can get all stocks (more than 146k!!!) with:
http://finance.yahoo.com/lookup?s=**&t=S

All US stocks with:
http://finance.yahoo.com/lookup?s=**&t=S&m=US

Juan C.

--- In smf_addin@yahoogroups.com, Scott Jackson <scottandrewjackson@...> wrote:
>
> If you run a yahoo stock screen with no criteria, that might work.
>
> Scott
>
> Sent from my iPhone
>
> On Oct 1, 2011, at 7:50 PM, "RobbR" <robbrafferty@...> wrote:
>
> > OK, Thanks. Just Something I wanted to try.
> >
> > Robb
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > No easy way to do it that I know of.
> > >
> > > I can't see the value -- it would probably change daily anyway.
> > >
> > > On Sat, Oct 1, 2011 at 4:52 PM, Robb Rafferty <robbrafferty@>wrote:
> > >
> > > > Is there a template or some other method for obtaining ALL listed
> > > > Companies in Yahoo, name and ticker.
> > > >
> > > > I searched messages but could not find anything.
> > > >
> > > > I see there is a similar list from from finviz in files section.
> > > >
> > > >
> > >
> >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
1b.

Re: List of All Companies from Yahoo

Posted by: "RobbR" robbrafferty@verizon.net   aslanspirit

Mon Oct 3, 2011 3:35 pm (PDT)



Really good stuff.
I see the starting or landing page.
So, just trying to get my head around the process, can you give some direction on how to utilize SMF query to get all US Names-Tickers

I ahve used SMF to pull indidual stock quotes as well as finanical data, but not clear on how to pull down 71000 names into a spreadsheet.

Thanks,
Robb

--- In smf_addin@yahoogroups.com, "jcarlosd" <jcdelrio@...> wrote:
>
> It works, not exactly with an empty search. You need to enter a double asterisk.
>
> You can get all stocks (more than 146k!!!) with:
> http://finance.yahoo.com/lookup?s=**&t=S
>
> All US stocks with:
> http://finance.yahoo.com/lookup?s=**&t=S&m=US
>
> Juan C.
>
>
> --- In smf_addin@yahoogroups.com, Scott Jackson <scottandrewjackson@> wrote:
> >
> > If you run a yahoo stock screen with no criteria, that might work.
> >
> > Scott
> >
> > Sent from my iPhone
> >
> > On Oct 1, 2011, at 7:50 PM, "RobbR" <robbrafferty@> wrote:
> >
> > > OK, Thanks. Just Something I wanted to try.
> > >
> > > Robb
> > >
> > > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > > >
> > > > No easy way to do it that I know of.
> > > >
> > > > I can't see the value -- it would probably change daily anyway.
> > > >
> > > > On Sat, Oct 1, 2011 at 4:52 PM, Robb Rafferty <robbrafferty@>wrote:
> > > >
> > > > > Is there a template or some other method for obtaining ALL listed
> > > > > Companies in Yahoo, name and ticker.
> > > > >
> > > > > I searched messages but could not find anything.
> > > > >
> > > > > I see there is a similar list from from finviz in files section.
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
1c.

Re: List of All Companies from Yahoo

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Oct 3, 2011 3:39 pm (PDT)



That's why I said no easy way -- you'd have to grab them page by page, 20 at
a time.

Why do you even need them?

On Mon, Oct 3, 2011 at 3:35 PM, RobbR <robbrafferty@verizon.net> wrote:

> Really good stuff.
> I see the starting or landing page.
> So, just trying to get my head around the process, can you give some
> direction on how to utilize SMF query to get all US Names-Tickers
>
> I ahve used SMF to pull indidual stock quotes as well as finanical data,
> but not clear on how to pull down 71000 names into a spreadsheet.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
1d.

Re: List of All Companies from Yahoo

Posted by: "RobbR" robbrafferty@verizon.net   aslanspirit

Mon Oct 3, 2011 3:53 pm (PDT)



I know it sounds strange, but I am constructing a demonstration of the power of Excel as one way to demo some excel modeling to potential employer. It's usefulness to me is in illustrating how Excel can be used for the web and once data is pulled down.

In other cases, I like to do research on companies and funds for investing, which is more of a secondary objective for this example.

The first case is the usefulness of Excel, the secnd case, the intrinsic data is what I am after.

Hope this clarifies my creative endeavor.

Regards,
Robb

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That's why I said no easy way -- you'd have to grab them page by page, 20 at
> a time.
>
> Why do you even need them?
>
> On Mon, Oct 3, 2011 at 3:35 PM, RobbR <robbrafferty@...> wrote:
>
> > Really good stuff.
> > I see the starting or landing page.
> > So, just trying to get my head around the process, can you give some
> > direction on how to utilize SMF query to get all US Names-Tickers
> >
> > I ahve used SMF to pull indidual stock quotes as well as finanical data,
> > but not clear on how to pull down 71000 names into a spreadsheet.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
1e.

Re: List of All Companies from Yahoo

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Oct 3, 2011 4:21 pm (PDT)



I see no reason to know about all of the available companies for any of
those purposes.

You should use a simple screening product to determine which companies to do
further research on. There's no way you can do ANY research with the add-in
on 71000 companies. It's meant for ad hoc data retrieval, not for building
databases. Besides, the vast majority of those companies won't even have the
same data items available.

In any case, your general formula to get the ticker symbols would be
something like:

=RCHGetTableCell("http://finance.yahoo.com/lookup/stocks?s=**&t=S&m=US&r=&b="&B2,1,">Last
Trade",,,,C2)

...where B2 iterates as 0, 20, 40, etc (i.e. each page of 20 companies) and
C2 iterates from 1 to 20 within each iteration of B2 (i.e. the 20 companies
on each page).

However, the add-in only allows access to 1000 web pages per "session" (see
the smfForceRecalculation item in the "Links" area of the group for more
info), so you can't just create formulas for all 71000 companies in one
worksheet and get them all at one time. You would need to retrieve nearly
3600 web pages to get the data -- and that's going to be slow.

On Mon, Oct 3, 2011 at 3:53 PM, RobbR <robbrafferty@verizon.net> wrote:

> I know it sounds strange, but I am constructing a demonstration of the
> power of Excel as one way to demo some excel modeling to potential employer.
> It's usefulness to me is in illustrating how Excel can be used for the web
> and once data is pulled down.
>
> In other cases, I like to do research on companies and funds for investing,
> which is more of a secondary objective for this example.
>
> The first case is the usefulness of Excel, the secnd case, the intrinsic
> data is what I am after.
>
> Hope this clarifies my creative endeavor.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
1f.

Re: List of All Companies from Yahoo

Posted by: "RobbR" robbrafferty@verizon.net   aslanspirit

Mon Oct 3, 2011 6:43 pm (PDT)



Thank you, you are coorect it woulde very slow and I see the add hoc nature of SMF. I am going to reasess.

Thanks,
Robb

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I see no reason to know about all of the available companies for any of
> those purposes.
>
> You should use a simple screening product to determine which companies to do
> further research on. There's no way you can do ANY research with the add-in
> on 71000 companies. It's meant for ad hoc data retrieval, not for building
> databases. Besides, the vast majority of those companies won't even have the
> same data items available.
>
> In any case, your general formula to get the ticker symbols would be
> something like:
>
> =RCHGetTableCell("http://finance.yahoo.com/lookup/stocks?s=**&t=S&m=US&r=&b="&B2,1,">Last
> Trade",,,,C2)
>
> ...where B2 iterates as 0, 20, 40, etc (i.e. each page of 20 companies) and
> C2 iterates from 1 to 20 within each iteration of B2 (i.e. the 20 companies
> on each page).
>
> However, the add-in only allows access to 1000 web pages per "session" (see
> the smfForceRecalculation item in the "Links" area of the group for more
> info), so you can't just create formulas for all 71000 companies in one
> worksheet and get them all at one time. You would need to retrieve nearly
> 3600 web pages to get the data -- and that's going to be slow.
>
> On Mon, Oct 3, 2011 at 3:53 PM, RobbR <robbrafferty@...> wrote:
>
> > I know it sounds strange, but I am constructing a demonstration of the
> > power of Excel as one way to demo some excel modeling to potential employer.
> > It's usefulness to me is in illustrating how Excel can be used for the web
> > and once data is pulled down.
> >
> > In other cases, I like to do research on companies and funds for investing,
> > which is more of a secondary objective for this example.
> >
> > The first case is the usefulness of Excel, the secnd case, the intrinsic
> > data is what I am after.
> >
> > Hope this clarifies my creative endeavor.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2a.

Help - Need Breakdown on ROE - Utilizing the Dupont Model

Posted by: "shadowemailclone" shadowemailclone@yahoo.com   shadowemailclone

Mon Oct 3, 2011 7:58 am (PDT)



Hi all,

I am having an issue with the Morningstar Key ratios excel file.
I sometimes use it to get the various profitability ratios and how they have changed over time. Problem is that only have the worksheet wants to work right now.

I would love to have an excel spreadsheet that not only gets the metrics and ratios from this site, but the graphs as well.

Any ideas?

Thanks.

Scott

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: Help - Need Breakdown on ROE - Utilizing the Dupont Model

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Oct 3, 2011 10:40 am (PDT)



Sorry, but MorningStar has been changing their pages to be dynamic delivery
of the data. The add-in extracts data from the source code of the web page,
so when it is dynamically displayed, the add-in no longer has access to the
data. You'll need to use a different source of the ratios.

As long as the image URL is under 99 bytes, you can bring in graphs using
the RCHCreateComment() function.

On Mon, Oct 3, 2011 at 7:58 AM, shadowemailclone <shadowemailclone@yahoo.com
> wrote:

>
> I am having an issue with the Morningstar Key ratios excel file.
> I sometimes use it to get the various profitability ratios and how they
> have changed over time. Problem is that only have the worksheet wants to
> work right now.
>
> I would love to have an excel spreadsheet that not only gets the metrics
> and ratios from this site, but the graphs as well.
>
> Any ideas?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Industry comparison ratios definition, where can I get a definition

Posted by: "cy.dufort" cy.dufort@yahoo.com   cy.dufort

Mon Oct 3, 2011 10:35 am (PDT)



I'm trying to better understand the following ratios..

where can I find documentation to explains how these ratios are calculated?

Thanks

YCD

Financial Ratios -- Industry Comparison Ratios -- % of Sales-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Earnings-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of EPS-to-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Price-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of PE-to-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Price/Book-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Price/Sales-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Price/Cashflow-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Pric/Free Cashlow-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Debt/Equity-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Current Ratio-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Gross Profit Margin-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Pre-Tax Profit Margin-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Post-Tax Profit Margin-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Net Profit Margin-To-Industry
Financial Ratios -- Industry Comparison Ratios -- % of ROE-to-Industry
Financial Ratios -- Industry Comparison Ratios -- % of Leverage-To-Industry

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.

Re: Industry comparison ratios definition, where can I get a definit

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Oct 3, 2011 10:43 am (PDT)



You'd have to go to the source of the data. For most elements, you can use
"Source" and "P-URL" in place of the ticker symbol in the
RCHGetElementNumber() function to get the general source and the specific
web page address that the data element is extracted from.

On Mon, Oct 3, 2011 at 7:15 AM, cy.dufort <cy.dufort@yahoo.com> wrote:

> I'm trying to better understand the following ratios..
>
> where can I find documentation to explains how these ratios are calculated?
>
> Financial Ratios -- Industry Comparison Ratios -- % of Sales-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of Earnings-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of EPS-to-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of Price-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of PE-to-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of
> Price/Book-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of
> Price/Sales-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of
> Price/Cashflow-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of Pric/Free
> Cashlow-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of
> Debt/Equity-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of Current
> Ratio-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of Gross Profit
> Margin-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of Pre-Tax Profit
> Margin-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of Post-Tax Profit
> Margin-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of Net Profit
> Margin-To-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of ROE-to-Industry
> Financial Ratios -- Industry Comparison Ratios -- % of Leverage-To-Industry
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: Equtiy CUSIP lookup

Posted by: "scottandrewjackson" scottandrewjackson@yahoo.com   scottandrewjackson

Mon Oct 3, 2011 2:29 pm (PDT)



Randy is there any way to pull the CUSIP number using the RCHgettable function? I tried and am coming up with no results.

Best

Scott

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> This:
>
> =smfGetTagContent("
> http://quantumonline.com/search.cfm?sopt=symbol&1.0.1=Search&tickersymbol=
> "&D2,"b",-1,"CUSIP:")
>
> ...should get you something like this, from which you can extract the CUSIP:
>
> Ticker Symbol: IBM CUSIP: 459200101 Exchange: NYSE
>
> For example, if you were using the latest beta version of the add-in from
> the "Works in Progress" folder:
>
> =smfStrExtr(smfGetTagContent("
> http://quantumonline.com/search.cfm?sopt=symbol&1.0.1=Search&tickersymbol=
> "&D2,
> "b",-1,"CUSIP:"),"CUSIP: "," ")
>
> On Fri, Sep 30, 2011 at 8:57 AM, john.sitarz <john.sitarz@...> wrote:
>
> > Is there anyway to get cusip info from this website
> > http://quantumonline.com/search.cfm
> >
> > I need to be able to lookup the CUSIP info by ticker.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4b.

Re: Equtiy CUSIP lookup

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Oct 3, 2011 3:00 pm (PDT)



Only if you have a data source that has the data in a table that the add-in
can extract the data from...

I had to use the smfGetTagContent() function on the QuantumOnline site
because they didn't have the data in an HTML table.

On Mon, Oct 3, 2011 at 2:29 PM, scottandrewjackson <
scottandrewjackson@yahoo.com> wrote:

> Randy is there any way to pull the CUSIP number using the RCHgettable
> function? I tried and am coming up with no results.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
5a.

Re: List of All  Companies from Yahoo

Posted by: "RobbR" robbrafferty@verizon.net   aslanspirit

Mon Oct 3, 2011 3:36 pm (PDT)



Very helpful. Good manual list.

Robb

--- In smf_addin@yahoogroups.com, "Ralph" <ralph.bagwell@...> wrote:
>
>
>
> This might work.
>
> Go here:
>
> http://www.americanbulls.com/StockList.asp?MarketTicker=AMEX&Tick=A .
>
> You can get all if you select each letter tab . If you have Adobe Acrobat which can create a PDF - select multilevel - or "whole site" . I haven't done this nor do I see why anyone would ( like Randy said ) but it might get you what you want.
>
> --- In smf_addin@yahoogroups.com, "Robb Rafferty" <robbrafferty@> wrote:
> >
> >
> >
> > Is there a template or some other method for obtaining ALL listed Companies in Yahoo, name and ticker.
> >
> > I searched messages but could not find anything.
> >
> > I see there is a similar list from from finviz in files section.
> >
> > Thanks,
> > Robb
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
6.

Recording each and every price stamp in a new row from a stream

Posted by: "Farhan Ansari" farhan86a@gmail.com   farsdocs

Tue Oct 4, 2011 3:01 am (PDT)



Hi all,

I had a query not related to the SMF Add-in (all praise to Randy and I
apologize to the group to ask an off topic question). But does any body know
how to record the data from a real-time steam. For e.g. the Google real-time
display of a stock price can be imported to Excel and with the auto-refresh
code the price can be made to appear updating on a real-time basis. However,
can there be any code in excel to auto record each and every price stamp in
a new row out of that stream?

Apologize again group and thanks.

-Farhan
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 03.54

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)