Rabu, 19 Juni 2013

[smf_addin] Digest Number 2661

9 New Messages

Digest #2661
1a
Re: earnings.com data issue? by "sjagers" sjagers
1b
Re: earnings.com data issue? by "Randy Harmelink" rharmelink
1c
Re: earnings.com data issue? by "Paul Dyson" pdyson10
1d
Re: earnings.com data issue? by "Randy Harmelink" rharmelink
2a
Credit Spread Option Screener? by "schlange.meister" schlange.meister
2b
Re: Credit Spread Option Screener? by "Randy Harmelink" rharmelink
4a
Re: financial times extraction by "Randy Harmelink" rharmelink

Messages

Tue Jun 18, 2013 5:15 am (PDT) . Posted by:

"sjagers" sjagers

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?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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?
> >
>

Tue Jun 18, 2013 6:00 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

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@yahoo.com> 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&quot; 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?
>

Tue Jun 18, 2013 11:01 am (PDT) . Posted by:

"Paul Dyson" pdyson10

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&quot; 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?
> >
>

Tue Jun 18, 2013 11:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your "row" parameter is in the wrong place. There are four search string
parameters., Try something like:

=RCHGetTableCell("
http://earnings.com/company.asp?ticker=ADBE&coid=110578&client=cb",
col,"earnings releases",,,,row)

Note the extra commas before "row", as placeholders for the unused
parameters. Otherwise, it uses your "row" as the second search string.

On Tue, Jun 18, 2013 at 10:44 AM, Paul Dyson <pdysonuk@gmail.com> wrote:

>
> 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?
>
>

Tue Jun 18, 2013 5:34 am (PDT) . Posted by:

"schlange.meister" schlange.meister

Hello Randy and Others,

I have used a SMF sheet that I really like to find the best Call to write for ITM and OTM covered calls based on Return if exercised or expired.

I was wondering if there is a similar sheet which will determine various credit spreads (bull put or bear call) that will look at % return based on risk capital, Probability of expiring (ToS has this in the platform, but not sure if available elsewhere).

Any ideas on how to create something like this if it does not already exist?

Tue Jun 18, 2013 6:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Well, the various utility option functions can tell you what expirations
and strikes are available, as well as which strikes are ITM or OTM.

I don't do anything with spreads. Wouldn't the biggest issue be doing the
possible combinations?

In terms of creating it -- I would do a mock-up by hand, and then look at
automating the retrieval of the data for that model. I don't even have a
concept of what such a model would even look like.

On Tue, Jun 18, 2013 at 5:34 AM, schlange.meister <
schlange.meister@yahoo.com> wrote:

>
> I have used a SMF sheet that I really like to find the best Call to write
> for ITM and OTM covered calls based on Return if exercised or expired.
>
> I was wondering if there is a similar sheet which will determine various
> credit spreads (bull put or bear call) that will look at % return based on
> risk capital, Probability of expiring (ToS has this in the platform, but
> not sure if available elsewhere).
>
> Any ideas on how to create something like this if it does not already
> exist?
>

Tue Jun 18, 2013 5:48 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Thanks, Randy

That is very possible as I tend to have more activity during testing. I'll try reducing the number of request.

Do you have any suggestions on how I can control the rate of request so I don't flood the site with request?

I was thinking maybe a macro to control the time interval to retrieve only 3 or 4 symbols at a time.

Really appreciate all you do for us less excel capable folks.

I know you don't do this for personal rewards but is there a charity that we can contribute to in your name?

Thanks again, Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Monday, June 17, 2013 10:11 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo Real Time Quote with smfGetTagContent Function


I just tried getting all of the web pages in my browser at the same time. Many had a web page that simply said "Try later". So all of those will get "Error" returned by an add-in function, since there is nothing in the content of the web page to extract.

So it is the website telling you you're accessing too many web pages too quickly. I don't know what their determination is of that. Presumably, number of requests from an IP address.
On Mon, Jun 17, 2013 at 5:36 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

Randy, I just uploaded this file -- Fails-on-upper-and-lower-case-symbols.xlsx -- to the Files <http://finance.groups.yahoo.com/group/smf_addin/files/> > Uploads by forum members folder

It is just one example of a spreadsheet that fails on upper or lower case. To test it I have been rebooting each time before I open the file. The same symbols do not fail every time.
I hilited in RED those which were failing the last time I save the file. All of the symbols in this file are valid on dividata.com
Also, it has nothing to do with how many symbols I have in the list. It has failed with as little as 6 and as many as is in the uploaded file.

Yes rebooting does not make a difference as I testing by rebooting before each file open and without rebooting it fails both ways. I rebooted just to eliminate that as a cause.

This fails on a few other spreadsheet I have as well.


Tue Jun 18, 2013 6:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The best way I know to limit retrieval is using the smfUpdateDownloadTable
process, since it will only update rows of data until it finds an empty
ticker symbol. And since it does it row-by-row, you know the ORDER of the
calculations that are being done. When you use formulas throughout the
workbook, it can be difficult to tell which ones will calculate first. I
generally delete the data in the rows I'm going to update -- it just makes
it easier to see the progress of the macro.

smfUpdateDownloadTable would also make it easier to redo those that come
back as error. Just sort them to the top, insert a blank line, run
smfForceRecalculation to purge the previously retrieve web pages, and run
smfUpdateDownloadTable again. Only those rows at the top will be updated.

There is an enhancement to smfUpdateDownloadTable that someone posted that
would allow the updates to be controlled by highlighting which rows to
update before running the macro. But I've never gotten around to updating
the macro that way. It would be handy in a situation like this.

My preferred charity would be the American Cancer Society. Cancer has
struck several members of my family several times.

On Tue, Jun 18, 2013 at 5:48 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
>
> That is very possible as I tend to have more activity during testing. I'll
> try reducing the number of request. ****
>
> ** **
>
> Do you have any suggestions on how I can control the rate of request so I
> don't flood the site with request? ****
>
> ** **
>
> I was thinking maybe a macro to control the time interval to retrieve only
> 3 or 4 symbols at a time.****
>
> ** **
>
> Really appreciate all you do for us less excel capable folks. ****
>
> ** **
>
> I know you don't do this for personal rewards but is there a charity that
> we can contribute to in your name? ****
>
>
>

Tue Jun 18, 2013 1:06 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

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@yahoo.com> 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..
>
Diposting oleh EXCEL FEED LEARNING di 01.38

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)