Selasa, 20 Desember 2011

[smf_addin] Digest Number 2052

Messages In This Digest (8 Messages)

1a.
Re: Legal Issue - discussed only once before From: msimmsx
2a.
Re: Extracting Data From Yahoo From: bushpilote@yahoo.ca
3a.
Softball of a question From: nickvanbrigman
3b.
Re: Softball of a question From: Randy Harmelink
4a.
Short interest From: Frank
4b.
Re: Short interest From: Randy Harmelink
4c.
Re: Short interest From: Steven Sun
5a.
Re: Nasdaq number of 52 week highs, lows, total From: investor952

Messages

1a.

Re: Legal Issue - discussed only once before

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

Mon Dec 19, 2011 3:15 am (PST)



Mike - thanks for that response...it does make sense to me. And as long as the Yahoo Terms of Service applies specifically to their software modules and the posting of their data on another entities website, I think this puts the matter to rest.
Finally, If the data was proprietary, they would have password protected it and sold it on a subscription basis. Instead, they've given it away in return for marketing and promotional reasons....which is consistent with many web business models.

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> 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
>

2a.

Re: Extracting Data From Yahoo

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

Mon Dec 19, 2011 4:19 am (PST)



Good to know. Thanks and best wishes for the holidays.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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?
> >
>

3a.

Softball of a question

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

Mon Dec 19, 2011 7:38 am (PST)



Randy, Back to tinkering with an old file of mine as I look to balance of gains and losses for the year. My google values have stopped working. Saw several threads and it looks like Google is a bit of a pain.

Is there a downloadable fix for google to correct URL's and such? OR am I better off to remap values I was plucking to AdvFN-Q and AdvFN-Y values?

Looks like most everything is here.
If I do use the AdvFN-Q, are the twenty quarters sequenced by the last trailing twenty quarters or aligned by last five fiscal years? I guess I can always test. Thanks again for all you work on this . You have become an institution.

3b.

Re: Softball of a question

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

Mon Dec 19, 2011 7:40 am (PST)



There is an update for Google element definitions in the "Works in
Progress" folder.

As far as I know, *ALL* sources have quarterly data for the trailing
quarter, not aligned on the fiscal years.

On Mon, Dec 19, 2011 at 8:11 AM, nickvanbrigman <nickvanbrigman@yahoo.com>wrote:

> Randy, Back to tinkering with an old file of mine as I look to balance of
> gains and losses for the year. My google values have stopped working. Saw
> several threads and it looks like Google is a bit of a pain.
>
> Is there a downloadable fix for google to correct URL's and such? OR am I
> better off to remap values I was plucking to AdvFN-Q and AdvFN-Y values?
>
> Looks like most everything is here.
> If I do use the AdvFN-Q, are the twenty quarters sequenced by the last
> trailing twenty quarters or aligned by last five fiscal years? I guess I
> can always test. Thanks again for all you work on this . You have become
> an institution.
>
4a.

Short interest

Posted by: "Frank" fwkirk@gmail.com   nautilustech

Mon Dec 19, 2011 8:27 am (PST)



Can someone tell me the element number for short interest? I've looked through the element definition list until my eyes are starting to go around in circles. I'm sure there's one there; just can't find it.

Many thanks.

4b.

Re: Short interest

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

Mon Dec 19, 2011 8:33 am (PST)



From the Yahoo Key Statistics page:

*#* *Source* *Element* 985 YahooKS Shares Short -- Current 986 YahooKS Short
Ratio 987 YahooKS Short % of Float 988 YahooKS Shares Short -- Prior
You can get the history of the short interest from the NASDAQ web site:

=RCHGetHTMLTable("http://www.nasdaq.com/symbol/mmm/short-interest
",">Settlement",-1,"",1)

On Mon, Dec 19, 2011 at 9:27 AM, Frank <fwkirk@gmail.com> wrote:

> Can someone tell me the element number for short interest? I've looked
> through the element definition list until my eyes are starting to go around
> in circles. I'm sure there's one there; just can't find it.
>
4c.

Re: Short interest

Posted by: "Steven Sun" ssun24cd@gmail.com   ssun_tdam

Mon Dec 19, 2011 8:41 am (PST)



985

On Mon, Dec 19, 2011 at 11:27 AM, Frank <fwkirk@gmail.com> wrote:

> **
>
>
> Can someone tell me the element number for short interest? I've looked
> through the element definition list until my eyes are starting to go around
> in circles. I'm sure there's one there; just can't find it.
>
> Many thanks.
>
>
>
5a.

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

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

Mon Dec 19, 2011 11:37 pm (PST)



Thanks Randy..

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> http://unicorn.us.com/advdec
>
> On Sun, Dec 18, 2011 at 7:41 PM, investor952 <investor952@...> 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.
> >
>

Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

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.

Tidak ada komentar:

Posting Komentar