3 Messages
Digest #3014
Messages
Fri Mar 21, 2014 6:40 pm (PDT) . Posted by:
advertise78
hello,
I'll try to supply all the information I can, but I'm not a wiz when it comes to the SMF functions in excel.
Problem and background: I have been using a file titled New 10 year model... I think that was the original version. It pulls 10 years of financial statement data and the last 5 quarters from gurufocus.com. I then have many sheets that do various things with that information.
My problem started today. For some reason, no matter what stock ticker i enter, I get blanks for the income statement portion. Everything else works fine.
Background:
parameter used. I'm not sure what you need exaclty, so I included a line from 2004 revenue per share. (=IF(ISNUMBER(RCHGetTableCell("http://www.gurufocus.com/financials/"&Ticker,D$4,"except for per share",">"&$B$8,">"&$C10)),RCHGetTableCell("http://www.gurufocus.com/financials/"&Ticker,D$4,"except for per share",">"&$B$8,">"&$C10),"")
Version of excel: Microsoft excel 2010
operating system: Windows XP
ticker symbol: I started with F, but tried IBM, and DE as well.
results expected: I should see 10 years of income statements displayed, but I get a blank screen. Balance sheet and cash flow statements show up fine. Navigated to gurufocus.com and everything seemed to be working fine on their end as far as financial statements loading and displaying.
Any help would be greatly appreciated, since I spent quite a bit of time updating this sheet a few months ago, and then finished adding on even more features recently. I'd rather not have to find a new system and have to relink everything again.
V/R
Todd
I'll try to supply all the information I can, but I'm not a wiz when it comes to the SMF functions in excel.
Problem and background: I have been using a file titled New 10 year model... I think that was the original version. It pulls 10 years of financial statement data and the last 5 quarters from gurufocus.com. I then have many sheets that do various things with that information.
My problem started today. For some reason, no matter what stock ticker i enter, I get blanks for the income statement portion. Everything else works fine.
Background:
parameter used. I'm not sure what you need exaclty, so I included a line from 2004 revenue per share. (=IF(ISNUMBER(RCHGetTableCell("http://www.gurufocus.com/financials/"&Ticker,D$4,"except for per share",">"&$B$8,">"&$C10)),RCHGetTableCell("http://www.gurufocus.com/financials/"&Ticker,
Version of excel: Microsoft excel 2010
operating system: Windows XP
ticker symbol: I started with F, but tried IBM, and DE as well.
results expected: I should see 10 years of income statements displayed, but I get a blank screen. Balance sheet and cash flow statements show up fine. Navigated to gurufocus.com and everything seemed to be working fine on their end as far as financial statements loading and displaying.
Any help would be greatly appreciated, since I spent quite a bit of time updating this sheet a few months ago, and then finished adding on even more features recently. I'd rather not have to find a new system and have to relink everything again.
V/R
Todd
Fri Mar 21, 2014 7:10 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I have no idea what your formula is using for search terms, so can't offer
any specific advice.
However, it seems to be working fine here. I used:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&D$8,$C9,"except for
per share",">Income Statement",">Revenue")
...where cell D8 contained the ticker symbol and C9 contained the column
number to extract and got:
Col MMM F 1 20011 172316 2 21167 176835 3 22923 160065 4 24462 172455
5 25269 145114 6 23123 116283 7 26662 128954 8 29611 136264 9 29904
133559 10 30871 146917 11 30871 146917 12 7387 35731 13 7634 35810 14
7752 38095 15 7916 35976 16 7569 37036
On Fri, Mar 21, 2014 at 4:47 PM, <advertise78@yahoo.com> wrote:
>
> I'll try to supply all the information I can, but I'm not a wiz when it
> comes to the SMF functions in excel.
>
> Problem and background: I have been using a file titled New 10 year
> model... I think that was the original version. It pulls 10 years of
> financial statement data and the last 5 quarters from gurufocus.com. I
> then have many sheets that do various things with that information.
>
> My problem started today. For some reason, no matter what stock ticker i
> enter, I get blanks for the income statement portion. Everything else
> works fine.
>
> Background:
>
> parameter used. I'm not sure what you need exaclty, so I included a line
> from 2004 revenue per share. (=IF(ISNUMBER(RCHGetTableCell("
> http://www.gurufocus.com/financials/"&Ticker,D$4,"except for per
> share",">"&$B$8,">"&$C10)),RCHGetTableCell("
> http://www.gurufocus.com/financials/"&Ticker,D$4,"except for per
> share",">"&$B$8,">"&$C10),"")
>
> Version of excel: Microsoft excel 2010
>
> operating system: Windows XP
>
> ticker symbol: I started with F, but tried IBM, and DE as well.
>
> results expected: I should see 10 years of income statements displayed,
> but I get a blank screen. Balance sheet and cash flow statements show up
> fine. Navigated to gurufocus.com and everything seemed to be working
> fine on their end as far as financial statements loading and displaying.
>
> Any help would be greatly appreciated, since I spent quite a bit of time
> updating this sheet a few months ago, and then finished adding on even more
> features recently. I'd rather not have to find a new system and have to
> relink everything again.
>
any specific advice.
However, it seems to be working fine here. I used:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&D$8,$C9,"except for
per share",">Income Statement",">Revenue")
...where cell D8 contained the ticker symbol and C9 contained the column
number to extract and got:
Col MMM F 1 20011 172316 2 21167 176835 3 22923 160065 4 24462 172455
5 25269 145114 6 23123 116283 7 26662 128954 8 29611 136264 9 29904
133559 10 30871 146917 11 30871 146917 12 7387 35731 13 7634 35810 14
7752 38095 15 7916 35976 16 7569 37036
On Fri, Mar 21, 2014 at 4:47 PM, <advertise78@yahoo.com> wrote:
>
> I'll try to supply all the information I can, but I'm not a wiz when it
> comes to the SMF functions in excel.
>
> Problem and background: I have been using a file titled New 10 year
> model... I think that was the original version. It pulls 10 years of
> financial statement data and the last 5 quarters from gurufocus.com. I
> then have many sheets that do various things with that information.
>
> My problem started today. For some reason, no matter what stock ticker i
> enter, I get blanks for the income statement portion. Everything else
> works fine.
>
> Background:
>
> parameter used. I'm not sure what you need exaclty, so I included a line
> from 2004 revenue per share. (=IF(ISNUMBER(RCHGetTableCell("
> http://www.gurufocus.com/financials/"&Ticker,D$4,"except for per
> share",">"&$B$8,">"&$C10)),RCHGetTableCell("
> http://www.gurufocus.com/financials/"&Ticker,
> share",
>
> Version of excel: Microsoft excel 2010
>
> operating system: Windows XP
>
> ticker symbol: I started with F, but tried IBM, and DE as well.
>
> results expected: I should see 10 years of income statements displayed,
> but I get a blank screen. Balance sheet and cash flow statements show up
> fine. Navigated to gurufocus.com and everything seemed to be working
> fine on their end as far as financial statements loading and displaying.
>
> Any help would be greatly appreciated, since I spent quite a bit of time
> updating this sheet a few months ago, and then finished adding on even more
> features recently. I'd rather not have to find a new system and have to
> relink everything again.
>
Sat Mar 22, 2014 3:19 am (PDT) . Posted by:
"vijay gangrade" vijay_gangrade
Dear Sir,
Thank you
for your reply. It certainly pointed me in the right direction.
The first
number in [1201759200000,70],[1204264800000,70],[1206939600000,70] seems to be
the representation of the date which is used in creating the graph. I think so
because I calculated the difference between the successive numbers and they are
all in range of 28 to 31 just like the number of days in the month.
However
there is a better method to get historical Institutional holding summary. The
same page has path to an xls which has all the details on institutional summary
and has other tabs too for other info. Below is the example. http://www.gurufocus.com/download_dataset.php?symbol=XOM
I also found
a very peculiar thing. In some cases, the data is vastly different on different
sources. For example, in yahoo and gurufocus, FB has institutional shareholding
as 51% but in NASDAQ page, it is 66%. There is change in number of
institutional shareholders too. I am not sure which one to trust now. Below are
the links for both pages.
http://www.nasdaq.com/symbol/fb/institutional-holdings
http://finance.yahoo.com/q/mh?s=FB%2C+&ql=1
I guess
the site of the stock exchange would have more accurate info. So I might go
with what is in NASDAQ.
Ideally I
want the data in very detailed level. For example, in below page
http://www.bseindia.com/corporates/ShareholdingPattern.aspx?scripcd=532540&flag_qtr=1&qtrid=80.00&Flag=New
This is
the site of the Bombay Stock Exchange (India) and it has this level of
detail for all the companies for all the quarters and is available to everybody.
I think there must be some site in US too which will have this kind of data. I
just don't know where to look.
Is there
some government site which will have all these archives. It may not be easy to
automate but might be worth a try.
Thanks
& Regards,
Vijay
Gangrade
On Thursday, March 20, 2014 7:56 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
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.
>
Thank you
for your reply. It certainly pointed me in the right direction.
The first
number in [1201759200000,70],[1204264800000,70],[1206939600000,70] seems to be
the representation of the date which is used in creating the graph. I think so
because I calculated the difference between the successive numbers and they are
all in range of 28 to 31 just like the number of days in the month.
However
there is a better method to get historical Institutional holding summary. The
same page has path to an xls which has all the details on institutional summary
and has other tabs too for other info. Below is the example. http://www.gurufocus.com/download_dataset.php?symbol=XOM
I also found
a very peculiar thing. In some cases, the data is vastly different on different
sources. For example, in yahoo and gurufocus, FB has institutional shareholding
as 51% but in NASDAQ page, it is 66%. There is change in number of
institutional shareholders too. I am not sure which one to trust now. Below are
the links for both pages.
http://www.nasdaq.com/symbol/fb/institutional-holdings
http://finance.yahoo.com/q/mh?s=FB%2C+&ql=1
I guess
the site of the stock exchange would have more accurate info. So I might go
with what is in NASDAQ.
Ideally I
want the data in very detailed level. For example, in below page
http://www.bseindia.com/corporates/ShareholdingPattern.aspx?scripcd=532540&flag_qtr=1&qtrid=80.00&Flag=New
This is
the site of the Bombay Stock Exchange (India) and it has this level of
detail for all the companies for all the quarters and is available to everybody.
I think there must be some site in US too which will have this kind of data. I
just don't know where to look.
Is there
some government site which will have all these archives. It may not be easy to
automate but might be worth a try.
Thanks
& Regards,
Vijay
Gangrade
On Thursday, March 20, 2014 7:56 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
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.
>
Tidak ada komentar:
Posting Komentar