15 New Messages
Digest #2659
4a
Re: How Can I Include RCH Stock Market Functions in a Spreadsheet fo by "ultimatestockfinder" ultimatestockfinder
Messages
Mon Jun 17, 2013 2:03 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Several issues:
1. The data is not in a table.
2. The "P/E Ratio" search string is found earlier on the web page than
where you're attempting to extract.
3. There is other data within the "span" tag, besides just the P/E ratio
value.
Try:
=smfConvertData(smfStrExtr(smfGetTagContent("
http://quotes.wsj.com/ID/XIDX/BMRI ","span",1,"Key Stock Data","P/E
Ratio"),"~","<"))
On Mon, Jun 17, 2013 at 12:06 AM, sri yanto <sri.yanto@yahoo.com > wrote:
> hallo randy, i need your help again.
>
> here i want to capture P/E data from WSJ.
>
> i am using RCHGettable
>
> =RCHGetTableCell("http://quotes.wsj.com/ID/XIDX/BMRI ",1,"P/E Ratio")
>
> it's return "ERROR"
>
> are this stuff need use smftagcontent to grab it?
>
> Thanks after all
>
1. The data is not in a table.
2. The "P/E Ratio" search string is found earlier on the web page than
where you're attempting to extract.
3. There is other data within the "span" tag, besides just the P/E ratio
value.
Try:
=smfConvertData(
http://quotes.
Ratio")
On Mon, Jun 17, 2013 at 12:06 AM, sri yanto <sri.yanto@yahoo.
> hallo randy, i need your help again.
>
> here i want to capture P/E data from WSJ.
>
> i am using RCHGettable
>
> =RCHGetTableCell(
>
> it's return "ERROR"
>
> are this stuff need use smftagcontent to grab it?
>
> Thanks after all
>
Mon Jun 17, 2013 2:14 am (PDT) . Posted by:
"sri yanto" sri.yanto
it's return 0 randy
:D
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Several issues:
>
> 1. The data is not in a table.
> 2. The "P/E Ratio" search string is found earlier on the web page than
> where you're attempting to extract.
> 3. There is other data within the "span" tag, besides just the P/E ratio
> value.
>
> Try:
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> http://quotes.wsj.com/ID/XIDX/BMRI ","span",1,"Key Stock Data","P/E
> Ratio"),"~","<"))
>
> On Mon, Jun 17, 2013 at 12:06 AM, sri yanto <sri.yanto@...> wrote:
>
> > hallo randy, i need your help again.
> >
> > here i want to capture P/E data from WSJ.
> >
> > i am using RCHGettable
> >
> > =RCHGetTableCell("http://quotes.wsj.com/ID/XIDX/BMRI ",1,"P/E Ratio")
> >
> > it's return "ERROR"
> >
> > are this stuff need use smftagcontent to grab it?
> >
> > Thanks after all
> >
>
:D
--- In smf_addin@yahoogrou
>
> Several issues:
>
> 1. The data is not in a table.
> 2. The "P/E Ratio" search string is found earlier on the web page than
> where you're attempting to extract.
> 3. There is other data within the "span" tag, besides just the P/E ratio
> value.
>
> Try:
>
> =smfConvertData(
> http://quotes.
> Ratio")
>
> On Mon, Jun 17, 2013 at 12:06 AM, sri yanto <sri.yanto@
>
> > hallo randy, i need your help again.
> >
> > here i want to capture P/E data from WSJ.
> >
> > i am using RCHGettable
> >
> > =RCHGetTableCell(
> >
> > it's return "ERROR"
> >
> > are this stuff need use smftagcontent to grab it?
> >
> > Thanks after all
> >
>
Mon Jun 17, 2013 2:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's returning 12.94 here.
Which version of the add-in are you using?
=RCHGetElementNumber("Version")
On Mon, Jun 17, 2013 at 2:14 AM, sri yanto <sri.yanto@yahoo.com > wrote:
> it's return 0 randy
>
> :D
>
Which version of the add-in are you using?
=RCHGetElementNumbe
On Mon, Jun 17, 2013 at 2:14 AM, sri yanto <sri.yanto@yahoo.
> it's return 0 randy
>
> :D
>
Mon Jun 17, 2013 2:39 am (PDT) . Posted by:
"sri yanto" sri.yanto
i'am using
addin
version 2.1.2012.02.02
randy, there's any update of addin ?
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It's returning 12.94 here.
>
> Which version of the add-in are you using?
>
> =RCHGetElementNumber("Version")
>
> On Mon, Jun 17, 2013 at 2:14 AM, sri yanto <sri.yanto@...> wrote:
>
> > it's return 0 randy
> >
> > :D
> >
>
addin
version 2.1.2012.02.
randy, there's any update of addin ?
thanks
--- In smf_addin@yahoogrou
>
> It's returning 12.94 here.
>
> Which version of the add-in are you using?
>
> =RCHGetElementNumbe
>
> On Mon, Jun 17, 2013 at 2:14 AM, sri yanto <sri.yanto@
>
> > it's return 0 randy
> >
> > :D
> >
>
Mon Jun 17, 2013 3:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The current official release is 2.1.2012.12.29.
The formula isn't working for you because of a change made to smfStrExtr()
in July of 2012, to allow the tilda symbol to represent the start or end of
the string. As a result, it's finding nothing, resulting in a zero value.
On Mon, Jun 17, 2013 at 2:39 AM, sri yanto <sri.yanto@yahoo.com > wrote:
> i'am using
> addin
>
> version 2.1.2012.02.02
> randy, there's any update of addin ?
> thanks
>
The formula isn't working for you because of a change made to smfStrExtr()
in July of 2012, to allow the tilda symbol to represent the start or end of
the string. As a result, it's finding nothing, resulting in a zero value.
On Mon, Jun 17, 2013 at 2:39 AM, sri yanto <sri.yanto@yahoo.
> i'am using
> addin
>
> version 2.1.2012.02.
> randy, there's any update of addin ?
> thanks
>
Mon Jun 17, 2013 6:24 am (PDT) . Posted by:
"ridgebacksexcel" ridgebacksexcel
I have caught this problem on a number of line items.
The best way to fix it as Randy shows is to go to the source code, copy the line from the code and paste it into the Pfind section of the function. It is hard to see the spaces and easily missed. Most of the time it is a typing mistake from the web designer with an extra space somewhere. This has fixed most of the bugs for me.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> When I look at the source code of the web page, I'm seeing the tag on the
> web page as ">pre-tax income <", not ">pre-tax income<", with a space
> before the HTML mark at the end.
>
> So this works for me:
>
> =smfGetADVFNElement("PFE","Q",1,">Pre-Tax Income <",,"--")
>
> On Sun, Jun 16, 2013 at 7:42 AM, RaviA <rannavajjhala@...> wrote:
>
> > I am using smfGetAdvFNElement to retrieve financial statement data. It's
> > generally working well. but, it seems to be missing some fields.
> > For eg. if I am pulling annual financial statements of Pfizer (PFE), most
> > fields are being pulled. One example of a field that's not getting pulled
> > is "Pre-Tax Income". The field is populated and has numbers - yet I get a
> > zero in excel. This is the syntax I am using (which works for every other
> > field)
> > Where B2 Has the ticker (PFE), B3 has the Annual or Quarterly data
> > (currently set to A) and C9 has the field "Pre-Tax Income"
> > =smfGetADVFNElement($B$2,$B$3,COLUMNS($D:D),">"&$C9&"<",,"--")
> >
> > I even cut and paste the field "Pre-Tax Income" from advfn website-just to
> > make sure I am not messing something up - still doesn't work.
> >
>
The best way to fix it as Randy shows is to go to the source code, copy the line from the code and paste it into the Pfind section of the function. It is hard to see the spaces and easily missed. Most of the time it is a typing mistake from the web designer with an extra space somewhere. This has fixed most of the bugs for me.
--- In smf_addin@yahoogrou
>
> When I look at the source code of the web page, I'm seeing the tag on the
> web page as ">pre-
> before the HTML mark at the end.
>
> So this works for me:
>
> =smfGetADVFNElement
>
> On Sun, Jun 16, 2013 at 7:42 AM, RaviA <rannavajjhala@
>
> > I am using smfGetAdvFNElement to retrieve financial statement data. It's
> > generally working well. but, it seems to be missing some fields.
> > For eg. if I am pulling annual financial statements of Pfizer (PFE), most
> > fields are being pulled. One example of a field that's not getting pulled
> > is "Pre-Tax Income"
> > zero in excel. This is the syntax I am using (which works for every other
> > field)
> > Where B2 Has the ticker (PFE), B3 has the Annual or Quarterly data
> > (currently set to A) and C9 has the field "Pre-Tax Income"
> > =smfGetADVFNElement
> >
> > I even cut and paste the field "Pre-Tax Income" from advfn website-just to
> > make sure I am not messing something up - still doesn't work.
> >
>
Mon Jun 17, 2013 6:43 am (PDT) . Posted by:
"ridgebacksexcel" ridgebacksexcel
Randy,
I saw somewhere on this site a code for extracting a Real Time Quote from the Yahoo Finance Summary page for a company. In this case AAPL.
I am using this function that I have adjusted from what I copied to see if I can get it to work. It shows the function correctly extracting the quote but the formula result is False, not the data extracted.
Here is the formula with cell C2 showing the ticker: aapl
=smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s= "&$C2,"span",-1,"yfs_l84"))
I pulled "yfs_l84" directly from the source code.
Is there a way to pull these real time quotes from this page for all tickers and not just aapl?
Thanks.
You have saved me tons of time automatically extracting data now instead of having to manually enter it.
I saw somewhere on this site a code for extracting a Real Time Quote from the Yahoo Finance Summary page for a company. In this case AAPL.
I am using this function that I have adjusted from what I copied to see if I can get it to work. It shows the function correctly extracting the quote but the formula result is False, not the data extracted.
Here is the formula with cell C2 showing the ticker: aapl
=smfConvertData(
I pulled "yfs_l84" directly from the source code.
Is there a way to pull these real time quotes from this page for all tickers and not just aapl?
Thanks.
You have saved me tons of time automatically extracting data now instead of having to manually enter it.
Mon Jun 17, 2013 7:59 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure what to tell you. Your formula worked just fine for me. I just
put AAPL into cell C2 and then copied and pasted it. And if I change the
ticker symbol, it updates to the new company.
On Mon, Jun 17, 2013 at 6:43 AM, ridgebacksexcel <tmallen2@bellsouth.net >wrote:
>
> I saw somewhere on this site a code for extracting a Real Time Quote from
> the Yahoo Finance Summary page for a company. In this case AAPL.
>
> I am using this function that I have adjusted from what I copied to see if
> I can get it to work. It shows the function correctly extracting the quote
> but the formula result is False, not the data extracted.
>
> Here is the formula with cell C2 showing the ticker: aapl
>
> =smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s=
> "&$C2,"span",-1,"yfs_l84"))
>
> I pulled "yfs_l84" directly from the source code.
>
> Is there a way to pull these real time quotes from this page for all
> tickers and not just aapl?
>
put AAPL into cell C2 and then copied and pasted it. And if I change the
ticker symbol, it updates to the new company.
On Mon, Jun 17, 2013 at 6:43 AM, ridgebacksexcel <tmallen2@bellsouth.
>
> I saw somewhere on this site a code for extracting a Real Time Quote from
> the Yahoo Finance Summary page for a company. In this case AAPL.
>
> I am using this function that I have adjusted from what I copied to see if
> I can get it to work. It shows the function correctly extracting the quote
> but the formula result is False, not the data extracted.
>
> Here is the formula with cell C2 showing the ticker: aapl
>
> =smfConvertData(
> "&$C2,"
>
> I pulled "yfs_l84" directly from the source code.
>
> Is there a way to pull these real time quotes from this page for all
> tickers and not just aapl?
>
Mon Jun 17, 2013 9:09 am (PDT) . Posted by:
"ridgebacksexcel" ridgebacksexcel
I was able to fix the problem. I actually had another formula buried in the same spot but hidden by a lot of spaces two rows down. Once I expanded the formula view, I saw the problem. Deleted the rest of the formula and it now works.
It seems to only update on a forced recalculation but that is ok.
--- In smf_addin@yahoogroups.com , "ridgebacksexcel" <tmallen2@...> wrote:
>
> Randy,
>
> I saw somewhere on this site a code for extracting a Real Time Quote from the Yahoo Finance Summary page for a company. In this case AAPL.
>
> I am using this function that I have adjusted from what I copied to see if I can get it to work. It shows the function correctly extracting the quote but the formula result is False, not the data extracted.
>
> Here is the formula with cell C2 showing the ticker: aapl
>
> =smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s= "&$C2,"span",-1,"yfs_l84"))
>
> I pulled "yfs_l84" directly from the source code.
>
> Is there a way to pull these real time quotes from this page for all tickers and not just aapl?
>
> Thanks.
>
> You have saved me tons of time automatically extracting data now instead of having to manually enter it.
>
It seems to only update on a forced recalculation but that is ok.
--- In smf_addin@yahoogrou
>
> Randy,
>
> I saw somewhere on this site a code for extracting a Real Time Quote from the Yahoo Finance Summary page for a company. In this case AAPL.
>
> I am using this function that I have adjusted from what I copied to see if I can get it to work. It shows the function correctly extracting the quote but the formula result is False, not the data extracted.
>
> Here is the formula with cell C2 showing the ticker: aapl
>
> =smfConvertData(
>
> I pulled "yfs_l84" directly from the source code.
>
> Is there a way to pull these real time quotes from this page for all tickers and not just aapl?
>
> Thanks.
>
> You have saved me tons of time automatically extracting data now instead of having to manually enter it.
>
Mon Jun 17, 2013 7:18 am (PDT) . Posted by:
"ultimatestockfinder" ultimatestockfinder
Randy,
Thanks that sounds good to me. I will follow your instructions and see how often I need to manually make updates to the add-in.
Thanks,
John D.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> To make the workbooks portable, you would need to copy the applicable
> modules to the workbook. There are several examples in the group, in the
> FILES area:
>
> Files > Templates and Examples > SMFLite
>
> I think the RCHGetElementNumber() function is the only one that doesn't
> work well for this, because the element definitions are in external files.
>
> The disadvantage of doing this is that if I make updates to the add-in, the
> updates would need to be manually done to each of the stand-alone workbooks.
>
> On Fri, Jun 14, 2013 at 3:45 PM, Ultimate Stock <
> ultimatestockfinder@...> wrote:
>
> >
> > Randy,
> > I have a free website http://www.ultimatestockfinder.com/ for individual
> > investors that contains Excel spreadsheets that help my users find good
> > stocks (StockEvaluator) and mutual funds (MutualFundEvaluator). These
> > spreadsheets take 17 different company financial and stock price data
> > values from the web and allow the user to set customized target limits for
> > each data value. Each company cell that does not meet these custom limits
> > is turned red with a conditional format command. Macro sorting commands
> > allow the user to sort the companies with the least red cells to the top.
> > The spreadsheet also contains Macro sorts on: % above 52 week low;
> > Dividend Yield; Daily Stock Price Volatility; and P/E Ratio.
> >
> > The "Training"; page has other articles and spreadsheet tools to help
> > individual investors manage their investments. One of these spreadsheets
> > is "Investment Tracker" (see attached) which will hold a complete list of
> > the users investments by stock symbol, number of shares, buy price, current
> > price, total current value and institution holding the investment. I had
> > been updating the current price manually for years, but my friend, Nathan
> > Welborne, showed me how to use the RCH Stock Market Functions last month
> > and I am now using your functions on my personal version of the Investment
> > Tracker spreadsheet to get current stock prices.
> >
> > I would like to provide this automatic look up function as a downloadable
> > file to all my web site users, and need to confirm with you if I can add
> > the RCH Stock Market Functions to my website as a download my web visitors
> > would do along with downloading the InvestmentTracker.xls file.
> >
> > Also, is there any way that these RCH Stock Market Functions could be
> > included as a worksheet in an InvestmentTracker.xls workbook so that my
> > users would not have to download them separately, but the one download of
> > InvestmentTracker.xls (workbook) would be ready to do the automatic stock
> > price look ups automatically.
> >
> > Thank you,
> > John DeCamp
> > www.UltimateStockFinder.com
> >
>
Thanks that sounds good to me. I will follow your instructions and see how often I need to manually make updates to the add-in.
Thanks,
John D.
--- In smf_addin@yahoogrou
>
> To make the workbooks portable, you would need to copy the applicable
> modules to the workbook. There are several examples in the group, in the
> FILES area:
>
> Files > Templates and Examples > SMFLite
>
> I think the RCHGetElementNumber
> work well for this, because the element definitions are in external files.
>
> The disadvantage of doing this is that if I make updates to the add-in, the
> updates would need to be manually done to each of the stand-alone workbooks.
>
> On Fri, Jun 14, 2013 at 3:45 PM, Ultimate Stock <
> ultimatestockfinder
>
> >
> > Randy,
> > I have a free website http://www.ultimate
> > investors that contains Excel spreadsheets that help my users find good
> > stocks (StockEvaluator) and mutual funds (MutualFundEvaluato
> > spreadsheets take 17 different company financial and stock price data
> > values from the web and allow the user to set customized target limits for
> > each data value. Each company cell that does not meet these custom limits
> > is turned red with a conditional format command. Macro sorting commands
> > allow the user to sort the companies with the least red cells to the top.
> > The spreadsheet also contains Macro sorts on: % above 52 week low;
> > Dividend Yield; Daily Stock Price Volatility; and P/E Ratio.
> >
> > The "Training"
> > individual investors manage their investments. One of these spreadsheets
> > is "Investment Tracker" (see attached) which will hold a complete list of
> > the users investments by stock symbol, number of shares, buy price, current
> > price, total current value and institution holding the investment. I had
> > been updating the current price manually for years, but my friend, Nathan
> > Welborne, showed me how to use the RCH Stock Market Functions last month
> > and I am now using your functions on my personal version of the Investment
> > Tracker spreadsheet to get current stock prices.
> >
> > I would like to provide this automatic look up function as a downloadable
> > file to all my web site users, and need to confirm with you if I can add
> > the RCH Stock Market Functions to my website as a download my web visitors
> > would do along with downloading the InvestmentTracker.
> >
> > Also, is there any way that these RCH Stock Market Functions could be
> > included as a worksheet in an InvestmentTracker.
> > users would not have to download them separately, but the one download of
> > InvestmentTracker.
> > price look ups automatically.
> >
> > Thank you,
> > John DeCamp
> > www.UltimateStockFi
> >
>
Mon Jun 17, 2013 7:34 am (PDT) . Posted by:
"mahluwa" mahluwa
Hi,
Is there a problem with earnings.com, elements: 1286 onwards? I'm using latest version (released dec 12) but all fore-mentioned elements using RCHGetElementNumber() come back with error. If indeed there is a problem, are there alternative elements available providing same information? Do I need to patch a file?
Thanks
Manoj
Is there a problem with earnings.com, elements: 1286 onwards? I'm using latest version (released dec 12) but all fore-mentioned elements using RCHGetElementNumber
Thanks
Manoj
Mon Jun 17, 2013 8:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like the website no longer exists. If I type the URL into my
browser, I get redirected to:
http://www.reuters.com/finance/markets/earnings
...so Reuters must have acquired them, or merged them into their website.
The dividend and split history can be retrieved from Yahoo, but I don't
know of another source of the earnings announcements history...
On Mon, Jun 17, 2013 at 7:33 AM, mahluwa <mahluwa@yahoo.com > wrote:
>
> Is there a problem with earnings.com, elements: 1286 onwards? I'm using
> latest version (released dec 12) but all fore-mentioned elements using
> RCHGetElementNumber() come back with error. If indeed there is a problem,
> are there alternative elements available providing same information? Do I
> need to patch a file?
>
browser, I get redirected to:
http://www.reuters.
...so Reuters must have acquired them, or merged them into their website.
The dividend and split history can be retrieved from Yahoo, but I don't
know of another source of the earnings announcements history...
On Mon, Jun 17, 2013 at 7:33 AM, mahluwa <mahluwa@yahoo.
>
> Is there a problem with earnings.com, elements: 1286 onwards? I'm using
> latest version (released dec 12) but all fore-mentioned elements using
> RCHGetElementNumber
> are there alternative elements available providing same information? Do I
> need to patch a file?
>
Mon Jun 17, 2013 8:20 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
may i ask how do i extract files from ft
from the respective pages
1) http://markets.ft.com/research/Markets/Tearsheets/Summary?s=GOOG:NSQ
Past 90 days
1 week 1 month 6 months 1 year 5 years
Google Inc -0.41% -2.49% +26.29% +57.04% +55.68%
S&P 500 INDEX -0.98% -2.44% +15.08% +21.14% +20.42%
USA/INFORMATION TECH -1.55% -2.43% +7.36% +8.67% --
USA/INTERNET SOFT & SVC -2.15% -5.95% +11.76% +28.75% --
2) http://markets.ft.com/research/Markets/Tearsheets/Summary?s=GOOG:NSQ
Markit short selling activity
3) http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=GOOG:NSQ
Mergers & acquisitions
Acquired company
Deal status
Date GOOG:NSQ since
announced Transaction
value
Channel Intelligence Inc Deal completed 06 Feb 2013 +16.00% 125.00m
Makani Power Deal completed 22 May 2013 +2.06% --
Wavii Inc Deal completed 26 Apr 2013 +9.78% --
Waze Ltd Deal completed 11 Jun 2013 +0.22% --
WhatsApp Inc Rumoured 08 Apr 2013 +13.44%
4) http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AV.:LSE
Peer analysis
View
Company Revenue (TTM) Net income (TTM) Market cap Employees
AEGON N.V. 40.47bn 845.56m 9.13bn 24000
Aviva plc 43.10bn -442.00m 9.85bn 33122
CNP Assurances SA 36.91bn 757.86m 6.67bn 4842
Legal & General Group Plc 34.98bn 813.00m 10.11bn 8329
Mapfre SA -- -- 7.02bn 35345
Old Mutual plc 19.79bn 577.00m 9.05bn 54368
Standard Life Plc 19.19bn 698.00m 8.67bn 845
5) http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=GOOG:NSQ
Institutional Holders
MoversTop Holders
Holder Shares % Held
Fidelity Management & Research Co.
as of 31 Mar 2013
16.54m 6.36%
The Vanguard Group, Inc.
as of 31 Mar 2013
11.83m 4.52%
SSgA Funds Management, Inc.
as of 31 Mar 2013
10.61m 4.13%
BlackRock Fund Advisors
as of 31 Mar 2013
9.70m 3.64%
T. Rowe Price Associates, Inc.
as of 31 Mar 2013
9.46m 3.45%
Capital Research & Management Co. (World Investors)
as of 31 Mar 2013
6.31m 2.37%
Capital Research & Management Co. (Global Investors)
as of 31 Mar 2013
3.90m 1.59%
Northern Trust Investments, Inc.
as of 31 Mar 2013
3.82m 1.44%
PRIMECAP Management Co.
as of 31 Mar 2013
3.21m 1.14%
Sands Capital Management LLC
as of 31 Mar 2013
2.49m 1.06%
29.70%
Per cent of shares
held by top holders
Data from 31 Dec 2012 - 31 Mar 2013
6) http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=GOOG:NSQ
Consensus recommendation
As of Jun 14, 2013, the consensus forecast amongst 40 polled investment analysts covering Google Inc advises that the company will outperform the market. This has been the consensus forecast since the sentiment of investment analysts deteriorated on Dec 08, 2011. The previous consensus forecast advised investors to purchase equity in Google Inc.
Previous recommendations
Last year 3 months ago 2 months ago 4 weeks ago Latest
Latest recommendation
Buy 13
Outperform 15
Hold 12
Underperform 0
Sell 0
No opinion 0
tried using
rchgettable eg.
=RCHGetHTMLTable("http://markets.ft.com/research/Markets/Tearsheets/Summary?s=GOOG:NSQ ","Past 90 Days",0,"",0)
But i cant extract anything out even with all sort of combination in the examination excel..
may i ask how do i extract files from ft
from the respective pages
1) http://markets.
Past 90 days
1 week 1 month 6 months 1 year 5 years
Google Inc -0.41% -2.49% +26.29% +57.04% +55.68%
S&P 500 INDEX -0.98% -2.44% +15.08% +21.14% +20.42%
USA/INFORMATION TECH -1.55% -2.43% +7.36% +8.67% --
USA/INTERNET SOFT & SVC -2.15% -5.95% +11.76% +28.75% --
2) http://markets.
Markit short selling activity
3) http://markets.
Mergers & acquisitions
Acquired company
Deal status
Date GOOG:NSQ since
announced Transaction
value
Channel Intelligence Inc Deal completed 06 Feb 2013 +16.00% 125.00m
Makani Power Deal completed 22 May 2013 +2.06% --
Wavii Inc Deal completed 26 Apr 2013 +9.78% --
Waze Ltd Deal completed 11 Jun 2013 +0.22% --
WhatsApp Inc Rumoured 08 Apr 2013 +13.44%
4) http://markets.
Peer analysis
View
Company Revenue (TTM) Net income (TTM) Market cap Employees
AEGON N.V. 40.47bn 845.56m 9.13bn 24000
Aviva plc 43.10bn -442.00m 9.85bn 33122
CNP Assurances SA 36.91bn 757.86m 6.67bn 4842
Legal & General Group Plc 34.98bn 813.00m 10.11bn 8329
Mapfre SA -- -- 7.02bn 35345
Old Mutual plc 19.79bn 577.00m 9.05bn 54368
Standard Life Plc 19.19bn 698.00m 8.67bn 845
5) http://markets.
Institutional Holders
MoversTop Holders
Holder Shares % Held
Fidelity Management & Research Co.
as of 31 Mar 2013
16.54m 6.36%
The Vanguard Group, Inc.
as of 31 Mar 2013
11.83m 4.52%
SSgA Funds Management, Inc.
as of 31 Mar 2013
10.61m 4.13%
BlackRock Fund Advisors
as of 31 Mar 2013
9.70m 3.64%
T. Rowe Price Associates, Inc.
as of 31 Mar 2013
9.46m 3.45%
Capital Research & Management Co. (World Investors)
as of 31 Mar 2013
6.31m 2.37%
Capital Research & Management Co. (Global Investors)
as of 31 Mar 2013
3.90m 1.59%
Northern Trust Investments, Inc.
as of 31 Mar 2013
3.82m 1.44%
PRIMECAP Management Co.
as of 31 Mar 2013
3.21m 1.14%
Sands Capital Management LLC
as of 31 Mar 2013
2.49m 1.06%
29.70%
Per cent of shares
held by top holders
Data from 31 Dec 2012 - 31 Mar 2013
6) http://markets.
Consensus recommendation
As of Jun 14, 2013, the consensus forecast amongst 40 polled investment analysts covering Google Inc advises that the company will outperform the market. This has been the consensus forecast since the sentiment of investment analysts deteriorated on Dec 08, 2011. The previous consensus forecast advised investors to purchase equity in Google Inc.
Previous recommendations
Last year 3 months ago 2 months ago 4 weeks ago Latest
Latest recommendation
Buy 13
Outperform 15
Hold 12
Underperform 0
Sell 0
No opinion 0
tried using
rchgettable eg.
=RCHGetHTMLTable(
But i cant extract anything out even with all sort of combination in the examination excel..
Mon Jun 17, 2013 10:59 am (PDT) . Posted by:
"the_drake_03" the_drake_03
Hello,
I've been using Element for several years. I've searched all around the forum but can't find an answer. It seems like #25 last price has changed and we should use RCHGetYahooQuotes instead.
When I put in =RCHGetElementNumber($A7, C$14)I get "Error"
When I put in =RCHGetYahooQuotes($A7, C$14)I get a blank cell, nothing, nada. I've tried with stocks, ETFs, and mutual funds.
I'm trying to get the latest price, real time or delay, doesn't matter.
I've downloaded the latest version from the forum here.
Can someone help and tell me what I'm doing wrong?
Thank you!!
I've been using Element for several years. I've searched all around the forum but can't find an answer. It seems like #25 last price has changed and we should use RCHGetYahooQuotes instead.
When I put in =RCHGetElementNumbe
When I put in =RCHGetYahooQuotes(
I'm trying to get the latest price, real time or delay, doesn't matter.
I've downloaded the latest version from the forum here.
Can someone help and tell me what I'm doing wrong?
Thank you!!
Mon Jun 17, 2013 11:34 am (PDT) . Posted by:
"Pete" petekoch
The following comment works just fine:
=RCHCreateComment("http://stockcharts.com/c-sc/sc?p=W&yr=0&mn=36&dy=0&i=t39628903145&r=9933&s= "&Ticker,99,800,515)
But when I try to move the chart down or to the right, it remains in the same (relative) position:
=RCHCreateComment("http://stockcharts.com/c-sc/sc?p=W&yr=0&mn=36&dy=0&i=t39628903145&r=9933&s= "&Ticker,99,800,515,0,150,150)
What I would really like to do is move the chart up and to the left (with negative numbers?).
What am I missing/doing wrong ? Or is it that I am running
Version 2.1.2012.02.02 ???
=RCHCreateComment(
But when I try to move the chart down or to the right, it remains in the same (relative) position:
=RCHCreateComment(
What I would really like to do is move the chart up and to the left (with negative numbers?).
What am I missing/doing wrong ? Or is it that I am running
Version 2.1.2012.02.
Tidak ada komentar:
Posting Komentar