Minggu, 02 Desember 2012

[smf_addin] Digest Number 2419

8 New Messages

Digest #2419

Messages

Sat Dec 1, 2012 5:16 am (PST) . Posted by:

"yp_chandler" yp_chandler


Thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Keyboard shortcut is alt+d+d+w. It brings up the IE object that EXCEL uses.
> Usually this matches the version of th external browser version of IE, but
> not always. That why I say the EXCEL Web Query dialog is preferred.
>
> Note that you can only be logged in from one browser/object at a time. Most
> of the time, IBD logs you out of an existing session if you start up a new
> session with a different program.
>
> On Fri, Nov 23, 2012 at 8:39 PM, yp_chandler <ferozma@...> wrote:
>
> >
> > It seems to be flaky because it started to work again after I posted this
> > message and now its back to showing an error (although i'm logged in on IBD
> > through IE). BTW, what is 'excel web query dialog'? Can you point me on how
> > to do this 'preferred' method?
> >
>

Sat Dec 1, 2012 7:34 am (PST) . Posted by:

"oryxius" oryxius

Does any one know where one could get the insider ownership percentages for the past four quarters?

Sat Dec 1, 2012 8:49 pm (PST) . Posted by:

"bozo" calhandon

> Does anyone know where one could get the insider ownership

percentages for the past four quarters?

Watch your numbers, as they may or may not include large individual
stakeholders (> 5%). I would suggest you start at the company's Investor
Relations web page, or email the Investor Relations contact.

You might also try ...

http://www.insider-monitor.com/search.html

http://www.insidermonkey.com/

... or a Google search, something like ...

"insider ownership" mcd (with the quotes)

... or the regular Financial sites ...

http://finance.yahoo.com/q/ir?s=MCD+Insider+Roster (replace "MCD")

http://www.nasdaq.com/symbol/mcd/insider-trades (replace "mcd")

http://investing.money.msn.com/investments/institutional-ownership?symbol=mc
d (replace "mcd")

http://investing.businessweek.com/research/stocks/ownership/ownership.asp?ti
cker=MCD (replace "MCD")

http://research.scottrade.com/qnr/Public/Stocks/Insiders?symbol=MCD
(replace "MCD")

etc.

As a last resort, look up the "Form 4" filings with the SEC, or at an
EdgarOnline data distributor such as ...

http://google.brand.edgar-online.com/?sym=MCD (replace "MCD")

http://research.scottrade.com/qnr/Public/Stocks/SECFilings?symbol=MCD
(replace "MCD")

... but you will need to figure out the totals manually.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of oryxius
Sent: Saturday, December 01, 2012 8:35 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Historical info on insider ownership

Does any one know where one could get the insider ownership percentages for
the past four quarters?

Sun Dec 2, 2012 12:53 am (PST) . Posted by:

"oryxius" oryxius


Thank you for the suggestions and the warning on large individual stakeholders. I did notice that some sites have different numbers for the insiders which puzzled me, and I think your note could explain the disparity. But why would they not include these individuals (with stakes > 5%) if they are insiders?

Best,

Moe

--- In smf_addin@yahoogroups.com, "bozo" <bozo@...> wrote:
>
> > Does anyone know where one could get the insider ownership
>
> percentages for the past four quarters?
>
>
>
> Watch your numbers, as they may or may not include large individual
> stakeholders (> 5%). I would suggest you start at the company's Investor
> Relations web page, or email the Investor Relations contact.
>
>
>
> You might also try ...
>
>
>
> http://www.insider-monitor.com/search.html
>
>
>
> http://www.insidermonkey.com/
>
>
>
>
>
> ... or a Google search, something like ...
>
> "insider ownership" mcd (with the quotes)
>
>
>
>
>
> ... or the regular Financial sites ...
>
>
>
> http://finance.yahoo.com/q/ir?s=MCD+Insider+Roster (replace "MCD")
>
>
>
> http://www.nasdaq.com/symbol/mcd/insider-trades (replace "mcd")
>
>
>
>
> http://investing.money.msn.com/investments/institutional-ownership?symbol=mc
> d (replace "mcd")
>
>
>
>
> http://investing.businessweek.com/research/stocks/ownership/ownership.asp?ti
> cker=MCD (replace "MCD")
>
>
>
> http://research.scottrade.com/qnr/Public/Stocks/Insiders?symbol=MCD
> (replace "MCD")
>
>
>
> etc.
>
>
>
>
>
> As a last resort, look up the "Form 4" filings with the SEC, or at an
> EdgarOnline data distributor such as ...
>
>
>
> http://google.brand.edgar-online.com/?sym=MCD (replace "MCD")
>
>
>
> http://research.scottrade.com/qnr/Public/Stocks/SECFilings?symbol=MCD
> (replace "MCD")
>
>
>
> ... but you will need to figure out the totals manually.
>
>
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of oryxius
> Sent: Saturday, December 01, 2012 8:35 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Historical info on insider ownership
>
>
>
>
>
> Does any one know where one could get the insider ownership percentages for
> the past four quarters?
>

Sat Dec 1, 2012 10:55 am (PST) . Posted by:

"ddbohrer" ddbohrer

I can use the various functions and get them to work. However,when I try to use any of the templates or files I get the following error message response

#name? query response

I was using the following template but get the same message for other files.

smfGetAdvFNElement-Template-All-Line-Items

Thanks
Daryll

Sat Dec 1, 2012 11:19 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Check out the location errors item in the LINKS area of the group. You need
to fix unresolved links.

On Sat, Dec 1, 2012 at 11:55 AM, ddbohrer <ddbohrer@gmail.com> wrote:

> I can use the various functions and get them to work. However,when I try
> to use any of the templates or files I get the following error message
> response
>
> #name? query response
>
> I was using the following template but get the same message for other
> files.
>
> smfGetAdvFNElement-Template-All-Line-Items
>

Sun Dec 2, 2012 3:50 am (PST) . Posted by:

"oryxius" oryxius

Hello Randy,

I am trying to extract a table of the recent insider trades from www.insidertrading.org. I have been able to do so using the following array table link:

=RCHGetHTMLTable("http://insidertrading.org/?sort_by=acceptance_datetime&asc=&symbol="&A1&"&date_from=2012-11-01&date_to=2012-12-02&submit=+GO+","clear:both",1,"center;margin",-1)

Where I replaced the ticker symbol with "&A1&". But when I tried to replace the dates with references to cells with self-updating dates, the link did not work. Is it possible to do this at all?

Sun Dec 2, 2012 3:57 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Sure. If cell B1 contains an EXCEL serial date, you'd just use something
like:

TEXT(B1,"yyyy-mm-dd")

...as a replacement for the date in the URL. But it wouldn't do any good to
format the content of cell B1 as yyyy-mm-dd and then try to concatenate it.
It would still just concatenate the value of cell B1, which is a 5-digit
number.

I'm just guessing where you may have gone wrong...

On Sun, Dec 2, 2012 at 4:50 AM, oryxius <oryxius@yahoo.com> wrote:

>
> I am trying to extract a table of the recent insider trades from
> www.insidertrading.org. I have been able to do so using the following
> array table link:
>
> =RCHGetHTMLTable("
> http://insidertrading.org/?sort_by=acceptance_datetime&asc=&symbol=
> "&A1&"&date_from=2012-11-01&date_to=2012-12-02&submit=+GO+","clear:both",1,"center;margin",-1)
>
> Where I replaced the ticker symbol with "&A1&". But when I tried to
> replace the dates with references to cells with self-updating dates, the
> link did not work. Is it possible to do this at all?
>
Diposting oleh EXCEL FEED LEARNING di 03.57

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)