3 New Messages
Digest #2416
Messages
Wed Nov 28, 2012 5:32 pm (PST) . Posted by:
"Roger Diaz" rogerdiazbernal
Franklin:
My worksheet for various tickers would be:
1. Tickers Variable column A. No part of array.
2. I reserve two rows for each ticker
3. I select B1: H2 and put formula array
=RCHGetHTMLTable("http://www.earnings.com/company.asp?client=cb&ticker= "&A2,">Earnings
Releases",1,"",2)
4. Result: First row and second row titles the most recent data from the
utilities.
5. I copy and paste every two lines and then change the name of tickers.
Have you another way to do it?
[image: Imágenes integradas 1]
Roger
2012/11/28 Roger Diaz <rogerdiazb@gmail.com >
> Thanks Franklin, but How do I get this data from multiple stocks?
>
> Roger
>
>
> 2012/11/28 invesco88 <franklin.forward@gmail.com >
>
>> Randy is it possible to use the "ticker" named range in arrays? I have
>> tried using the smfjoin function but I can't get it to work properly with
>> the formula you provided. Thanks again.
>
>
>
My worksheet for various tickers would be:
1. Tickers Variable column A. No part of array.
2. I reserve two rows for each ticker
3. I select B1: H2 and put formula array
=RCHGetHTMLTable(
Releases",1,
4. Result: First row and second row titles the most recent data from the
utilities.
5. I copy and paste every two lines and then change the name of tickers.
Have you another way to do it?
[image: Imágenes integradas 1]
Roger
2012/11/28 Roger Diaz <rogerdiazb@gmail.
> Thanks Franklin, but How do I get this data from multiple stocks?
>
> Roger
>
>
> 2012/11/28 invesco88 <franklin.forward@
>
>> Randy is it possible to use the "ticker" named range in arrays? I have
>> tried using the smfjoin function but I can't get it to work properly with
>> the formula you provided. Thanks again.
>
>
>
Wed Nov 28, 2012 5:50 pm (PST) . Posted by:
"invesco88" invesco88
I have multiple spreadsheets that are pulling different data for one ticker. I enter that ticker into the first spreadsheet so I don't have to enter it 15 times. I've named that cell with the ticker symbol "ticker" and I reference all of the other sheets to that. When I try to do that for the this formula it throws an error. I hope that's a little more clear my apologies for being vague.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm not sure what you're asking? The URL can only do one ticker symbol at a
> time.
>
> On Wed, Nov 28, 2012 at 4:53 PM, invesco88 <franklin.forward@...>wrote:
>
> > Randy is it possible to use the "ticker" named range in arrays? I have
> > tried using the smfjoin function but I can't get it to work properly with
> > the formula you provided. Thanks again.
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Try something like:
> > >
> > > =RCHGetHTMLTable("
> > http://www.earnings.com/company.asp?client=cb&ticker=IBM ",">Earnings
> > > Releases",1,"",2)
> >
>
--- In smf_addin@yahoogrou
>
> I'm not sure what you're asking? The URL can only do one ticker symbol at a
> time.
>
> On Wed, Nov 28, 2012 at 4:53 PM, invesco88 <franklin.forward@
>
> > Randy is it possible to use the "ticker" named range in arrays? I have
> > tried using the smfjoin function but I can't get it to work properly with
> > the formula you provided. Thanks again.
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Try something like:
> > >
> > > =RCHGetHTMLTable(
> > http://www.earnings
> > > Releases",1,
> >
>
Wed Nov 28, 2012 8:10 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Possibly you gave the "Ticker" defined name a worksheet-level scope instead
of a workbook-level scope?
On Wed, Nov 28, 2012 at 6:50 PM, invesco88 <franklin.forward@gmail.com >wrote:
> I have multiple spreadsheets that are pulling different data for one
> ticker. I enter that ticker into the first spreadsheet so I don't have to
> enter it 15 times. I've named that cell with the ticker symbol "ticker" and
> I reference all of the other sheets to that. When I try to do that for the
> this formula it throws an error. I hope that's a little more clear my
> apologies for being vague.
>
of a workbook-level scope?
On Wed, Nov 28, 2012 at 6:50 PM, invesco88 <franklin.forward@
> I have multiple spreadsheets that are pulling different data for one
> ticker. I enter that ticker into the first spreadsheet so I don't have to
> enter it 15 times. I've named that cell with the ticker symbol "ticker" and
> I reference all of the other sheets to that. When I try to do that for the
> this formula it throws an error. I hope that's a little more clear my
> apologies for being vague.
>
Tidak ada komentar:
Posting Komentar