5 New Messages
Digest #2594
Messages
Tue Apr 23, 2013 3:19 am (PDT) . Posted by:
"navman92000" navman92000
That worked. Thanks! How did you find that symbol?
--- In smf_addin@yahoogrou
>
> Try using the Yahoo ticker symbol: AIG-WT?
>
> On Mon, Apr 22, 2013 at 12:26 PM, navman92000 <navman9@
>
> > I own some AIG warrants, ticker AIG.WS according to E-Trade. I can't get
> > quotes using the standard RCHGetYahooQuotes for that ticker symbol. Can
> > anyone help me?
> >
>
Tue Apr 23, 2013 7:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just used the symbol lookup on Yahoo.
On Tue, Apr 23, 2013 at 3:19 AM, navman92000 <navman9@comcast.net > wrote:
>
> That worked. Thanks! How did you find that symbol?
>
On Tue, Apr 23, 2013 at 3:19 AM, navman92000 <navman9@comcast.
>
> That worked. Thanks! How did you find that symbol?
>
Tue Apr 23, 2013 8:20 pm (PDT) . Posted by:
"sewuzy" sewuzy
Hi Again,
Perhaps I misread what you meant in saying that any of the parameters below could be cell references ---- in generating cumulative volume between dates:
=smfPricesBetween("MMM",DATE(2013,4,1),DATE(2013,4,1),"09")
I was unsuccessful in trying this variation (P5 being a cell with a date:
=smfPricesBetween("MMM",DATE(P5),DATE(P5),"09")
Do you merely mean that each of 2013 and 4 and 1 could be a separate cell reference?
Thanks for clarifying.
Seth
--- In smf_addin@yahoogroups.com , "sewuzy" <sewuzy@...> wrote:
>
>
>
> Thanks Randy.
>
> I was just thinking of that old book I read so many years ago, "How I Made $2,000,000 in the Stock Market", by Nicholas Darvas, while he was a cruise ship dance instructor back in the sixties when he had to wait a week or two before picking up a Barron's on a port call, and then going over all the stock data and focusing on those with large volume upticks ..... indicating insider buying on mergers / acquisitions / or large earnings gains. Of course quarterly volume data is not going to be enough, more like weekly for the last two months. Or better yet a moving average or MACD or whatever based on volume.
>
> Just a thought.
>
> Seth
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Personally, I don't see volume for a given date as being all that valuable.
> > It would never occur to me to make a special function for it.
> >
> > You could look at the smfPricesBetween() function, which could give you the
> > cumulative volume between two dates. For example:
> >
> > =smfPricesBetween("MMM",DATE(2013,4,1),DATE(2013,4,1),"09")
> >
> > And, of course, any or all of those parameters could be cell references.
> >
> > On Sat, Apr 20, 2013 at 10:44 AM, sewuzy <sewuzy@> wrote:
> >
> > > I was hoping if there might be something simple like
> > >
> > > =smfVolumesByDates("Ticker","Date")
> > >
> > > =smfVolumesByDates("MMM",Date_A)
> > >
> > > I would like to have several date headings (say 12 months ago, 9 months
> > > ago, 6 months ago, 3 months ago, Today), over the volumes for such dates
> > > for a column of Symbols.
> > >
> > > I am not that good with Excel formulas, and the problem I have with
> > > RCHGetYahooHistory, is that I think have to parse each date into three
> > > different cells (year cell, month cell, date cell), and then use string
> > > arithmetic to recombine them.
> > >
> > > Maybe we just have to use RCHGetYahooHistory for this. If so I wonder if
> > > there might be some available formula to directly pick up the date
> > > specified by some column header?
> > >
> > > Another question would be if whether the Average Volume for a stock on a
> > > particular date is somehow available somewhere. I think the Yahoo
> > > elements Average Volume is only as of Last Date, not as of any historical
> > > date.
> > >
> >
>
Perhaps I misread what you meant in saying that any of the parameters below could be cell references ---- in generating cumulative volume between dates:
=smfPricesBetween(
I was unsuccessful in trying this variation (P5 being a cell with a date:
=smfPricesBetween(
Do you merely mean that each of 2013 and 4 and 1 could be a separate cell reference?
Thanks for clarifying.
Seth
--- In smf_addin@yahoogrou
>
>
>
> Thanks Randy.
>
> I was just thinking of that old book I read so many years ago, "How I Made $2,000,000 in the Stock Market"
>
> Just a thought.
>
> Seth
>
> --- In smf_addin@yahoogrou
> >
> > Personally, I don't see volume for a given date as being all that valuable.
> > It would never occur to me to make a special function for it.
> >
> > You could look at the smfPricesBetween(
> > cumulative volume between two dates. For example:
> >
> > =smfPricesBetween(
> >
> > And, of course, any or all of those parameters could be cell references.
> >
> > On Sat, Apr 20, 2013 at 10:44 AM, sewuzy <sewuzy@> wrote:
> >
> > > I was hoping if there might be something simple like
> > >
> > > =smfVolumesByDates(
> > >
> > > =smfVolumesByDates(
> > >
> > > I would like to have several date headings (say 12 months ago, 9 months
> > > ago, 6 months ago, 3 months ago, Today), over the volumes for such dates
> > > for a column of Symbols.
> > >
> > > I am not that good with Excel formulas, and the problem I have with
> > > RCHGetYahooHistory, is that I think have to parse each date into three
> > > different cells (year cell, month cell, date cell), and then use string
> > > arithmetic to recombine them.
> > >
> > > Maybe we just have to use RCHGetYahooHistory for this. If so I wonder if
> > > there might be some available formula to directly pick up the date
> > > specified by some column header?
> > >
> > > Another question would be if whether the Average Volume for a stock on a
> > > particular date is somehow available somewhere. I think the Yahoo
> > > elements Average Volume is only as of Last Date, not as of any historical
> > > date.
> > >
> >
>
Tue Apr 23, 2013 8:27 pm (PDT) . Posted by:
"sewuzy" sewuzy
Hi Again,
Perhaps I misread what you meant in saying that any of the parameters below could be cell references ---- in generating cumulative volume between dates:
=smfPricesBetween("MMM",DATE(2013,4,1),DATE(2013,4,1),"09")
I was unsuccessful in trying this variation (P5 being a cell with a date:
=smfPricesBetween("MMM",DATE(P5),DATE(P5),"09")
Do you merely mean that each of 2013 and 4 and 1 could be a separate cell reference?
Thanks for clarifying.
Seth
Postscript
I was hoping that I could then simply use:
=(smfPricesBetween("MMM",DATE(P5),DATE(P5-90),"09"))/90
to generate a simplistic and rough average volume over last 90 days, or whatever number of days I might insert as a variable X.
=(smfPricesBetween("MMM",DATE(P5),DATE(P5-X),"09"))/X
But perhaps not.
Kindest regards,
Seth
--- In smf_addin@yahoogroups.com , "sewuzy" <sewuzy@...> wrote:
>
>
>
> Thanks Randy.
>
> I was just thinking of that old book I read so many years ago, "How I Made $2,000,000 in the Stock Market", by Nicholas Darvas, while he was a cruise ship dance instructor back in the sixties when he had to wait a week or two before picking up a Barron's on a port call, and then going over all the stock data and focusing on those with large volume upticks ..... indicating insider buying on mergers / acquisitions / or large earnings gains. Of course quarterly volume data is not going to be enough, more like weekly for the last two months. Or better yet a moving average or MACD or whatever based on volume.
>
> Just a thought.
>
> Seth
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Personally, I don't see volume for a given date as being all that valuable.
> > It would never occur to me to make a special function for it.
> >
> > You could look at the smfPricesBetween() function, which could give you the
> > cumulative volume between two dates. For example:
> >
> > =smfPricesBetween("MMM",DATE(2013,4,1),DATE(2013,4,1),"09")
> >
> > And, of course, any or all of those parameters could be cell references.
> >
> > On Sat, Apr 20, 2013 at 10:44 AM, sewuzy <sewuzy@> wrote:
> >
> > > I was hoping if there might be something simple like
> > >
> > > =smfVolumesByDates("Ticker","Date")
> > >
> > > =smfVolumesByDates("MMM",Date_A)
> > >
> > > I would like to have several date headings (say 12 months ago, 9 months
> > > ago, 6 months ago, 3 months ago, Today), over the volumes for such dates
> > > for a column of Symbols.
> > >
> > > I am not that good with Excel formulas, and the problem I have with
> > > RCHGetYahooHistory, is that I think have to parse each date into three
> > > different cells (year cell, month cell, date cell), and then use string
> > > arithmetic to recombine them.
> > >
> > > Maybe we just have to use RCHGetYahooHistory for this. If so I wonder if
> > > there might be some available formula to directly pick up the date
> > > specified by some column header?
> > >
> > > Another question would be if whether the Average Volume for a stock on a
> > > particular date is somehow available somewhere. I think the Yahoo
> > > elements Average Volume is only as of Last Date, not as of any historical
> > > date.
> > >
> >
>
Perhaps I misread what you meant in saying that any of the parameters below could be cell references ---- in generating cumulative volume between dates:
=smfPricesBetween(
I was unsuccessful in trying this variation (P5 being a cell with a date:
=smfPricesBetween(
Do you merely mean that each of 2013 and 4 and 1 could be a separate cell reference?
Thanks for clarifying.
Seth
Postscript
I was hoping that I could then simply use:
=(smfPricesBetween(
to generate a simplistic and rough average volume over last 90 days, or whatever number of days I might insert as a variable X.
=(smfPricesBetween(
But perhaps not.
Kindest regards,
Seth
--- In smf_addin@yahoogrou
>
>
>
> Thanks Randy.
>
> I was just thinking of that old book I read so many years ago, "How I Made $2,000,000 in the Stock Market"
>
> Just a thought.
>
> Seth
>
> --- In smf_addin@yahoogrou
> >
> > Personally, I don't see volume for a given date as being all that valuable.
> > It would never occur to me to make a special function for it.
> >
> > You could look at the smfPricesBetween(
> > cumulative volume between two dates. For example:
> >
> > =smfPricesBetween(
> >
> > And, of course, any or all of those parameters could be cell references.
> >
> > On Sat, Apr 20, 2013 at 10:44 AM, sewuzy <sewuzy@> wrote:
> >
> > > I was hoping if there might be something simple like
> > >
> > > =smfVolumesByDates(
> > >
> > > =smfVolumesByDates(
> > >
> > > I would like to have several date headings (say 12 months ago, 9 months
> > > ago, 6 months ago, 3 months ago, Today), over the volumes for such dates
> > > for a column of Symbols.
> > >
> > > I am not that good with Excel formulas, and the problem I have with
> > > RCHGetYahooHistory, is that I think have to parse each date into three
> > > different cells (year cell, month cell, date cell), and then use string
> > > arithmetic to recombine them.
> > >
> > > Maybe we just have to use RCHGetYahooHistory for this. If so I wonder if
> > > there might be some available formula to directly pick up the date
> > > specified by some column header?
> > >
> > > Another question would be if whether the Average Volume for a stock on a
> > > particular date is somehow available somewhere. I think the Yahoo
> > > elements Average Volume is only as of Last Date, not as of any historical
> > > date.
> > >
> >
>
Tue Apr 23, 2013 8:35 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What I would usually do is:
=smfPricesBetween(A2,B2,C2,"09")
...where cell A2 contains the ticker symbol, cell B2 contains the starting
date, and cell C2 contains the ending date. It would certainly be possible
to do:
=smfPricesBetween(A2,B2,B2+90,"09")
If you want to do multiple periods, it would be faster to retrieve the data
once with RCHGetYahooHistory() and then extract your volumes from that
returned range of data.
On Tue, Apr 23, 2013 at 8:20 PM, sewuzy <sewuzy@gmail.com > wrote:
>
> Perhaps I misread what you meant in saying that any of the parameters
> below could be cell references ---- in generating cumulative volume
> between dates:
>
> =smfPricesBetween("MMM",DATE(2013,4,1),DATE(2013,4,1),"09")
>
> I was unsuccessful in trying this variation (P5 being a cell with a date:
>
> =smfPricesBetween("MMM",DATE(P5),DATE(P5),"09")
>
> Do you merely mean that each of 2013 and 4 and 1 could be a separate cell
> reference?
>
=smfPricesBetween(
...where cell A2 contains the ticker symbol, cell B2 contains the starting
date, and cell C2 contains the ending date. It would certainly be possible
to do:
=smfPricesBetween(
If you want to do multiple periods, it would be faster to retrieve the data
once with RCHGetYahooHistory(
returned range of data.
On Tue, Apr 23, 2013 at 8:20 PM, sewuzy <sewuzy@gmail.
>
> Perhaps I misread what you meant in saying that any of the parameters
> below could be cell references ---- in generating cumulative volume
> between dates:
>
> =smfPricesBetween(
>
> I was unsuccessful in trying this variation (P5 being a cell with a date:
>
> =smfPricesBetween(
>
> Do you merely mean that each of 2013 and 4 and 1 could be a separate cell
> reference?
>
Tidak ada komentar:
Posting Komentar