Stock data is extracted from an API via R. The data is then used for a valuation model in Excel.
 

The model in the template is only for illustrative purposes but not the actual model.
 

User guide: You will need software R or R studio to open the R script. You can modify the stock code on line 22, data period start date on line 23, data period end date on line 24 to get the data you need. You also have to update the file export location on line 33.
 

Once you run the script, the data will be loaded in an Excel file and the Excel file will open automatically.
 

The Excel file is an example of the output data and the valuation model. The example stock is HSBC listed in Hong Kong.