9 Messages
Digest #3655
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
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.
>
>
>
>
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.
>
=smfGetOptionQuotes
Zacks isn't an available source code.
On Thu, Mar 10, 2016 at 10:50 AM, dgfullmer@..
> 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.
>
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.
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
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
>
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:
Posting Komentar