Messages In This Digest (4 Messages)
- 1a.
- Re: smfPricesBetween() appears to be subtracting dividends from High From: eduba01
- 2a.
- Re: StockHouse data errors From: A B
- 2b.
- Re: StockHouse data errors From: Randy Harmelink
- 2c.
- Re: StockHouse data errors From: A B
Messages
- 1a.
-
Re: smfPricesBetween() appears to be subtracting dividends from High
Posted by: "eduba01" Erich_Wiener@yahoo.com eduba01
Sat Oct 22, 2011 4:51 pm (PDT)
..hmmmm...you're making some strong points to consider...
The original Turtle Trader rules definitely didn't have to worry about splits or divs since they were trading futures.
Thanks for pointing me to the line of code if I decide to use non-adjusted.
Enjoy the weekend and thanks again.
-Erich
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> On Sat, Oct 22, 2011 at 12:01 AM, eduba01 <Erich_Wiener@...> wrote:
>
> >
> > Thanks for the reply...I'm assuming that feature can't be disabled within
> > smfPricesBetween() based on your response.
> >
>
> You could edit the code:
>
> vHQ = RCHGetYahooHistory(pTicker, , , , , , , "d", "DOHLCV", 0, 1, 0,
> Int(Now - pBegDate + 3), 6)
>
> ...just change that "1" parameter to a zero.
>
>
> > I'm working on Turtle Trader spreadsheet looking for 50 day breakouts, so
> > my preference is to use non-adjusted histories since charts and daily prices
> > are also listed in non-adjusted prices.
> >
>
> So you're willing to allow a dividend (or stock split) event to prevent or
> cause the identification of a breakout? OR -- a reverse split could trigger
> a breakout signal.
>
> The reason many charts have unadjusted prices is they are lazy. In general,
> a dividend event is small enough that they don't consider it worth the
> trouble. But many chart services had BIG issues several years ago when the
> leveraged ETFs had huge distributions at year-end. And even a number of
> mutual funds regularly have large distributions at year-end.
>
> Thanks again for the time you've committed to the smf_addin and if you
> > consider feature requests, I hope you'd consider adding a non-adjusted
> > option for smfPricesBetween().
> >
>
> I've considered allowing a parameter to toggle it, but like I said -- I
> can't think of a valid reason to use unadjusted prices. IMO, a dividend or
> split event should NEVER affect the calculation of a technical indicator.
>
> Even if one only wants the splits, most data services treat something like a
> 5% stock dividend as a 21-20 stock split.
>
- 2a.
-
Re: StockHouse data errors
Posted by: "A B" morvornagh@yahoo.com morvornagh
Sat Oct 22, 2011 5:23 pm (PDT)
Randy - First I would like to say what a great piece of development the add-in and follow up on this group is, really amazed.
Secondly - A question for all members. I was also using quite a few of the stockhouse indicators that are now 'moved'. I have found work arounds for most of the ones I was using except the 1 / 2 day support / resistance. Which I think are very useful. While looking for suitable alternatives I noticed that Barchart on their cheat sheet have this page http://www.barchart.com/cheatsheet. php?sym=MMM.
Does anyone know If I wanted to configure the addin to pull say the one and two day pivot prices from this page which documentation should I read?
The RCHGetelementnumber already supports the other technical pages from barchart i.e http://www.barchart.com/technicals/ (#'s 1215 - 1284) and http://www.barchartstocks/MMM .com/opinions/ (#'s 702-717) to so I am thinking this should be fairly easy for me to configure for myself (if they dont already exist).stocks/MMM
I did try to figure it out prior to this note but could not quite get to grips with how the code worked. i.e. to configure the url get and post and then assign it to an element number (I am a coder but a VBA developer I am not).
Many thanks
N
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, October 22, 2011 12:47 AM
Subject: Re: [smf_addin] StockHouse data errors
Looks like they dropped the data elements. What used to be a "technical analysis page" is now an "analysts' page":
http://www.stockhouse.com/financial tools/sn_ technicalanalysi s.aspx?qm_ symbol=MMM
On Fri, Oct 21, 2011 at 8:15 PM, Bike bum <ttwilt@mchsi.com > wrote:
Greetings, is any one besides myself unable to extract data from StockHouse? Specifically item numbers 802, 825,790 and 789. I have been using this data for quite a while but it has began returning error messages recently. Just wondering if it is on my end or if others are having the same problem.
>
- 2b.
-
Re: StockHouse data errors
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Oct 22, 2011 5:28 pm (PDT)
Try something like:
Value Formula 81.59 =RCHGetTableCell("
http://www.barchart.com/cheatsheet. ",1,"2nd Level Resistance")php?sym=MMM
81.03 =RCHGetTableCell("http://www.barchart .com/cheatsheet. ",1,"1stphp?sym=MMM
Level Resistance") 79.45 =RCHGetTableCell("
http://www.barchart.com/cheatsheet. ",1,"1st Level Support")php?sym=MMM
78.43 =RCHGetTableCell("http://www.barchart .com/cheatsheet. ",1,"2ndphp?sym=MMM
Level Support")
On Sat, Oct 22, 2011 at 5:20 PM, A B <morvornagh@yahoo.com > wrote:
>
> A question for all members. I was also using quite a few of the stockhouse
> indicators that are now 'moved'. I have found work arounds for most of the
> ones I was using except the 1 / 2 day support / resistance. Which I think
> are very useful. While looking for suitable alternatives I noticed that
> Barchart on their cheat sheet have this page http://www.barchart.com/cheatsheet. php?sym=MMM.
>
> <http://www.barchart.com/cheatsheet. >php?sym=MMM
> Does anyone know If I wanted to configure the addin to pull say the one and
> two day pivot prices from this page which documentation should I read?
>
> The RCHGetelementnumber already supports the other technical pages from
> barchart i.e http://www.barchart.com/technicals/ <http://www.barchartstocks/MMM .com/cheatsheet. >(#'s 1215 - 1284) andphp?sym=MMM
> http://www.barchart.com/opinions/ (#'s 702-717) to so I amstocks/MMM
> thinking this should be fairly easy for me to configure for myself (if they
> dont already exist).
>
> I did try to figure it out prior to this note but could not quite get to
> grips with how the code worked. i.e. to configure the url get and post and
> then assign it to an element number (I am a coder but a VBA developer I am
> not).
>
- 2c.
-
Re: StockHouse data errors
Posted by: "A B" morvornagh@yahoo.com morvornagh
Sat Oct 22, 2011 5:35 pm (PDT)
Wow - Thanks so much!!!!
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, October 22, 2011 8:28 PM
Subject: Re: [smf_addin] StockHouse data errors
Try something like:
Value
Formula
81.59 =RCHGetTableCell("http://www.barchart .com/cheatsheet. ",1,"2nd Level Resistance")php?sym=MMM
81.03 =RCHGetTableCell("http://www.barchart .com/cheatsheet. ",1,"1st Level Resistance")php?sym=MMM
79.45 =RCHGetTableCell("http://www.barchart .com/cheatsheet. ",1,"1st Level Support")php?sym=MMM
78.43 =RCHGetTableCell("http://www.barchart .com/cheatsheet. ",1,"2nd Level Support")php?sym=MMM
On Sat, Oct 22, 2011 at 5:20 PM, A B <morvornagh@yahoo.com > wrote:
>
>A question for all members. I was also using quite a few of the stockhouse indicators that are now 'moved'. I have found work arounds for most of the ones I was using except the 1 / 2 day support / resistance. Which I think are very useful. While looking for suitable alternatives I noticed that Barchart on their cheat sheet have this page http://www.barchart.com/cheatsheet. (#'s 1215 - 1284) and http://www.barchartphp?sym=MMM .com/opinions/ (#'s 702-717) to so I am thinking this should be fairly easy for me to configure for myself (if they dont already exist).stocks/MMM
>
>I did try to figure it out prior to this note but could not quite get to grips with how the code worked. i.e. to configure the url get and post and then assign it to an element number (I am a coder but a VBA developer I am not).
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar