Note that the 50-day and 200-day moving averages you get from Yahoo are not normal ones. Yahoo bases their data on calendar days instead of trading days.
FinViz also has a nice export tool. Here is a link to export their technical indicators for MMM and IBM:
http://finviz.
I use my add-in to grab both the Yahoo and FinViz data via user-defined functions in EXCEL. For example:
=smfGetCSVFile("http://finviz.
=RCHGetYahooQuotes("MMM,IBM","sl1p2",,,1)
Produce:
| No. | Ticker | Beta | Average True Range | 20-Day Simple Moving Average | 50-Day Simple Moving Average | 200-Day Simple Moving Average | 52-Week High | 52-Week Low | Relative Strength Index (14) | Price | Change | Change from Open | Gap | Volume |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | IBM | 0.80 | 1.46 | 1.60% | 3.49% | 15.78% | -0.04% | 66.32% | 63.35 | $129.93 | $0.0099 | $0.0040 | $0.0059 | 5533656 |
| 2 | MMM | 0.78 | 1.27 | 3.34% | 6.09% | 25.34% | -1.28% | 105.10% | 61.49 | $81.96 | $0.0065 | $0.0013 | $0.0052 | 1843864 |
| Symbol | Last Trade | Percent Change |
|---|---|---|
| MMM | $81.96 | 0.65% |
| IBM | $129.93 | 0.99% |
The add-in is here:
http://finance.
Some option-related worksheets using it can be found in the files area of this group:
http://finance.
On Mon, Dec 21, 2009 at 8:42 AM, joe & leigh <gass20@aol.com> wrote:
i posted a file before yahoo quotes...a spreadsheet that allows you to download not only quotes by many other variables like moving averages and fundamental data......scroll spreadsheet to the left to identify the yahoo tags...drjoe
__._,_.___
MARKETPLACE
.
__,_._,___
No comments:
Post a Comment