NIKKEI Europe Home > NEEDS Home > Products & Services > NEEDS FinancialQUEST > Focus on FinancialQUEST 2.0

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 (Stock code: 6758) and Nintendo (Stock code: 7974) in 6 steps.

1. Database Selection
With FinancialQUEST, users can choose either ‘Easy Search’ or ‘Detailed Search’ and the former has series of default options to allow faster downloads. For this demonstration, the ‘Detailed Search’ will be used to show as many features of FinancialQUEST as possible. For Equity data, the ‘Stock Price and Indicators’ database has been selected under the 'Stocks and Debenture' Group.
click to enlarge

2. Company Search and Selection Process
After selecting target search preferences in ‘Target Code’ section, and stock type and market preferences in ‘Subkey’ section, you go into ‘Target’ section to select targeting companies. Users can select companies either via Group List under Group/Code tab, or search by stock codes or names (Japanese or English) under Target Search tab. Advanced users will utilise Screening & Sort to list up companies which meets their exact criteria.
The Group List is very useful if you want to analyse more than one company in a particular industry, just double click the industry you want and all the companies in that group list is added. Here we are only analysing two companies and they are added to the ‘Adopt’ menu along the bottom.
click to enlarge

3. Database Item Selection
After selecting the targets, the next step is to choose which attributes/items to download. Using the ‘Group List’ menu on the left hand side, you can look for items in 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 (‘Selection List’) to choose specific items in this group (similarly to the company selection, you can double click the group list to select all the items in the group). The following items are selected, i) Close Price, ii) Ask price, iii) Last Bid Price and iii) Trading Volume, which then appear along the bottom window.
click to enlarge

4. Defining the Time Period to Download
Setting the output time period is the next step. 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

5. Control the Layout of the Download
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

6. Easy Export to MS Excel
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 want to update this data every month, you do not need to repeat the search again, simply ‘drag and drop’ 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) 2019 Nikkei Inc., Nikkei Europe Ltd. All Rights Reserved.