Selasa, 22 Mei 2012

[smf_addin] Digest Number 2220

Messages In This Digest (19 Messages)

Messages

1a.

Re: RCHGet

Posted by: "ego_1230" ego_1230@yahoo.de   ego_1230

Mon May 21, 2012 5:36 am (PDT)




Hi all,

Sorry for digging up an old tread...

I am also looking income/balance sheet data for european companies.

Reuters.com worked more or less for a while, but not any more. It seems I can't stay logged-in on reuters.com , nor can my Excel(2003). Hence, no data are "added in".

Seems the trouble started after installing a new browser version (Firefox).

Any ideas on a different data source and/or on a fix ?

Regards,
M.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> There is a Reuters RCHGetTableCell() example in the files area...
>
> On Mon, Nov 7, 2011 at 5:35 PM, P Palminha <palminha@...> wrote:
>
> >
> > OK, is there any samples or people working with them on Reuters that you
> > know off?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1b.

Re: RCHGet

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon May 21, 2012 6:34 am (PDT)



FireFox usage is irrelevant to the add-in. The add-in uses the MicroSoft
Internet engine used by both IE and EXCEL, so you would need to log in or
create the cookie either with the EXCEL Web Query dialog or with IE.

Give me an example of a European ticker symbol on Reuters that had
income/balance sheet data.

On Mon, May 21, 2012 at 5:36 AM, ego_1230 <ego_1230@yahoo.de> wrote:

>
> I am also looking income/balance sheet data for european companies.
>
> Reuters.com worked more or less for a while, but not any more. It seems I
> can't stay logged-in on reuters.com , nor can my Excel(2003). Hence, no
> data are "added in".
>
> Seems the trouble started after installing a new browser version (Firefox).
>
> Any ideas on a different data source and/or on a fix ?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

Re: Financial data lag time

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon May 21, 2012 6:36 am (PDT)



I believe MSN gets its data from Reuters, so it going directly to Reuters
might speed up things.

Otherwise, you could look at retrieving the data directly from SEC filings.
I haven't looked at that alternative in some time. Especially since it may
not be a good way to go if you are "mixing" data items from various
sources, because the "pigeon holing" of the data into categories won't be
done the data sources may not be done by the SEC since they have the raw
data.

On Sun, May 20, 2012 at 2:15 AM, hbeetroot <hbeetroot@yahoo.com> wrote:

>
> What I have noticed is that the update frequency between the various
> sources of data seems to vary quite dramatically. For example I came across
> a number of companies who's annual/quarterly data is out of date by at
> least a month on MSN.
>
> Does anyone have a suggestion on comment as to the best source for raw
> financial statement?
>
> Critical would be:
> -timely updates of quarterly/annual data (AdvFN seems to be quite good in
> this regard, perhaps better than MSN?)
> -standardized formatting of data across companies (This is one of the
> reasons I like MSN)
> -Accuracy of data obviously, and
> -As much details as possible, i.e. doesn't just aggregate a number of line
> items into a single entry
>
> I was quite happy with MSN, particularly as the author of the
> Cash_Flow_v17 spreadsheet has done a lot of the leg work already, but I am
> concerned that in some cases the data will be a month or more out of date -
> this is my biggest concern. From experience as AdvFN better in this regard?
> Others I've looked at like Morningstar, Yahoo! etc. seem to be even worse,
> so I don't think they're an option.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
3a.

[Help] RCHGetHTMLTable

Posted by: "lethanhtai" le_thanhtai@ymail.com   melody_of_destiny

Mon May 21, 2012 10:37 am (PDT)



Hi Randy,
I tried RCHGetHTMLTable to get financial statements from the following
links:
http://www.cophieu68.com/incomestatementq.php?view=ist&id=ree&year=-1
<http://www.cophieu68.com/incomestatementq.php?view=ist&id=ree&year=-1>
http://www.cophieu68.com/incomestatementq.php?view=bs&id=ree&year=-1
<http://www.cophieu68.com/incomestatementq.php?view=bs&id=ree&year=-1>
http://www.cophieu68.com/incomestatementq.php?view=cf&id=ree&year=-1
<http://www.cophieu68.com/incomestatementq.php?view=cf&id=ree&year=-1>
With the 1st link, the below function worked fine.(Summary!D4 is the
stock ticker cell: id = ree)
=RCHGetHTMLTable("http://www.cophieu68.com/incomestatementq.php?view=ist\
&year=-1&id="&Summary!D4,"Kết Quả Kinh Doanh",-1,"",1)
<=RCHGetHTMLTable(>

For the 2nd and 3th links, I tried different ways but did not succeed.
For example,
=RCHGetHTMLTable("http://www.cophieu68.com/incomestatementq.php?id=ree&y\
ear=-1&view=bs","BẢNG CÂN ÐỐI KẾ TOÁN",-1,"",1)
<=RCHGetHTMLTable(>

Hope you could help me.Thanks you so much.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3b.

Re: [Help] RCHGetHTMLTable

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon May 21, 2012 1:36 pm (PDT)



The reason the add-in is having a problem because of this HTML coding on
the web page:

colspan="2"style="background...

The add-in expects the "colspan" value to end with a space. Since there is
no space between "2" and "style", it has a problem.

As a workaround, you can use individual RCHGetTableCell() functions...

On Mon, May 21, 2012 at 10:37 AM, lethanhtai <le_thanhtai@ymail.com> wrote:

>
> I tried RCHGetHTMLTable to get financial statements from the following
> links:
>
> http://www.cophieu68.com/incomestatementq.php?view=ist&id=ree&year=-1
> http://www.cophieu68.com/incomestatementq.php?view=bs&id=ree&year=-1
> http://www.cophieu68.com/incomestatementq.php?view=cf&id=ree&year=-1
>
> With the 1st link, the below function worked fine.(Summary!D4 is the stock
> ticker cell: id = ree) =RCHGetHTMLTable("http://www.cophieu68.com/incomestatementq.php?view=ist&year=-1&id="&Summary!D4,"Kết
> Quả Kinh Doanh",-1,"",1) <http://=RCHGetHTMLTable%28>
>
>
> For the 2nd and 3th links, I tried different ways but did not succeed. For
> example,
> =RCHGetHTMLTable("http://www.cophieu68.com/incomestatementq.php?id=ree&year=-1&view=bs","BẢNG
> CÂN Ðá» I KẾ TOÁN",-1,"",1) <http://=RCHGetHTMLTable%28>
>
> Hope you could help me.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.

Re: [Help] RCHGetHTMLTable

Posted by: "lethanhtai" le_thanhtai@ymail.com   melody_of_destiny

Mon May 21, 2012 4:24 pm (PDT)



Thank you very much.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The reason the add-in is having a problem because of this HTML coding on
> the web page:
>
> colspan="2"style="background...
>
> The add-in expects the "colspan" value to end with a space. Since there is
> no space between "2" and "style", it has a problem.
>
> As a workaround, you can use individual RCHGetTableCell() functions...

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4a.

Re: looking for templates for ETF data from MSH, Morningstar, others

Posted by: "mff2805" mff3429@comcast.net   mff2805

Mon May 21, 2012 11:12 am (PDT)



here's some parameters i'm interested in consolidating into one spreadsheet. some info occurs on multiple sites, sometimes numbers like yield can be different at different sites. basically i'm currently printing a one page summary when i make a purchase, generally for stocks; now i'm looking to print an etf summary page.

MSN volume, bid and ask (doesn't seem to provide bid/ask spread),
objective
morningstar ratings
holdings overview
top holdings
Yahoo net assets
volume, avg 3mo avg
yield
category
expense ratio
annual turnover
portfolio composition
top 10 holdings
risk info
seeking alpha
avg bid/ask ratio
number of securities
etftrends.com
exp ratio, yield
number of holdings and top 10
composition: sector, industry group, country, market cap
morningstar
12mo yield, SEC yield, total assets, expense ratio
prem/discount, volume, ang volume, bid/ask spread %, category
top holdings, top sectors
latest distributions table
star rating
asset allocation, style details,
net assets, turnover ratio, 12 mo yield

-mike

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I think there's only the Yahoo ETF template, but even that is somewhat
> obsolete as Yahoo has changed a number of their web pages.
>
> What are you trying to pick up?
>
> On Fri, May 18, 2012 at 10:42 PM, Mike Fitzpatrick <mff3429@...>wrote:
>
> > I was looking for some templates to grap data about ETFs from MSN,
> > Morningstar, and maybe other places. It seems that no one place has all
> > the
> > info I'm interested in. I get as much info as I can from etftrends.com
> > using the smfgettagcontact functions, along with the ever-useful smfStrExtr
> > function, but I couldn't figure out how to use that with MSN, as the I
> > really could not decipher the view source code.
> > Any help or comments would be appreciated.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4b.

Re: looking for templates for ETF data from MSH, Morningstar, others

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon May 21, 2012 1:38 pm (PDT)



OK. But I meant which data items were you having trouble picking up,
extracting from the web pages?

On Mon, May 21, 2012 at 11:12 AM, mff2805 <mff3429@comcast.net> wrote:

> here's some parameters i'm interested in consolidating into one
> spreadsheet. some info occurs on multiple sites, sometimes numbers like
> yield can be different at different sites. basically i'm currently
> printing a one page summary when i make a purchase, generally for stocks;
> now i'm looking to print an etf summary page.
>
> MSN volume, bid and ask (doesn't seem to provide bid/ask spread),
> objective
> morningstar ratings
> holdings overview
> top holdings
> Yahoo net assets
> volume, avg 3mo avg
> yield
> category
> expense ratio
> annual turnover
> portfolio composition
> top 10 holdings
> risk info
> seeking alpha
> avg bid/ask ratio
> number of securities
> etftrends.com
> exp ratio, yield
> number of holdings and top 10
> composition: sector, industry group, country, market cap
> morningstar
> 12mo yield, SEC yield, total assets, expense ratio
> prem/discount, volume, ang volume, bid/ask spread %, category
> top holdings, top sectors
> latest distributions table
> star rating
> asset allocation, style details,
> net assets, turnover ratio, 12 mo yield
>
>
> -mike
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5.

(no subject)

Posted by: "Bruce Heil" bruceheil@yahoo.com   bruceheil

Mon May 21, 2012 11:39 am (PDT)



http://www.rossodisansecondo.it/uhepzyqldx/843790.html
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
6a.

RCHCreateComment()function

Posted by: "almondtree" almondtree@yahoo.com   almondtree

Mon May 21, 2012 4:01 pm (PDT)



Thank you for great function, RCHCreateComment() function to create a view of multiple charts, based on input ticker symbols.
This is one neat SMF Template I use it use it for row over charts (3) and PnF (2) charts.
I found out best way to copy it down by shutting off Auto Cal, then paste special formulas, Excel 2010. Then cal sheet and watch the Magic.
Then in Review chick (show all Comments twice) then roll on. Do you have one for news (general ) and (ticker).

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.

Re: RCHCreateComment()function

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon May 21, 2012 6:06 pm (PDT)



I'm not sure what you're asking?

On Mon, May 21, 2012 at 4:01 PM, almondtree <almondtree@yahoo.com> wrote:

> Thank you for great function, RCHCreateComment() function to create a view
> of multiple charts, based on input ticker symbols.
> This is one neat SMF Template I use it use it for row over charts (3)
> and PnF (2) charts.
> I found out best way to copy it down by shutting off Auto Cal, then paste
> special formulas, Excel 2010. Then cal sheet and watch the Magic.
> Then in Review chick (show all Comments twice) then roll on. Do you have
> one for news (general ) and (ticker).
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

What does #value! response mean when using RCHGetElementNumber funct

Posted by: "investor952" investor952@yahoo.com   investor952

Mon May 21, 2012 7:05 pm (PDT)



For many stock tickers and for man RCHGetElementNumber functions, I get a "#value!" response (it doesn't say error)...however for some tickers, the same functions sometimes return values. For example,
RCHGetElementNumber(ticker, 7356), where ticker is GBCI, returns "#VALUE#". Other times, with others, I get 'error'. What is the difference and what is the cause of "#value!"? thx.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7b.

Re: What does #value! response mean when using RCHGetElementNumber f

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon May 21, 2012 7:14 pm (PDT)



My first suspicion would be that "ticker" isn't a defined name when you get
the #VALUE? errors.

For "Error", there could be a variety of reasons -- have you applied the
fix mentioned in the "Links" area of the group, for AdvFN access?

On Mon, May 21, 2012 at 7:05 PM, investor952 <investor952@yahoo.com> wrote:

> For many stock tickers and for man RCHGetElementNumber functions, I get a
> "#value!" response (it doesn't say error)...however for some tickers, the
> same functions sometimes return values. For example,
> RCHGetElementNumber(ticker, 7356), where ticker is GBCI, returns
> "#VALUE#". Other times, with others, I get 'error'. What is the difference
> and what is the cause of "#value!"? thx.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7c.

Re: What does #value! response mean when using RCHGetElementNumber f

Posted by: "investor952" investor952@yahoo.com   investor952

Mon May 21, 2012 7:34 pm (PDT)



Hello Randy..Not sure if I understood you correctly, but I didn't
use the actual word ticker...but rather..replace that with stock's ticker. ..and the ticker must exist because it has an msn stock scouter value and a dividend..so, it must have a payout ratio, which is what the example I listed was for...right?

here is a copy/paste example from my spreadsheet...note, the numbers above the column names are the associated numbers assigned to them by your RCHGetElementNumber function..thx.

45 47 7356 7357
BV/shr Payout Ratio Payout Ratio FY1 Payout Ratio FY2
24.15 0.64 0.51 0.56
12.18 0.46 0.47 1.01
41.51 0.2 #VALUE! #VALUE!
23.99 0.38 0.39 0.44
20.86 0.58 0.58 0.49
21.71 0.69 0.64 0.59
34.88 NA #VALUE! 0.33
NA 0.3 0.29 0.2
21.92 0.32 #VALUE! #VALUE!
68.73 0.2 0.2 0.19
5.71 0.56 0.56 0.59

The tickers for the above are

Symbol Company Name
AWK American Water Works Company Inc
UTMD Utah Medical Products Inc
AMP Ameriprise Financial Inc
TWC Time Warner Cable Inc
KFT Kraft Foods Inc
OKE Oneok Inc
EIX Edison International
KNL Knoll Inc
SRCE 1st Source Corp
LLL L-3 Communications Holdings Inc
MPR Met Pro Corp

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> My first suspicion would be that "ticker" isn't a defined name when you get
> the #VALUE? errors.
>
> For "Error", there could be a variety of reasons -- have you applied the
> fix mentioned in the "Links" area of the group, for AdvFN access?
>
> On Mon, May 21, 2012 at 7:05 PM, investor952 <investor952@...> wrote:
>
> > For many stock tickers and for man RCHGetElementNumber functions, I get a
> > "#value!" response (it doesn't say error)...however for some tickers, the
> > same functions sometimes return values. For example,
> > RCHGetElementNumber(ticker, 7356), where ticker is GBCI, returns
> > "#VALUE#". Other times, with others, I get 'error'. What is the difference
> > and what is the cause of "#value!"? thx.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7d.

Re: What does #value! response mean when using RCHGetElementNumber f

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon May 21, 2012 7:52 pm (PDT)



Ahem. Your formula was NOT as you represent. The 0.51 and 0.56 you have in
the first row for AWK are actually 51 and 56 on AdvFN -- so you must be
dividing what is returned by 100.

So, AMP is returning "#VALUE!" because the add-in function itself is
returning "Error", which you are trying to divide by 100. That won't work.
The add-in function returns "Error" because AMP is a financial institution
and has different line items on AdvFN. Payout Ratio is not among them.

EIX only gets a "#VALUE!" error on the first fiscal year because AdvFN has
no data for payout ratio in the first year, so it returns "Error". Again,
attempting to divide by 100 gives "#VALUE!".

SRCE is another financial institution, so you get the two "#VALUE!" errors
again.

On Mon, May 21, 2012 at 7:34 PM, investor952 <investor952@yahoo.com> wrote:

> Hello Randy..Not sure if I understood you correctly, but I didn't
> use the actual word ticker...but rather..replace that with stock's ticker.
> ..and the ticker must exist because it has an msn stock scouter value and a
> dividend..so, it must have a payout ratio, which is what the example I
> listed was for...right?
>
> here is a copy/paste example from my spreadsheet...note, the numbers above
> the column names are the associated numbers assigned to them by your
> RCHGetElementNumber function..thx.
>
>
> 45 47 7356 7357
> BV/shr Payout Ratio Payout Ratio FY1 Payout Ratio FY2
> 24.15 0.64 0.51 0.56
> 12.18 0.46 0.47 1.01
> 41.51 0.2 #VALUE! #VALUE!
> 23.99 0.38 0.39 0.44
> 20.86 0.58 0.58 0.49
> 21.71 0.69 0.64 0.59
> 34.88 NA #VALUE! 0.33
> NA 0.3 0.29 0.2
> 21.92 0.32 #VALUE! #VALUE!
> 68.73 0.2 0.2 0.19
> 5.71 0.56 0.56 0.59
>
>
> The tickers for the above are
>
> Symbol Company Name
> AWK American Water Works Company Inc
> UTMD Utah Medical Products Inc
> AMP Ameriprise Financial Inc
> TWC Time Warner Cable Inc
> KFT Kraft Foods Inc
> OKE Oneok Inc
> EIX Edison International
> KNL Knoll Inc
> SRCE 1st Source Corp
> LLL L-3 Communications Holdings Inc
> MPR Met Pro Corp
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7e.

Re: What does #value! response mean when using RCHGetElementNumber f

Posted by: "investor952" investor952@yahoo.com   investor952

Mon May 21, 2012 8:03 pm (PDT)



Sorry..you are correct..I was dividing the results by 100 because a payout ratio .. is.. a ratio...and not a whole number and I use these values elsewhere in my spreadsheet.

hmm...do you know if there are other areas in rchgetelementnumber that have HISTORICAL payout ratios over several years?..whether they are financial companies or not?thx.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Ahem. Your formula was NOT as you represent. The 0.51 and 0.56 you have in
> the first row for AWK are actually 51 and 56 on AdvFN -- so you must be
> dividing what is returned by 100.
>
> So, AMP is returning "#VALUE!" because the add-in function itself is
> returning "Error", which you are trying to divide by 100. That won't work.
> The add-in function returns "Error" because AMP is a financial institution
> and has different line items on AdvFN. Payout Ratio is not among them.
>
> EIX only gets a "#VALUE!" error on the first fiscal year because AdvFN has
> no data for payout ratio in the first year, so it returns "Error". Again,
> attempting to divide by 100 gives "#VALUE!".
>
> SRCE is another financial institution, so you get the two "#VALUE!" errors
> again.
>
> On Mon, May 21, 2012 at 7:34 PM, investor952 <investor952@...> wrote:
>
> > Hello Randy..Not sure if I understood you correctly, but I didn't
> > use the actual word ticker...but rather..replace that with stock's ticker.
> > ..and the ticker must exist because it has an msn stock scouter value and a
> > dividend..so, it must have a payout ratio, which is what the example I
> > listed was for...right?
> >
> > here is a copy/paste example from my spreadsheet...note, the numbers above
> > the column names are the associated numbers assigned to them by your
> > RCHGetElementNumber function..thx.
> >
> >
> > 45 47 7356 7357
> > BV/shr Payout Ratio Payout Ratio FY1 Payout Ratio FY2
> > 24.15 0.64 0.51 0.56
> > 12.18 0.46 0.47 1.01
> > 41.51 0.2 #VALUE! #VALUE!
> > 23.99 0.38 0.39 0.44
> > 20.86 0.58 0.58 0.49
> > 21.71 0.69 0.64 0.59
> > 34.88 NA #VALUE! 0.33
> > NA 0.3 0.29 0.2
> > 21.92 0.32 #VALUE! #VALUE!
> > 68.73 0.2 0.2 0.19
> > 5.71 0.56 0.56 0.59
> >
> >
> > The tickers for the above are
> >
> > Symbol Company Name
> > AWK American Water Works Company Inc
> > UTMD Utah Medical Products Inc
> > AMP Ameriprise Financial Inc
> > TWC Time Warner Cable Inc
> > KFT Kraft Foods Inc
> > OKE Oneok Inc
> > EIX Edison International
> > KNL Knoll Inc
> > SRCE 1st Source Corp
> > LLL L-3 Communications Holdings Inc
> > MPR Met Pro Corp
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7f.

Re: What does #value! response mean when using RCHGetElementNumber f

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon May 21, 2012 8:14 pm (PDT)



Not that I'm aware of, sorry.

On Mon, May 21, 2012 at 8:03 PM, investor952 <investor952@yahoo.com> wrote:

>
> hmm...do you know if there are other areas in rchgetelementnumber that
> have HISTORICAL payout ratios over several years?..whether they are
> financial companies or not?thx.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
8a.

gethtmltable

Posted by: "Jason" xxjaysonxx@aol.com   g3m1n1980

Mon May 21, 2012 7:54 pm (PDT)



Randy,

What am I missing

=RCHGetTableCell("http://wallstwatchdog.com/company?symbol="&B2&"",1,">Index",,,,1,"</table",,"--")

Im trying to grab the insider trading table from wallstwatchdog.

http://wallstwatchdog.com/company?symbol=ORCL

I can pull the earnings date from Finviz so I know its possible

=RCHGetTableCell("http://finviz.com/quote.ashx?t="&B2&"",6,">Index",,,,10,"</table",,"--")

http://finviz.com/quote.ashx?t=ORCL&ty=c&ta=1&p=d

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
8b.

Re: gethtmltable

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon May 21, 2012 8:11 pm (PDT)



It appears they have something going on in the web page that prevents the
add-in from retrieving the source code of the web page. I can't even access
the web page with the EXCEL Web Query process.

On Mon, May 21, 2012 at 7:54 PM, Jason <xxjaysonxx@aol.com> wrote:

>
> What am I missing
>
> =RCHGetTableCell("http://wallstwatchdog.com/company?symbol=
> "&B2&"",1,">Index",,,,1,"</table",,"--")
>
> Im trying to grab the insider trading table from wallstwatchdog.
>
> http://wallstwatchdog.com/company?symbol=ORCL
>
> I can pull the earnings date from Finviz so I know its possible
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=
> "&B2&"",6,">Index",,,,10,"</table",,"--")
>
> http://finviz.com/quote.ashx?t=ORCL&ty=c&ta=1&p=d
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.17

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)