4 New Messages
Digest #2480
Messages
Thu Jan 24, 2013 8:17 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Then you'll need to retrieve the 12 monthly OHLC amounts using
RCHGetYahooHistory() and compute your own...
Just curious -- of what use are unadjusted OHLC during the year? For
example, if a stock had a 2-for-1 split mid-year, your high for the year
will no doubt be prior to the stock split, and your low for the year will
no doubt be after the stock split, and closing price of the year should be
about half the opening price of the year. That's why I never even
considered anything other than adjusted prices for smfPricesBetween().
For example, look at the unadjusted prices on FMC:
Open for 2012 = $86.24
High for 2012 = $112.89
Low for 2012 = $48.35
Close for 2012 = $58.52
Yet the stock had a total return of 37% for the year, even though the
unadjusted close is 32% less than the unadjusted open.
On Thu, Jan 24, 2013 at 8:25 PM, lexstar lexstar@yahoo.com > wrote:
> I do wanted just 1 row and 4 columns of data...
>
> I want the OHLC for the period between the 2 dates, not just the last
> month.
>
> I don't want to download the whole history each month's OHLC from the
> beginning of the period to the end.
>
> I try the SMFPricesBetween(), but that only provides me with the adjusted
> OHLC prices, which is not want. I want the "non-adjusted" OHLC.
>
> And, the RCHGetYahooQuotes() has its limitations.
>
> So, if any function that could provide me with the same thing as the
> smfPricesBetween(), but only gives me the "non-adjusted" prices, that would
> solve my problem.
>
RCHGetYahooHistory(
Just curious -- of what use are unadjusted OHLC during the year? For
example, if a stock had a 2-for-1 split mid-year, your high for the year
will no doubt be prior to the stock split, and your low for the year will
no doubt be after the stock split, and closing price of the year should be
about half the opening price of the year. That's why I never even
considered anything other than adjusted prices for smfPricesBetween(
For example, look at the unadjusted prices on FMC:
Open for 2012 = $86.24
High for 2012 = $112.89
Low for 2012 = $48.35
Close for 2012 = $58.52
Yet the stock had a total return of 37% for the year, even though the
unadjusted close is 32% less than the unadjusted open.
On Thu, Jan 24, 2013 at 8:25 PM, lexstar lexstar@yahoo.
> I do wanted just 1 row and 4 columns of data...
>
> I want the OHLC for the period between the 2 dates, not just the last
> month.
>
> I don't want to download the whole history each month's OHLC from the
> beginning of the period to the end.
>
> I try the SMFPricesBetween(
> OHLC prices, which is not want. I want the "non-adjusted&
>
> And, the RCHGetYahooQuotes(
>
> So, if any function that could provide me with the same thing as the
> smfPricesBetween(
> solve my problem.
>
Fri Jan 25, 2013 4:19 am (PST) . Posted by:
"lexstar" lexstar
You do have a point about the splits.
What I am hoping to do is to ignore the dividends so that I can see what the true movement of the stock is with just its OHLC prices.
So splits will present another problem with the way I'm thinking.
Hmm, what to do then?
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Then you'll need to retrieve the 12 monthly OHLC amounts using
> RCHGetYahooHistory() and compute your own...
>
> Just curious -- of what use are unadjusted OHLC during the year? For
> example, if a stock had a 2-for-1 split mid-year, your high for the year
> will no doubt be prior to the stock split, and your low for the year will
> no doubt be after the stock split, and closing price of the year should be
> about half the opening price of the year. That's why I never even
> considered anything other than adjusted prices for smfPricesBetween().
>
> For example, look at the unadjusted prices on FMC:
>
> Open for 2012 = $86.24
> High for 2012 = $112.89
> Low for 2012 = $48.35
> Close for 2012 = $58.52
>
> Yet the stock had a total return of 37% for the year, even though the
> unadjusted close is 32% less than the unadjusted open.
>
> On Thu, Jan 24, 2013 at 8:25 PM, lexstar wrote:
>
> > I do wanted just 1 row and 4 columns of data...
> >
> > I want the OHLC for the period between the 2 dates, not just the last
> > month.
> >
> > I don't want to download the whole history each month's OHLC from the
> > beginning of the period to the end.
> >
> > I try the SMFPricesBetween(), but that only provides me with the adjusted
> > OHLC prices, which is not want. I want the "non-adjusted" OHLC.
> >
> > And, the RCHGetYahooQuotes() has its limitations.
> >
> > So, if any function that could provide me with the same thing as the
> > smfPricesBetween(), but only gives me the "non-adjusted" prices, that would
> > solve my problem.
> >
>
What I am hoping to do is to ignore the dividends so that I can see what the true movement of the stock is with just its OHLC prices.
So splits will present another problem with the way I'm thinking.
Hmm, what to do then?
--- In smf_addin@yahoogrou
>
> Then you'll need to retrieve the 12 monthly OHLC amounts using
> RCHGetYahooHistory(
>
> Just curious -- of what use are unadjusted OHLC during the year? For
> example, if a stock had a 2-for-1 split mid-year, your high for the year
> will no doubt be prior to the stock split, and your low for the year will
> no doubt be after the stock split, and closing price of the year should be
> about half the opening price of the year. That's why I never even
> considered anything other than adjusted prices for smfPricesBetween(
>
> For example, look at the unadjusted prices on FMC:
>
> Open for 2012 = $86.24
> High for 2012 = $112.89
> Low for 2012 = $48.35
> Close for 2012 = $58.52
>
> Yet the stock had a total return of 37% for the year, even though the
> unadjusted close is 32% less than the unadjusted open.
>
> On Thu, Jan 24, 2013 at 8:25 PM, lexstar wrote:
>
> > I do wanted just 1 row and 4 columns of data...
> >
> > I want the OHLC for the period between the 2 dates, not just the last
> > month.
> >
> > I don't want to download the whole history each month's OHLC from the
> > beginning of the period to the end.
> >
> > I try the SMFPricesBetween(
> > OHLC prices, which is not want. I want the "non-adjusted&
> >
> > And, the RCHGetYahooQuotes(
> >
> > So, if any function that could provide me with the same thing as the
> > smfPricesBetween(
> > solve my problem.
> >
>
Fri Jan 25, 2013 4:33 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Dividends just do the same thing on a smaller basis. Larger on some
equities vs others. The "true movement" would include adjustments, since
you want pre- and post-dividend prices to be comparable.
Note that some of the capital gains distributions have been a large
percentage of price on some year-ends, especially for some of the leveraged
ETFs.
And a stock dividend is treated as if it were a split.
On Fri, Jan 25, 2013 at 5:19 AM, lexstar lexstar@yahoo.com > wrote:
> You do have a point about the splits.
>
> What I am hoping to do is to ignore the dividends so that I can see what
> the true movement of the stock is with just its OHLC prices.
>
> So splits will present another problem with the way I'm thinking.
>
> Hmm, what to do then?
>
equities vs others. The "true movement" would include adjustments, since
you want pre- and post-dividend prices to be comparable.
Note that some of the capital gains distributions have been a large
percentage of price on some year-ends, especially for some of the leveraged
ETFs.
And a stock dividend is treated as if it were a split.
On Fri, Jan 25, 2013 at 5:19 AM, lexstar lexstar@yahoo.
> You do have a point about the splits.
>
> What I am hoping to do is to ignore the dividends so that I can see what
> the true movement of the stock is with just its OHLC prices.
>
> So splits will present another problem with the way I'm thinking.
>
> Hmm, what to do then?
>
Fri Jan 25, 2013 5:36 am (PST) . Posted by:
"lexstar" lexstar
Hmmm, good points to consider. I appreciate your thoughts.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Dividends just do the same thing on a smaller basis. Larger on some
> equities vs others. The "true movement" would include adjustments, since
> you want pre- and post-dividend prices to be comparable.
>
> Note that some of the capital gains distributions have been a large
> percentage of price on some year-ends, especially for some of the leveraged
> ETFs.
>
> And a stock dividend is treated as if it were a split.
>
> On Fri, Jan 25, 2013 at 5:19 AM, lexstar wrote:
>
> > You do have a point about the splits.
> >
> > What I am hoping to do is to ignore the dividends so that I can see what
> > the true movement of the stock is with just its OHLC prices.
> >
> > So splits will present another problem with the way I'm thinking.
> >
> > Hmm, what to do then?
> >
>
--- In smf_addin@yahoogrou
>
> Dividends just do the same thing on a smaller basis. Larger on some
> equities vs others. The "true movement" would include adjustments, since
> you want pre- and post-dividend prices to be comparable.
>
> Note that some of the capital gains distributions have been a large
> percentage of price on some year-ends, especially for some of the leveraged
> ETFs.
>
> And a stock dividend is treated as if it were a split.
>
> On Fri, Jan 25, 2013 at 5:19 AM, lexstar wrote:
>
> > You do have a point about the splits.
> >
> > What I am hoping to do is to ignore the dividends so that I can see what
> > the true movement of the stock is with just its OHLC prices.
> >
> > So splits will present another problem with the way I'm thinking.
> >
> > Hmm, what to do then?
> >
>
Tidak ada komentar:
Posting Komentar