11 New Messages
Digest #2541
3a
Calculating Historical Breaking Below Of Simple10 Day Moving Average by "iloveangelsanne" iloveangelsanne
3b
Re: Calculating Historical Breaking Below Of Simple10 Day Moving Ave by "Randy Harmelink" rharmelink
Messages
Mon Mar 11, 2013 8:07 am (PDT) . Posted by:
"iamruf" iamruf
Hi Randy,
Is there a site/formula that would extract/provide number of consecutive months a company paid a dividend?
e.g. Am looking for best way to find companies that have been consistent in paying dividends without having to look up history on each.
Best regards
Is there a site/formula that would extract/provide number of consecutive months a company paid a dividend?
e.g. Am looking for best way to find companies that have been consistent in paying dividends without having to look up history on each.
Best regards
Mon Mar 11, 2013 9:11 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Would the Dividend Champion workbook from this web site suffice?
http://dripinvesting.org/Tools/Tools.asp
On Mon, Mar 11, 2013 at 8:07 AM, iamruf <iamruf@yahoo.com > wrote:
> Hi Randy,
> Is there a site/formula that would extract/provide number of consecutive
> months a company paid a dividend?
> e.g. Am looking for best way to find companies that have been consistent
> in paying dividends without having to look up history on each.
> Best regards
>
http://dripinvestin
On Mon, Mar 11, 2013 at 8:07 AM, iamruf <iamruf@yahoo.
> Hi Randy,
> Is there a site/formula that would extract/provide number of consecutive
> months a company paid a dividend?
> e.g. Am looking for best way to find companies that have been consistent
> in paying dividends without having to look up history on each.
> Best regards
>
Mon Mar 11, 2013 11:38 am (PDT) . Posted by:
"iamruf" iamruf
Great start- many thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Would the Dividend Champion workbook from this web site suffice?
>
> http://dripinvesting.org/Tools/Tools.asp
>
> On Mon, Mar 11, 2013 at 8:07 AM, iamruf <iamruf@...> wrote:
>
> > Hi Randy,
> > Is there a site/formula that would extract/provide number of consecutive
> > months a company paid a dividend?
> > e.g. Am looking for best way to find companies that have been consistent
> > in paying dividends without having to look up history on each.
> > Best regards
> >
>
--- In smf_addin@yahoogrou
>
> Would the Dividend Champion workbook from this web site suffice?
>
> http://dripinvestin
>
> On Mon, Mar 11, 2013 at 8:07 AM, iamruf <iamruf@.
>
> > Hi Randy,
> > Is there a site/formula that would extract/provide number of consecutive
> > months a company paid a dividend?
> > e.g. Am looking for best way to find companies that have been consistent
> > in paying dividends without having to look up history on each.
> > Best regards
> >
>
Mon Mar 11, 2013 9:06 am (PDT) . Posted by:
"JCHyjun" JCHyjun
Hello,
Is it an element to define country of company issued stock?
Ideally I'd like to put ticker symbol and get country, e.g.
IBM <--- USA
BP <---- UK
Thanks
J. Chang
Is it an element to define country of company issued stock?
Ideally I'd like to put ticker symbol and get country, e.g.
IBM <--- USA
BP <---- UK
Thanks
J. Chang
Mon Mar 11, 2013 9:16 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
No element for it. If you have a source, you could probably use one of the
other functions.
On Mon, Mar 11, 2013 at 9:06 AM, JCHyjun <jchyjun@yahoo.com > wrote:
> Is it an element to define country of company issued stock?
> Ideally I'd like to put ticker symbol and get country, e.g.
> IBM <--- USA
> BP <---- UK
>
other functions.
On Mon, Mar 11, 2013 at 9:06 AM, JCHyjun <jchyjun@yahoo.
> Is it an element to define country of company issued stock?
> Ideally I'd like to put ticker symbol and get country, e.g.
> IBM <--- USA
> BP <---- UK
>
Mon Mar 11, 2013 9:10 am (PDT) . Posted by:
"iloveangelsanne" iloveangelsanne
Hi,
I would like to write a program to do the following:
1) Determin each time an underlying index, such as SPY, moves below its Simple 10 day moving average.
2) Determine what deltas that index's option chains have for 30 DTE and 45 DTE.
3) Determine the mark price for those deltas.
4) Calculate the projected 10 day moving average to include the closing price of the underlying index for the day it moved below the simple 10 day moving average.
6) Determine the option prices for when the the underlying finally does go above the that calculated simple 10 day moving average.
Is it possible to do all of the above with the smf_addin? I am a programmer and new to this group (who currently programs in C# mostly, but feel can learn any language I need to).
Any help or guidance is deeply appreciated.
Thank you!
Anne
I would like to write a program to do the following:
1) Determin each time an underlying index, such as SPY, moves below its Simple 10 day moving average.
2) Determine what deltas that index's option chains have for 30 DTE and 45 DTE.
3) Determine the mark price for those deltas.
4) Calculate the projected 10 day moving average to include the closing price of the underlying index for the day it moved below the simple 10 day moving average.
6) Determine the option prices for when the the underlying finally does go above the that calculated simple 10 day moving average.
Is it possible to do all of the above with the smf_addin? I am a programmer and new to this group (who currently programs in C# mostly, but feel can learn any language I need to).
Any help or guidance is deeply appreciated.
Thank you!
Anne
Mon Mar 11, 2013 9:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Whether the add-in could do that would be dependent on your source of the
data and whether the add-in could retrieve the data from that source. But I
don't know of any index that will have an option chain 45 DTE from any
given point. The 30 DTE would probably be easy for an ETF of an index,
since most have weekly options.
On Mon, Mar 11, 2013 at 7:16 AM, iloveangelsanne <athorne@arbonne.com >wrote:
>
> I would like to write a program to do the following:
>
> 1) Determin each time an underlying index, such as SPY, moves below its
> Simple 10 day moving average.
> 2) Determine what deltas that index's option chains have for 30 DTE and 45
> DTE.
> 3) Determine the mark price for those deltas.
> 4) Calculate the projected 10 day moving average to include the closing
> price of the underlying index for the day it moved below the simple 10 day
> moving average.
> 6) Determine the option prices for when the the underlying finally does go
> above the that calculated simple 10 day moving average.
>
> Is it possible to do all of the above with the smf_addin? I am a
> programmer and new to this group (who currently programs in C# mostly, but
> feel can learn any language I need to).
>
> Any help or guidance is deeply appreciated.
>
data and whether the add-in could retrieve the data from that source. But I
don't know of any index that will have an option chain 45 DTE from any
given point. The 30 DTE would probably be easy for an ETF of an index,
since most have weekly options.
On Mon, Mar 11, 2013 at 7:16 AM, iloveangelsanne <athorne@arbonne.
>
> I would like to write a program to do the following:
>
> 1) Determin each time an underlying index, such as SPY, moves below its
> Simple 10 day moving average.
> 2) Determine what deltas that index's option chains have for 30 DTE and 45
> DTE.
> 3) Determine the mark price for those deltas.
> 4) Calculate the projected 10 day moving average to include the closing
> price of the underlying index for the day it moved below the simple 10 day
> moving average.
> 6) Determine the option prices for when the the underlying finally does go
> above the that calculated simple 10 day moving average.
>
> Is it possible to do all of the above with the smf_addin? I am a
> programmer and new to this group (who currently programs in C# mostly, but
> feel can learn any language I need to).
>
> Any help or guidance is deeply appreciated.
>
Mon Mar 11, 2013 11:38 am (PDT) . Posted by:
"Mark Clemmons" mark.clemmons@rocketmail.com
Got it. It works beautifully. Thanks.
Regards,
Mark D. Clemmons
[cid:image001.png@01CE1E5D.B4FDD950 ]Top of Form
Bottom of Form
Mullins Clemmons & Mayes, PLLC
320 Seven Springs Way, Suite 120
Brentwood, TN 37027-4537
Phone: (615) 370-8576
Fax: (615) 370-8579
http://www.mcmpllc.com/
*****
This electronic message (including any attachments) may contain confidential or privileged information and is intended only for the use of the specific individual or entity named above. If you are not the intended recipient, or have received this message in error, please notify the sender by reply transmission and delete this message without copying or disclosing it. Any disclosure, copying, or distribution of this message (including any attachments), or the taking of any action based on it, is strictly prohibited.
Department of Treasury regulations disclosed in IRS Circular 230 require us to inform you that any tax advice contained in this communication, including any attachments or enclosures, was not intended to be used, and cannot be used, for the purpose of avoiding penalties under the Internal Revenue Code or promoting, marketing or recommending to another party any transaction or matter addressed in this communication.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Sunday, March 10, 2013 5:39 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo Adjusted Close vs. Actual Close
The only function that can get actual historical quotes is the RCHGetYahooHistory() function. The function you're referring to with the "08" parameter is the smfPricesBetween() function, where it wouldn't make sense to get anything other than adjusted closing prices. smfPricesByDates() also only gets adjusted closing prices, because it wouldn't make sense to get actual closing prices for multiple dates, other than a few very specific situations -- in which case the RCHGetYahooHistory() function can gill the gap.
On Sun, Mar 10, 2013 at 2:58 PM, Mark Clemmons <mark.clemmons@mcmpllc.com <mailto:mark.clemmons@mcmpllc.com >> wrote:
I am using one the templates to obtain historical closing stock prices from Yahoo as of a specific date. The template obtains the adjusted close price, but I would like to obtain the actual close price. I am a new user, so I may not explain things correctly, but the data element that provides the adjusted close is "08". Is there an element that will give me the actual historical closing price?
Regards,
Mark D. Clemmons
[cid:image001.png@
Bottom of Form
Mullins Clemmons & Mayes, PLLC
320 Seven Springs Way, Suite 120
Brentwood, TN 37027-4537
Phone: (615) 370-8576
Fax: (615) 370-8579
http://www.mcmpllc.
*****
This electronic message (including any attachments) may contain confidential or privileged information and is intended only for the use of the specific individual or entity named above. If you are not the intended recipient, or have received this message in error, please notify the sender by reply transmission and delete this message without copying or disclosing it. Any disclosure, copying, or distribution of this message (including any attachments)
Department of Treasury regulations disclosed in IRS Circular 230 require us to inform you that any tax advice contained in this communication, including any attachments or enclosures, was not intended to be used, and cannot be used, for the purpose of avoiding penalties under the Internal Revenue Code or promoting, marketing or recommending to another party any transaction or matter addressed in this communication.
From: smf_addin@yahoogrou
Sent: Sunday, March 10, 2013 5:39 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Yahoo Adjusted Close vs. Actual Close
The only function that can get actual historical quotes is the RCHGetYahooHistory(
On Sun, Mar 10, 2013 at 2:58 PM, Mark Clemmons <mark.clemmons@
I am using one the templates to obtain historical closing stock prices from Yahoo as of a specific date. The template obtains the adjusted close price, but I would like to obtain the actual close price. I am a new user, so I may not explain things correctly, but the data element that provides the adjusted close is "08". Is there an element that will give me the actual historical closing price?
Mon Mar 11, 2013 3:36 pm (PDT) . Posted by:
"Pete A" option2z
--- In smf_addin@yahoogrou
>
> Just a heads-up on some sample VBA to post a chart into your workbook.
>
> http://boards.
>
> For example, I might have a subroutine to call that one:
>
> Sub Test()
> Call DisplayChartForTick
> Call DisplayChartForTick
> End Sub
>
That works well! But it does leave the charts open as graphic boxes in your spreadsheet, but it is not much work to delete them either. Thanks for the post!
Pete A
Mon Mar 11, 2013 3:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
A quick way to delete all of the objects -- select one, then hit Ctrl-A.
Then the delete key deletes them all.
Not helpful if you have some items you want to keep though. :)
On Mon, Mar 11, 2013 at 3:36 PM, Pete A <optionzz@gmail.com > wrote:
> That works well! But it does leave the charts open as graphic boxes in
> your spreadsheet, but it is not much work to delete them either. Thanks
> for the post!
> Pete A
>
Then the delete key deletes them all.
Not helpful if you have some items you want to keep though. :)
On Mon, Mar 11, 2013 at 3:36 PM, Pete A <optionzz@gmail.
> That works well! But it does leave the charts open as graphic boxes in
> your spreadsheet, but it is not much work to delete them either. Thanks
> for the post!
> Pete A
>
Mon Mar 11, 2013 9:00 pm (PDT) . Posted by:
"Randy H" rharmelink
You should be able to return historical quotes ending at any given date
with the RCHGetYahooHistory() function. From there you could generate
your own technical values. The TA-LIB add-in (see the LINKS area of the
group) would be useful for that.
Also, it should be possible to extract that type of information from
barcharts.com. Their charts display data in a box when you hover over a
date -- the information displayed is within the source code of the web
page and can be extracted.
However, for scanning of this type, I would think you'd be better off
using something like StockFetcher, or another technical scanning tool.
Should be much easier to do.
---------- Forwarded message ----------
From: Eric Stats <ericstats@gmail.com <mailto:ericstats@gmail.com > >
Date: Mon, Mar 11, 2013 at 9:32 PM
Subject: Historical technical analysis
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com >
Randy,
I would like to screen an index such as the Nasdaq 100 for different
dates over the last several years. Is there a way to get a technical
element returned for each ticker for a specific date? For example, a 1
month RSI number for every ticker on 6/30/2011. Another element would
be some breakout indicator for each ticker. I see where I can get
current technical elements, but not historical for a specific date.
with the RCHGetYahooHistory(
your own technical values. The TA-LIB add-in (see the LINKS area of the
group) would be useful for that.
Also, it should be possible to extract that type of information from
barcharts.com. Their charts display data in a box when you hover over a
date -- the information displayed is within the source code of the web
page and can be extracted.
However, for scanning of this type, I would think you'd be better off
using something like StockFetcher, or another technical scanning tool.
Should be much easier to do.
---------- Forwarded message ----------
From: Eric Stats <ericstats@gmail.
Date: Mon, Mar 11, 2013 at 9:32 PM
Subject: Historical technical analysis
To: smf_addin@yahoogrou
Randy,
I would like to screen an index such as the Nasdaq 100 for different
dates over the last several years. Is there a way to get a technical
element returned for each ticker for a specific date? For example, a 1
month RSI number for every ticker on 6/30/2011. Another element would
be some breakout indicator for each ticker. I see where I can get
current technical elements, but not historical for a specific date.
Tidak ada komentar:
Posting Komentar