Hi Developers,
I am working on a project that involves using the Fyers App API to fetch option chain data and display it in an Excel sheet with live updates. My specific requirements are:
Retrieve the entire option chain data for a selected stock/index.
The data should update in real-time or at a regular interval (e.g., every few seconds).
Seamless integration between the Fyers API and Excel.
Any suggestions on how to structure the data within Excel to make it easy to analyze would be appreciated.
I’ve gone through the Fyers API documentation but am struggling with implementation details. If anyone has:
Sample scripts (Python preferred)
Experience integrating Fyers API with Excel (e.g., using libraries like
pandas,openpyxl, or Excel’s Power Query)Any advice or a step-by-step guide
… I’d be incredibly grateful for your help.
Looking forward to hearing your suggestions and guidance!
Thanks in advance!