In our previous article we used a simple method for importing stock quote data into Excel. Today we will look at a robust automated method for querying more data sources then just Yahoo finance. The Stock Market Functions Add-in for Excel is a free tool developed by by Randy Harmelink. The stock market functions Add-In allows you to import data from sites like Yahoo, Business Week, Reuters, Google, Bloomberg, MSN and many more. In the latest release there are beta features for several technical analysis functions like
- Accumulation Distribution Line
- Average True Range
- Commodity Channel Index
- Simple Moving Average
- Moving Average Convergence Divergence
- Exponential Moving Average
Popularity: 100% [?]
