Yahoo financial data receiver program

6 Yahoo financial data receiver program

To create an organized presentation of the date in Excel, we need to perform the following steps in the Yahoo historical data receiver program:

1. 
   Select the starting date of the historical data you like to receive.
   
2. 
   Select the end date of the historical data you like to receive. If the interval between these data is not available in Yahoo, then it will take the largest interval of the target company which is available in Yahoo.
   
3. 
   Over here we can fill in our target company, we can also use the drop-down list box to select a predefined target company.
   
4. 
   Once the data and company are filled-in we can go to the next screen by pushing the “Next” button. While doing this there will be a check if there really is a target company selected and if the end date isn’t smaller then the starting date.
   

5. 
   It is now time to select the peer group. We can type each peer group manually in the textbox or we can select one from the drop-down box (6).
   

7. 
   The peer group can now be added to the list, we can do this by pressing the “Add data” button. If we aren’t satisfied with the added peer group we can always remove it with the “Remove Data” button (9).
   
8. 
   In this list we can see the whole peer group and the up most one is the target company itself.
   

10. 
    If we decide to use another company we can always go back to the previous page by selecting the “Back” button.
    
11. 
    When everything is filled in correctly it is time to create the list in excel by pushing the “Make list” button
    

Once the list is constructed, there will be a clear presentation of the daily share price and dividend of the selected companies. The third part of the project is done in Matlab, hence there is also a sheet “Matlab data” where you can copy paste the requested data directly into Matlab (see Figure 43).