How to link FYERS Next to excel?
You can link real-time market data from FYERS Next directly into Microsoft Excel using the inbuilt Excel Add-In. This is particularly useful for tracking scrips and live prices in custom spreadsheets for analysis or strategy building.
Step-by-Step: Linking FYERS Next to Excel
Open FYERS Next installation directory
- Right-click on the FYERS Next desktop shortcut.
- Select 'Open File Location' from the dropdown.
Navigate to add-in folder
- Open the first folder named
app-YYYY.MM.DD (this may differ based on install date). - Open the Addin folder inside it.
- Copy the full folder path (e.g.,
C:\Program Files\FYERS Next\app-YYYY.MM.DD\Addin).
Open Microsoft Excel
- Go to File > Options.
- Click on Add-ins.
- At the bottom, select Excel Add-ins and click Go.
Add the FYERS add-in
- Click Browse and paste the copied folder path into the dialog box.
- Select the file named NorenLink-AddIn-packed.
- Click OK to add it to Excel.
- Ensure the add-in is checked and click OK again.
Link data from FYERS Next
- Open FYERS Next.
- Right-click on any scrip.
- Select 'Link to Excel'.
- The live market data for that scrip will now appear in Excel.
What if...
| Situation | Resolution |
|---|
| Can’t find the Addin folder | Ensure FYERS Next is installed properly and updated |
| Excel says Add-In is invalid or not loading | Check you selected the correct NorenLink-AddIn-packed file |
| Data not updating in Excel | Confirm FYERS Next is running and the link is active |
Linking FYERS Next to Excel gives you a powerful, real-time workspace for market tracking and strategy planning. Use this setup with caution to avoid heavy refresh loads.
Last updated: 30 Jun 2025
Related Articles
What is FYERS Next?
FYERS Next is the desktop-based trading platform developed by FYERS, designed for advanced traders and investors seeking a robust, customizable terminal for executing trades across multiple asset classes. It provides real-time data, advanced tools, ...
How many banks can I link with my FYERS trading account?
You can link up to five bank accounts to your FYERS trading account. Among these, only one can be marked as the Primary Account, which is used for fund withdrawals, dividend credits, and quarterly settlement payouts. The remaining accounts are ...
Is FYERS Next available for Mac?
FYERS Next is currently only supported on Windows OS. However, Mac users can still access it by installing Windows on their device using the built-in Boot Camp feature. How Mac users can use FYERS Next? While there's no native macOS version of FYERS ...
What is options calculator in FYERS Next?
The Options Calculator in FYERS Next is a built-in tool that helps traders estimate the theoretical price and Greeks of an options contract. It provides key data to evaluate how the price of an option may react to various market conditions—crucial ...
How to create a watchlist in FYERS Next?
Creating a custom watchlist in FYERS Next helps you track your preferred instruments in one place. Whether it’s stocks, options, or commodities, you can organise and monitor them efficiently under personalised groups. Steps to create a watchlist in ...