Messages In This Digest (10 Messages)
- 1a.
- RCHGetYahooHistory From: Jacob Jose
- 1b.
- Re: RCHGetYahooHistory From: Randy Harmelink
- 1c.
- Re: RCHGetYahooHistory From: Jacob Jose
- 1d.
- Re: RCHGetYahooHistory From: Randy Harmelink
- 1e.
- Re: RCHGetYahooHistory, MA slope From: Jacob Jose
- 1f.
- Re: RCHGetYahooHistory, MA slope From: Randy Harmelink
- 2a.
- Reuters.com last quote From: yogimodak
- 2b.
- Re: Reuters.com last quote From: Randy Harmelink
- 3a.
- am having trouble retreiving IBD data From: investor952
- 3b.
- Re: am having trouble retreiving IBD data From: Randy Harmelink
Messages
- 1a.
-
RCHGetYahooHistory
Posted by: "Jacob Jose" pepecan47@yahoo.ca pepecan47
Sun Jun 12, 2011 11:08 am (PDT)
I am using for the 50 days MA
=AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,1))
but the results are a bit differents than the ones prvided by Yahoo
=RCHGetYahooQuotes(A3,"m3")
What is the difference between?
Data Items:
"C" = Closing price for the period
and
"A" = Adjusted closing price for the period
When one should use?
Adjust = A binary value to indicate whether data should be adjusted or not;
optional; defaults to 0.
0 = Do not adjust data; returns the raw data as returned from Yahoo!
1 = Adjust O/H/L/C prices based on the value of the Adjusted Close and Close
amounts returned from Yahoo!
Maybe I should use "A" instead of "C" for Data Items? or combined with the
Adjust parameter?
Regards,
Jose L. Jacob - 1b.
-
Re: RCHGetYahooHistory
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jun 12, 2011 11:50 am (PDT)
The value provided by "m3" is a 50-day moving average based on calendar
days, not trading days. Why Yahoo calculates it based on calendar days is
beyond me.
I would ALWAYS use adjusted prices when doing technical analysis. You don't
want a dividend event to create a technical signal.
On Sun, Jun 12, 2011 at 11:08 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> I am using for the 50 days MA
> =AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,1))
>
> but the results are a bit differents than the ones prvided by Yahoo
> =RCHGetYahooQuotes(A3,"m3")
>
> What is the difference between?
> *Data Items*:
> "C" = Closing price for the period
> and
> "A" = Adjusted closing price for the period
> When one should use?
>
> *Adjust* = A binary value to indicate whether data should be adjusted or
> not; optional; defaults to 0.
>
> 0 = Do not adjust data; returns the raw data as returned from Yahoo!
> 1 = Adjust O/H/L/C prices based on the value of the Adjusted Close and
> Close amounts returned from Yahoo!
> Maybe I should use "A" instead of "C" for Data Items? or combined with the
> Adjust parameter?
>
>
- 1c.
-
Re: RCHGetYahooHistory
Posted by: "Jacob Jose" pepecan47@yahoo.ca pepecan47
Sun Jun 12, 2011 1:58 pm (PDT)
Hi Randy, in this case, is the formula for the 50 days MA ok?
=AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,1))
or should I use
=AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"A",0,1, ,50,1))
Regards,
Jose L. Jacob
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sun, June 12, 2011 2:50:29 PM
Subject: Re: [smf_addin] RCHGetYahooHistory
The value provided by "m3" is a 50-day moving average based on calendar days,
not trading days. Why Yahoo calculates it based on calendar days is beyond me.
I would ALWAYS use adjusted prices when doing technical analysis. You don't want
a dividend event to create a technical signal.
On Sun, Jun 12, 2011 at 11:08 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
>I am using for the 50 days MA
> =AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,1))
>
>but the results are a bit differents than the ones prvided by Yahoo
>=RCHGetYahooQuotes(A3,"m3")
>
>What is the difference between?
> Data Items:
>"C" = Closing price for the period
> and
>"A" = Adjusted closing price for the period
>
>When one should use?
>
>Adjust = A binary value to indicate whether data should be adjusted or not;
>optional; defaults to 0.
>
>
> 0 = Do not adjust data; returns the raw data as returned from Yahoo!
> 1 = Adjust O/H/L/C prices based on the value of the Adjusted Close and Close
>amounts returned from Yahoo!
>
>
>Maybe I should use "A" instead of "C" for Data Items? or combined with the
>Adjust parameter?
>
- 1d.
-
Re: RCHGetYahooHistory
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jun 12, 2011 3:10 pm (PDT)
Both formulas should give you the same result. However, I would go with the
second formula -- it should be just slightly faster, because the adjusted
closing price is used directly instead of adjusting fifty raw closing
prices.
Also, you could just go with:
=AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"A",0,,, 50,1))
...since the "adjust" parameter isn't needed when you're already using the
adjusted closing price. The processing is exactly the same, whether you give
it the "adjust" parameter or not.
On Sun, Jun 12, 2011 at 1:57 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> Hi Randy, in this case, is the formula for the 50 days MA ok?
>
> =AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,1))
>
> or should I use
>
> =AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"A",0,1, ,50,1))
>
>
- 1e.
-
Re: RCHGetYahooHistory, MA slope
Posted by: "Jacob Jose" pepecan47@yahoo.ca pepecan47
Sun Jun 12, 2011 6:26 pm (PDT)
Randy, thans a lot.. now I have this clear.
Another question: I am trying to work with the slope of the moving averages, in
order to identfy tops/bottoms.
What I need to do is to substract the current moving average to the previos
period MA.
I tried the prvious period with the formula:
=AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,2))
but it gives me the same results as
=AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,1))
Maybe I don't understand what is the meaning of the last parameter.
My question is, how can I get the MA of the previous period, i.e yesterday
Regards,
Jose L. Jacob
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sun, June 12, 2011 6:10:06 PM
Subject: Re: [smf_addin] RCHGetYahooHistory
Both formulas should give you the same result. However, I would go with the
second formula -- it should be just slightly faster, because the adjusted
closing price is used directly instead of adjusting fifty raw closing prices.
Also, you could just go with:
=AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"A",0,,, 50,1))
...since the "adjust" parameter isn't needed when you're already using the
adjusted closing price. The processing is exactly the same, whether you give it
the "adjust" parameter or not.
On Sun, Jun 12, 2011 at 1:57 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
>Hi Randy, in this case, is the formula for the 50 days MA ok?
>
> =AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,1))
> or should I use
>=AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"A",0,1, ,50,1))
>
- 1f.
-
Re: RCHGetYahooHistory, MA slope
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jun 12, 2011 6:42 pm (PDT)
The last two parameters are telling the function how many rows and columns
of data to return. Since all you've asked for is a single data item, the
second column will be filled with blanks. An average of 100 items, where 50
are blanks, would give you the same result as an average of only the
original 50 items.
You'd need to pass the date parameters to get the previous 50 days of data.
For example, hard-coding it could be:
=AVERAGE(RCHGetYahooHistory( $A$3,2011, 1,1,2011, 6,9,,"C", 0,1,,50,1) )
The "2011,1,1" are just arbitrary values I chose to use -- as long as it is
more than 50 trading days ago, everything would work fine.
However, if you're doing a lot of this kind of thing, you'd be better off
just retrieving the array of data yourself and extracting it from there.
Otherwise, you're doing a new Internet access of each invocation of the
RCHGetYahooHistory() function.
On Sun, Jun 12, 2011 at 6:25 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
> Another question: I am trying to work with the slope of the moving
> averages, in order to identfy tops/bottoms.
>
> What I need to do is to substract the current moving average to the previos
> period MA.
>
> I tried the prvious period with the formula:
> =AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,2))
>
> but it gives me the same results as
> =AVERAGE(RCHGetYahooHistory( A3,,,,,,, ,"C",0,1, ,50,1))
>
> Maybe I don't understand what is the meaning of the last parameter.
>
> My question is, how can I get the MA of the previous period, i.e yesterday
>
- 2a.
-
Reuters.com last quote
Posted by: "yogimodak" ymodak@gmail.com yogimodak
Sun Jun 12, 2011 9:19 pm (PDT)
Randy,
A few weeks back you had guided me to an RCH Get Table spreadsheet for reuters fundamental data from the analyst page on reuters.com. I am working with it and making some progress so thanks for sending that along.
I had a few followup questions.
How can I get the last quote for a stock from reuters.com? Is there a simple way?
Also the Consensus Estimate Trend and Revision Summary section of the spreadsheet is not working. Any simple fix?
Thanks, Rgds, Yogi
- 2b.
-
Re: Reuters.com last quote
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 13, 2011 12:12 am (PDT)
This appears to get the last quote:
=0+smfGetTagContent("
http://www.reuters.com/finance/ stocks/overview? symbol=MMM
","span",2,"id=""headerQuote Container" "")
...although I'm a little uncomfortable with the search string and not sure
how reliable it will be over time. Also, since the data isn't presented in a
table, things might change...
I just uploaded a revised copy of the analyst workbook -- I just changed the
search string of ">Consensus Estimates Trend" to be "Consensus Estimates
Trend". Apparently they changed the web page.
On Sun, Jun 12, 2011 at 9:19 PM, yogimodak <ymodak@gmail.com > wrote:
>
> How can I get the last quote for a stock from reuters.com? Is there a
> simple way?
>
> Also the Consensus Estimate Trend and Revision Summary section of the
> spreadsheet is not working. Any simple fix?
>
- 3a.
-
am having trouble retreiving IBD data
Posted by: "investor952" investor952@yahoo.com investor952
Mon Jun 13, 2011 1:51 am (PDT)
Newbie here.
I was just trying to extract some IBD data using your formula's at:
http://finance.groups.yahoo. com/group/ smf_addin/ message/8607
..just replacing the d6 ticker with the cell value where the ticker is ...
and i get an error message.
hmmm...i tried to get to the website directly to look at it..and this window pops up saying you have to be registered to use it..with a paid subscription. Is that why it doesn't work? Thx.
- 3b.
-
Re: am having trouble retreiving IBD data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 13, 2011 2:33 am (PDT)
Yes, you need to be a logged-in subscriber to get to the IBD information.
On Mon, Jun 13, 2011 at 1:50 AM, investor952 <investor952@yahoo.com > wrote:
> Newbie here.
>
> I was just trying to extract some IBD data using your formula's at:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ message/8607
>
> ..just replacing the d6 ticker with the cell value where the ticker is ...
>
> and i get an error message.
>
> hmmm...i tried to get to the website directly to look at it..and this
> window pops up saying you have to be registered to use it..with a paid
> subscription. Is that why it doesn't work? Thx.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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
Tidak ada komentar:
Posting Komentar