HomeSesame analysisData downloadIndices

Downloading index data for Sesame

You can find examples of index charts made with Sesame here.

Step 1: Finding the index

As a first step the page of the index has to be located on Yahoo! Finance.
(Data can be downloaded from a website, similar to the one shown on the Figure below.)

Page of NASDAQ index within Yahoo! Finance (you can download data from here)

A specific index 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 index in the search box! (e.g: NASDAQ Composite., or IXIC)Searching for index data by name or ticker
  3. Click on the requested index in the search results field! The page of the index is displayed.
  4. Continue with downloading data.

Step 2: Download Data

Step 2.1: Verification

For accuracy, verify the name and the currency of the index.

Checking the index before downloading

Step 2.2: Data downloader page

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

Select

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 index, it can easily be accessed from the bookmarks.)

index historical data page

Step 2.3: Downloading index data file

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 3: Data Downloaded: What's next?

To start analysis:

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

button for loading .csv file


Share on: Facebook | Twitter