3 New Messages
Digest #2561
Messages
Tue Mar 26, 2013 7:20 pm (PDT) . Posted by:
"focus_man_focus" focus_man_focus
Thanks! All is well.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It's in the RCHGetTableCell() sub-folder of the Templates and Examples
> folder.
>
> Your old formula won't work because IBD no longer uses the ticker symbol as
> the parameter to get to the web pages.
>
> On Mon, Mar 25, 2013 at 7:20 PM, focus_man_focus <mattwolf67@...>wrote:
>
> >
> > Is the IBD worksheet example you mentioned still available? I could not
> > find it.
> >
> > My older worksheet used a statement like this which no longer seems to
> > work.
> >
> > =RCHGetTableCell("http://research.investors.com/Quote.aspx?symbol= "&A2,1,"Composite
> > Rating")
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Check out the RCHGetTableCell-Template-IBD-Stock-Checkup.xls example in
> > the
> > > FILES area of the group.
> > >
> > > You'll need to create a security cookie before using it, by logging in
> > with
> > > either the EXCEL Web Query dialog (preferred) or IE.
> >
>
--- In smf_addin@yahoogrou
>
> It's in the RCHGetTableCell(
> folder.
>
> Your old formula won't work because IBD no longer uses the ticker symbol as
> the parameter to get to the web pages.
>
> On Mon, Mar 25, 2013 at 7:20 PM, focus_man_focus <mattwolf67@
>
> >
> > Is the IBD worksheet example you mentioned still available? I could not
> > find it.
> >
> > My older worksheet used a statement like this which no longer seems to
> > work.
> >
> > =RCHGetTableCell(
> > Rating"
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Check out the RCHGetTableCell-
> > the
> > > FILES area of the group.
> > >
> > > You'll need to create a security cookie before using it, by logging in
> > with
> > > either the EXCEL Web Query dialog (preferred) or IE.
> >
>
Tue Mar 26, 2013 10:38 pm (PDT) . Posted by:
"Ricky Steed" rickysteed79
Hi Randy,
Will your program work for finding stocks with dividends that we were talking about on the other newsgroup? Can you also tell me what I can do with your program. Thanks
Ricky
Will your program work for finding stocks with dividends that we were talking about on the other newsgroup? Can you also tell me what I can do with your program. Thanks
Ricky
Tue Mar 26, 2013 10:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, it's not really intended for scanning, but for retrieving ad hoc data
on a small set of stocks. That's why I was stressing using a screener like
Zacks to first get down to that small set of stocks, where you can then get
more detailed information on them. Information that WASN'T available in the
screening tool. In this case, both declared ex-dividend date and an
estimate of the next ex-dividend date based on when the stock went
ex-dividend last year.
The add-in itself is primarily a collection of user-defined functions that
can take data off of the Internet and put it into EXCEL cells. Similar to
an EXCEL Web Query, but with more flexibility and precision.
For example, when I was looking to see what the ex-dividend date of a stock
was from the previous year, I was using a formula that looked like this:
=RCHGetYahooHistory(rTicker,YEAR(rBegDate)-1,MONTH(rBegDate),DAY(rBegDate),
YEAR(rEndDate)-1,MONTH(rEndDate),DAY(rEndDate),"v",,0)
...which works on these yellow-shaded cells and returns the dividend date,
if any, from the previous year, that would be between the two specified
dates:
BegDate EndDate *Ticker* *Prev Ex-Div* 2013-03-26 2013-04-20 FCX
2012-04-11
The last declared ex-dividend date is retrieved with:
=DATEVALUE(smfGetTagContent("
http://research.tdameritrade.com/public/stocks/overview/overview.asp?symbol=
"&rTicker,"div",1,">Ex-Dividend"))
...and so forth and so on.
It can't retrieve data from every web page, but it can access almost any
web page the EXCEL web query process can go after -- because both processes
use the Microsoft Window libraries for Internet web page retrieval.
On Tue, Mar 26, 2013 at 10:36 PM, Ricky Steed <rickysteed79@yahoo.com >wrote:
>
> Will your program work for finding stocks with dividends that we were
> talking about on the other newsgroup? Can you also tell me what I can do
> with your program. Thanks
>
on a small set of stocks. That's why I was stressing using a screener like
Zacks to first get down to that small set of stocks, where you can then get
more detailed information on them. Information that WASN'T available in the
screening tool. In this case, both declared ex-dividend date and an
estimate of the next ex-dividend date based on when the stock went
ex-dividend last year.
The add-in itself is primarily a collection of user-defined functions that
can take data off of the Internet and put it into EXCEL cells. Similar to
an EXCEL Web Query, but with more flexibility and precision.
For example, when I was looking to see what the ex-dividend date of a stock
was from the previous year, I was using a formula that looked like this:
=RCHGetYahooHistory
YEAR(rEndDate)
...which works on these yellow-shaded cells and returns the dividend date,
if any, from the previous year, that would be between the two specified
dates:
BegDate EndDate *Ticker* *Prev Ex-Div* 2013-03-26 2013-04-20 FCX
2012-04-11
The last declared ex-dividend date is retrieved with:
=DATEVALUE(smfGetTa
http://research.
"&rTicker,
...and so forth and so on.
It can't retrieve data from every web page, but it can access almost any
web page the EXCEL web query process can go after -- because both processes
use the Microsoft Window libraries for Internet web page retrieval.
On Tue, Mar 26, 2013 at 10:36 PM, Ricky Steed <rickysteed79@
>
> Will your program work for finding stocks with dividends that we were
> talking about on the other newsgroup? Can you also tell me what I can do
> with your program. Thanks
>
Tidak ada komentar:
Posting Komentar