15 New Messages
Digest #2628
Messages
Thu May 23, 2013 6:18 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
there is some problem with extracting data from 4traders
1) using this 2 code (D2 is where i point INTERNATIONAL-BUSINESS-MA-4828)
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Finance")," ","")
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Yield";)," ","")
but it gives me an ''ERROR'' message
and
=RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",
1,">Finance")
=RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",
1,">Yield")
and it gives a ''VALUE'' message
2) under the http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/ for example,
there is the row Debt, Finance etc,
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"EBITDA")," ","") points to the first column which shows the result ''24 135''
however, when i tweaked to =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"EBITDA")," ","")
i get an ''#VALUE'' message. The main purpose is to show EBITDA
can i know is there any codes where i can solve the problem?
thanks
--- In smf_addin@yahoogroups.com , "weekeewawa" <weekeewawa@...> wrote:
>
> works well!
>
> thanks randy
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Get rid of the trailing dollar sign from what you retrieve...
> >
> > Just drop the "0+" from the formula, and you'll see what gets returned. If
> > it's not numeric, you'll get a #VALUE! error when you try to add 0 to it.
> >
> > Or, you can use the smfConvertData() function instead of adding 0 to
> > convert it to numeric:
> >
> > =smfConvertData(SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/
> > "&C2&"/quotes/",
> > 1,"Session exchange")," ",""))
> >
> > On Thu, Apr 25, 2013 at 11:40 PM, weekeewawa <weekeewawa@> wrote:
> >
> > > hello randy, while extracting 4-traders data for this webpage
> > >
> > > http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/quotes/
> > >
> > > Session exchange 902 246 866$
> > > Avg. Exchange 20 sessions 979 378 017$
> > >
> > > shows a #VALUE error
> > > the code which i put is
> > >
> > > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&C2&"/quotes/",1,"Session
> > > exchange")," ","")
> > >
> > >
> > > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&C2&"/quotes/",1,"Avg.
> > > Exchange 20 sessions")," ","")
> > >
> > > any solution to that?
> > >
> >
>
there is some problem with extracting data from 4traders
1) using this 2 code (D2 is where i point INTERNATIONAL-
=0+SUBSTITUTE(
=0+SUBSTITUTE(
but it gives me an ''ERROR&#
and
=RCHGetTableCell(
1,">
=RCHGetTableCell(
1,">
and it gives a ''VALUE&#
2) under the http://www.4-
there is the row Debt, Finance etc,
=0+SUBSTITUTE(
however, when i tweaked to =0+SUBSTITUTE(
i get an ''#VALUE&#
can i know is there any codes where i can solve the problem?
thanks
--- In smf_addin@yahoogrou
>
> works well!
>
> thanks randy
>
> --- In smf_addin@yahoogrou
> >
> > Get rid of the trailing dollar sign from what you retrieve...
> >
> > Just drop the "0+" from the formula, and you'll see what gets returned. If
> > it's not numeric, you'll get a #VALUE! error when you try to add 0 to it.
> >
> > Or, you can use the smfConvertData(
> > convert it to numeric:
> >
> > =smfConvertData(
> > "&C2&"
> > 1,"Session exchange"
> >
> > On Thu, Apr 25, 2013 at 11:40 PM, weekeewawa <weekeewawa@
> >
> > > hello randy, while extracting 4-traders data for this webpage
> > >
> > > http://www.4-
> > >
> > > Session exchange 902 246 866$
> > > Avg. Exchange 20 sessions 979 378 017$
> > >
> > > shows a #VALUE error
> > > the code which i put is
> > >
> > > =0+SUBSTITUTE(
> > > exchange"
> > >
> > >
> > > =0+SUBSTITUTE(
> > > Exchange 20 sessions"
> > >
> > > any solution to that?
> > >
> >
>
Thu May 23, 2013 8:36 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Plain old words like "Finance" and "Yield" are not likely to be good search
strings to position yourself on the web page. You need to look at the
source code of the web page in some circumstances.
Something like ">Finance" positions you at the link for the "Finance
Calculator". But I don't get the #VALUE! errors you mention.
This works fine for me:
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"EBITDA"),"
","")
On Thu, May 23, 2013 at 6:18 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
> hello randy,
>
> there is some problem with extracting data from 4traders
>
> 1) using this 2 code (D2 is where i point INTERNATIONAL-BUSINESS-MA-4828)
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Finance"),"
> ","")
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Yield";),"
> ","")
>
> but it gives me an ''ERROR'' message
>
> and
>
> =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",
> 1,">Finance")
>
> =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",
> 1,">Yield")
>
> and it gives a ''VALUE'' message
>
> 2) under the
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/ for
> example,
>
> there is the row Debt, Finance etc,
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"EBITDA"),"
> ","") points to the first column which shows the result ''24 135''
>
> however, when i tweaked to =0+SUBSTITUTE(RCHGetTableCell("
> http://www.4-traders.com/ "&D2&"/financials/",0,"EBITDA")," ","")
>
> i get an ''#VALUE'' message. The main purpose is to show EBITDA
>
> can i know is there any codes where i can solve the problem?
>
>
strings to position yourself on the web page. You need to look at the
source code of the web page in some circumstances.
Something like ">Finance&q
Calculator"
This works fine for me:
=0+SUBSTITUTE(
","
On Thu, May 23, 2013 at 6:18 AM, weekeewawa <weekeewawa@yahoo.
> hello randy,
>
> there is some problem with extracting data from 4traders
>
> 1) using this 2 code (D2 is where i point INTERNATIONAL-
>
> =0+SUBSTITUTE(
> ","
>
> =0+SUBSTITUTE(
> ","
>
> but it gives me an ''ERROR&#
>
> and
>
> =RCHGetTableCell(
> 1,">
>
> =RCHGetTableCell(
> 1,">
>
> and it gives a ''VALUE&#
>
> 2) under the
> http://www.4-
> example,
>
> there is the row Debt, Finance etc,
>
> =0+SUBSTITUTE(
> ","
>
> however, when i tweaked to =0+SUBSTITUTE(
> http://www.4-
>
> i get an ''#VALUE&#
>
> can i know is there any codes where i can solve the problem?
>
>
Thu May 23, 2013 9:12 am (PDT) . Posted by:
"weekeewawa" weekeewawa
Hello randy,
=0+SUBSTITUTE(RCHGetTableCell("http://www.4traders.com/ "&D2&"/financials/",1,"EBITDA")," is working
but the problem lies with the column ''Finance'' and ''Yield''
if plain old words like these cannot get results for example
from http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/
Finance - - - - - -
Yield 1,21% 1,40% 1,59% 1,69% 1,84% 1,92%
what is a good word for it?
also, as you know, for example ''Sales''
whereby the result
''99 870'' code is =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Sales";)," ","")
''106 916'' code is =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",2,"Sales";)," ","")
is it possible to extract the word ''SALES''
with
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"Sales";)," ","")? i tried it but it gives an error
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",-1,"Sales";)," ","") as well
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Plain old words like "Finance" and "Yield" are not likely to be good search
> strings to position yourself on the web page. You need to look at the
> source code of the web page in some circumstances.
>
> Something like ">Finance" positions you at the link for the "Finance
> Calculator". But I don't get the #VALUE! errors you mention.
>
> This works fine for me:
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"EBITDA"),"
> ","")
>
> On Thu, May 23, 2013 at 6:18 AM, weekeewawa <weekeewawa@...> wrote:
>
> > hello randy,
> >
> > there is some problem with extracting data from 4traders
> >
> > 1) using this 2 code (D2 is where i point INTERNATIONAL-BUSINESS-MA-4828)
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Finance"),"
> > ","")
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Yield";),"
> > ","")
> >
> > but it gives me an ''ERROR'' message
> >
> > and
> >
> > =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",
> > 1,">Finance")
> >
> > =RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",
> > 1,">Yield")
> >
> > and it gives a ''VALUE'' message
> >
> > 2) under the
> > http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/ for
> > example,
> >
> > there is the row Debt, Finance etc,
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"EBITDA"),"
> > ","") points to the first column which shows the result ''24 135''
> >
> > however, when i tweaked to =0+SUBSTITUTE(RCHGetTableCell("
> > http://www.4-traders.com/ "&D2&"/financials/",0,"EBITDA")," ","")
> >
> > i get an ''#VALUE'' message. The main purpose is to show EBITDA
> >
> > can i know is there any codes where i can solve the problem?
> >
> >
>
=0+SUBSTITUTE(
but the problem lies with the column ''Finance&#
if plain old words like these cannot get results for example
from http://www.4-
Finance - - - - - -
Yield 1,21% 1,40% 1,59% 1,69% 1,84% 1,92%
what is a good word for it?
also, as you know, for example ''Sales&#
whereby the result
''99 870'' code is =0+SUBSTITUTE(
''106 916'' code is =0+SUBSTITUTE(
is it possible to extract the word ''SALES&#
with
=0+SUBSTITUTE(
=0+SUBSTITUTE(
--- In smf_addin@yahoogrou
>
> Plain old words like "Finance" and "Yield" are not likely to be good search
> strings to position yourself on the web page. You need to look at the
> source code of the web page in some circumstances.
>
> Something like ">Finance&q
> Calculator"
>
> This works fine for me:
>
> =0+SUBSTITUTE(
> ","
>
> On Thu, May 23, 2013 at 6:18 AM, weekeewawa <weekeewawa@
>
> > hello randy,
> >
> > there is some problem with extracting data from 4traders
> >
> > 1) using this 2 code (D2 is where i point INTERNATIONAL-
> >
> > =0+SUBSTITUTE(
> > ","
> >
> > =0+SUBSTITUTE(
> > ","
> >
> > but it gives me an ''ERROR&#
> >
> > and
> >
> > =RCHGetTableCell(
> > 1,">
> >
> > =RCHGetTableCell(
> > 1,">
> >
> > and it gives a ''VALUE&#
> >
> > 2) under the
> > http://www.4-
> > example,
> >
> > there is the row Debt, Finance etc,
> >
> > =0+SUBSTITUTE(
> > ","
> >
> > however, when i tweaked to =0+SUBSTITUTE(
> > http://www.4-
> >
> > i get an ''#VALUE&#
> >
> > can i know is there any codes where i can solve the problem?
> >
> >
>
Thu May 23, 2013 4:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's what there are multiple search strings, so that you can position
yourself better. For example:
=RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Finances
- Leverage",">Finance")
=RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",1,"Income
Statement Data","Yield")
I don't know why you would want to extract the word "Sales", but try this:
=RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"Sales";)
On Thu, May 23, 2013 at 9:12 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4traders.com/ "&D2&"/financials/",1,"EBITDA"),"
> is working
>
> but the problem lies with the column ''Finance'' and ''Yield''
>
> if plain old words like these cannot get results for example
> from http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/
>
> Finance - - - - - -
>
> Yield 1,21% 1,40% 1,59% 1,69% 1,84% 1,92%
>
> what is a good word for it?
>
> also, as you know, for example ''Sales''
>
> whereby the result
>
> ''99 870'' code is =0+SUBSTITUTE(RCHGetTableCell("
> http://www.4-traders.com/ "&D2&"/financials/",1,"Sales";)," ","")
>
> ''106 916'' code is =0+SUBSTITUTE(RCHGetTableCell("
> http://www.4-traders.com/ "&D2&"/financials/",2,"Sales";)," ","")
>
> is it possible to extract the word ''SALES''
>
> with
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",0,"Sales";),"
> ","")? i tried it but it gives an error
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&D2&"/financials/",-1,"Sales";),"
> ","") as well
>
yourself better. For example:
=RCHGetTableCell(
- Leverage"
=RCHGetTableCell(
Statement Data","
I don't know why you would want to extract the word "Sales"
=RCHGetTableCell(
On Thu, May 23, 2013 at 9:12 AM, weekeewawa <weekeewawa@yahoo.
>
> =0+SUBSTITUTE(
> is working
>
> but the problem lies with the column ''Finance&#
>
> if plain old words like these cannot get results for example
> from http://www.4-
>
> Finance - - - - - -
>
> Yield 1,21% 1,40% 1,59% 1,69% 1,84% 1,92%
>
> what is a good word for it?
>
> also, as you know, for example ''Sales&#
>
> whereby the result
>
> ''99 870'' code is =0+SUBSTITUTE(
> http://www.4-
>
> ''106 916'' code is =0+SUBSTITUTE(
> http://www.4-
>
> is it possible to extract the word ''SALES&#
>
> with
>
> =0+SUBSTITUTE(
> ","
>
> =0+SUBSTITUTE(
> ","
>
Thu May 23, 2013 6:55 am (PDT) . Posted by:
"antonvanas1989" antonvanas1989
Sorry it is possible with RCHGetYahooHistory() indeed. You can only have monthly quotes right? So for the "year high" i need to find the highest of the 12 months in the array right? Or can i adjust the macro to add period "y" in the code? So the macro will find the highest of the year himself?
This line will give me 12 highest of the month:
=RCHGetYahooHistory("ko";YEAR($H$1);MONTH($H$1);DAY($H$1);YEAR($H$2);MONTH($H$2);DAY($H$2);"m";"l";0)
But is it possible to get something like this:
=IFERROR(RCHGetYahooHistory("ko";YEAR($H$1);MONTH($H$1);DAY($H$1);YEAR($H$2);MONTH($H$2);DAY($H$2);"y";"l";0);"--")
where "y" stands for year and will gave the highest of the hole period?
Thanks for all the effort you put in Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Right. So you would need to use RCHGetYahooHistory() to get the unadjusted
> prices. So where is the problem?
>
> On Wed, May 22, 2013 at 10:15 AM, antonvanas1989
> <antonvanas1989@...>wrote:
>
> > I would like to create my own ratios for value a company.
> >
> > So for P/E i need Price and Earnings from past years.
> >
> > i get the eps from years back from Advfn, and i get prices with:
> > low/high = SMFPricesBetween()
> > close = SMFPricesByDates()
> > close (not adjusted) = RCHGetYahooHistory()
> >
> > Now is those data fully adjusted for dividends etc.
> >
> > But when i want to know what the P/E ratio was last 10 years i need the
> > non adjusted prices, otherwise all those adjustment etc would make a wrong
> > view of the "real" P/E ratio at the time. Do you understand where my
> > problem is?
> >
> > Same with all other ratios using "Historical Prices" for calculations.
> > (Like Price/Bookvalue).
> >
>
This line will give me 12 highest of the month:
=RCHGetYahooHistory
But is it possible to get something like this:
=IFERROR(RCHGetYaho
where "y" stands for year and will gave the highest of the hole period?
Thanks for all the effort you put in Randy.
--- In smf_addin@yahoogrou
>
> Right. So you would need to use RCHGetYahooHistory(
> prices. So where is the problem?
>
> On Wed, May 22, 2013 at 10:15 AM, antonvanas1989
> <antonvanas1989@
>
> > I would like to create my own ratios for value a company.
> >
> > So for P/E i need Price and Earnings from past years.
> >
> > i get the eps from years back from Advfn, and i get prices with:
> > low/high = SMFPricesBetween(
> > close = SMFPricesByDates(
> > close (not adjusted) = RCHGetYahooHistory(
> >
> > Now is those data fully adjusted for dividends etc.
> >
> > But when i want to know what the P/E ratio was last 10 years i need the
> > non adjusted prices, otherwise all those adjustment etc would make a wrong
> > view of the "real" P/E ratio at the time. Do you understand where my
> > problem is?
> >
> > Same with all other ratios using "Historical Prices" for calculations.
> > (Like Price/Bookvalue)
> >
>
Thu May 23, 2013 8:11 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo only provides the data on a daily, weekly, or monthly basis. Not
annually.
You'd be best off getting the whole range of data that you're interested in
and then extracting it from that range. Especially since your dates will
not correspond to calendar periods.
On Thu, May 23, 2013 at 6:55 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> Sorry it is possible with RCHGetYahooHistory() indeed. You can only have
> monthly quotes right? So for the "year high" i need to find the highest of
> the 12 months in the array right? Or can i adjust the macro to add period
> "y" in the code? So the macro will find the highest of the year himself?
>
> This line will give me 12 highest of the month:
>
> =RCHGetYahooHistory("ko";YEAR($H$1);MONTH($H$1);DAY($H$1);YEAR($H$2);MONTH($H$2);DAY($H$2);"m";"l";0)
>
> But is it possible to get something like this:
>
>
> =IFERROR(RCHGetYahooHistory("ko";YEAR($H$1);MONTH($H$1);DAY($H$1);YEAR($H$2);MONTH($H$2);DAY($H$2);"y";"l";0);"--")
>
> where "y" stands for year and will gave the highest of the hole period?
>
annually.
You'd be best off getting the whole range of data that you're interested in
and then extracting it from that range. Especially since your dates will
not correspond to calendar periods.
On Thu, May 23, 2013 at 6:55 AM, antonvanas1989 <antonvanas1989@
> Sorry it is possible with RCHGetYahooHistory(
> monthly quotes right? So for the "year high" i need to find the highest of
> the 12 months in the array right? Or can i adjust the macro to add period
> "y" in the code? So the macro will find the highest of the year himself?
>
> This line will give me 12 highest of the month:
>
> =RCHGetYahooHistory
>
> But is it possible to get something like this:
>
>
> =IFERROR(RCHGetYaho
>
> where "y" stands for year and will gave the highest of the hole period?
>
Thu May 23, 2013 7:34 am (PDT) . Posted by:
"bs2167" bs2167
Hello,
I am trying to download the table on this page using RCHgethtmltable():
http://www.dividend.com/ex-dividend-dates.php
but it's coming back blank. This is how I have the formula set up:
=rchgethtmltable("http://www.dividend.com/ex-dividend-dates.php ","Ex-Dividend Date Search Results",1,"What are Ex-Dividend Dates?",-1)
Is it possible to download this data? If so, if anyone could point out why my strings and table tag search directions didn't work, I would appreciate it...hopefully then I can be a little more self sufficient in the future.
I am trying to download the table on this page using RCHgethtmltable(
http://www.dividend
but it's coming back blank. This is how I have the formula set up:
=rchgethtmltable(
Is it possible to download this data? If so, if anyone could point out why my strings and table tag search directions didn't work, I would appreciate it...hopefully then I can be a little more self sufficient in the future.
Thu May 23, 2013 8:21 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your formula works fine for me. As does:
=RCHGetHTMLTable("http://www.dividend.com/ex-dividend-dates.php ","Ex-Dividend
Date Search Results",1,"",1)
=RCHGetHTMLTable("http://www.dividend.com/ex-dividend-dates.php ","
DARS",-1,"",1)
On Thu, May 23, 2013 at 7:34 AM, bs2167 <bs2167@yahoo.com > wrote:
>
> I am trying to download the table on this page using RCHgethtmltable():
>
> http://www.dividend.com/ex-dividend-dates.php
>
> but it's coming back blank. This is how I have the formula set up:
>
> =*rchgethtmltable("http://www.dividend.com/ex-dividend-dates.php ","Ex-Dividend
> Date Search Results",1,"What are Ex-Dividend Dates?",-1)*
>
> Is it possible to download this data? If so, if anyone could point out
> why my strings and table tag search directions didn't work, I would
> appreciate it...hopefully then I can be a little more self sufficient in
> the future.
>
=RCHGetHTMLTable(
Date Search Results"
=RCHGetHTMLTable(
DARS",-
On Thu, May 23, 2013 at 7:34 AM, bs2167 <bs2167@yahoo.
>
> I am trying to download the table on this page using RCHgethtmltable(
>
> http://www.dividend
>
> but it's coming back blank. This is how I have the formula set up:
>
> =*rchgethtmltable(
> Date Search Results"
>
> Is it possible to download this data? If so, if anyone could point out
> why my strings and table tag search directions didn't work, I would
> appreciate it...hopefully then I can be a little more self sufficient in
> the future.
>
Thu May 23, 2013 8:42 am (PDT) . Posted by:
"bs2167" bs2167
Thanks for confirming it works. After some more fiddling, it appears that site only allows so many free hits on that page before you get a redirect to a subscription form. I must have hit the limit right when I started working in Excel.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Your formula works fine for me. As does:
>
> =RCHGetHTMLTable("http://www.dividend.com/ex-dividend-dates.php ","Ex-Dividend
> Date Search Results",1,"",1)
> =RCHGetHTMLTable("http://www.dividend.com/ex-dividend-dates.php ","
> DARS",-1,"",1)
>
> On Thu, May 23, 2013 at 7:34 AM, bs2167 <bs2167@...> wrote:
>
> >
> > I am trying to download the table on this page using RCHgethtmltable():
> >
> > http://www.dividend.com/ex-dividend-dates.php
> >
> > but it's coming back blank. This is how I have the formula set up:
> >
> > =*rchgethtmltable("http://www.dividend.com/ex-dividend-dates.php ","Ex-Dividend
> > Date Search Results",1,"What are Ex-Dividend Dates?",-1)*
> >
> > Is it possible to download this data? If so, if anyone could point out
> > why my strings and table tag search directions didn't work, I would
> > appreciate it...hopefully then I can be a little more self sufficient in
> > the future.
> >
>
--- In smf_addin@yahoogrou
>
> Your formula works fine for me. As does:
>
> =RCHGetHTMLTable(
> Date Search Results"
> =RCHGetHTMLTable(
> DARS",-
>
> On Thu, May 23, 2013 at 7:34 AM, bs2167 <bs2167@.
>
> >
> > I am trying to download the table on this page using RCHgethtmltable(
> >
> > http://www.dividend
> >
> > but it's coming back blank. This is how I have the formula set up:
> >
> > =*rchgethtmltable(
> > Date Search Results"
> >
> > Is it possible to download this data? If so, if anyone could point out
> > why my strings and table tag search directions didn't work, I would
> > appreciate it...hopefully then I can be a little more self sufficient in
> > the future.
> >
>
Thu May 23, 2013 8:06 am (PDT) . Posted by:
"domellner" domellner
Hi, I'm also getting a value of 0 for Net Income, for example:
=RCHGetElementNumber("AAPL",8847)
=RCHGetElementNumber("DELL",8848) //I get 0 for range 8848-8862
Same for HPQ, most of INTC, BBRY and TXN.
Any help much appreciated!!
-Dominique
--- In smf_addin@yahoogroups.com , "sma11dragon" <sma11dragon@...> wrote:
>
> Hi Randy,
> I got a quick question. I recently found out that there's no value in the Net Income when using =RCHGetElementNumber(TICKER,range) when the range is 5597-5600. This range corresponds to the Net Income for 2008-2011. Other years are fine and advfn website is showing these numbers. Do you know what's happening?
>
> Thanks,
> SD
>
=RCHGetElementNumbe
=RCHGetElementNumbe
Same for HPQ, most of INTC, BBRY and TXN.
Any help much appreciated!
-Dominique
--- In smf_addin@yahoogrou
>
> Hi Randy,
> I got a quick question. I recently found out that there's no value in the Net Income when using =RCHGetElementNumbe
>
> Thanks,
> SD
>
Thu May 23, 2013 8:06 am (PDT) . Posted by:
"domellner" domellner
Hi, when trying to retrieve net income for the following range 8848-8862 for several tickers, I get a value of 0.
RCHGetElementNumber("AAPL";,8847)
RCHGetElementNumber("DELL";,8848)
Same problem with HPQ, INTC, BBRY, TXN.
Any help much appreciated!!
Best, Dominique
RCHGetElementNumber
RCHGetElementNumber
Same problem with HPQ, INTC, BBRY, TXN.
Any help much appreciated!
Best, Dominique
Thu May 23, 2013 8:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It appears that is what AdvFN has posted...
On Thu, May 23, 2013 at 6:53 AM, domellner <dominique.ellner@gmail.com >wrote:
> Hi, when trying to retrieve net income for the following range 8848-8862
> for several tickers, I get a value of 0.
>
> RCHGetElementNumber("AAPL";,8847)
> RCHGetElementNumber("DELL";,8848)
>
> Same problem with HPQ, INTC, BBRY, TXN.
>
> Any help much appreciated!!
>
On Thu, May 23, 2013 at 6:53 AM, domellner <dominique.ellner@
> Hi, when trying to retrieve net income for the following range 8848-8862
> for several tickers, I get a value of 0.
>
> RCHGetElementNumber
> RCHGetElementNumber
>
> Same problem with HPQ, INTC, BBRY, TXN.
>
> Any help much appreciated!
>
Thu May 23, 2013 4:40 pm (PDT) . Posted by:
"domellner" domellner
Thank you. Should I try to alert them to the problem?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It appears that is what AdvFN has posted...
>
> On Thu, May 23, 2013 at 6:53 AM, domellner <dominique.ellner@...>wrote:
>
> > Hi, when trying to retrieve net income for the following range 8848-8862
> > for several tickers, I get a value of 0.
> >
> > RCHGetElementNumber("AAPL";,8847)
> > RCHGetElementNumber("DELL";,8848)
> >
> > Same problem with HPQ, INTC, BBRY, TXN.
> >
> > Any help much appreciated!!
> >
>
--- In smf_addin@yahoogrou
>
> It appears that is what AdvFN has posted...
>
> On Thu, May 23, 2013 at 6:53 AM, domellner <dominique.
>
> > Hi, when trying to retrieve net income for the following range 8848-8862
> > for several tickers, I get a value of 0.
> >
> > RCHGetElementNumber
> > RCHGetElementNumber
> >
> > Same problem with HPQ, INTC, BBRY, TXN.
> >
> > Any help much appreciated!
> >
>
Thu May 23, 2013 9:23 am (PDT) . Posted by:
"sudhir agarwal" sudhir_agarwal1
Hi,
I am trying to get the company information using RCHGetElementNumber("IBM",
1)
I am getting error. I am able to retrieve information from yahoo but not
anything from MSN...
Is anyone else facing the same issue
Regards,
Sudhir Agarwal
*Want to increase your knowledge about capital, Currency and cities, check
this Android free app *
*
*
*
https://play.google.com/store/apps/details?id=sudhir.countryquiz&feature=search_result#?t=W251bGwsMSwyLDEsInN1ZGhpci5jb3VudHJ5cXVpeiJd
*
I am trying to get the company information using RCHGetElementNumber
1)
I am getting error. I am able to retrieve information from yahoo but not
anything from MSN...
Is anyone else facing the same issue
Regards,
Sudhir Agarwal
*Want to increase your knowledge about capital, Currency and cities, check
this Android free app *
*
*
*
https://play.
*
Thu May 23, 2013 4:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Are you using the most recent version of the add-in? I had to update MSN
element definitions last year because they changed the structure of their
web site.
On Thu, May 23, 2013 at 9:23 AM, sudhir agarwal <Agarwal.sudhir@gmail.com >wrote:
> I am trying to get the company information using
> RCHGetElementNumber("IBM", 1)
> I am getting error. I am able to retrieve information from yahoo but not
> anything from MSN...
>
> Is anyone else facing the same issue
>
element definitions last year because they changed the structure of their
web site.
On Thu, May 23, 2013 at 9:23 AM, sudhir agarwal <Agarwal.sudhir@
> I am trying to get the company information using
> RCHGetElementNumber
> I am getting error. I am able to retrieve information from yahoo but not
> anything from MSN...
>
> Is anyone else facing the same issue
>
Tidak ada komentar:
Posting Komentar