Messages In This Digest (18 Messages)

1a.: Re: smfPrice by and between From: Kermit W. Prather
1b.: Re: smfPrice by and between From: Randy Harmelink
1c.: Re: smfPrice by and between From: antonvanas1989
1d.: Re: smfPrice by and between From: Mike McQuaid
1e.: Re: smfPrice by and between From: antonvanas1989
1f.: Re: smfPrice by and between From: Mike McQuaid
1g.: Re: smfPrice by and between From: antonvanas1989
1h.: Re: smfPrice by and between From: Randy Harmelink
1i.: Re: smfPrice by and between From: antonvanas1989
1j.: Re: smfPrice by and between From: Randy Harmelink
1k.: Re: smfPrice by and between From: Mike McQuaid
1l.: Re: smfPrice by and between From: antonvanas1989
1m.: Re: smfPrice by and between From: Mike McQuaid

2a.: Re: Yearly Close From: ronmac17

3a.: Making element definitions generic with possibly unique URLs From: curls07
3b.: Re: Making element definitions generic with possibly unique URLs From: Randy Harmelink

4a.: Google Finance Stock Screener From: mattmadakshare
4b.: Re: Google Finance Stock Screener From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.: Re: smfPrice by and between

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Mon Jan 9, 2012 6:54 am (PST)

Randy are you certain Yahoo prices are adjusted for dividends? I don't think they are.

I check the yahoo price history for AGNC in 2008 & 2009 with my Worden Stockfinder and the prices agree they do not appear to be adjusted by either group.

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Sunday, January 08, 2012 1:12 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: smfPrice by and between

Yup. Whether a dividend or a split, they have adjusted closing prices for all history, so that it will be compatible with all prices forward. Until the next dividend or split, the closing prices and adjusted closing prices for any given date will match.

It's one reason you can't keep adding current data to previously retrieved historical data, unless you adjust the historical data yourself. I used to do that -- it was a real pain.
On Sun, Jan 8, 2012 at 9:55 AM, antonvanas1989 <antonvanas1989@yahoo.com> wrote:
Oke, How Yahoo handle's an 3-1 split then?

I assume that after the split the past data divided by 3?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1b.: Re: smfPrice by and between

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

Mon Jan 9, 2012 9:21 am (PST)

Yahoo has the normal prices, but also has an adjusted closing price. The
functions mentioned here use that adjusted closing price to adjust all of
the prices.

http://finance.yahoo.com/q/hp?s=AGNC&a=04&b=15&c=2008&d=00&e=9&f=2012&g=m

On Mon, Jan 9, 2012 at 7:54 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> Randy are you certain Yahoo prices are adjusted for dividends? I don't
> think they are. ****
>
> ** **
>
> I check the yahoo price history for AGNC in 2008 & 2009 with my Worden
> Stockfinder and the prices agree they do not appear to be adjusted by
> either group. ****
>
> ** **
>
> Kermit
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1c.: Re: smfPrice by and between

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

Mon Jan 9, 2012 10:00 am (PST)

The adjusteds works indeed.

I'm trying historicals now but walks to a little problem.
i have the date in one cell (mm-dd-yy) and for the formula i need to put in this dates separate.

=RCHGetYahooHistory( Ticker, [Start Year], [Start Month], [Start Day],

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Yahoo has the normal prices, but also has an adjusted closing price. The
> functions mentioned here use that adjusted closing price to adjust all of
> the prices.
>
> http://finance.yahoo.com/q/hp?s=AGNC&a=04&b=15&c=2008&d=00&e=9&f=2012&g=m
>
> On Mon, Jan 9, 2012 at 7:54 AM, Kermit W. Prather
> <kermitp@...>wrote:
>
> >
> > Randy are you certain Yahoo prices are adjusted for dividends? I donâ€™t
> > think they are. ****
> >
> > ** **
> >
> > I check the yahoo price history for AGNC in 2008 & 2009 with my Worden
> > Stockfinder and the prices agree they do not appear to be adjusted by
> > either group. ****
> >
> > ** **
> >
> > Kermit
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1d.: Re: smfPrice by and between

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Mon Jan 9, 2012 10:05 am (PST)

if cell A1 is start date

(Ticker,year(a1),month(a1),day(a1))

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of antonvanas1989
Sent: Monday, January 09, 2012 1:00 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: smfPrice by and between

The adjusteds works indeed.

I'm trying historicals now but walks to a little problem.
i have the date in one cell (mm-dd-yy) and for the formula i need to put in this dates separate.

=RCHGetYahooHistory( Ticker, [Start Year], [Start Month], [Start Day],

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> , Randy Harmelink <rharmelink@...> wrote:
>
> Yahoo has the normal prices, but also has an adjusted closing price. The
> functions mentioned here use that adjusted closing price to adjust all of
> the prices.
>
> http://finance.yahoo.com/q/hp?s=AGNC <http://finance.yahoo.com/q/hp?s=AGNC&a=04&b=15&c=2008&d=00&e=9&f=2012&g=m> &a=04&b=15&c=2008&d=00&e=9&f=2012&g=m
>
> On Mon, Jan 9, 2012 at 7:54 AM, Kermit W. Prather
> <kermitp@...>wrote:
>
> >
> > Randy are you certain Yahoo prices are adjusted for dividends? I donâ€™t
> > think they are. ****
> >
> > ** **
> >
> > I check the yahoo price history for AGNC in 2008 & 2009 with my Worden
> > Stockfinder and the prices agree they do not appear to be adjusted by
> > either group. ****
> >
> > ** **
> >
> > Kermit
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1e.: Re: smfPrice by and between

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

Mon Jan 9, 2012 10:46 am (PST)

=RCHGetYahooHistory(Ticker;YEAR(N3);MONTH(N3);DAY(N3);YEAR(N4);MONTH(N4);DAY(N4);;"H";0)

it aint working yet.. N3 is start date and N4 is end date

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> if cell A1 is start date
>
> (Ticker,year(a1),month(a1),day(a1))
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of antonvanas1989
> Sent: Monday, January 09, 2012 1:00 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: smfPrice by and between
>
>
>
>
> The adjusteds works indeed.
>
> I'm trying historicals now but walks to a little problem.
> i have the date in one cell (mm-dd-yy) and for the formula i need to put in this dates separate.
>
> =RCHGetYahooHistory( Ticker, [Start Year], [Start Month], [Start Day],
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> , Randy Harmelink <rharmelink@> wrote:
> >
> > Yahoo has the normal prices, but also has an adjusted closing price. The
> > functions mentioned here use that adjusted closing price to adjust all of
> > the prices.
> >
> > http://finance.yahoo.com/q/hp?s=AGNC <http://finance.yahoo.com/q/hp?s=AGNC&a=04&b=15&c=2008&d=00&e=9&f=2012&g=m> &a=04&b=15&c=2008&d=00&e=9&f=2012&g=m
> >
> > On Mon, Jan 9, 2012 at 7:54 AM, Kermit W. Prather
> > <kermitp@>wrote:
> >
> > >
> > > Randy are you certain Yahoo prices are adjusted for dividends? I donÃ¢â‚¬â„¢t
> > > think they are. ****
> > >
> > > ** **
> > >
> > > I check the yahoo price history for AGNC in 2008 & 2009 with my Worden
> > > Stockfinder and the prices agree they do not appear to be adjusted by
> > > either group. ****
> > >
> > > ** **
> > >
> > > Kermit
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1f.: Re: smfPrice by and between

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Mon Jan 9, 2012 10:55 am (PST)

I pasted yours into my spreadsheet and it worked fine

I changed ticker to a quoted symbol since I didn't have that label defined.
I also used commas as that is my custom rather than ;

Did you enter as array-formula?

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of antonvanas1989
Sent: Monday, January 09, 2012 1:46 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: smfPrice by and between

=RCHGetYahooHistory(Ticker;YEAR(N3);MONTH(N3);DAY(N3);YEAR(N4);MONTH(N4);DAY
(N4);;"H";0)

it aint working yet.. N3 is start date and N4 is end date

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Mike McQuaid" <mikemcq802@...> wrote:
>
> if cell A1 is start date
>
> (Ticker,year(a1),month(a1),day(a1))
>
> _____
>
> From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
[mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
Behalf Of antonvanas1989
> Sent: Monday, January 09, 2012 1:00 PM
> To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> Subject: [smf_addin] Re: smfPrice by and between
>
>
>
>
> The adjusteds works indeed.
>
> I'm trying historicals now but walks to a little problem.
> i have the date in one cell (mm-dd-yy) and for the formula i need to put
in this dates separate.
>
> =RCHGetYahooHistory( Ticker, [Start Year], [Start Month], [Start Day],
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com> , Randy Harmelink <rharmelink@> wrote:
> >
> > Yahoo has the normal prices, but also has an adjusted closing price. The
> > functions mentioned here use that adjusted closing price to adjust all
of
> > the prices.
> >
> > http://finance.yahoo.com/q/hp?s=AGNC
<http://finance.yahoo.com/q/hp?s=AGNC
<http://finance.yahoo.com/q/hp?s=AGNC&a=04&b=15&c=2008&d=00&e=9&f=2012&g=m>
&a=04&b=15&c=2008&d=00&e=9&f=2012&g=m> &a=04&b=15&c=2008&d=00&e=9&f=2012&g=m
> >
> > On Mon, Jan 9, 2012 at 7:54 AM, Kermit W. Prather
> > <kermitp@>wrote:
> >
> > >
> > > Randy are you certain Yahoo prices are adjusted for dividends? I
donÃ¢â‚¬â„¢t
> > > think they are. ****
> > >
> > > ** **
> > >
> > > I check the yahoo price history for AGNC in 2008 & 2009 with my Worden
> > > Stockfinder and the prices agree they do not appear to be adjusted by
> > > either group. ****
> > >
> > > ** **
> > >
> > > Kermit
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1g.: Re: smfPrice by and between

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

Mon Jan 9, 2012 11:34 am (PST)

It's works here too now but i don't get the High of the year only.

How i would get that with this formula

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> I pasted yours into my spreadsheet and it worked fine
>
> I changed ticker to a quoted symbol since I didn't have that label defined.
> I also used commas as that is my custom rather than ;
>
> Did you enter as array-formula?
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of antonvanas1989
> Sent: Monday, January 09, 2012 1:46 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: smfPrice by and between
>
>
>
>
> =RCHGetYahooHistory(Ticker;YEAR(N3);MONTH(N3);DAY(N3);YEAR(N4);MONTH(N4);DAY
> (N4);;"H";0)
>
> it aint working yet.. N3 is start date and N4 is end date
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> "Mike McQuaid" <mikemcq802@> wrote:
> >
> > if cell A1 is start date
> >
> > (Ticker,year(a1),month(a1),day(a1))
> >
> > _____
> >
> > From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
> Behalf Of antonvanas1989
> > Sent: Monday, January 09, 2012 1:00 PM
> > To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> > Subject: [smf_addin] Re: smfPrice by and between
> >
> >
> >
> >
> > The adjusteds works indeed.
> >
> > I'm trying historicals now but walks to a little problem.
> > i have the date in one cell (mm-dd-yy) and for the formula i need to put
> in this dates separate.
> >
> > =RCHGetYahooHistory( Ticker, [Start Year], [Start Month], [Start Day],
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com> , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Yahoo has the normal prices, but also has an adjusted closing price. The
> > > functions mentioned here use that adjusted closing price to adjust all
> of
> > > the prices.
> > >
> > > http://finance.yahoo.com/q/hp?s=AGNC
> <http://finance.yahoo.com/q/hp?s=AGNC
> <http://finance.yahoo.com/q/hp?s=AGNC&a=04&b=15&c=2008&d=00&e=9&f=2012&g=m>
> &a=04&b=15&c=2008&d=00&e=9&f=2012&g=m> &a=04&b=15&c=2008&d=00&e=9&f=2012&g=m
> > >
> > > On Mon, Jan 9, 2012 at 7:54 AM, Kermit W. Prather
> > > <kermitp@>wrote:
> > >
> > > >
> > > > Randy are you certain Yahoo prices are adjusted for dividends? I
> donÃ¢â‚¬â„¢t
> > > > think they are. ****
> > > >
> > > > ** **
> > > >
> > > > I check the yahoo price history for AGNC in 2008 & 2009 with my Worden
> > > > Stockfinder and the prices agree they do not appear to be adjusted by
> > > > either group. ****
> > > >
> > > > ** **
> > > >
> > > > Kermit
> > > >
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1h.: Re: smfPrice by and between

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

Mon Jan 9, 2012 11:41 am (PST)

I think you're best off retrieving the array of data and computing the high
from it.

If you're computing your own ratios, though, you've got another problem --
during that year, you may have a different number of shares. A split, a
buyback, additional shares released, etc. So you'd need to adjust the high
prices by the number of shares, on a daily basis, before creating your
ratio.

On Mon, Jan 9, 2012 at 12:34 PM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

> It's works here too now but i don't get the High of the year only.
>
> How i would get that with this formula
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1i.: Re: smfPrice by and between

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

Mon Jan 9, 2012 11:53 am (PST)

Oke you confinced me of not doing it this way its to much data to collect and to much risk to go wrong.

But it is oke to calculate other ratios where you don't need prices right?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I think you're best off retrieving the array of data and computing the high
> from it.
>
> If you're computing your own ratios, though, you've got another problem --
> during that year, you may have a different number of shares. A split, a
> buyback, additional shares released, etc. So you'd need to adjust the high
> prices by the number of shares, on a daily basis, before creating your
> ratio.
>
> On Mon, Jan 9, 2012 at 12:34 PM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > It's works here too now but i don't get the High of the year only.
> >
> > How i would get that with this formula
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1j.: Re: smfPrice by and between

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

Mon Jan 9, 2012 12:49 pm (PST)

I've not done all that many ratios myself, so I don't know all the
pitfalls. I've pretty much gone with the ratios that are already published.

On Mon, Jan 9, 2012 at 12:53 PM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

> Oke you confinced me of not doing it this way its to much data to collect
> and to much risk to go wrong.
>
> But it is oke to calculate other ratios where you don't need prices right?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1k.: Re: smfPrice by and between

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Mon Jan 9, 2012 12:56 pm (PST)

You also have issues between fiscal years and calendar.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy Harmelink
Sent: Monday, January 09, 2012 2:42 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: smfPrice by and between

I think you're best off retrieving the array of data and computing the high
from it.

If you're computing your own ratios, though, you've got another problem --
during that year, you may have a different number of shares. A split, a
buyback, additional shares released, etc. So you'd need to adjust the high
prices by the number of shares, on a daily basis, before creating your
ratio.

On Mon, Jan 9, 2012 at 12:34 PM, antonvanas1989 <antonvanas1989@yahoo.com>
wrote:

It's works here too now but i don't get the High of the year only.

How i would get that with this formula

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1l.: Re: smfPrice by and between

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

Mon Jan 9, 2012 2:15 pm (PST)

How do you mean?

What issues?

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> You also have issues between fiscal years and calendar.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of Randy Harmelink
> Sent: Monday, January 09, 2012 2:42 PM
> To: smf_addin@yahoogroups.com
> Subject: Re: [smf_addin] Re: smfPrice by and between
>
>
>
>
> I think you're best off retrieving the array of data and computing the high
> from it.
>
> If you're computing your own ratios, though, you've got another problem --
> during that year, you may have a different number of shares. A split, a
> buyback, additional shares released, etc. So you'd need to adjust the high
> prices by the number of shares, on a daily basis, before creating your
> ratio.
>
>
>
> On Mon, Jan 9, 2012 at 12:34 PM, antonvanas1989 <antonvanas1989@...>
> wrote:
>
>
> It's works here too now but i don't get the High of the year only.
>
> How i would get that with this formula
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
1m.: Re: smfPrice by and between

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Mon Jan 9, 2012 2:18 pm (PST)

Simply that earnings, sales, and such are reported for fiscal years.

If you want to calculate ratios you should use prices which align with the
fiscal periods.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of antonvanas1989
Sent: Monday, January 09, 2012 5:15 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: smfPrice by and between

How do you mean?

What issues?

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Mike McQuaid" <mikemcq802@...> wrote:
>
> You also have issues between fiscal years and calendar.
>
> _____
>
> From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
[mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
Behalf
> Of Randy Harmelink
> Sent: Monday, January 09, 2012 2:42 PM
> To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> Subject: Re: [smf_addin] Re: smfPrice by and between
>
>
>
>
> I think you're best off retrieving the array of data and computing the
high
> from it.
>
> If you're computing your own ratios, though, you've got another problem --
> during that year, you may have a different number of shares. A split, a
> buyback, additional shares released, etc. So you'd need to adjust the high
> prices by the number of shares, on a daily basis, before creating your
> ratio.
>
>
>
> On Mon, Jan 9, 2012 at 12:34 PM, antonvanas1989 <antonvanas1989@...>
> wrote:
>
>
> It's works here too now but i don't get the High of the year only.
>
> How i would get that with this formula
>

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

2a.: Re: Yearly Close

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

Mon Jan 9, 2012 7:09 am (PST)

Thanks Randy EOMONTH() does it.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Year is not an option provided by Yahoo for their historical quotes.
>
> You can use the smfPricesByDates() function and provide it year-end dates
> -- easy to create using the EOMONTH() function.
>
> On Sun, Jan 8, 2012 at 3:36 PM, ronmac17 <ronmac17@...> wrote:
>
> > I put "y" in the period input to get the yearly close for the 30 DJI
> > stocks. It doesn't seem to work now. I thought the period input took
> > d,w,m,and y. Is there another way get the yearly close as an array?
> >
>

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

3a.: Making element definitions generic with possibly unique URLs

Posted by: "curls07" agc11d@gmail.com curls07

Mon Jan 9, 2012 8:45 pm (PST)

Hey Guys,

I've been working on some research analyzing Chinese companies IPOs traded on the NASDAQ and NYSE. I've been trying to collect information from about the circumstances in which they went public.

I am trying to collect information from EDGAR OnlineIpo like share price, number of shares outstanding, offer amount etc. I have written these elements to grab the information from the page. I am having trouble making the elements 'generic' so that I can input any ticker and get the corresponding information because it seems that each URL is unique.

Does anyone have any ideas to get around this?

Thanks in advance.

Here's an example of the page I am trying to pull information form;

http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E

Here are the current element formulas I'm using:

19564;Evaluate;ipo share price;=RCHGetTableCell("http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E",1,"Share Price :");;;;;;;;;0
19565;Evaluate;ipo Shares Offered;=RCHGetTableCell("http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E",1,"Shares Offered");;;;;;;;;0
19566;Evaluate;ipo Offer Amount ;=RCHGetTableCell("http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E",1,"Offer Amount");;;;;;;;;0
19567;Evaluate;ipo Shares Outstanding ;=RCHGetTableCell("http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E",1,"Shares Outstanding ");;;;;;;;;0

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.: Re: Making element definitions generic with possibly unique URLs

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

Mon Jan 9, 2012 8:48 pm (PST)

Place a "~~~~~" string in your URL for the ticker symbol. The ticker symbol
you pass to the function will replace those give tildas. However, that is
the only substitution that can occur.

On Mon, Jan 9, 2012 at 9:45 PM, curls07 <agc11d@gmail.com> wrote:

>
> I've been working on some research analyzing Chinese companies IPOs traded
> on the NASDAQ and NYSE. I've been trying to collect information from about
> the circumstances in which they went public.
>
> I am trying to collect information from EDGAR OnlineIpo like share price,
> number of shares outstanding, offer amount etc. I have written these
> elements to grab the information from the page. I am having trouble making
> the elements 'generic' so that I can input any ticker and get the
> corresponding information because it seems that each URL is unique.
>
> Does anyone have any ideas to get around this?
>
> Thanks in advance.
>
> Here's an example of the page I am trying to pull information form;
>
>
> http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E
>
> Here are the current element formulas I'm using:
>
> 19564;Evaluate;ipo share price;=RCHGetTableCell("
> http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E",1,"Share
> Price :");;;;;;;;;0
> 19565;Evaluate;ipo Shares Offered;=RCHGetTableCell("
> http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E",1,"Shares
> Offered");;;;;;;;;0
> 19566;Evaluate;ipo Offer Amount ;=RCHGetTableCell("
> http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E",1,"Offer
> Amount");;;;;;;;;0
> 19567;Evaluate;ipo Shares Outstanding ;=RCHGetTableCell("
> http://ipoportal.edgar-online.com/ipo/displayFundamentals.asp?cikid=785256&fnid=65660&IPO=1&coname=YOUKU+INC%2E",1,"Shares
> Outstanding ");;;;;;;;;0
>

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

4a.: Google Finance Stock Screener

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

Mon Jan 9, 2012 8:47 pm (PST)

How can I download Google Finance stock Screener to excel??

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.: Re: Google Finance Stock Screener

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

Mon Jan 9, 2012 8:50 pm (PST)

I don't think the add-in can do it. The screening parameters aren't in the
URL, so there is no bookmarkable web page for the add-in to extract the
data from.

Can you use FinViz instead (see "Links" area of group)?

On Mon, Jan 9, 2012 at 9:39 PM, mattmadakshare <mattmadakshare@yahoo.com>wrote:

> How can I download Google Finance stock Screener to excel??
>

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

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

Selasa, 10 Januari 2012

Messages In This Digest (18 Messages)

Messages

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Mon Jan 9, 2012 6:54 am (PST)

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

Mon Jan 9, 2012 9:21 am (PST)

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

Mon Jan 9, 2012 10:00 am (PST)

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Mon Jan 9, 2012 10:05 am (PST)

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

Mon Jan 9, 2012 10:46 am (PST)

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Mon Jan 9, 2012 10:55 am (PST)

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

Mon Jan 9, 2012 11:34 am (PST)

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

Mon Jan 9, 2012 11:41 am (PST)

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

Mon Jan 9, 2012 11:53 am (PST)

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

Mon Jan 9, 2012 12:49 pm (PST)

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Mon Jan 9, 2012 12:56 pm (PST)

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

Mon Jan 9, 2012 2:15 pm (PST)

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Mon Jan 9, 2012 2:18 pm (PST)

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

Mon Jan 9, 2012 7:09 am (PST)

Posted by: "curls07" agc11d@gmail.com curls07

Mon Jan 9, 2012 8:45 pm (PST)

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

Mon Jan 9, 2012 8:48 pm (PST)

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

Mon Jan 9, 2012 8:47 pm (PST)

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

Mon Jan 9, 2012 8:50 pm (PST)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me