15 Messages
Digest #3011
Messages
Thu Mar 20, 2014 4:54 am (PDT) . Posted by:
"vijay gangrade" vijay_gangrade
Dear Sir,
Your previous suggestions worked wonderfully for me. Thank you so much for that. It made my work a lot easier.
I
didn't find any source from where I can get the Historical Shareholding
Patterns/Ownership Summary/Major Holders for the the companies listed
in Nasdaq and NYSE. I was wondering if you know some pointers and can share them with me.
Also
I noticed that we don't have any plugin for shareholding pattern like
we have for advfn results and other data. I would like to give something
back to the community and can share whatever I develop with the group.
Please let me know your thoughts. I really appreciate it.
Thanks & Regards,Vijay Gangrade
Your previous suggestions worked wonderfully for me. Thank you so much for that. It made my work a lot easier.
I
didn't find any source from where I can get the Historical Shareholding
Patterns/Ownership Summary/Major Holders for the the companies listed
in Nasdaq and NYSE. I was wondering if you know some pointers and can share them with me.
Also
I noticed that we don't have any plugin for shareholding pattern like
we have for advfn results and other data. I would like to give something
back to the community and can share whatever I develop with the group.
Please let me know your thoughts. I really appreciate it.
Thanks & Regards,Vijay Gangrade
Thu Mar 20, 2014 5:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There are three templates based on ownership:
RCHGetTableCell-Template-Reuters-Insider-Transactions.xls
RCHGetTableCell-Template-Morningstar-Top-Stock-Holders.xls
RCHGetTableCell-Template-Morningstar-Top-20-Stock-Holders.xls
NASDAQ appears to have the most comprehensive:
http://www.nasdaq.com/symbol/mmm/ownership-summary
http://www.nasdaq.com/symbol/mmm/institutional-holdings
http://www.nasdaq.com/symbol/mmm/insider-trades
It depends so much on what you're looking for. MorningStar and Yahoo both
have a lot of data. For example, you can get the insider trades for the
past 2 years from Yahoo with:
=RCHGetHTMLTable("http://finance.yahoo.com/q/it?s=MMM","Insider
Transactions Reported",-1,"",2)
On Thu, Mar 20, 2014 at 4:54 AM, vijay gangrade <vijay_gangrade@yahoo.com>wrote:
>
> I didn't find any source from where I can get the Historical Shareholding
> Patterns/Ownership Summary/Major Holders for the the companies listed in
> Nasdaq and NYSE. I was wondering if you know some pointers and can share
> them with me.
>
> Also I noticed that we don't have any plugin for shareholding pattern like
> we have for advfn results and other data. I would like to give something
> back to the community and can share whatever I develop with the group.
> Please let me know your thoughts. I really appreciate it.
>
>
>
RCHGetTableCell-Template-Reuters-Insider-Transactions.xls
RCHGetTableCell-Template-Morningstar-Top-Stock-Holders.xls
RCHGetTableCell-Template-Morningstar-Top-20-Stock-Holders.xls
NASDAQ appears to have the most comprehensive:
http://www.nasdaq.com/symbol/mmm/ownership-summary
http://www.nasdaq.com/symbol/mmm/institutional-holdings
http://www.nasdaq.com/symbol/mmm/insider-trades
It depends so much on what you're looking for. MorningStar and Yahoo both
have a lot of data. For example, you can get the insider trades for the
past 2 years from Yahoo with:
=RCHGetHTMLTable("http://finance.yahoo.com/q/it?s=MMM","Insider
Transactions Reported",-1,"",2)
On Thu, Mar 20, 2014 at 4:54 AM, vijay gangrade <vijay_gangrade@yahoo.com>wrote:
>
> I didn't find any source from where I can get the Historical Shareholding
> Patterns/Ownership Summary/Major Holders for the the companies listed in
> Nasdaq and NYSE. I was wondering if you know some pointers and can share
> them with me.
>
> Also I noticed that we don't have any plugin for shareholding pattern like
> we have for advfn results and other data. I would like to give something
> back to the community and can share whatever I develop with the group.
> Please let me know your thoughts. I really appreciate it.
>
>
>
Thu Mar 20, 2014 6:16 am (PDT) . Posted by:
"vijay gangrade" vijay_gangrade
Dear Sir,
Thank you for your reply.
In the page http://www.nasdaq.com/symbol/mmm/institutional-holdings, there is a section for "ownership summary" just beside "Company Details" at the top. It explains the increase/decrease in position with respect to previous quarters. But it is available only for this quarter i.e. 2013/12/31. I would like to have it for past quarters too.
Can you tell me your thoughts on what si the best way to achieve this.
Thanks & Regards,
Vijay Gangrade
On Thursday, March 20, 2014 5:47 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
There are three templates based on ownership:
RCHGetTableCell-Template-Reuters-Insider-Transactions.xls
RCHGetTableCell-Template-Morningstar-Top-Stock-Holders.xls
RCHGetTableCell-Template-Morningstar-Top-20-Stock-Holders.xls
NASDAQ appears to have the most comprehensive:
http://www.nasdaq.com/symbol/mmm/ownership-summary
http://www.nasdaq.com/symbol/mmm/institutional-holdings
http://www.nasdaq.com/symbol/mmm/insider-trades
It depends so much on what you're looking for. MorningStar and Yahoo both have a lot of data. For example, you can get the insider trades for the past 2 years from Yahoo with:
=RCHGetHTMLTable("http://finance.yahoo.com/q/it?s=MMM","Insider Transactions Reported",-1,"",2)
On Thu, Mar 20, 2014 at 4:54 AM, vijay gangrade <vijay_gangrade@yahoo.com> wrote:
>I
didn't find any source from where I can get the Historical Shareholding
Patterns/Ownership Summary/Major Holders for the the companies listed
in Nasdaq and NYSE. I was wondering if you know some pointers and can share them with me.
>
>Also
I noticed that we don't have any plugin for shareholding pattern like
we have for advfn results and other data. I would like to give something
back to the community and can share whatever I develop with the group.
Please let me know your thoughts. I really appreciate it.
>
>
>
>
Thank you for your reply.
In the page http://www.nasdaq.com/symbol/mmm/institutional-holdings, there is a section for "ownership summary" just beside "Company Details" at the top. It explains the increase/decrease in position with respect to previous quarters. But it is available only for this quarter i.e. 2013/12/31. I would like to have it for past quarters too.
Can you tell me your thoughts on what si the best way to achieve this.
Thanks & Regards,
Vijay Gangrade
On Thursday, March 20, 2014 5:47 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
There are three templates based on ownership:
RCHGetTableCell-Template-Reuters-Insider-Transactions.xls
RCHGetTableCell-Template-Morningstar-Top-Stock-Holders.xls
RCHGetTableCell-Template-Morningstar-Top-20-Stock-Holders.xls
NASDAQ appears to have the most comprehensive:
http://www.nasdaq.com/symbol/mmm/ownership-summary
http://www.nasdaq.com/symbol/mmm/institutional-holdings
http://www.nasdaq.com/symbol/mmm/insider-trades
It depends so much on what you're looking for. MorningStar and Yahoo both have a lot of data. For example, you can get the insider trades for the past 2 years from Yahoo with:
=RCHGetHTMLTable("http://finance.yahoo.com/q/it?s=MMM","Insider Transactions Reported",-1,"",2)
On Thu, Mar 20, 2014 at 4:54 AM, vijay gangrade <vijay_gangrade@yahoo.com> wrote:
>I
didn't find any source from where I can get the Historical Shareholding
Patterns/Ownership Summary/Major Holders for the the companies listed
in Nasdaq and NYSE. I was wondering if you know some pointers and can share them with me.
>
>Also
I noticed that we don't have any plugin for shareholding pattern like
we have for advfn results and other data. I would like to give something
back to the community and can share whatever I develop with the group.
Please let me know your thoughts. I really appreciate it.
>
>
>
>
Thu Mar 20, 2014 7:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know of a source of such history...
Hmmm. After a few Google searches, GuruFocus looks like a possibility. They
have charts of history here:
http://www.gurufocus.com/insider/MMM
If you rollover the charts, you'll see data pop up. That data is contained
within scripting arrays within the source code of the web page. For
example, this returns the 74-month array of Institutional Ownership History:
=smfstrExtr(RCHGetWebData("http://www.gurufocus.com/insider/MMM","Institutional
Ownership History"),"data:[[","]]}")
It looks something like:
1201759200000,70],[1204264800000,70],[1206939600000,70], ...
I have no idea how to interpret the first number in each pair, but the
second number is the percent of institutional ownership. In this case, for
2008-01-31, 2008-02-29, and 2008-03-31 -- which I only know by working
backwards from the current quarter.
It looks like MorningStar has eight quarters of quarterly history of many
items for premium members:
http://investors.morningstar.com/ownership/shareholders-overview.html?t=mmm
Again, data is within scripting code. For example:
=smfstrExtr(RCHGetWebData("
http://investors.morningstar.com/ownership/shareholders-overview.html?t=mmm","function
cacheAllDataAboutCurrAndHis"),"= {","}")
On Thu, Mar 20, 2014 at 6:16 AM, vijay gangrade <vijay_gangrade@yahoo.com>wrote:
>
> In the page http://www.nasdaq.com/symbol/mmm/institutional-holdings,
> there is a section for "ownership summary" just beside "Company Details" at
> the top. It explains the increase/decrease in position with respect to
> previous quarters. But it is available only for this quarter i.e.
> 2013/12/31. I would like to have it for past quarters too.
>
> Can you tell me your thoughts on what si the best way to achieve this.
>
Hmmm. After a few Google searches, GuruFocus looks like a possibility. They
have charts of history here:
http://www.gurufocus.com/insider/MMM
If you rollover the charts, you'll see data pop up. That data is contained
within scripting arrays within the source code of the web page. For
example, this returns the 74-month array of Institutional Ownership History:
=smfstrExtr(RCHGetWebData("http://www.gurufocus.com/insider/MMM","Institutional
Ownership History"),"data:[[","]]}")
It looks something like:
1201759200000,70],[1204264800000,70],[1206939600000,70], ...
I have no idea how to interpret the first number in each pair, but the
second number is the percent of institutional ownership. In this case, for
2008-01-31, 2008-02-29, and 2008-03-31 -- which I only know by working
backwards from the current quarter.
It looks like MorningStar has eight quarters of quarterly history of many
items for premium members:
http://investors.morningstar.com/ownership/shareholders-overview.html?t=mmm
Again, data is within scripting code. For example:
=smfstrExtr(RCHGetWebData("
http://investors.morningstar.com/ownership/shareholders-overview.html?t=mmm","function
cacheAllDataAboutCurrAndHis"),"= {","}")
On Thu, Mar 20, 2014 at 6:16 AM, vijay gangrade <vijay_gangrade@yahoo.com>wrote:
>
> In the page http://www.nasdaq.com/symbol/mmm/institutional-holdings,
> there is a section for "ownership summary" just beside "Company Details" at
> the top. It explains the increase/decrease in position with respect to
> previous quarters. But it is available only for this quarter i.e.
> 2013/12/31. I would like to have it for past quarters too.
>
> Can you tell me your thoughts on what si the best way to achieve this.
>
Thu Mar 20, 2014 8:07 am (PDT) . Posted by:
zarathustra_winced
Historical data at yahoo seems to be down. Anyone know what's happening? Was working fine last night. Or is it just me?
Sent from my iPhone
Sent from my iPhone
Thu Mar 20, 2014 8:26 am (PDT) . Posted by:
petekoch
It's not just Yahoo history. Quotes aren't working, it doesn't always remember that I'm signed in and I'm even getting time-out messages as I type this.
Just yesterday, I was about to state here that the Yahoo problems with history/quotes seemed to have been corrected. I thought too soon.
Just yesterday, I was about to state here that the Yahoo problems with history/quotes seemed to have been corrected. I thought too soon.
Thu Mar 20, 2014 9:31 am (PDT) . Posted by:
petekoch
Yahoo also having problems directing to the correct page via its links.
Thu Mar 20, 2014 10:37 am (PDT) . Posted by:
zarathustra_winced
Working for me now. Must have been some maintenance. Thanks.
Sent from my iPhone
> On Mar 20, 2014, at 12:31 PM, <petekoch@yahoo.com> wrote:
>
>
>
> Yahoo also having problems directing to the correct page via its links.
>
>
Sent from my iPhone
> On Mar 20, 2014, at 12:31 PM, <petekoch@yahoo.com> wrote:
>
>
>
> Yahoo also having problems directing to the correct page via its links.
>
>
Thu Mar 20, 2014 1:10 pm (PDT) . Posted by:
"Christopher G. Skyba" cskyba
Hi All,
New to this group.
Was wondering if anyone has a template I can use for historical P/E ratios, stock prices, earnings, etc. for a quarterly basis.
Thank you,
Chris
Cskyba@yahoo.com
On Thursday, March 20, 2014 11:26 AM, "petekoch@yahoo.com" <petekoch@yahoo.com> wrote:
It's not just Yahoo history. Quotes aren't working, it doesn't always remember that I'm signed in and I'm even getting time-out messages as I type this.
Just yesterday, I was about to state here that the Yahoo problems with history/quotes seemed to have been corrected. I thought too soon.
New to this group.
Was wondering if anyone has a template I can use for historical P/E ratios, stock prices, earnings, etc. for a quarterly basis.
Thank you,
Chris
Cskyba@yahoo.com
On Thursday, March 20, 2014 11:26 AM, "petekoch@yahoo.com" <petekoch@yahoo.com> wrote:
It's not just Yahoo history. Quotes aren't working, it doesn't always remember that I'm signed in and I'm even getting time-out messages as I type this.
Just yesterday, I was about to state here that the Yahoo problems with history/quotes seemed to have been corrected. I thought too soon.
Thu Mar 20, 2014 1:10 pm (PDT) . Posted by:
pthickey
Confirmed. I notice RCHGetYahooQuotes has not been working all morning...
Thu Mar 20, 2014 1:11 pm (PDT) . Posted by:
nelsonmuntz1000
Same thing here. RCHGetYahooQuotes array stopped working, Can't retrieve any Yahoo data though their website data seems to be up. I even updated the add-in files and tried different computers, it made no difference.
RCHGetElementNumber functions are still working.
Does anyone know if there is a problem with Yahoo?
By the way, thanks you Randy for the great add-in.
RCHGetElementNumber functions are still working.
Does anyone know if there is a problem with Yahoo?
By the way, thanks you Randy for the great add-in.
Thu Mar 20, 2014 1:11 pm (PDT) . Posted by:
nelsonmuntz1000
I had the same problem.. RCHGetYahooQuotes array stopped producing data this morning. RCHGetElementNumber still works. I tried different files and computers, even updated the add-in files.
It's 12:28pm EST now, looks like it is working again. Must have been a problem with Yahoo. What a PITA.
Thanks, Randy, for the great add-in.
It's 12:28pm EST now, looks like it is working again. Must have been a problem with Yahoo. What a PITA.
Thanks, Randy, for the great add-in.
Thu Mar 20, 2014 1:15 pm (PDT) . Posted by:
"Chris Couperus" nelsonmuntz1000
Was having problems with RCHGetYahooQuotes array data retrieval all
morning. Appears to be working correctly now.
Thanks for the great add-in Randy.
On Thu, Mar 20, 2014 at 12:31 PM, <petekoch@yahoo.com> wrote:
>
>
> Yahoo also having problems directing to the correct page via its links.
>
>
morning. Appears to be working correctly now.
Thanks for the great add-in Randy.
On Thu, Mar 20, 2014 at 12:31 PM, <petekoch@yahoo.com> wrote:
>
>
> Yahoo also having problems directing to the correct page via its links.
>
>
Thu Mar 20, 2014 8:09 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I have played with this for a few hours without any solution. I know
I'm making it much harder than it should be.
Can you tell me what is most efficient method to get the PCAR Split History
into a spreadsheet.
http://www.splithistory.com/?symbol=pcar I used PCAR because it has
multiple splits.
I was able to get split history from http://getsplithistory.com for other
stocks but they don't support all stocks such as EGPT.
I haven't found any site that supports all stocks. So I am having to build
my own list of sources for splits and dividends.
Thanks, I truly appreciate all you do for us.
Kermit
I'm making it much harder than it should be.
Can you tell me what is most efficient method to get the PCAR Split History
into a spreadsheet.
http://www.splithistory.com/?symbol=pcar I used PCAR because it has
multiple splits.
I was able to get split history from http://getsplithistory.com for other
stocks but they don't support all stocks such as EGPT.
I haven't found any site that supports all stocks. So I am having to build
my own list of sources for splits and dividends.
Thanks, I truly appreciate all you do for us.
Kermit
Thu Mar 20, 2014 1:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The table isn't coded properly, so you can't use RCHGetHTMLTable(). This
seems to work best:
=smfGetTagContent("http://www.splithistory.com/?symbol=pcar
","td",1,">Ratio")
...incrementing the 1 as needed.
What problems did you run into just using Yahoo?
On Thu, Mar 20, 2014 at 8:09 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> Randy, I have played with this for a few hours without any solution. I
> know I'm making it much harder than it should be.
>
>
>
> Can you tell me what is most efficient method to get the *PCAR Split
> History* into a spreadsheet.
>
>
>
> http://www.splithistory.com/?symbol=pcar I used PCAR because it has
> multiple splits.
>
>
>
> I was able to get split history from http://getsplithistory.com for
> other stocks but they don't support all stocks such as EGPT.
>
>
>
> I haven't found any site that supports all stocks. So I am having to build
> my own list of sources for splits and dividends.
>
>
>
> Thanks, I truly appreciate all you do for us.
>
>
>
seems to work best:
=smfGetTagContent("http://www.splithistory.com/?symbol=pcar
","td",1,">Ratio")
...incrementing the 1 as needed.
What problems did you run into just using Yahoo?
On Thu, Mar 20, 2014 at 8:09 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> Randy, I have played with this for a few hours without any solution. I
> know I'm making it much harder than it should be.
>
>
>
> Can you tell me what is most efficient method to get the *PCAR Split
> History* into a spreadsheet.
>
>
>
> http://www.splithistory.com/?symbol=pcar I used PCAR because it has
> multiple splits.
>
>
>
> I was able to get split history from http://getsplithistory.com for
> other stocks but they don't support all stocks such as EGPT.
>
>
>
> I haven't found any site that supports all stocks. So I am having to build
> my own list of sources for splits and dividends.
>
>
>
> Thanks, I truly appreciate all you do for us.
>
>
>
Tidak ada komentar:
Posting Komentar