Jumat, 11 Maret 2016

[smf_addin] Digest Number 3655

9 Messages

Digest #3655
1a
1b
Re: Fundamental Analysis in excel by "Randy Harmelink" rharmelink
2b
Re: Getting Delta for Options by "Randy Harmelink" rharmelink
2d
Re: Getting Delta for Options by "Randy Harmelink" rharmelink
2e
Re: Getting Delta for Options by "Kermit W. Prather" kermitpra
3b
Re: 10 Years of History by Ticker? by "Randy Harmelink" rharmelink

Messages

Thu Mar 10, 2016 8:17 am (PST) . Posted by:

ppinal_ppravin

Hello Friends,


I would like to have a excel sheet where all the required data for fundamental analysis can be extracted from website. If you have any such kind of sheet or formula for indian stock market, please send me.


Regards

Thu Mar 10, 2016 8:24 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You could need to use the add-in formulas to create such a worksheet
yourself. But the add-in is just a tool to use to build it, not a
fundamental analysis product itself.

On Thu, Mar 10, 2016 at 6:35 AM, ppinal_ppravin@yahoo.co.in [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I would like to have a excel sheet where all the required data for
> fundamental analysis can be extracted from website. If you have any such
> kind of sheet or formula for indian stock market, please send me.
>
>
>
>

Thu Mar 10, 2016 9:50 am (PST) . Posted by:

gfullmer

Gone through a lot of old conversations and examples in the file section about getting the Greek Delta for options. Are the only way still through Options Express and/or Zacks? What is the most up-to-date way to do that? Thanks in advance.

Thu Mar 10, 2016 11:03 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Best way is using the "OX2" source code, as in:

=smfGetOptionQuotes("SPY 3/11 2016 $200 Call","5",,"OX2")

Zacks isn't an available source code.

On Thu, Mar 10, 2016 at 10:50 AM, dgfullmer@... wrote:

> Gone through a lot of old conversations and examples in the file section
> about getting the Greek Delta for options. Are the only way still through
> Options Express and/or Zacks? What is the most up-to-date way to do that?
> Thanks in advance.
>

Thu Mar 10, 2016 11:26 am (PST) . Posted by:

gfullmer

Thanks, Randy - works like a charm. Working on a expected rate of return for different types of spreads using delta, risk/reward, etc. Anyone done that recently that you know? Thanks again.

Thu Mar 10, 2016 11:34 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I don't do anything with spreads, so I'd pretty much automatically filter
out any messages I see about them. Sorry.

On Thu, Mar 10, 2016 at 12:26 PM, dgfullmer@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks, Randy - works like a charm. Working on a expected rate of return
> for different types of spreads using delta, risk/reward, etc. Anyone done
> that recently that you know? Thanks again.
>

Thu Mar 10, 2016 12:11 pm (PST) . Posted by:

"Kermit W. Prather" kermitpra

You might try a google search or use this one

http://www.google.com/url?sa=t <http://www.google.com/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=1&ved=0ahUKEwiF38eL8bbLAhWFlx4KHYoLCVMQFggwMAA&url=http%3A%2F%2Fwww.exinfm.com%2Fexcel%2520files%2FOptionTradingWorkbook.xls&usg=AFQjCNFJ4kkCJq8Os7MvXyND8uopejAO0w> &rct=j&q=&esrc=s&frm=1&source=web&cd=1&ved=0ahUKEwiF38eL8bbLAhWFlx4KHYoLCVMQFggwMAA&url=http%3A%2F%2Fwww.exinfm.com%2Fexcel%2520files%2FOptionTradingWorkbook.xls&usg=AFQjCNFJ4kkCJq8Os7MvXyND8uopejAO0w

or this online one which I use often.

http://www.optionsprofitcalculator.com/

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, March 10, 2016 2:34 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Getting Delta for Options


I don't do anything with spreads, so I'd pretty much automatically filter out any messages I see about them. Sorry.

On Thu, Mar 10, 2016 at 12:26 PM, dgfullmer@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Thanks, Randy - works like a charm. Working on a expected rate of return for different types of spreads using delta, risk/reward, etc. Anyone done that recently that you know? Thanks again.


Thu Mar 10, 2016 1:49 pm (PST) . Posted by:

partlowjeff

I'm a newbie and have not looked at details yet of how to develop an SMF Add-In. But if it is possible, I'm very interested in obtaining one that will show the 10 most recent years of history for various metrics (ROE, etc. etc.) by company ticker. Hoping someone who is currently already doing this is willing to mentor me to get me up and running.

Thanks for your consideration,
Jeff Partlow
partlow@cox.net


Thu Mar 10, 2016 5:28 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Hey Jeff. I thought you were already using the add-in for options-based
worksheets?

In any case, there are several sources of 10-year data.

AdvFN has data going back to 1992-1993, both quarterly and annually.
However, there have been times I was suspicious of their numbers, or their
updating has lagged quite a bit, so I'm really leery of them these days.
There are several template showing how to retrieve data from AdvFN.

MorningStar has some easily accessible CSV files, which you could actually
get without the add-in. But it does require you to be a member for the
10-year set of data. See:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/19776

The data source I primarily use these days is GuruFocus, but it requires
subscriber fees for more than 5 years of data on a few data items.
Subscribers have access to 20 years of quarterly and annual data.

On Thu, Mar 10, 2016 at 2:49 PM, partlow@... wrote:

>
> I'm a newbie and have not looked at details yet of how to develop an SMF
> Add-In. But if it is possible, I'm very interested in obtaining one that
> will show the 10 most recent years of history for various metrics (ROE,
> etc. etc.) by company ticker. Hoping someone who is currently already
> doing this is willing to mentor me to get me up and running.
>
> Thanks for your consideration,
> Jeff Partlow
> partlow@cox.net
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar