Rabu, 30 Mei 2012

[smf_addin] Digest Number 2230[1 Attachment]

Messages In This Digest (10 Messages)

Messages

1a.

Covered Calls on Stocks I own - Existing Spreadsheet?

Posted by: "schlange.meister" schlange.meister@yahoo.com   schlange.meister

Tue May 29, 2012 6:23 am (PDT)




Hello All,

I currently invest in dividend stocks that I would be happy to own for
the foreseeable future and I let the dividends automatically be
reinvested. I have been recently thinking about writing covered calls
on the stocks to enhance the income stream.

I am at Fidelity now and the price to write a call option is I think:
9.95 + .75 cents per option (100 shares).

Now my question is:

1. Is there a good spreadsheet already that memebers recommend to
analyse the next 1-2 months out on the option charts and find which
option would give the best return with the least % change of being
called (best chance of expiring)?

Does anyone do this and have you found that writing calls is profitable
and worth the time?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1b.

Re: Covered Calls on Stocks I own - Existing Spreadsheet?

Posted by: "Sudhir Agarwal" Agarwal.sudhir@gmail.com   sudhir_agarwal1

Tue May 29, 2012 6:49 am (PDT)



Hi ,

Covered call can be beneficial but writing for 1-2 months may not work out
for you since the transaction cost may eat most of the profit.

Also, I hope you do understand that if the stocks move downward, you may
suffer a big loss on stock even though you may make money on call you sold
(that will lose value and may become worthless).

There was an article sometime back in Time/Money magazine where they have
analyzed and came to conclusion that Covered Call writers don't make much
money since the loss suffered in stocks may be compensated by money you make
on selling the calls.

I don't want to discourage you from doing the same but do make all the
calculation.

I will recommend that you send the out of money , leaps where you will get
significant premium to offset your transaction cost.

I can surely help you to put together that sheet where you can do all the
benefit analysis..

Sudhir

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of schlange.meister
Sent: Tuesday, May 29, 2012 9:24 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Covered Calls on Stocks I own - Existing Spreadsheet?

Hello All,

I currently invest in dividend stocks that I would be happy to own for
the foreseeable future and I let the dividends automatically be
reinvested. I have been recently thinking about writing covered calls
on the stocks to enhance the income stream.

I am at Fidelity now and the price to write a call option is I think:
9.95 + .75 cents per option (100 shares).

Now my question is:

1. Is there a good spreadsheet already that memebers recommend to
analyse the next 1-2 months out on the option charts and find which
option would give the best return with the least % change of being
called (best chance of expiring)?

Does anyone do this and have you found that writing calls is profitable
and worth the time?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1c.

Re: Covered Calls on Stocks I own - Existing Spreadsheet?

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Tue May 29, 2012 10:43 am (PDT)



Sudhir is right on

Since you are investing in the stocks already writing the Covered call is
not a bad idea. That is I am assuming you live thru the large draw downs now
as Sudhir mentioned.

I have done covered calls for years but I buy the LEAPS instead of the
stock. It ties up a lot less money. So you can do many more contacts. I
usually buy 2 to 3 years out LEAPS then sell the cover calls every 2 - 3
months.

The time/Money article is correct Covered calls are not highly profitable
but they are easy and take very little effort once you get the hang of it.
You definitely will want to paper trade them for awhile.

You might want to investigate Valueline as they have a very service
<http://www.valueline.com/Options/> http://www.valueline.com/Options/ I
think it is still run by my friend Lawrence D. Cavanagh. Lawrence was a
guest speaker on my "Seminar at Sea" in 2008. He has written several
articles on covered calls and they have an excellent report done daily on
ranking covered calls.

The quick answer to your question - Is there a good spreadsheet already that
members recommend to analyse

Yes, Valueline does it. They call them reports but it is really a
spreadsheet.

A quick search of the Valueline website shows these articles:



Managing a
<http://www.valueline.com/Tools/Educational_Articles/Options/Managing_a_Cove
red_Call_Portfolio.aspx> Covered Call Portfolio
Jun 19, 2009 ... A covered call portfolio is more complicated to manage than
a stock portfolio, but a few simple calculations and basic guidelines can
make its ...
www.valueline.com
www.valueline.com/.../Managing_a_Covered_Call_Portfolio.aspx
clipped from Google - 5/2012
<http://code.google.com/apis/ajaxsearch/faq.html>
10
<http://www.valueline.com/Options/Commentaries/10_Covered_Call_Myths_(or_%E2
%80%9CMyth_Conceptions%E2%80%9D).aspx> Covered Call Myths (or "Myth
Conceptions")
www.valueline.com
www.valueline.com/.../10_Covered_Call_Myths_(or_"Myth_Conceptions"). aspx

<http://www.valueline.com/Options/Commentaries/10_Covered_Call_Myths_(or_%E2
%80%9CMyth_Conceptions%E2%80%9D).aspx>
https://encrypted-tbn2.google.com/images?q=tbn:ANd9GcSFc8dX-4-iVQ42UhJxsUf54
SfvqAVkm64n2U7rd6FzbBiK-AJ3nfpJklk
10
<http://www.valueline.com/Options/Commentaries/10_Covered_Call_Myths_(or_%E2
%80%9CMyth_Conceptions%E2%80%9D).aspx> Covered Call Myths (or "Myth
Conceptions")
Aug 12, 2011 ... Much of what you are told about covered call writing, even
by many ... This week, we explore ten myths about covered call writing that
you may ...
www.valueline.com
www.valueline.com/.../10_Covered_Call_Myths_(or_"Myth_Conceptions"). aspx
clipped from Google - 5/2012
<http://code.google.com/apis/ajaxsearch/faq.html>

<http://www.valueline.com/WorkArea/linkit.aspx?LinkIdentifier=id&ItemID=7119
> Covered Calls: Doing the Math
www.valueline.com
www.valueline.com/WorkArea/linkit.aspx?LinkIdentifier=id...

<http://www.valueline.com/WorkArea/linkit.aspx?LinkIdentifier=id&ItemID=7119
>
https://encrypted-tbn1.google.com/images?q=tbn:ANd9GcQvl_Yx2vHtC2b0WTsH3hIGj
DRoAUZzTPaYSCXNOPpOnXZRbEkCSCSHIYY

<http://www.valueline.com/WorkArea/linkit.aspx?LinkIdentifier=id&ItemID=7119
> Covered Calls: Doing the Math
Jun 19, 2009 ... Why and when should I invest in a covered call? Which
covered calls are best for me? In this report, we review some helpful
covered call ...
www.valueline.com
www.valueline.com/WorkArea/linkit.aspx?LinkIdentifier=id...
clipped from Google - 5/2012
<http://code.google.com/apis/ajaxsearch/faq.html>
Using Value Line Options for Your
<http://www.valueline.com/Options/Commentaries/Using_Value_Line_Options_for_
Your_Covered_Calls.aspx> Covered Calls
www.valueline.com
www.valueline.com/.../Using_Value_Line_Options_for_Your_Covered_Calls .aspx

<http://www.valueline.com/Options/Commentaries/Using_Value_Line_Options_for_
Your_Covered_Calls.aspx>
https://encrypted-tbn0.google.com/images?q=tbn:ANd9GcTGWQxgmTXzPLn6FhpwF0zcl
L5g8UBz6NvBDNj21buG2q6PpJ-qKlm0JK0
Using Value Line Options for Your
<http://www.valueline.com/Options/Commentaries/Using_Value_Line_Options_for_
Your_Covered_Calls.aspx> Covered Calls
Dec 22, 2009 ... We believe that The Value Line Daily Options Survey offers
the best tools in the business for the covered call investor. These tools
include our ...
www.valueline.com
www.valueline.com/.../Using_Value_Line_Options_for_Your_Covered_Calls .aspx
clipped from Google - 5/2012
<http://code.google.com/apis/ajaxsearch/faq.html>
March 2009 Quarter Option and
<http://www.valueline.com/Options/Commentaries/March_2009_Quarter_Option_and
_Covered_Call_Rank_Performance.aspx> Covered Call Rank Performance
www.valueline.com
www.valueline.com/.../March_2009_Quarter_Option_and_Covered_Call_
Rank_Performance.aspx

<http://www.valueline.com/Options/Commentaries/March_2009_Quarter_Option_and
_Covered_Call_Rank_Performance.aspx>
https://encrypted-tbn3.google.com/images?q=tbn:ANd9GcQeJ1sy57TWdj0GBAXDAuXY-
RWBtzlm5s2VTTiYD_iNrg0iDcL2_IeoTgsH
March 2009 Quarter Option and
<http://www.valueline.com/Options/Commentaries/March_2009_Quarter_Option_and
_Covered_Call_Rank_Performance.aspx> Covered Call Rank Performance
May 18, 2009 ... March 2009 Quarter Option and Covered Call Rank
Performance. Loading... In as much as our rank order performance was mixed,
the March ...
www.valueline.com
www.valueline.com/.../March_2009_Quarter_Option_and_Covered_Call_
Rank_Performance.aspx

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Sudhir Agarwal
Sent: Tuesday, May 29, 2012 9:49 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Covered Calls on Stocks I own - Existing
Spreadsheet?


Hi ,
Covered call can be beneficial but writing for 1-2 months may not work out
for you since the transaction cost may eat most of the profit.
Also, I hope you do understand that if the stocks move downward, you may
suffer a big loss on stock even though you may make money on call you sold
(that will lose value and may become worthless).
There was an article sometime back in Time/Money magazine where they have
analyzed and came to conclusion that Covered Call writers don't make much
money since the loss suffered in stocks may be compensated by money you make
on selling the calls.
I don't want to discourage you from doing the same but do make all the
calculation.
I will recommend that you send the out of money , leaps where you will get
significant premium to offset your transaction cost.
I can surely help you to put together that sheet where you can do all the
benefit analysis..

Sudhir

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of schlange.meister
Sent: Tuesday, May 29, 2012 9:24 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Covered Calls on Stocks I own - Existing Spreadsheet?



Hello All,

I currently invest in dividend stocks that I would be happy to own for
the foreseeable future and I let the dividends automatically be
reinvested. I have been recently thinking about writing covered calls
on the stocks to enhance the income stream.

I am at Fidelity now and the price to write a call option is I think:
9.95 + .75 cents per option (100 shares).

Now my question is:

1. Is there a good spreadsheet already that memebers recommend to
analyse the next 1-2 months out on the option charts and find which
option would give the best return with the least % change of being
called (best chance of expiring)?

Does anyone do this and have you found that writing calls is profitable
and worth the time?


Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1d.

Re: Covered Calls on Stocks I own - Existing Spreadsheet?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue May 29, 2012 12:09 pm (PDT)



In my experience, quality dividend stocks usually have very low premiums,
high spreads, and bad liquidty on their options.

On Tue, May 29, 2012 at 6:23 AM, schlange.meister <
schlange.meister@yahoo.com> wrote:

>
> Hello All,
>
> I currently invest in dividend stocks that I would be happy to own for
> the foreseeable future and I let the dividends automatically be
> reinvested. I have been recently thinking about writing covered calls
> on the stocks to enhance the income stream.
>
> I am at Fidelity now and the price to write a call option is I think:
> 9.95 + .75 cents per option (100 shares).
>
> Now my question is:
>
> 1. Is there a good spreadsheet already that memebers recommend to
> analyse the next 1-2 months out on the option charts and find which
> option would give the best return with the least % change of being
> called (best chance of expiring)?
>
> Does anyone do this and have you found that writing calls is profitable
> and worth the time?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1e.

Re: Covered Calls on Stocks I own - Existing Spreadsheet?

Posted by: "schlange.meister" schlange.meister@yahoo.com   schlange.meister

Tue May 29, 2012 11:27 pm (PDT)



Thanks all,

It appears to be the case that the long term dividend stocks are not best for calls. I was looking to make a small incremental return in addition to the stock appreciation and dividends, but it seems not many of the holdings have options. I guess if I want to do covered calls, i need to think about other stocks that I would be happy to hold for long term.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> In my experience, quality dividend stocks usually have very low premiums,
> high spreads, and bad liquidty on their options.
>
> On Tue, May 29, 2012 at 6:23 AM, schlange.meister <
> schlange.meister@...> wrote:
>
> >
> > Hello All,
> >
> > I currently invest in dividend stocks that I would be happy to own for
> > the foreseeable future and I let the dividends automatically be
> > reinvested. I have been recently thinking about writing covered calls
> > on the stocks to enhance the income stream.
> >
> > I am at Fidelity now and the price to write a call option is I think:
> > 9.95 + .75 cents per option (100 shares).
> >
> > Now my question is:
> >
> > 1. Is there a good spreadsheet already that memebers recommend to
> > analyse the next 1-2 months out on the option charts and find which
> > option would give the best return with the least % change of being
> > called (best chance of expiring)?
> >
> > Does anyone do this and have you found that writing calls is profitable
> > and worth the time?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2a.

Pull competitor data using RCHGETHTMLTABLE() function

Posted by: "Amir" amir.rehman@yahoo.com   amir.rehman

Tue May 29, 2012 8:12 am (PDT)



hi all,

I am trying to pull data from

http://finance.yahoo.com/q/in?s=MSFT

about the competitors in excel but can't do so. Please help

Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: Pull competitor data using RCHGETHTMLTABLE() function

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue May 29, 2012 8:37 am (PDT)



Try:

=RCHGetHTMLTable("http://finance.yahoo.com/q/in?s=MSFT",">Market
Cap",-1,"",1)

On Tue, May 29, 2012 at 8:12 AM, Amir <amir.rehman@yahoo.com> wrote:

>
> I am trying to pull data from
>
> http://finance.yahoo.com/q/in?s=MSFT
>
> about the competitors in excel but can't do so. Please help
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3.1.

Re: ADVFN Financial Statements

Posted by: "Clark F. Grain" cgrain@rcn.com   cgrain76

Tue May 29, 2012 8:38 am (PDT)

[Attachment(s) from Clark F. Grain included below]

Kermit,

The spreadsheets have been configured such that companies that do not have at least five years of sales and earnings are not analyzed properly. I have attached a copy in which I changed the settings for AGNC,and left the "Start" and "Calculation" tabs unprotected. I belong to an Investment Club and we usuually don't consider campanies with less than five years of earnings.

The -274 should not be where it is,but is related to the number days left in the current fiscal year.

If you go to the Fundemental and Financial tabs you will see a column in each that list the criteria required for a company to be given a high rating. We usuallly do not buy campanies .with an overall rating less than 80. I hope this information is helpful.

Clark Grain
----- Original Message -----
From: Kermit W. Prather
To: smf_addin@yahoogroups.com
Sent: Saturday, May 26, 2012 9:56 AM
Subject: RE: [smf_addin] Re: ADVFN Financial Statements

Clark, thanks, I just downloaded both versions. They both work well. However, they both have problems on stocks that were listed after 2007, such as AGNC.

Since this isn't an SMF addin function is there another place where we can discuss your spreadsheet? This looks like a tremendous about of work on your part and we appreciate your willingness to share it.

I know it is asking a lot but for those of us that are not great on fundamentals could you possibly provide more instructi! ons on how to best take advantage of these spreadsheet.

For example, using IBM I see this on the Start worksheet

SCORES

Fundamental
72

Financial
56

Average
64

StockScouter Rating
10

-274


I am familiar with stockscouter but not with the other scores and what is the -274

Thanks,

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Clark F. Grain
Sent: Friday, May 25, 2012 9:27 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: ADVFN Financial Statements

I forgot to give instructions. Open the Start tab and type in the stock symbol in the upper left cell (Blue) press enter and wait about 30 seconds or so for the downloads to! finish.

C. Grain

----- Original Message -----

From: rebalance85

To: smf_addin@yahoogroups.com

Sent: Thursday, May 24, 201! 2 11:01 PM

Subject: [smf_addin] Re: ADVFN Financial Statements

Thank you very much for your kindess.
We want to have 10 years financial statments, the goal is the same, find, analysis, buy and sell.
I want to put some tab into your file, if it's possible, I will sent the file to your mailbox.
Thanks again!

--- In smf_addin@yahoogroups.com, "Clark F. Grain" <cgrain@...> wrote:
>
> Hello all,
>
> I am not sure about what you are trying to accomplish. I think you are interested in downloading financial data, for specific companies, in order to purchase shares of ! the company, If this is true I have developed a rather simple way of getting the data and analyzing it using "web queries". If you are interested the spreadsheets can be downloaded from the link shown below. The files to be downloaded are "SA_6.0.4"(Excel 2007-2010), and "SA_6.0.4(2000) for Excel 97-2003.
>
> C. Grain
> https://www.myiclub.com/club/folders/public.aspx?club=3442

Attachment(s) from Clark F. Grain

1 of 1 File(s)

AGNC.xlsm
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (30)
4a.

Re: All Equity Summary Score

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Wed May 30, 2012 1:09 am (PDT)



Randy,
Thank you for your help.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The RCHGetTableCell() function will not work, because the data is not
> within a table. You'll need to use the smfGetTagContent() function.
>
> Try something like this (untested, of course):
>
> =smfGetTagContent("
> http://eresearch.fidelity.com/eresearch/goto/evaluate/analystsOpinions.jhtml?symbols=ALL","span",1,"ALL
> Equity Summary Score:")
>
> ...although that will give you something you'll need to extract the
> necessary data from. The smfStrExtr() functionj would probably be best for
> that.
>
> On Mon, May 28, 2012 at 11:15 AM, smithjhhic <smithjhhic@...> wrote:
>
> > I am attempting to retrieve the "All Equity Summary Score:" from Fidelity,
> > but have an error in my formula. I'd like to return "Bullish (8.2)" from
> > the pages code below. However, my formula returns "ALL Equity Summary
> > Score Firms", which is at the bottom of the cut/pasted code. I'd
> > appreciate any help getting me on the right track.
> >
> > =RCHGetTableCell("
> > http://eresearch.fidelity.com/eresearch/goto/evaluate/analystsOpinions.jhtml?symbols=ALL",1,"ALL
> > Equity Summary Score:")
> >
> >
> > <h3>ALL Equity Summary Score:
> > </h3>
> > <span class="stock-sentiment"><span class='tableCallout'>Bullish</span>
> > (8.2)</span>
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
5.

hello

Posted by: "J. S. Deason" js_deason@yahoo.com   js_deason

Wed May 30, 2012 1:11 am (PDT)




wow this is pretty crazy you should look into it http://www.ethnews.net/biz/?news=7378601

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.14

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)