2 New Messages
Digest #2591
Messages
Sat Apr 20, 2013 10:44 am (PDT) . Posted by:
"sewuzy" sewuzy
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.
Thanks a lot.
Seth
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Not sure what you mean by "more simple way"? Maybe:
>
> =RCHGetYahooHistory("MMM",2013,4,1,2013,4,1,"d","v",0)
>
> On Fri, Apr 19, 2013 at 5:36 PM, sewuzy <sewuzy@...> wrote:
>
> > Hi Randy, or anyone who might know,
> >
> > From Yahoo History, you showed us that we can get table data as by
> >
> > =RCHGetYahooHistory("MMM",2013,1,1,2013,4,1,d,"AV",1,1,)
> >
> > Is there a more simple way just to retrieve a symbol's last closing volume
> > as of any date?
> >
>
=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.
Thanks a lot.
Seth
--- In smf_addin@yahoogrou
>
> Not sure what you mean by "more simple way"? Maybe:
>
> =RCHGetYahooHistory
>
> On Fri, Apr 19, 2013 at 5:36 PM, sewuzy <sewuzy@.
>
> > Hi Randy, or anyone who might know,
> >
> > From Yahoo History, you showed us that we can get table data as by
> >
> > =RCHGetYahooHistory
> >
> > Is there a more simple way just to retrieve a symbol's last closing volume
> > as of any date?
> >
>
Sat Apr 20, 2013 1:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
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@gmail.com > 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.
>
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@gmail.
> 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.
>
Tidak ada komentar:
Posting Komentar