Senin, 19 Desember 2011

[smf_addin] Digest Number 2051

Messages In This Digest (19 Messages)

Messages

1a.

Re: Extracting Data From Yahoo

Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca   bushpilote

Sun Dec 18, 2011 5:04 am (PST)



Thank you all for your responses.

Randy, regarding the institutional transaction how did you determine the anchors ("Net Institutional Purchases",">Net Shares Purchased<br>(Sold)<") and their sequence in the formula?


--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try something like:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/it?s="&Ticker,1,">Net Shares
> Purchased",">Net Shares Purchased",,,,,,"--")
> =smfGetTagContent("http://finance.yahoo.com/q?s=
> "&Ticker,"h2",1,"class=""title""")
>
> On Fri, Dec 16, 2011 at 6:00 AM, <bushpilote@...> wrote:
>
> > Good morning Randy,
> > I'd appreciate your help on the following two issues:
> >
> > 1. Extracting Insider Transactions From Yahoo
> > I've been able to extract all of the information on the page except the
> > net for institutional investors. I've tried all variarions of the this
> > formula : =RCHGetTableCell("http://finance.yahoo.com/q/it?s="&ticker,1,"Net
> > Institutional Purchases",">Net Shares Purchased<br>(Sold)<",,,,,,,"--")with
> > no success.
> >
> > 2. Company Name
> > I've been extracting a company's full name with =smfGetTagContent("
> > http://finance.yahoo.com/q?s="&$B1,"h2",4,"class=","title")where B1 is
> > the ticker symbol.However of late I need to keep changing the number 4 in
> > the formula daily to get it to work. The number ranges from 1 to 4.
> >
> > Thanks
> >
>

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

Re: Extracting Data From Yahoo (Correction to my previous post)

Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca   bushpilote

Sun Dec 18, 2011 5:34 am (PST)



I meant the anchors: [">Net Shares Purchased",">Net Shares Purchased"]

Sorry for the confusion.

--- In smf_addin@yahoogroups.com, bushpilote@... wrote:
>
> Thank you all for your responses.
>
> Randy, regarding the institutional transaction how did you determine the anchors ("Net Institutional Purchases",">Net Shares Purchased<br>(Sold)<") and their sequence in the formula?
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Try something like:
> >
> > =RCHGetTableCell("http://finance.yahoo.com/q/it?s="&Ticker,1,">Net Shares
> > Purchased",">Net Shares Purchased",,,,,,"--")
> > =smfGetTagContent("http://finance.yahoo.com/q?s=
> > "&Ticker,"h2",1,"class=""title""")
> >
> > On Fri, Dec 16, 2011 at 6:00 AM, <bushpilote@> wrote:
> >
> > > Good morning Randy,
> > > I'd appreciate your help on the following two issues:
> > >
> > > 1. Extracting Insider Transactions From Yahoo
> > > I've been able to extract all of the information on the page except the
> > > net for institutional investors. I've tried all variarions of the this
> > > formula : =RCHGetTableCell("http://finance.yahoo.com/q/it?s="&ticker,1,"Net
> > > Institutional Purchases",">Net Shares Purchased<br>(Sold)<",,,,,,,"--")with
> > > no success.
> > >
> > > 2. Company Name
> > > I've been extracting a company's full name with =smfGetTagContent("
> > > http://finance.yahoo.com/q?s="&$B1,"h2",4,"class=","title")where B1 is
> > > the ticker symbol.However of late I need to keep changing the number 4 in
> > > the formula daily to get it to work. The number ranges from 1 to 4.
> > >
> > > Thanks
> > >
> >
>

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

Re: Extracting Data From Yahoo

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

Sun Dec 18, 2011 7:48 am (PST)



I knew "<br>" would no longer be there, because the add-in converts those
to carriage return/line feed characters, so that text will be displayed
properly in EXCEL. The add-in converts a lot of "special characters" found
on the web page.

I usually go for shorter than longer, and rarely will include any HTML tags
other than the ending ">" or the beginning "<".

On Sun, Dec 18, 2011 at 6:04 AM, <bushpilote@yahoo.ca> wrote:

>
> Randy, regarding the institutional transaction how did you determine the
> anchors ("Net Institutional Purchases",">Net Shares Purchased<br>(Sold)<")
> and their sequence in the formula?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
2a.

Zacks Indust and Sector

Posted by: "craig" craigmorris@yahoo.com   craigmorris

Sun Dec 18, 2011 7:46 am (PST)



In the files section, if the file Zacks Sector and Industry Groups is "clicked", does it download the latest data, or data from a point sometime in the past?

Thans

Craig

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

Re: Zacks Indust and Sector

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

Sun Dec 18, 2011 7:50 am (PST)



It was a snapshot at a given point in time, because someone was having
difficulties getting data from the Zacks screener. However, it's a lot
easier now. Do a search on the message archives and you should be able to
find it.

FinViz is another option.

On Sun, Dec 18, 2011 at 4:20 AM, craig <craigmorris@yahoo.com> wrote:

> In the files section, if the file Zacks Sector and Industry Groups is
> "clicked", does it download the latest data, or data from a point sometime
> in the past?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Legal Issue - discussed only once before

Posted by: "msimmsx" marksimms@verizon.net   msimmsx

Sun Dec 18, 2011 11:44 am (PST)



From.... Yahoo Terms of Service <http://finance.yahoo.com/badges/tos>

I believe this is the key clause (below) that would permit this addin
from essentially clipping the data without violating these terms.

Yahoo!'s rights apply to the Yahoo! Finance Modules and all output and
executables of the Yahoo! Finance Modules, excluding any software
components developed by you which do not themselves incorporate the
Yahoo! Finance Modules or any output or executables of the Yahoo!
Finance Modules.

Am I correct ? Any lawyers on this list ?

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

Re: Legal Issue - discussed only once before

Posted by: "msimmsx" marksimms@verizon.net   msimmsx

Sun Dec 18, 2011 6:47 pm (PST)



>
> From.... Yahoo Terms of Service <http://finance.yahoo.com/badges/tos>
>
> I believe this is the key clause (below) that would permit this addin
> from essentially clipping the data without violating these terms.
>
> Yahoo!'s rights apply to the Yahoo! Finance Modules and all output and
> executables of the Yahoo! Finance Modules, excluding any software
> components developed by you which do not themselves incorporate the
> Yahoo! Finance Modules or any output or executables of the Yahoo!
> Finance Modules.
>
Anyone with an opinion on this ? Anyone ?

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

Re: Legal Issue - discussed only once before

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Sun Dec 18, 2011 7:45 pm (PST)



I don't know what your point is. The SMF is clearly legal and needs no
authority from any website. It's basically a fancy "screen scraper" and
these types of things have been used for decades (even pre-internet) for
various purposes. They basically just automate the process of reading
something and writing it down manually - there is nothing illegal about
that.

In fact, Excel has a WEB Query function to automatically retrieve data from
sites too - it's just Randy's is much nicer to use.

If Randy was extracting data and repackaging that on his own website and
offering that data for sale, well, that's a bit different. But, that isn't
at all what he is doing. Heck, he isn't even charging for SMF (even though
he could).

Signed:
Old software entrepreneur and executive


_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of msimmsx
Sent: Sunday, December 18, 2011 9:47 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Legal Issue - discussed only once before

>
> From.... Yahoo Terms of Service <http://finance.yahoo.com/badges/tos>
>
> I believe this is the key clause (below) that would permit this addin
> from essentially clipping the data without violating these terms.
>
> Yahoo!'s rights apply to the Yahoo! Finance Modules and all output and
> executables of the Yahoo! Finance Modules, excluding any software
> components developed by you which do not themselves incorporate the
> Yahoo! Finance Modules or any output or executables of the Yahoo!
> Finance Modules.
>
Anyone with an opinion on this ? Anyone ?

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

Info Beyond Stock Data

Posted by: "Gregory Foster" gfoster07k@sbcglobal.net   gfoster07k@sbcglobal.net

Sun Dec 18, 2011 3:03 pm (PST)





Just a note to thank all who responded to my inquiry.  It sounds like there is lots of potential and I will try all the recommendations.  I'm sure I will come out ahead.  Thanks again.
 
Greg

"Habit is habit, and not to be flung out the window by any man, but to be coaxed downstairs one step at a time." Mark Twain
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
5a.

S&P 500 member stocks

Posted by: "KailuaKid" Gary.Hartling@gmail.com   garyhartling

Sun Dec 18, 2011 4:48 pm (PST)



Is there a formula to find out if a particular stock is a member of the S&P 500 stock market index?

Thx,
Gary

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

Re: S&P 500 member stocks

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

Sun Dec 18, 2011 5:20 pm (PST)



Try something like:

=NOT(ISERROR(FIND("S&P500",RCHGetTableCell("
http://finviz.com/quote.ashx?t=MMM",1,">Index")))
=NOT(ISERROR(FIND("DJIA",RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM
",1,">Index"))))

On Sun, Dec 18, 2011 at 5:48 PM, KailuaKid <Gary.Hartling@gmail.com> wrote:

> Is there a formula to find out if a particular stock is a member of the
> S&P 500 stock market index?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5c.

Re: S&P 500 member stocks

Posted by: "KailuaKid" Gary.Hartling@gmail.com   garyhartling

Sun Dec 18, 2011 5:32 pm (PST)



Thanks!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try something like:
>
> =NOT(ISERROR(FIND("S&P500",RCHGetTableCell("
> http://finviz.com/quote.ashx?t=MMM",1,">Index")))
> =NOT(ISERROR(FIND("DJIA",RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM
> ",1,">Index"))))
>
> On Sun, Dec 18, 2011 at 5:48 PM, KailuaKid <Gary.Hartling@...> wrote:
>
> > Is there a formula to find out if a particular stock is a member of the
> > S&P 500 stock market index?
> >
>

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

Re: S&P 500 member stocks

Posted by: "KailuaKid" Gary.Hartling@gmail.com   garyhartling

Sun Dec 18, 2011 5:56 pm (PST)





Actually, for it to work right, the formula should include an extra space, instead of "S&P500" it should be "S&P 500". --gh

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try something like:
>
> =NOT(ISERROR(FIND("S&P500",RCHGetTableCell("
> http://finviz.com/quote.ashx?t=MMM",1,">Index")))
> =NOT(ISERROR(FIND("DJIA",RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM
> ",1,">Index"))))
>
> On Sun, Dec 18, 2011 at 5:48 PM, KailuaKid <Gary.Hartling@...> wrote:
>
> > Is there a formula to find out if a particular stock is a member of the
> > S&P 500 stock market index?
> >
>

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

Re: S&P 500 member stocks

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

Sun Dec 18, 2011 6:15 pm (PST)



They must have it mixed then, because ticker MMM had no space -- maybe just
use "S&P" or "500". I think FinViz only carried the two indexes.

On Sun, Dec 18, 2011 at 6:56 PM, KailuaKid <Gary.Hartling@gmail.com> wrote:

>
> Actually, for it to work right, the formula should include an extra space,
> instead of "S&P500" it should be "S&P 500". --gh
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5f.

Re: S&P 500 member stocks

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Sun Dec 18, 2011 6:21 pm (PST)



I'd suggest "500" then. S&P has other indexes (Mid-Cap, Small-Cap, etc) so
if FinViz ever starts identifying those you won't find them if you just use
"S&P"

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy Harmelink
Sent: Sunday, December 18, 2011 9:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: S&P 500 member stocks

They must have it mixed then, because ticker MMM had no space -- maybe just
use "S&P" or "500". I think FinViz only carried the two indexes.

On Sun, Dec 18, 2011 at 6:56 PM, KailuaKid <Gary.Hartling@gmail.com> wrote:

Actually, for it to work right, the formula should include an extra space,
instead of "S&P500" it should be "S&P 500". --gh

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

Nasdaq number of 52 week highs, lows, total

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

Sun Dec 18, 2011 6:41 pm (PST)



Can someone point me to where I can get a DAILY HISTORY of these values?..not just the current value...say for the past year? Thx. I am looking for the number of issues in the nasdaq index that make new highs and lows ..and (total number of elements)..daily..for the past year.

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

Re: Nasdaq number of 52 week highs, lows, total

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

Sun Dec 18, 2011 7:11 pm (PST)



http://unicorn.us.com/advdec

On Sun, Dec 18, 2011 at 7:41 PM, investor952 <investor952@yahoo.com> wrote:

> Can someone point me to where I can get a DAILY HISTORY of these
> values?..not just the current value...say for the past year? Thx. I am
> looking for the number of issues in the nasdaq index that make new highs
> and lows ..and (total number of elements)..daily..for the past year.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

Extracting Data for Multiple Companies

Posted by: "craig" craigmorris@yahoo.com   craigmorris

Sun Dec 18, 2011 10:26 pm (PST)



Randi

I can now get the following:
=smfGetTagContent("http://www.sec.gov/cgi-bin/browse-edgar?Find=Find+Companies&action=getcompany&CIK=ibm", "a",1,">SIC")

to return 3570.

But after reading the files etc, I am unsure how to get data for multiple companies. I thoght I could list the companies in column "A" and get the SIC code in column "B". But I need some help to get there.
All help is appreciated.
Thanks

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

Re: Extracting Data for Multiple Companies

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

Sun Dec 18, 2011 11:50 pm (PST)



Just do normal EXCEL string concatenation when creating the URL. For
example:

="...string1..."&A1
="...string1..."&A1&"...string2..."
=A1&"...string2..."
=A1&"...string1..."&B1

On Sun, Dec 18, 2011 at 11:26 PM, craig <craigmorris@yahoo.com> wrote:

>
> I can now get the following:
> =smfGetTagContent("
> http://www.sec.gov/cgi-bin/browse-edgar?Find=Find+Companies&action=getcompany&CIK=ibm",
> "a",1,">SIC")
>
> to return 3570.
>
> But after reading the files etc, I am unsure how to get data for multiple
> companies. I thoght I could list the companies in column "A" and get the
> SIC code in column "B". But I need some help to get there.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

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 02.20

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)