Excel Connect is a first-in-market product by Trendlyne designed to provide investors with easy access to financial data for any listed stock in the market through Excel or a Google sheet.
What does Excel Connect do?
Fetch the latest financial data:
To do this is quite simple. Open the sheet, grant the necessary permissions, follow the initial instructions, select the stock, and fetch the latest financial data.
Let you make your formulas and parameters inside the worksheet:
Besides getting the latest data, you can make new custom parameters within the worksheet itself, by entering formulas into cells.
You can sort, filter, and add charts:
You can also apply color-coding, sorting, and various visualizations like charts and graphs to improve your analysis. Once you fetch new stock data in the sheet, derived parameters are calculated automatically for that stock.
Excel Connect is available in the Data Downloader section. Only Strat-Q subscribers can generate tokens to access the latest available data within the file