ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

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 

      12 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 

      2 years ago

      I had been using this and it's great.

    • profile image


      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


      7 years ago from Sri Lanka

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

    • profile image

      james moylan 

      7 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


      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


      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


      8 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 

      8 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


      8 years ago

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

    • Hello, hello, profile image

      Hello, hello, 

      8 years ago from London, UK

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

    • msorensson profile image


      8 years ago

      Wow, definitely helpful!! Thanks!!


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)