6 Messages
Digest #3067
Messages
Sat May 17, 2014 6:51 am (PDT) . Posted by:
jcredline
I am trying to locate a source for the 200 day Simple MA which is calculated on daily close prices to pull for a list of stocks on a daily basis.
The value returned for the RCHGetElementNumber() 978 from the Yahoo Key Statistics 200-Day Moving Average doesn't doesn't seem to match the 200 Day Simple MA when compared to other sources. Maybe it is using a different calculation and is not the Simple MA?
For example:
Using Ticker ADBE:
1.) Yahoo Key Statistics, Element 978 returns - $61.21 for the most recently ended week. Matching the Key Statistics page.
2.) Yahoo Interactive Charts returns 200 Day SMA Technical Indicator returns - $57.49 as of 05/16/2014.
3.) Google, using the chart with the Technical indicator of the 200 day Simple Moving Average on a daily basis returns - $57.49 as of 05/16/2014.
4.) StockCharts.com Moving Average (simple) 200 day returns - $57.49 as of the 05/16/2014 ending period.
I get the similar results for other Tickers I have reviewed.
I am using it for a list of Tickers and was looking for a dynamic method to populated this data field without having to pull 200 days of price history for each Ticker in my list.
Any thoughts or suggestions from the group would be welcome. I apologize if this has been covered in the past. I was unable to locate a thread on this subject.
All the best,
Chris
The value returned for the RCHGetElementNumber
For example:
Using Ticker ADBE:
1.) Yahoo Key Statistics, Element 978 returns - $61.21 for the most recently ended week. Matching the Key Statistics page.
2.) Yahoo Interactive Charts returns 200 Day SMA Technical Indicator returns - $57.49 as of 05/16/2014.
3.) Google, using the chart with the Technical indicator of the 200 day Simple Moving Average on a daily basis returns - $57.49 as of 05/16/2014.
4.) StockCharts.
I get the similar results for other Tickers I have reviewed.
I am using it for a list of Tickers and was looking for a dynamic method to populated this data field without having to pull 200 days of price history for each Ticker in my list.
Any thoughts or suggestions from the group would be welcome. I apologize if this has been covered in the past. I was unable to locate a thread on this subject.
All the best,
Chris
Sat May 17, 2014 8:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yeah. For some reason, Yahoo's 50-day and 200-day SMA are calculated based
on CALENDAR days instead of TRADING days. I have no idea why.
You can try picking it up from barcharts.com, using element #1236. See:
SMF-Template-Barchart-Technical-Indicators.xls<http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Technical-Indicators.xls>
On Sat, May 17, 2014 at 6:51 AM, miller@sun-capital.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I am trying to locate a source for the 200 day Simple MA which is
> calculated on daily close prices to pull for a list of stocks on a daily
> basis.
>
> The value returned for the RCHGetElementNumber() 978 from the Yahoo Key
> Statistics 200-Day Moving Average doesn't doesn't seem to match the 200 Day
> Simple MA when compared to other sources. Maybe it is using a different
> calculation and is not the Simple MA?
>
> For example:
>
> Using Ticker ADBE:
> 1.) Yahoo Key Statistics, Element 978 returns - $61.21 for the most
> recently ended week. Matching the Key Statistics page.
> 2.) Yahoo Interactive Charts returns 200 Day SMA Technical Indicator
> returns - $57.49 as of 05/16/2014.
> 3.) Google, using the chart with the Technical indicator of the 200 day
> Simple Moving Average on a daily basis returns - $57.49 as of 05/16/2014.
> 4.) StockCharts.com Moving Average (simple) 200 day returns - $57.49 as of
> the 05/16/2014 ending period.
>
> I get the similar results for other Tickers I have reviewed.
>
> I am using it for a list of Tickers and was looking for a dynamic method
> to populated this data field without having to pull 200 days of price
> history for each Ticker in my list.
>
> Any thoughts or suggestions from the group would be welcome. I apologize
> if this has been covered in the past. I was unable to locate a thread on
> this subject.
>
on CALENDAR days instead of TRADING days. I have no idea why.
You can try picking it up from barcharts.com, using element #1236. See:
SMF-Template-Barchart-Technical-Indicators.xls<http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Technical-Indicators.xls>
On Sat, May 17, 2014 at 6:51 AM, miller@sun-capital.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I am trying to locate a source for the 200 day Simple MA which is
> calculated on daily close prices to pull for a list of stocks on a daily
> basis.
>
> The value returned for the RCHGetElementNumber
> Statistics 200-Day Moving Average doesn't doesn't seem to match the 200 Day
> Simple MA when compared to other sources. Maybe it is using a different
> calculation and is not the Simple MA?
>
> For example:
>
> Using Ticker ADBE:
> 1.) Yahoo Key Statistics, Element 978 returns - $61.21 for the most
> recently ended week. Matching the Key Statistics page.
> 2.) Yahoo Interactive Charts returns 200 Day SMA Technical Indicator
> returns - $57.49 as of 05/16/2014.
> 3.) Google, using the chart with the Technical indicator of the 200 day
> Simple Moving Average on a daily basis returns - $57.49 as of 05/16/2014.
> 4.) StockCharts.
> the 05/16/2014 ending period.
>
> I get the similar results for other Tickers I have reviewed.
>
> I am using it for a list of Tickers and was looking for a dynamic method
> to populated this data field without having to pull 200 days of price
> history for each Ticker in my list.
>
> Any thoughts or suggestions from the group would be welcome. I apologize
> if this has been covered in the past. I was unable to locate a thread on
> this subject.
>
Sat May 17, 2014 3:01 pm (PDT) . Posted by:
jcredline
Randy,
Thanks I will give it a try.
All the best,
Chris
Thanks I will give it a try.
All the best,
Chris
Sat May 17, 2014 7:59 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I'd send you my OLD copy but it is riddled with errors.
When I brought them to Tom attention he removed me from the group.
Keep in mind he also copied this information from <http://conscious-investor.com/> http://conscious-investor.com/
which is written by Professor John Price
Personnally, in my opinion you'd be better off purchasing the product from Professor Price,
But it is rather pricey $4900. I bought it back in 2005 for a lot less when I was more of an investor than a trader. I no longer use it.
But I'll send you a zip file with all the WIT files (13 MB) but I won't answer any questions related to WIT or Conscious investor. As I haven't used either since 2008.
Send me an email to <mailto:kermitp@tampabay.rr.com> kermitp@tampabay.rr.com
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, May 17, 2014 1:18 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Wit Prospector Lite
Is there anywhere I can obtain WIT prospector? I would like the regular version and the lite version. Thank you for any help you can give me. I have tried the links given but they seem extinct .
When I brought them to Tom attention he removed me from the group.
Keep in mind he also copied this information from <http://conscious-investor.com/> http://conscious-investor.com/
which is written by Professor John Price
Personnally, in my opinion you'd be better off purchasing the product from Professor Price,
But it is rather pricey $4900. I bought it back in 2005 for a lot less when I was more of an investor than a trader. I no longer use it.
But I'll send you a zip file with all the WIT files (13 MB) but I won't answer any questions related to WIT or Conscious investor. As I haven't used either since 2008.
Send me an email to <mailto:kermitp@tampabay.rr.com> kermitp@tampabay.rr.com
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, May 17, 2014 1:18 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Wit Prospector Lite
Is there anywhere I can obtain WIT prospector? I would like the regular version and the lite version. Thank you for any help you can give me. I have tried the links given but they seem extinct .
Sat May 17, 2014 10:38 am (PDT) . Posted by:
navelhunt
Thanks, though what i wanted to refer to is the table with the daily prices of the last month at the bottom of that page. Those dont seem to be put in a table format, and i cant seem to extract the data with the RCHgettablecell, nor with smfgettagcontent. Any ideas? Thanks
Sat May 17, 2014 11:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can grab the whole table with:
=RCHGetHTMLTable("http://www.indexq.org/index/MS001.php",">Date",-1,"",1)
...or by table cell, with:
=RCHGetTableCell("http://www.indexq.org/index/MS001.php
",...column...,">Date",,,,...row...)
...where "...row..." varies from 1 to 10 and "...column..." varies from 1
to 6. Or with:
=smfGetTagContent("http://www.indexq.org/index/MS001.php
","td",...Count...,">Date")
...where "...Count..." varies from 6 to 65.
On Sat, May 17, 2014 at 10:38 AM, navelhunt@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks, though what i wanted to refer to is the table with the daily
> prices of the last month at the bottom of that page. Those dont seem to be
> put in a table format, and i cant seem to extract the data with the
> RCHgettablecell, nor with smfgettagcontent. Any ideas? Thanks
>
=RCHGetHTMLTable("http://www.indexq.org/index/MS001.php",">Date",-1,"",1)
...or by table cell, with:
=RCHGetTableCell("http://www.indexq.org/index/MS001.php
",...column...,">Date",,,,...row...)
...where "...row..." varies from 1 to 10 and "...column..." varies from 1
to 6. Or with:
=smfGetTagContent("http://www.indexq.org/index/MS001.php
","td",...Count...,">Date")
...where "...Count..." varies from 6 to 65.
On Sat, May 17, 2014 at 10:38 AM, navelhunt@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks, though what i wanted to refer to is the table with the daily
> prices of the last month at the bottom of that page. Those dont seem to be
> put in a table format, and i cant seem to extract the data with the
> RCHgettablecell, nor with smfgettagcontent. Any ideas? Thanks
>
Tidak ada komentar:
Posting Komentar