Downloading stock data for Sesame

Step 1: Finding the stock

As a first step the page of the stock has to be located on Yahoo! Finance.

Search for either:

  • a specific stock (Step 1a)
  • stocks, which comply with specific criteria (Step 1b).

(Data can be downloaded from a website, similar to the one shown on the Figure below.)

Page of Google Inc. stock within Yahoo! Finance (you can download data from here)
Page of Google Inc. stock within Yahoo! Finance (you can download data from here)

 

Step 1a: Searching a Specific stock Using Names

A specific stock can be searched and located based on its name or abbreviation (ticker).

 

  1. Visit the Finance.Yahoo.com site!
  2. Enter the name or ticker of the requested stock in the search box! (e.g: Google Inc., or GOOG)
    Searching for stocks by name
    Searching for stocks by name


  3. Click on the requested stock in the search results field! The page of the stock is displayed.

  4. Continue with downloading data.

Step 1b: Searching stocks Using the Stock Screener

Stocks can be searched according to industry, dividend yield, valuation ratios, etc.

  1. Visit the http://screener.finance.yahoo.com/stocks.html site!
  2. Set the appropriate search criteria (e.g. set Industry: “Wireless Communication (Technology)” if you are searching for AT&T stock, but you can specify any other search criteria as you like), then click the “Find Stocks” button.

    Searching with Yahoo! Finance stock screener
    Searching with Yahoo! Finance stock screener
  3. Stocks that fulfill the set criteria are displayed. Select the one of interest, in the example “AT&T”. (To select multiple stocks, for example to contrast them, then these steps need to be repeated for each stock separately.)

    Search results of stock screener
    Search results of stock screener
  4. Click on “Quotes” in the line of the selected stock. The page of the stock is displayed.
  5. Continue with downloading data.

Step 1c: stock is Not Found

Some European stocks can only be located on Yahoo! Finance UK. Try searching Yahoo! Finance UK using the name of the stock.

verifying if the right stock's data is going to be downloaded

Step 2.2: Data Downloader page

From the Yahoo Finance website, price of shares, as well as dividend information of a stock can be downloaded. To perform analysis using the Chartoasis Sesame application, price data is essential.

 

On the page of the stock click on ?Historical Prices?.

Selecting Historical Prices to download data

A page similar to the one shown is displayed:

It is practical to Bookmark the page for future use. Whenever up-to-date information is required on the stock, it can easily be accessed from the bookmarks.

historical prices page of a stock on Yahoo! Finance

Step 2.3: Downloading Price Data

Setting up price data download

 

  1. By default you do not have to modify any settings
    • Leave the radio-button on the top of the page set to “Daily“.
    • Modify dates only if the widest possible time range is not suitable for you.
  2. On the bottom of the page click “Download to Spreadsheet“. Save the data file to your computer.

data download link

For saving data note the following:

  • The file must be saved in .csv format. (Keep file extension!)
  • The browser will offer the “table.csv” filename as default. Rename the file describing its contents, or the name of the respective index.
  • Depending on the given computer settings, it is possible, that instead of downloading, the index data file is automatically opened in MS Excel, or Open Office. In this case do not save the file from Excel or Open Office as .csv (the original file format is changed, when doing so). —

To avoid opening .csv files with other software, right-click the “Download to Spreadsheet” URL, and:

  • In Internet Explorer select “Save target as…”

save as in internet explorer

  • In Firefox select “Save link As…”

save as in firefox

  • In Google Chrome select “Save link As…”

save as in google chrome

Step 2.4: Downloading Dividend Data (Optional)

Dividend data is not absolutely necessary for analysis. (Chartoasis Sesame uses a data set for calculations that is adjusted according to dividends.)

setting up dividend-download

  1. Set the radio-button on top of the Historical Prices” page to “Dividends only“.
  2. Click “Get Prices“.
  3. Click “Download to Spreadsheet” on the bottom of the page.
  4. Save the data file on the computer.

Step 3: Data Downloaded: What’s next?

To start analysis:

 

  1. Visit the Chartoasis Sesame site (www.chartoasis.com/sesameSelecting Historical Prices to download data)!
  2. Load index data file using the button shown on the image below.

button for loading .csv file

If dividend data was also downloaded, use this same button to load the data file.