Hello,
Here’s how I propose to approach the project:
Automated Data Import with Power Query: I’ll set up Power Query to pull the specified data points—Strike Price, Open Interest, Last Price, Implied Volatility, Change in Open Interest, Volume, and Change of Open Interest/Volume—directly from NSE’s option chain into Excel. Power Query will automate this import process, ensuring data is refreshed with minimal effort.
Dynamic Row Update: The Excel sheet will automatically append a new row with the latest values upon each refresh, maintaining a continuous, up-to-date record of historical data.
Data Visualization: I’ll create dynamic charts to visualize key data points across all records, providing you with clear, insightful trend analysis.
Relevant Skills and Experience:
Advanced Excel & Power Query Proficiency: Strong expertise in automation, data manipulation, and visualization using Excel and Power Query.
Financial Data Analysis: Experience handling complex financial datasets, especially in stock options and market analysis.
Attention to Detail: I’ll ensure your solution is reliable, intuitive, and tailored to your specific needs.
Let me know if you have any specific requirements or questions. I look forward to the opportunity to assist you!
Best regards,
Prakash