15 New Messages
Digest #2662
Messages
Wed Jun 19, 2013 2:24 am (PDT) . Posted by:
"Andrew" ah8ung
Is this file working for anyone?
It was working fine yesterday for me, but has errors on most fields today.
I have a feeling that the data is not accessible anymore.
Anyone else have any views on this?
It was working fine yesterday for me, but has errors on most fields today.
I have a feeling that the data is not accessible anymore.
Anyone else have any views on this?
Wed Jun 19, 2013 2:28 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Looks like MSN redesigned their financial statements pages. They changed a
lot of labels, and dropped a number of line items.
On Wed, Jun 19, 2013 at 2:11 AM, Andrew <ah8ung@yahoo.co.uk > wrote:
> Is this file working for anyone?
>
> It was working fine yesterday for me, but has errors on most fields today.
>
> I have a feeling that the data is not accessible anymore.
>
> Anyone else have any views on this?
>
lot of labels, and dropped a number of line items.
On Wed, Jun 19, 2013 at 2:11 AM, Andrew <ah8ung@yahoo.
> Is this file working for anyone?
>
> It was working fine yesterday for me, but has errors on most fields today.
>
> I have a feeling that the data is not accessible anymore.
>
> Anyone else have any views on this?
>
Wed Jun 19, 2013 2:49 am (PDT) . Posted by:
"Andrew" ah8ung
Thanks Randy for the quick response.
I only started using this stuff yesterday (so I thought I was going mad!), I was really impressed how easy it was to link all the fields into all the cash flow modelling spreadsheets "Financial Import" tab. I did actually have a thought at the back of my mind about how often they may reformat this data, or whether they will stop publishing it any time soon :(
Can anyone that is using the cash flow modelling spreadsheets make suggestions on how they have now replaced the missing data?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Looks like MSN redesigned their financial statements pages. They changed a
> lot of labels, and dropped a number of line items.
>
> On Wed, Jun 19, 2013 at 2:11 AM, Andrew <ah8ung@...> wrote:
>
> > Is this file working for anyone?
> >
> > It was working fine yesterday for me, but has errors on most fields today.
> >
> > I have a feeling that the data is not accessible anymore.
> >
> > Anyone else have any views on this?
> >
>
I only started using this stuff yesterday (so I thought I was going mad!), I was really impressed how easy it was to link all the fields into all the cash flow modelling spreadsheets "Financial Import" tab. I did actually have a thought at the back of my mind about how often they may reformat this data, or whether they will stop publishing it any time soon :(
Can anyone that is using the cash flow modelling spreadsheets make suggestions on how they have now replaced the missing data?
--- In smf_addin@yahoogrou
>
> Looks like MSN redesigned their financial statements pages. They changed a
> lot of labels, and dropped a number of line items.
>
> On Wed, Jun 19, 2013 at 2:11 AM, Andrew <ah8ung@.
>
> > Is this file working for anyone?
> >
> > It was working fine yesterday for me, but has errors on most fields today.
> >
> > I have a feeling that the data is not accessible anymore.
> >
> > Anyone else have any views on this?
> >
>
Wed Jun 19, 2013 3:41 am (PDT) . Posted by:
"pdysonuk@gmail" pdyson10
Randy
Thank you. I notice that the link has been taken down today!
Regards
Paul
On 18 Jun 2013, at 18:44, Paul Dyson <pdysonuk@gmail.com > wrote:
> Randy
>
>
> I realise that the website may get redirected soon but I thought I would try and create the data using the RCHGetTableCell function but I am getting confused as to why I can't get it to work properly.
>
> I am using this function:
>
> RCHGetTableCell("http://earnings.com/company.asp?ticker=ADBE&coid=110578&client=cb ",col,"earnings releases",row)
>
>
>
> When I set the "row" to be 1 and the "col" variable to be 0,1,2,3,4,5 I get the first row of the table as expected as shown below.
>
>
>
> Q2 2014 Q2 2014 Adobe Systems Earnings Release-Tenative 0.41 n/a 0.34 17-Jun-14 AMC
>
>
> However, when I start increasing the "row" variable to obtain the other data in the additional rows, I get some strange results as shown below(the first number in each row is just to increase the row number by 1 and does not appear on the website):
>
>
>
> 1 Q2 2014 Q2 2014 Adobe Systems Earnings Release-Tenative 0.41 n/a 0.34 17-Jun-14 AMC
> 2 EVENT TITLE EPS ESTIMATE EPS ACTUAL PREV. YEAR ACTUAL DATE/TIME (ET) Error
> 3 0.34 17-Jun-14 AMC Error Error Error Error
> 4 Q2 2014 Q2 2014 Adobe Systems Earnings Release-Tenative 0.41 n/a 0.34 17-Jun-14 AMC
> 5 ADBE Q2 2014 Q2 2014 Adobe Systems Earnings Release-Tenative 0.41 n/a 0.34
> 6 0.61 12-Dec-13 AMC Error Error Error Error
> 7 17-Jun-14 AMC Error Error Error Error Error
> 8 18-Mar-14 AMC Error Error Error Error Error
> 9 19-Mar-13 AMC Error Error Error Error Error
>
>
> What am I missing?
>
>
>
> Thanks
>
>
>
> Paul
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
> >
> > I think they just don't have redirection turned on for your bookmarked "
> > earnings.com" address.
> >
> > If you change your URL to "www.earnings.com", it doesn't work and still
> > redirects.
> >
> > So I have to wonder if your bookmarked URL is being updated, and how much
> > longer it will exist?
> >
> > On Tue, Jun 18, 2013 at 5:15 AM, sjagers sjagers@... wrote:
> >
> > > I had the Earnings.com website bookmarked and just tried it (below):
> > >
> > > Here's the URL for Adobe's earnings history, as an example:
> > > http://earnings.com/company.asp?ticker=ADBE&coid=110578&client=cb
> > >
> > > And, the Earnings.com "highights" tab:
> > > http://earnings.com/highlight.asp?client=cb
> > >
> > > I'm not sure what the "client=cb" means. But if I enter just earnings.com,
> > > I'm directed to the Reuter's website that Randy mentioned.
> > >
> > > I have a worksheet with several GetElementNumbers for Earnings.com and it
> > > hasn't worked for about 5 days now. They must have recently changed
> > > something.
> > >
> > > Could we tweak the URL lookup for the Earnings.com ElementNumbers so they
> > > look up data on the website that I had bookmarked?
> > >
> >
>
>
Thank you. I notice that the link has been taken down today!
Regards
Paul
On 18 Jun 2013, at 18:44, Paul Dyson <pdysonuk@gmail.
> Randy
>
>
> I realise that the website may get redirected soon but I thought I would try and create the data using the RCHGetTableCell function but I am getting confused as to why I can't get it to work properly.
>
> I am using this function:
>
> RCHGetTableCell(
>
>
>
> When I set the "row" to be 1 and the "col" variable to be 0,1,2,3,4,5 I get the first row of the table as expected as shown below.
>
>
>
> Q2 2014 Q2 2014 Adobe Systems Earnings Release-Tenative 0.41 n/a 0.34 17-Jun-14 AMC
>
>
> However, when I start increasing the "row" variable to obtain the other data in the additional rows, I get some strange results as shown below(the first number in each row is just to increase the row number by 1 and does not appear on the website):
>
>
>
> 1 Q2 2014 Q2 2014 Adobe Systems Earnings Release-Tenative 0.41 n/a 0.34 17-Jun-14 AMC
> 2 EVENT TITLE EPS ESTIMATE EPS ACTUAL PREV. YEAR ACTUAL DATE/TIME (ET) Error
> 3 0.34 17-Jun-14 AMC Error Error Error Error
> 4 Q2 2014 Q2 2014 Adobe Systems Earnings Release-Tenative 0.41 n/a 0.34 17-Jun-14 AMC
> 5 ADBE Q2 2014 Q2 2014 Adobe Systems Earnings Release-Tenative 0.41 n/a 0.34
> 6 0.61 12-Dec-13 AMC Error Error Error Error
> 7 17-Jun-14 AMC Error Error Error Error Error
> 8 18-Mar-14 AMC Error Error Error Error Error
> 9 19-Mar-13 AMC Error Error Error Error Error
>
>
> What am I missing?
>
>
>
> Thanks
>
>
>
> Paul
>
> --- In smf_addin@yahoogrou
> >
> > I think they just don't have redirection turned on for your bookmarked "
> > earnings.com" address.
> >
> > If you change your URL to "www.earnings.
> > redirects.
> >
> > So I have to wonder if your bookmarked URL is being updated, and how much
> > longer it will exist?
> >
> > On Tue, Jun 18, 2013 at 5:15 AM, sjagers sjagers@... wrote:
> >
> > > I had the Earnings.com website bookmarked and just tried it (below):
> > >
> > > Here's the URL for Adobe's earnings history, as an example:
> > > http://earnings.
> > >
> > > And, the Earnings.com "highights&quo
> > > http://earnings.
> > >
> > > I'm not sure what the "client=
> > > I'm directed to the Reuter's website that Randy mentioned.
> > >
> > > I have a worksheet with several GetElementNumbers for Earnings.com and it
> > > hasn't worked for about 5 days now. They must have recently changed
> > > something.
> > >
> > > Could we tweak the URL lookup for the Earnings.com ElementNumbers so they
> > > look up data on the website that I had bookmarked?
> > >
> >
>
>
Wed Jun 19, 2013 6:09 am (PDT) . Posted by:
"another_investor" another_investor
Hi Randy
With regards to the 1000-page limit, I could swear on a previous post you mentioned there was a command/function to return the number of pages that have been cache/downloaded.
I have searched through the posts but cannot find it.
Have I been drinking too much again? ;-)
Many thanks in advance,
Steve
With regards to the 1000-page limit, I could swear on a previous post you mentioned there was a command/function to return the number of pages that have been cache/downloaded.
I have searched through the posts but cannot find it.
Have I been drinking too much again? ;-)
Many thanks in advance,
Steve
Wed Jun 19, 2013 6:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nothing like that exists that I know of...
Although it could be done manually via something like:
=SUM((smfGetAData(1,1)<>""),(smfGetAData(2,1)<>""),(smfGetAData(3,1)<>""),
..., (smfGetAData(1000,1)<>""))
Since each of those would contain a URL if the slot was being used.
On Wed, Jun 19, 2013 at 6:09 AM, another_investor
<steviejacobs@hotmail.com >wrote:
>
> With regards to the 1000-page limit, I could swear on a previous post you
> mentioned there was a command/function to return the number of pages that
> have been cache/downloaded.
> I have searched through the posts but cannot find it.
>
> Have I been drinking too much again? ;-)
>
Although it could be done manually via something like:
=SUM((smfGetAData(
..., (smfGetAData(
Since each of those would contain a URL if the slot was being used.
On Wed, Jun 19, 2013 at 6:09 AM, another_investor
<steviejacobs@
>
> With regards to the 1000-page limit, I could swear on a previous post you
> mentioned there was a command/function to return the number of pages that
> have been cache/downloaded.
> I have searched through the posts but cannot find it.
>
> Have I been drinking too much again? ;-)
>
Wed Jun 19, 2013 7:01 am (PDT) . Posted by:
"another_investor" another_investor
Hi Randy,
Thanks for the prompt reply - that's good enough for me.
All the best,
Steve
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Nothing like that exists that I know of...
>
> Although it could be done manually via something like:
>
> =SUM((smfGetAData(1,1)<>""),(smfGetAData(2,1)<>""),(smfGetAData(3,1)<>""),
> ..., (smfGetAData(1000,1)<>""))
>
> Since each of those would contain a URL if the slot was being used.
>
> On Wed, Jun 19, 2013 at 6:09 AM, another_investor
> <steviejacobs@...>wrote:
>
> >
> > With regards to the 1000-page limit, I could swear on a previous post you
> > mentioned there was a command/function to return the number of pages that
> > have been cache/downloaded.
> > I have searched through the posts but cannot find it.
> >
> > Have I been drinking too much again? ;-)
> >
>
Thanks for the prompt reply - that's good enough for me.
All the best,
Steve
--- In smf_addin@yahoogrou
>
> Nothing like that exists that I know of...
>
> Although it could be done manually via something like:
>
> =SUM((smfGetAData(
> ..., (smfGetAData(
>
> Since each of those would contain a URL if the slot was being used.
>
> On Wed, Jun 19, 2013 at 6:09 AM, another_investor
> <steviejacobs@
>
> >
> > With regards to the 1000-page limit, I could swear on a previous post you
> > mentioned there was a command/function to return the number of pages that
> > have been cache/downloaded.
> > I have searched through the posts but cannot find it.
> >
> > Have I been drinking too much again? ;-)
> >
>
Wed Jun 19, 2013 7:19 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
ah, i can see why i couldn't get it
I was referring to the webpage itself for the reference points.
The reason is the source code is way way way too messy and complex and i have difficulty getting it
But, it works like a charm as always and i am now looking back at the source code to learn more about it
thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 1. Your formula didn't work because zero makes no sense for where to
> find the table tags.
>
> =RCHGetHTMLTable("
> http://markets.ft.com/research/Markets/Tearsheets/Summary?s=GOOG:NSQ ","Past
> 90 Days",1,"",1)
>
> ...to get the table FOLLOWING the "Past 90 Days" string.
>
> 2. I think this would do it:
>
> =smfGetTagContent("
> http://markets.ft.com/research/Markets/Tearsheets/Summary?s= "&C4,
> "div",0,"Markit"," active")
>
> 3. This is as straight-forward as they come:
>
> =RCHGetHTMLTable("
> http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=GOOG:NSQ ","Deal
> Status",-1,"",1)
>
> 4. Also as easy as they come:
>
> =RCHGetHTMLTable("
> http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=AV.:LSE ","Market
> cap",-1,"",1)
>
> 5. Did you even try to do these?
>
> =RCHGetHTMLTable("
> http://markets.ft.com/research/Markets/Tearsheets/Business-profile?s=GOOG:NSQ ","%
> Held",-1,"",1)
>
> The easiest thing to do is find a search string unique enough INSIDE the
> table (usually a column heading) and then go backward (e.g.-1) for the
> start of the table and forward (e.g. 1) to find the end of the table.
>
> 6. A little trickier, but easy to find with the examination worksheet:
>
> =RCHGetHTMLTable("
> http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=GOOG:NSQ ","Consensus
> recommendation";,3,"",3)
>
> I just put in the URL and search string, then did some trial and error
> on the table start and table end parameters, starting with 1 and 1, then
> incrementing the table end value until I see the table I want. Then I know
> what the starting value should be as well.
>
> On Mon, Jun 17, 2013 at 8:20 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > 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..
> >
>
ah, i can see why i couldn't get it
I was referring to the webpage itself for the reference points.
The reason is the source code is way way way too messy and complex and i have difficulty getting it
But, it works like a charm as always and i am now looking back at the source code to learn more about it
thanks!
--- In smf_addin@yahoogrou
>
> 1. Your formula didn't work because zero makes no sense for where to
> find the table tags.
>
> =RCHGetHTMLTable(
> http://markets.
> 90 Days",1,
>
> ...to get the table FOLLOWING the "Past 90 Days" string.
>
> 2. I think this would do it:
>
> =smfGetTagContent(
> http://markets.
> "div"
>
> 3. This is as straight-forward as they come:
>
> =RCHGetHTMLTable(
> http://markets.
> Status"
>
> 4. Also as easy as they come:
>
> =RCHGetHTMLTable(
> http://markets.
> cap",-1,
>
> 5. Did you even try to do these?
>
> =RCHGetHTMLTable(
> http://markets.
> Held",-
>
> The easiest thing to do is find a search string unique enough INSIDE the
> table (usually a column heading) and then go backward (e.g.-1) for the
> start of the table and forward (e.g. 1) to find the end of the table.
>
> 6. A little trickier, but easy to find with the examination worksheet:
>
> =RCHGetHTMLTable(
> http://markets.
> recommendation"
>
> I just put in the URL and search string, then did some trial and error
> on the table start and table end parameters, starting with 1 and 1, then
> incrementing the table end value until I see the table I want. Then I know
> what the starting value should be as well.
>
> On Mon, Jun 17, 2013 at 8:20 AM, weekeewawa <weekeewawa@
>
> >
> > 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(
> > http://markets.
> > 90 Days",0,
> >
> > But i cant extract anything out even with all sort of combination in the
> > examination excel..
> >
>
Wed Jun 19, 2013 7:34 am (PDT) . Posted by:
"rogacox" rogacox
the function for returning the company name must have changed. it now returns a blank
Wed Jun 19, 2013 7:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sigh. It looks like MSN is starting to go through their annual "let's
change our web pages" process...
I've upload a new smf-element-1.txt file to the "Works in Progress" folder
with the new element definition.
On Wed, Jun 19, 2013 at 7:34 AM, rogacox <rogacox@yahoo.com > wrote:
> the function for returning the company name must have changed. it now
> returns a blank
>
change our web pages" process...
I've upload a new smf-element-
with the new element definition.
On Wed, Jun 19, 2013 at 7:34 AM, rogacox <rogacox@yahoo.
> the function for returning the company name must have changed. it now
> returns a blank
>
Wed Jun 19, 2013 5:40 pm (PDT) . Posted by:
"kabrod77" mustang66.7599
Hi Randy
Tried the new file – have errors with
=RCHGetElementNumber($A$1,27)
=RCHGetElementNumber($A$1, 28)
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Wednesday, June 19, 2013 10:55 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] 13862 now returns a blank
Sigh. It looks like MSN is starting to go through their annual "let's change our web pages" process...
I've upload a new smf-element-1.txt file to the "Works in Progress" folder with the new element definition.
On Wed, Jun 19, 2013 at 7:34 AM, rogacox <rogacox@yahoo.com > wrote:
the function for returning the company name must have changed. it now returns a blank
Tried the new file – have errors with
=RCHGetElementNumbe
=RCHGetElementNumbe
From: smf_addin@yahoogrou
Sent: Wednesday, June 19, 2013 10:55 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] 13862 now returns a blank
Sigh. It looks like MSN is starting to go through their annual "let'
I've upload a new smf-element-
On Wed, Jun 19, 2013 at 7:34 AM, rogacox <rogacox@yahoo.
the function for returning the company name must have changed. it now returns a blank
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Works-In-Progress/
Uploaded by : rharmelink <rharmelink@gmail.
Description : Updated to fix of element #13862, "Company Name" from MSN.
You can access this file at the URL:
http://groups.
To learn more about file sharing for your group, please visit:
http://help.
Regards,
rharmelink <rharmelink@gmail.
Wed Jun 19, 2013 11:20 am (PDT) . Posted by:
"Jim" buckleca
I see that MSN has changed things around. It seems they also changed data providers.
I sometimes use the Excel MSN web query (Stock Quotes Provided by MSN Money)and note that it's now limited to 50 quotes per query.
Also note that the company name is now all upper case. Some quotes no longer available (for warrants) in the Cdn market.
All this changed yesterday.
I sometimes use the Excel MSN web query (Stock Quotes Provided by MSN Money)and note that it's now limited to 50 quotes per query.
Also note that the company name is now all upper case. Some quotes no longer available (for warrants) in the Cdn market.
All this changed yesterday.
Wed Jun 19, 2013 3:27 pm (PDT) . Posted by:
"Mark" mballard34a
Thanks for fixing the company name from MSN. I am also getting errors retrieving elements number 35 and 35 (moving averages) and 27, 28, and 29 (price changes).
Thanks!
Thanks!
Wed Jun 19, 2013 4:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't see those on their new print page...
On Wed, Jun 19, 2013 at 3:26 PM, Mark <ballard@bankchampaign.com > wrote:
> Thanks for fixing the company name from MSN. I am also getting errors
> retrieving elements number 35 and 35 (moving averages) and 27, 28, and 29
> (price changes).
>
On Wed, Jun 19, 2013 at 3:26 PM, Mark <ballard@bankchampai
> Thanks for fixing the company name from MSN. I am also getting errors
> retrieving elements number 35 and 35 (moving averages) and 27, 28, and 29
> (price changes).
>
Tidak ada komentar:
Posting Komentar