Follow the steps mentioned below to access financial data using Excel Connect in Excel Sheets:


1. In the Data Downloader section, select Trendlyne-Excel Connect and click on DOWNLOAD EXCEL.



2. Open the downloaded Excel file from the Downloads folder. If a pop-up message appears stating that "Microsoft has blocked macros from running because the source of this file is untrusted," follow these steps:



 A). Go to the Downloads folder and locate the Excel Connect Master file.




B). Right-click the file, and select Properties. In the General section, check the box next to Unblock under Security, then click Apply.




C). Now, reopen the Excel file and click Enable Content to access the Excel Connect Master sheet.




3. Copy the token from the website and paste it into the highlighted cell of the Excel sheet.




4. Click on Validate Token & Fetch Stocks Master List to run the script. The script will run and populate the “Stock Master List” sheet with all listed stocks.



5. You can view the list of the latest stocks available, as highlighted in the image. Please don’t edit/ delete any of the cells present in this sheet.




6. Search for the stock in the dropdown menu in cell G5 for which you need to fetch financial data.



7. Click on Fetch Financials in cell B7 to retrieve the latest financial data for the selected stock.




8. You can see the status of financials data fetch in the highlighted cells.




9. You can visit any of the highlighted sheets to see the financial data.


Quarterly - Raw Data sheet contains Quarterly financial data
Annual - Raw Data contains Annual financial data including P&L, Cash Flow, and Balance Sheet parameters.

Please don’t edit/ delete any cells in these two sheets as these are the data sources for the subsequent sheets in the Excel sheet:
- Quarterly - P&L
- Annual - P&L
- Balance Sheet
- Cash Flow





10. Quarterly - Raw Data sheet has standalone parameters at the top; consolidated parameters start from the 125th Row.


Annual - Raw Data has Standalone parameters at the top and consolidated parameters from the 300th Row.






11. These 4 sheets have to be used by the user for stock analysis to view their respective Quarterly P&L, Annual P&L, Balance Sheet, and Cash Flow parameters.




12. Some parameters are already pre-filled for you in all four sheets for reference purposes. 


The data source for the Quarterly - P&L sheet is Quarterly - Raw Data.
The data source for the other three sheets -  Annual - P&L, Balance Sheet, and Cash Flow, is Annual - Raw Data.

You can click on any of the cells to see the formula in the formula bar.




13. Some parameters are derived using custom formulas in the cells with fetched data. Those parameters are highlighted for your convenience. You can click on any highlighted cell to see the formula used.

In the following image, a new derived parameter named “Basic EPS Qtr change%” has been created in the 18th row by applying formulas on the parameter “Basic EPS Qtr” located in the 17th row of the same sheet. This row is also color-coded using conditional formatting for better visualization.



14. Now, you can do the following:


- Fetch financials for any other stock using the dropdown menu in cell G5 of the Main Dashboard.


- Add a new parameter in the four mentioned sheets using parameters from the Quarterly - Raw data and Annual - Raw data sheets.


- To create a new custom parameter, simply add the desired formulas in the cell. For more details, please refer to the following FAQ: How can I make a new custom parameter?


15. If you save and close the Excel sheet for the first time, a disclaimer will appear, indicating that this action will discard the signature from the sheet. However, this will not affect the functionality of the Excel Connect tool.


To proceed:

  • Click on Save Changes and discard the signature to save the changes in the Excel sheet.



This disclaimer will only appear the first time you download the Excel file from the website and close it.


16. Each time you open the Excel file, you must click on Validate Token & Fetch Stocks Master List to run the script and retrieve financial data for any new stock. 


17. MAC users might encounter issues when accessing the Trendlyne-Excel Connect Excel sheet. However, you can still access stock financial data using Google Sheets.