ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Personal Finance»
  • Investing in Stocks, Bonds, Real Estate, More»
  • Stocks

Basic Technical Analysis – Stocks Trading Basics- Get Free Stock Data from Yahoo Using Excel

Updated on August 3, 2014

New To Stock Trading

If you are new to stock trading, the first thing you will hear of in your stocks trading basics is probably stocks technical analysis. A stock technical analysis is a method of evaluating the strength or weakness of a stock by use of the stock’s market prices, volume and open interest. By evaluating the stock’s weakness or strength, one can then extrapolate and predict the future market trend of the stock. With technical analysis, the intrinsic value of the stock is hardly considered. By use of the historical prices of the stock being analyzed, one can to a certain degree of accuracy determines the future prices of the stock.  This is usually done by plotting a chart of historical prices against time and assuming that the market psychology is actually influenced by the market prices.

Stock Technical Analysis

Stock technical analysis using stock charts was popularized by Charles H. Dow who theorized that stocks have measurable trends that are predictable in what became to be known as Dow Theory. A stock chart is usually plotted using the stock closing price on one axis and time on the other axis. Other than the closing price, the high price, low price and opening price can also be plotted against time. The time frame mostly used is the daily prices. Other time frames that are commonly used include minute prices, hourly prices, weekly prices and monthly prices.

Trend is Your Friend

Every stock analyst will usually use an arithmetic scale when analyzing stocks over a short period of less than five years and a logarithmic scale when analyzing stocks over a period of more than 5 years. The main aim of a technical analysis is to establish a trend based on the time frame that you are trading. The assumption is that a trend will continue with the same direction until it tells you otherwise. Investors therefore believe that trend is your friend and therefore they base their trades based on the current trend.

A stock can either follow an uptrend, a downtrend or a sideway trend. An uptrend is usually signified by a series of higher highs and higher lows. A downtrend is usually signified by a series of lower lows and lower highs.

Stock’s Historical Price Data

To do stocks analysis, you will need to have the stock’s historical price data. Today, there are many online sites where you can get that historical data. The best source may be from your stockbroker who may have ready plotted charts for you to download. If you already do not have a brokerage account with a stock broker, then you may not be able to get data information from them. One may need to do some paper trading before deciding to enter into stock trading in which case you will need free historical stock data.

Basic Technical Analysis

There is a good feel when you get raw stock data and you analyze it yourself rather than downloading ready plotted charts. In any case, for you to get a good understanding of the analysis you will definitely have to do the analysis by yourself and once you have a good understanding of Basic Technical Analysis, then you may opt to start using the ready made online charts.

Free Stock Data from Yahoo Finance Using Excel

The aim of this article was to explain how one can get Free Stock Data from Yahoo Finance using Excel. The easiest way is to go to Yahoo Finance Historical Data Webpage and download the data manually. All you need do is the following:

1. Input the Stock symbol of your stock

2. Set date range by inputting start date and end date

3. Input the time range of data - daily, weekly, monthly or dividends.

4. Click get prices

5. And then below the page, click ‘Download to Spreadsheet’.

And there you will have your historical data – open, high, low, close, and volume data, in an excel spreadsheet. With this data in excel, then you can do all kind of technical analysis you may think of.

Get Free Stock Data from Yahoo Using Excel Spreadsheet
Get Free Stock Data from Yahoo Using Excel Spreadsheet

Books on Basic Technical Analysis

Free Data for Multiple Stocks

The bad thing with this is that it is tedious since for stock analysis you may need to analyze the stock every day the stock trades. You may also need to analyze multiple stocks and in that case you will need a ready made excel spreadsheet that will automatically download stocks data from yahoo finance free.

To get Free Multiple Stock Data from Yahoo Using Excel, you will need to download either one or both of the following free spreadsheets.

1. Multiple Stock Data from Yahoo Using Excel – current data

2. Multiple Stock Data from Yahoo Using Excel – historical data

The credit to the two free excel spreadsheets goes to Peter Ponzo. Make sure to carefully read instructions in the worksheet named “Explain”.

If you have liked this article, and you would want this page to keep up and improved, you can help by purchasing some great items from Amazon by following Amazon links and widgets on this page. A free way to help would be to link back to this webpage from your web page, blog, or discussion forums.

The Author’s page is designed to help beginners and average readers make some money as an extra income to supplement what they may be earning elsewhere - details of which you can find in My Page, if you will.


    0 of 8192 characters used
    Post Comment

    • Denis Alaev profile image

      Denis Alaev 5 months ago

      It seems that after several changes Yahoo Finance closed their API forever. I think, it’s a part of cost cutting strategy from Verizon. The API was closed on May 15, one month ago.

      I've tested several alternatives and found that the best one for those who used Yahoo Finance. The services provides raw data, adjusted closes and splits/dividends. They also have CSV output, with very similar format for Yahoo Finance users.

    • profile image

      Harrison Delfino 23 months ago

      I had been using this and it's great.

    • profile image

      Gayathri 6 years ago

      uself one.. but at times of sideway trend volatile trend . where we have HH and LL.. how do we determine the trend for he next day.. UP or DOWN??

    • chamilj profile image

      chamilj 6 years ago from Sri Lanka

      Very helpful stock market investing tips. Thanks for sharing. Voted up!

    • profile image

      james moylan 6 years ago

      I have a web site where I give investment advise on penny stocks and stocks under five dollars. I would like to comment about technical analysis. the thing I don't get about technicial analysis is if theirs a pattern to the movement of the price of a stock than how do you account for surprise news coming out about a company that no one expects. this will affect the movement of a stock but if nobody knows about it ahead of time how can a trader plan for it. in other words the direction of the price of a stock is totally unpredictable in that case.

    • marketHEIST profile image

      marketHEIST 7 years ago from Los Angeles

      Great intro...including dow theory and the importance of the trend! For most people who have investment and trading accounts at any major online broker, there are great technical analysis tools beyond what yahoo! finance can offer. There are also a ton of other great technical analysis resources popping up all over the web! one of our favorites is

    • TradingStocks profile image

      TradingStocks 7 years ago

      Great tips here. And yes, yahoo is a very convenient way to get stock prices and charts to see the general pattern of performance over time.

    • profile image

      MakingAMillionDollars 7 years ago

      Very nice. The thing I like about Yahoo Finance is that you can get just about everything you need from the charts and analysis already on Yahoo.

    • profile image

      Vector Vest Reviews 7 years ago

      Great hub. The techniques to analyze stocks is quite informative and simple to use even for a layman in the shortest possible time.

    • profile image

      Recommendation 7 years ago

      A good over view of technical analyst. You have explained in simple terms well.

    • Hello, hello, profile image

      Hello, hello, 7 years ago from London, UK

      That is fantastic. Thank you for giving so much help and information.

    • msorensson profile image

      msorensson 7 years ago

      Wow, definitely helpful!! Thanks!!