7 New Messages
Digest #2356
| |
Messages
Thu Sep 27, 2012 6:40 am (PDT) . Posted by:
"back" backmehl
Hi Randy,
i tried to extract the Text from the following link, but i get no results:
http://product.datastream.com/navigator/HelpFiles/DatatypeDefinitions/en/0/WC08245.htm
I want it seperatly for "Applies To", "description" and "Footnotes"
Thanks & kind regards
BM
i tried to extract the Text from the following link, but i get no results:
http://product.
I want it seperatly for "Applies To", "description" and "Footnotes"
Thanks & kind regards
BM
Thu Sep 27, 2012 6:53 am (PDT) . Posted by:
"back" backmehl
--- In smf_addin@yahoogrou
>
> Hi Randy,
>
> i tried to extract the Text from the following link, but i get no results:
>
> http://product.
>
> I want it seperatly for "Applies To", "description" and "Footnotes"
>
> Thanks & kind regards
>
> BM
>
i tried:
=RCHGetHTMLTable(
... but it doesn't work ...
Thu Sep 27, 2012 8:12 am (PDT) . Posted by:
"T A R U N" tarun_1457
Hey,I picked 5 stocks to try it out (AIG, MTB, T, MU, DELL). Hoping the
pasted table below shows up as desired. But you can try it out by
following my test below.
symbols # shares in Mil div rate income aig 1896.8 NA
0 mtb 125 2.8 350 t 5926.5 1.76 10430.64
mu 984.3 NA 0 dell 1761 0.32 563.52
sum=> 10780.64
- Something I changed was source for Shares outstanding from
RCHGetElementNumber(Ticker, 46) to RCHGetElementNumber(Ticker, 6646)
{its ADVFN source and returns number value in Millions}.
- secondly, I added fourmula "IF(ISERROR(B2*C2),0,B2*C2)" in column D -
what it does is it checks if B2*C2 produces an Error. If yes it returns
a 0 else B2*C2 (Ref - Reference
<http://answers.yahoo.com/question/index?qid=20090105204319AALa1SO > )
- Lastly sum function to sum all Col D values
Let me know if this worked for you.
Cheers to Randy.Tarun
----------------------------------------------------------
--- In smf_addin@yahoogroups.com , "bobc94595" <conlonrc@...> wrote:
>
> Thanks, Ron, for taking the time to respond.
> In order to visualize my very simple calculation, consider that I have
stock symbols listed in column A- 1 through A-25, that column B1 through
B25 lists the number of shares for each stock, that each cell within
column C-1 through C-25 lists RCHGetElementNumber(ticker, 46) for the
Dividend Rate for each stock listed in column A, and that column D-1
through D-25 is simply a formula multiplying, for example, B-1 by C-1 to
arrive at the income from a particular stock in D-1.
>
> For those stocks listed in column A which have dividends, and return
that information, the calculation in column D works perfectly.
>
> For those stocks listed in column A which do not pay dividends, the
search return is NA in column C, and #VALUE! in column D, and I,
therefore, cannot total column D to arrive at a total income figure.
>
> I don't think I was using an Array calculation as you mentioned, and I
tried using the formula that you suggested, but had difficulty in
properly entering the formula. I then went to Excel Forum and, rather
than trying to change NA to zero in column C, I instead successfully
attacked column D to ignore all entries of #VALUE! with the following
formula: =SUMIF(D4:D105,"<>#value!"). It seems to have worked fine.
> Thanks for your effort.
>
>
> --- In smf_addin@yahoogroups.com , Ron Spruell hashky@ wrote:
> >
> > That's why you would NOT use instead of use.
> >
> >
> >
> >
> > >________________________________
> > > From: Ron Spruell hashky@
> > >To: "smf_addin@yahoogroups.com " smf_addin@yahoogroups.com
> > >Sent: Tuesday, September 25, 2012 7:57 AM
> > >Subject: Re: [smf_addin] RCHGetElementNumber(ticker, 46) - Return
"NA"
> > >
> > >
> > >Â
> > >I don't know your dividend calculation, but something like this
should work. If you don't like "--", you could use 0.
> > >
> > >
> > >
> > >=IF(ISNUMBER(Dividend Yield)=TRUE,+"Dividend calc","--")
> > >Where Dividend Yield = Cell containing the Dividend Yield, and
Dividend calc is your Dividend Calculation.
> > >
> > >
> > >I am curious why you would use and Array calculation like
=RCHGetYahooQuotes(A1:A25,"y"), where A1:A25 contains your stock
symbols.
> > >
> > >
> > >Or even Finviz.
> > >
> > >
> > >Ron Spruell
> > >
> > >
> > >>________________________________
> > >> From: bobc94595 conlonrc@
> > >>To: smf_addin@yahoogroups.com
> > >>Sent: Monday, September 24, 2012 2:36 PM
> > >>Subject: [smf_addin] RCHGetElementNumber(ticker, 46) - Return "NA"
> > >>
> > >>
> > >>Â
> > >>I have a spreadsheet with one column which uses
RCHGetElementNumber(ticker, 46), to get Dividend Rates for about 25
stocks. Those stocks that do not pay dividends return "NA", without the
quotes. I am using that Dividend Rate column information to calculate
another column of Dividend Income, but I get a #VALUE! in the Dividend
Income column for any stock with an NA in the Dividend Rate column.
> > >>Do you have a formula to convert NA to zero in the Dividend Rate
column?
> > >>
> > >>
> > >>
> > >>
> > >
> > >
> > >
> >
>
pasted table below shows up as desired. But you can try it out by
following my test below.
symbols # shares in Mil div rate income aig 1896.8 NA
0 mtb 125 2.8 350 t 5926.5 1.76 10430.64
mu 984.3 NA 0 dell 1761 0.32 563.52
sum=> 10780.64
- Something I changed was source for Shares outstanding from
RCHGetElementNumber
{its ADVFN source and returns number value in Millions}.
- secondly, I added fourmula "IF(ISERROR(
what it does is it checks if B2*C2 produces an Error. If yes it returns
a 0 else B2*C2 (Ref - Reference
<http://answers.
- Lastly sum function to sum all Col D values
Let me know if this worked for you.
Cheers to Randy.Tarun
------------
--- In smf_addin@yahoogrou
>
> Thanks, Ron, for taking the time to respond.
> In order to visualize my very simple calculation, consider that I have
stock symbols listed in column A- 1 through A-25, that column B1 through
B25 lists the number of shares for each stock, that each cell within
column C-1 through C-25 lists RCHGetElementNumber
Dividend Rate for each stock listed in column A, and that column D-1
through D-25 is simply a formula multiplying, for example, B-1 by C-1 to
arrive at the income from a particular stock in D-1.
>
> For those stocks listed in column A which have dividends, and return
that information, the calculation in column D works perfectly.
>
> For those stocks listed in column A which do not pay dividends, the
search return is NA in column C, and #VALUE! in column D, and I,
therefore, cannot total column D to arrive at a total income figure.
>
> I don't think I was using an Array calculation as you mentioned, and I
tried using the formula that you suggested, but had difficulty in
properly entering the formula. I then went to Excel Forum and, rather
than trying to change NA to zero in column C, I instead successfully
attacked column D to ignore all entries of #VALUE! with the following
formula: =SUMIF(D4:D105,
> Thanks for your effort.
>
>
> --- In smf_addin@yahoogrou
> >
> > That's why you would NOT use instead of use.
> >
> >
> >
> >
> > >___________
> > > From: Ron Spruell hashky@
> > >To: "smf_addin@yahoogrou
> > >Sent: Tuesday, September 25, 2012 7:57 AM
> > >Subject: Re: [smf_addin] RCHGetElementNumber
"NA"
> > >
> > >
> > >Â
> > >I don't know your dividend calculation, but something like this
should work. If you don't like "--", you could use 0.
> > >
> > >
> > >
> > >=IF(ISNUMBER(
> > >Where Dividend Yield = Cell containing the Dividend Yield, and
Dividend calc is your Dividend Calculation.
> > >
> > >
> > >I am curious why you would use and Array calculation like
=RCHGetYahooQuotes(
symbols.
> > >
> > >
> > >Or even Finviz.
> > >
> > >
> > >Ron Spruell
> > >
> > >
> > >>__________
> > >> From: bobc94595 conlonrc@
> > >>To: smf_addin@yahoogrou
> > >>Sent: Monday, September 24, 2012 2:36 PM
> > >>Subject: [smf_addin] RCHGetElementNumber
> > >>
> > >>
> > >>Â
> > >>I have a spreadsheet with one column which uses
RCHGetElementNumber
stocks. Those stocks that do not pay dividends return "NA", without the
quotes. I am using that Dividend Rate column information to calculate
another column of Dividend Income, but I get a #VALUE! in the Dividend
Income column for any stock with an NA in the Dividend Rate column.
> > >>Do you have a formula to convert NA to zero in the Dividend Rate
column?
> > >>
> > >>
> > >>
> > >>
> > >
> > >
> > >
> >
>
Thu Sep 27, 2012 1:45 pm (PDT) . Posted by:
"d.sweitzer22" d.sweitzer22
Hi. I am trying to get data from the Fed website using the RCHGetTableCell function. I am able to pull in the data from the table I want; however, my problem is that the table sometimes expands to more columns. I am trying to always pull in the data from the last column. I was wondering if there was some way to automate this instead of having to change the column in the function. Here is what I have.
=RCHGetTableCell("http://www.federalreserve.gov/releases/h15/update/default.htm ",2,"Baa")
Right now im pulling in data from column 2 but it expands to up to 5 columns depending on the time and day of the week. Is there a way to have the function always search for the last column in the row?
Thanks in advance for your help!
=RCHGetTableCell(
Right now im pulling in data from column 2 but it expands to up to 5 columns depending on the time and day of the week. Is there a way to have the function always search for the last column in the row?
Thanks in advance for your help!
Thu Sep 27, 2012 2:13 pm (PDT) . Posted by:
"dguillett1" donaldb36
You could get it all and have a macro look for the last column and copy elsewhere.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: d.sweitzer22
Sent: Thursday, September 27, 2012 3:45 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RCHGetTableCell
Hi. I am trying to get data from the Fed website using the RCHGetTableCell function. I am able to pull in the data from the table I want; however, my problem is that the table sometimes expands to more columns. I am trying to always pull in the data from the last column. I was wondering if there was some way to automate this instead of having to change the column in the function. Here is what I have.
=RCHGetTableCell("http://www.federalreserve.gov/releases/h15/update/default.htm ",2,"Baa")
Right now im pulling in data from column 2 but it expands to up to 5 columns depending on the time and day of the week. Is there a way to have the function always search for the last column in the row?
Thanks in advance for your help!
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: d.sweitzer22
Sent: Thursday, September 27, 2012 3:45 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] RCHGetTableCell
Hi. I am trying to get data from the Fed website using the RCHGetTableCell function. I am able to pull in the data from the table I want; however, my problem is that the table sometimes expands to more columns. I am trying to always pull in the data from the last column. I was wondering if there was some way to automate this instead of having to change the column in the function. Here is what I have.
=RCHGetTableCell(
Right now im pulling in data from column 2 but it expands to up to 5 columns depending on the time and day of the week. Is there a way to have the function always search for the last column in the row?
Thanks in advance for your help!
Thu Sep 27, 2012 2:28 pm (PDT) . Posted by:
"zarathustra_winced@yahoo.com" zarathustra_winced
You can get the FRED add in from the fed website which will allow you pull any series you want, or use the smf add in rchgetecondata function. If you want yields for Baa corporates, I posted a vba function to pull yields from the yahoo page about a month ago.
Sent via BlackBerry by AT&T
-----Original Message-----
From: "dguillett1" <dguillett1@gmail.com >
Sender: smf_addin@yahoogroups.com
Date: Thu, 27 Sep 2012 16:13:05
To: <smf_addin@yahoogroups.com >
Reply-To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell
You could get it all and have a macro look for the last column and copy elsewhere.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: d.sweitzer22
Sent: Thursday, September 27, 2012 3:45 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RCHGetTableCell
Hi. I am trying to get data from the Fed website using the RCHGetTableCell function. I am able to pull in the data from the table I want; however, my problem is that the table sometimes expands to more columns. I am trying to always pull in the data from the last column. I was wondering if there was some way to automate this instead of having to change the column in the function. Here is what I have.
=RCHGetTableCell("http://www.federalreserve.gov/releases/h15/update/default.htm ",2,"Baa")
Right now im pulling in data from column 2 but it expands to up to 5 columns depending on the time and day of the week. Is there a way to have the function always search for the last column in the row?
Thanks in advance for your help!
Sent via BlackBerry by AT&T
-----Original Message-----
From: "dguillett1" <dguillett1@gmail.
Sender: smf_addin@yahoogrou
Date: Thu, 27 Sep 2012 16:13:05
To: <smf_addin@yahoogrou
Reply-To: smf_addin@yahoogrou
Subject: Re: [smf_addin] RCHGetTableCell
You could get it all and have a macro look for the last column and copy elsewhere.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: d.sweitzer22
Sent: Thursday, September 27, 2012 3:45 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] RCHGetTableCell
Hi. I am trying to get data from the Fed website using the RCHGetTableCell function. I am able to pull in the data from the table I want; however, my problem is that the table sometimes expands to more columns. I am trying to always pull in the data from the last column. I was wondering if there was some way to automate this instead of having to change the column in the function. Here is what I have.
=RCHGetTableCell(
Right now im pulling in data from column 2 but it expands to up to 5 columns depending on the time and day of the week. Is there a way to have the function always search for the last column in the row?
Thanks in advance for your help!
Thu Sep 27, 2012 5:27 pm (PDT) . Posted by:
"andrewhills97" andrewhills97
Hi, Is there an Excel template which collects intraday price data from Yahoo Finance, say 5 min data. If so, is it delayed? Thanks and Regards
Tidak ada komentar:
Posting Komentar