4 New Messages
Digest #2603
Messages
Fri May 3, 2013 11:45 am (PDT) . Posted by:
"oryxius" oryxius
Thanks Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Nope. You'd need to use RCHGetTableCell(), as in:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/ao?s=MMM ",1,"(this week)")
>
> On Thu, May 2, 2013 at 3:56 AM, oryxius <oryxius@...> wrote:
>
> >
> > Is there an element number to get Yahoo's analysts mean recommendation for
> > a stock? For example:
> >
> > http://finance.yahoo.com/q/ao?s=mmm&ql=1
> >
>
--- In smf_addin@yahoogrou
>
> Nope. You'd need to use RCHGetTableCell(
>
> =RCHGetTableCell(
>
> On Thu, May 2, 2013 at 3:56 AM, oryxius <oryxius@
>
> >
> > Is there an element number to get Yahoo's analysts mean recommendation for
> > a stock? For example:
> >
> > http://finance.
> >
>
Fri May 3, 2013 3:05 pm (PDT) . Posted by:
"nmalhotr" nmalhotr
Try these two websites
1) This one will search candidates - you can change parameters. There is a tab for put write and strangles as well.
http://dollarfor40cents.com/find/coveredcall
2) More detailed results on all your options
http://www.optionsprofitcalculator.com/
The plugin is great for tracking options but I prefer these two sites for identifying strategies. And they are both free for now.
N
--- In smf_addin@yahoogroups.com , "schlange.meister" <schlange.meister@...> wrote:
>
> Hi Guys,
>
> I am looking for a good way or spreadsheet (if it already exists) that will identify the best in the money and out of the money calls to write on a portfolio of 5 - 10 symbols to help me write buy-writes or covered calls.
>
> Does this exist already or do you guys have recommendations on how to set something like this up? I do not need to see all available options, but would look at highest return on if option was exercised and highest return if unexercised as the "best" calls and with a max duration of 45 days.
>
1) This one will search candidates - you can change parameters. There is a tab for put write and strangles as well.
http://dollarfor40c
2) More detailed results on all your options
http://www.optionsp
The plugin is great for tracking options but I prefer these two sites for identifying strategies. And they are both free for now.
N
--- In smf_addin@yahoogrou
>
> Hi Guys,
>
> I am looking for a good way or spreadsheet (if it already exists) that will identify the best in the money and out of the money calls to write on a portfolio of 5 - 10 symbols to help me write buy-writes or covered calls.
>
> Does this exist already or do you guys have recommendations on how to set something like this up? I do not need to see all available options, but would look at highest return on if option was exercised and highest return if unexercised as the "best" calls and with a max duration of 45 days.
>
Fri May 3, 2013 4:12 pm (PDT) . Posted by:
"antonvanas1989" antonvanas1989
Hello Randy,
I have some problems on my sheet using: Yahoo price by dates (low, high, close, adj. close) and calculating ratios with those data.
Coca Cola (KO) 2012 2011 2010 2009
Diluted EPS 1,97 1,85 2,53 1,47
Price by dates from Yahoo
period low 32,15 28,97 22,88 16,46
period high 39,83 34,36 30,92 27,05
period close 35,99 33,78 30,86 25,93
not adjusted close 36,25 69,97 65,77 57,00
My sheet at this moment
PE Close 18,40 37,82 26,00 38,78
PE High 20,22 18,57 12,22 18,40
PE Low 16,32 15,66 9,04 11,20
Actual PE from Advfn
PE Close 18,4 19 13 19,5
PE High 20,6 19,5 13 20,4
PE Low 16,9 16,7 9,8 12,8
As you can see the data i calculate is not correct. The problem is because yahoo adjust the prices (i think for dividend). So my calculations will get off more and more after adjustment.
Now can i use Advfn data direct from the website, but then i have the following problem:
Because i am from Europa i like to use my sheet for American and Europeaan stocks aswell.
Advfn is not showing lot of stocks from Europe so i use for those calculations data from Msn instead.
So when i calculate all the formules on my own it is still working fine, but at this moment the data is not correct because the adjustments... How do you think about this? Hope you have a solution for me so i can still use data from both MSN and Advfn.
I have some problems on my sheet using: Yahoo price by dates (low, high, close, adj. close) and calculating ratios with those data.
Coca Cola (KO) 2012 2011 2010 2009
Diluted EPS 1,97 1,85 2,53 1,47
Price by dates from Yahoo
period low 32,15 28,97 22,88 16,46
period high 39,83 34,36 30,92 27,05
period close 35,99 33,78 30,86 25,93
not adjusted close 36,25 69,97 65,77 57,00
My sheet at this moment
PE Close 18,40 37,82 26,00 38,78
PE High 20,22 18,57 12,22 18,40
PE Low 16,32 15,66 9,04 11,20
Actual PE from Advfn
PE Close 18,4 19 13 19,5
PE High 20,6 19,5 13 20,4
PE Low 16,9 16,7 9,8 12,8
As you can see the data i calculate is not correct. The problem is because yahoo adjust the prices (i think for dividend). So my calculations will get off more and more after adjustment.
Now can i use Advfn data direct from the website, but then i have the following problem:
Because i am from Europa i like to use my sheet for American and Europeaan stocks aswell.
Advfn is not showing lot of stocks from Europe so i use for those calculations data from Msn instead.
So when i calculate all the formules on my own it is still working fine, but at this moment the data is not correct because the adjustments.
Fri May 3, 2013 4:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo adjusts both for dividends and for splits. I would think you'd want
prices adjusted only by splits for your calculations. But that's just an
opinion.
You could do your own adjustments, only for splits. See:
http://finance.groups.yahoo.com/group/smf_addin/message/14400
On Fri, May 3, 2013 at 4:12 PM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> Hello Randy,
>
> I have some problems on my sheet using: Yahoo price by dates (low, high,
> close, adj. close) and calculating ratios with those data.
>
> Coca Cola (KO) 2012 2011 2010 2009
>
> Diluted EPS 1,97 1,85 2,53 1,47
>
> Price by dates from Yahoo
> period low 32,15 28,97 22,88 16,46
> period high 39,83 34,36 30,92 27,05
> period close 35,99 33,78 30,86 25,93
> not adjusted close 36,25 69,97 65,77 57,00
>
> My sheet at this moment
> PE Close 18,40 37,82 26,00 38,78
> PE High 20,22 18,57 12,22 18,40
> PE Low 16,32 15,66 9,04 11,20
>
> Actual PE from Advfn
> PE Close 18,4 19 13 19,5
> PE High 20,6 19,5 13 20,4
> PE Low 16,9 16,7 9,8 12,8
>
> As you can see the data i calculate is not correct. The problem is because
> yahoo adjust the prices (i think for dividend). So my calculations will get
> off more and more after adjustment.
>
>
>
> Now can i use Advfn data direct from the website, but then i have the
> following problem:
>
> Because i am from Europa i like to use my sheet for American and Europeaan
> stocks aswell.
>
> Advfn is not showing lot of stocks from Europe so i use for those
> calculations data from Msn instead.
>
>
>
> So when i calculate all the formules on my own it is still working fine,
> but at this moment the data is not correct because the adjustments... How
> do you think about this? Hope you have a solution for me so i can still use
> data from both MSN and Advfn.
>
prices adjusted only by splits for your calculations. But that's just an
opinion.
You could do your own adjustments, only for splits. See:
http://finance.
On Fri, May 3, 2013 at 4:12 PM, antonvanas1989 <antonvanas1989@
> Hello Randy,
>
> I have some problems on my sheet using: Yahoo price by dates (low, high,
> close, adj. close) and calculating ratios with those data.
>
> Coca Cola (KO) 2012 2011 2010 2009
>
> Diluted EPS 1,97 1,85 2,53 1,47
>
> Price by dates from Yahoo
> period low 32,15 28,97 22,88 16,46
> period high 39,83 34,36 30,92 27,05
> period close 35,99 33,78 30,86 25,93
> not adjusted close 36,25 69,97 65,77 57,00
>
> My sheet at this moment
> PE Close 18,40 37,82 26,00 38,78
> PE High 20,22 18,57 12,22 18,40
> PE Low 16,32 15,66 9,04 11,20
>
> Actual PE from Advfn
> PE Close 18,4 19 13 19,5
> PE High 20,6 19,5 13 20,4
> PE Low 16,9 16,7 9,8 12,8
>
> As you can see the data i calculate is not correct. The problem is because
> yahoo adjust the prices (i think for dividend). So my calculations will get
> off more and more after adjustment.
>
>
>
> Now can i use Advfn data direct from the website, but then i have the
> following problem:
>
> Because i am from Europa i like to use my sheet for American and Europeaan
> stocks aswell.
>
> Advfn is not showing lot of stocks from Europe so i use for those
> calculations data from Msn instead.
>
>
>
> So when i calculate all the formules on my own it is still working fine,
> but at this moment the data is not correct because the adjustments.
> do you think about this? Hope you have a solution for me so i can still use
> data from both MSN and Advfn.
>
Tidak ada komentar:
Posting Komentar