|
| Using FinancialQUEST has never been quicker or easier. In this section you will be able to see for yourself how easy it is to download historical data on the stock price of Sony and Nintendo. Please click on the screenshots to expand them at any time.
|
For this demonstration, the detailed view will be used to show as many of the features of FinancialQUEST as possible. You will notice in the bottom left of the program there is a Easy Search and a Detailed Search button which can be clicked at any time during the download process to expand the number of options available. In Easy Search, the program has a series of default options to allow faster downloads. As we are currently searching for Equity data on Sony and Nintendo, the 'Stocks and Debenture' group of databases has been selected and then 'Stock Price and Indicators' has been selected. |
 click to enlarge |
|
After selecting to search via Stock Code or Nikkei Company code, you go into the company selection database. Here you can search for a company or companies either via the lists on the left hand side, or by selecting the Target Search tab, where you can enter the English name of the company. The Company lists are very useful if you want to analyze more than one company in a particular industry, just double click the industry you want and all companies in that list are automatically added. Here we are only analyzing two companies and they are added to the adopt menu along the bottom. |
 click to enlarge |
|
After selecting the company, the next option is to choose which attributes to download. Using the menu on the left hand side, it is possible to search for stock daily, weekly and monthly statistics, values and dividend estimation data. Here we have selected 'Daily Stock Prices'. You are then given further options in the right hand side and we have selected Closing Value, Last Ask Price, Last Bid Price and Trading Volume, all of which then appear along the bottom window. |
 click to enlarge |
|
The time period is the next option. You can specify the exact dates or even the exact interim period for your download using the detailed setting button in the top right of the window. As we are currently searching for the previous month closing values we can use the one month button. |
 click to enlarge |
|
The final screen allows you to control the layout of the final spreadsheet by rearranging the items. So for instance, should you want the date along the horizontal axis, the blue block named 'Date' can be dragged to the horizontal bar at the top. The current screen is the default setting of the program. After rearranging the layout of the database, the data is downloaded by pressing the Download button in the bottom right hand corner. |
 click to enlarge |
|
When the download has finished, it is automatically opened in the FinancialQUEST spreadsheet system. By clicking the MS Excel logo at the top of the page, your data is transferred to MS Excel. If you wanted to update this data every month, you do not need to repeat the search again, simply drag the Excel file into FinancialQUEST and it automatically performs the same search again, using the updated data on the Nikkei server. |
 click to enlarge |
|
 |
(C) 2011 Nikkei Digital Media, Inc. All rights reserved.
|
|
