1 New Message

Digest #2314

Re: Getting Started with Stockcharts by "dice962" dice962

Message

1a

Re: Getting Started with Stockcharts

Tue Aug 14, 2012 11:30 pm (PDT) . Posted by:

"dice962" dice962

Thank you Randy !

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You may want to look at these two templates in the files area:
>
> SMF-Template-Barchart-Technical-Indicators.xls
> RCHGetTableCell-Template-BarChart-Technical-Signals.xls
>
> I think they contain everything from the two pages you're looking at, plus
> another.
>
> And there was just a recent thread on getting the data from the "Cheat
> Sheet" page:
>
> http://www.barchart.com/cheatsheet.php?sym=MMM
>
> http://finance.groups.yahoo.com/group/smf_addin/message/19230
>
> On Fri, Aug 3, 2012 at 3:28 PM, dice962 <derekbarrett@...> wrote:
>
> >
> > A few more.
> >
> > Any feedback/criticism on a more consistent way for me to map these, let
> > me know, I'm just sort of winging it until I get the right combination that
> > matches the data on the webpage:
> >
> > PercentR(20-day)
> >
> > =RCHGetTableCell("http://www.barchart.com/technicals/stocks/LLY",0,"Percent
> > R","20-Day",1)
> >
> > Stochastic %D (20-day)
> >
> > =RCHGetTableCell("http://www.barchart.com/technicals/stocks/LLY",0,"Stochastic
> > %D","20-Day",6)
> >
> > Relative Strength (20-day)
> >
> > =RCHGetTableCell("http://www.barchart.com/technicals/stocks/LLY",1,"Relative
> > Strength","20-Day")
> >
> > MACD Oscillator (20-day)
> >
> > =RCHGetTableCell("http://www.barchart.com/technicals/stocks/LLY",1,"MACD
> > Oscillator","20-Day",4)
> >
> >
> > --- In smf_addin@yahoogroups.com, "dice962" <derekbarrett@> wrote:
> > >
> > >
> > >
> > > Okay thanks Randy that is very helpful. Looks like Teddi uses various
> > settings, depending on the time frame. I am going to try using some of the
> > indicators on Barcharts for now as a starting point and see how that goes,
> > maybe it is a better option, before moving on to the other indicators. Most
> > of the indicators that she uses are there.
> > >
> > > I started just with getting Support, Price, Pivot Point, and Resistance,
> > so here are my formulas. This is the first time I have pulled data directly
> > from a web page into your add-on, so has been a good learning experience.
> > >
> > > I had used different reference points to get it to locate, through trial
> > and error to get the data (in case anyone wonders why all the Find strings
> > and Row and Cell #'s are inconsistent with each other):
> > >
> > > SUPPORT
> > > =RCHGetTableCell("http://www.barchart.com/opinions/stocks/LLY",1,"Composite
> > Indicators","Support",1)
> > >
> > > PRICE
> > > =RCHGetTableCell("http://www.barchart.com/opinions/stocks/LLY",-4,"Composite
> > Indicators","Overall Average",3)
> > >
> > > PIVOT POINT
> > > =RCHGetTableCell("http://www.barchart.com/opinions/stocks/LLY",-2,"Composite
> > Indicators","Overall Average",3)
> > >
> > > RESISTANCE
> > > =RCHGetTableCell("http://www.barchart.com/opinions/stocks/LLY",1,"Composite
> > Indicators","Resistance",0)
> > >
> > > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > > >
> > > > Where are you seeing the numbers you want to extract from StockCharts?
> > > >
> > > > Do you know the settings that Teddi uses for the market indicators?
> > > >
> > > > Barchart has a several pages of various indicators that are easily
> > > > extractable:
> > > >
> > > > http://www.barchart.com/technicals/stocks/MMM
> > > > http://www.barchart.com/opinions/stocks/MMM
> > > >
> > > >
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>