Python-Excel Visualization Automation

@johibkhan

Hi, As an exceptionally skilled and experienced software developer, I am confident in my ability to deliver a top-notch solution for your need of a repeatable Python workflow that seamlessly integrates external databases with Excel while simultaneously creating data visualisation sheets. With over 15 years of programming under my belt, in companies like Avaya, CGI, and Pramati, I have perfected my skills in developing efficient systems capable of handling complex tasks efficiently. My expertise lies in problem-solving and building high-performance systems capable of handling real-time workloads which makes me the perfect candidate for your project. My understanding of algorithmic trading and market data processing, paired with my experience in working with Excel and databases, guarantees that I abide by your provided requirements - from secure connection to accurate visuals - fulfilling end-to-end run with just one command. Furthermore, I've led teams in delivering robust, secure and future-ready platforms in various domains including the trading and fintech sector. With all these attributes aligned to your project requirements, I offer you a comprehensive fit that delivers not just a product but results too.

@Sahyadri96

Completed projects till now 1) Python + DhanAPI +Excel + VBA option scalping strategy 2) Python 21 EMA and 9 EMA crossover strategy on DhanAPI 3) Google sheet + FyersAPI trading 4) Google sheet + Algomojo + Upstox 5) Tradetron Banknifty option scalping strategy 6) Excel 2600 NSE 10 years data 7) Copytrading using python 8) Tradetron Supertrend + MACD Crossover Strategy 9) Dhan option chain with Greeks in Google spreadsheet via Google Appscript 10) Backtesting of Nifty options for wait and trade strategy 11) Trigger orders for Dhan Nifty options 12) Shoonya API:- Wait and trade strategy 13) Tradetron: RSI + ADX + EMA strategy 14) Python Moving avarage channel trading Algo 15) Kotak Neo: Turtle scalping strategy for options 16) Fyers Filtered option chain in Excel 17) Binance Bitcoin tradingview strategy python bot 18) Fyers Tradingview python bot 19) Dhan Python order manager I can deliver any project in Trading. Readymade setups for Python available

@Ritesh11gupta

I can help you create a Python workflow that automates gathering data from your external databases for visualization. Just to clarify, which type of databases are you connecting to? Let's make this efficient!

@manoval09

Hi, I see you need a repeatable Python workflow that pulls from your external databases and generates Excel visualizations—right now that's likely manual, repetitive work you're doing by hand. I'll build this using pandas for data extraction and openpyxl for dynamic Excel generation with embedded charts. For the visualization layer, I'll use matplotlib or plotly depending on your chart complexity. For repeatability, I'll add scheduling via cron or Windows Task Scheduler so the entire pipeline runs on your set schedule without manual intervention each time. My first move is to map the exact data pipeline: which databases you're connecting to, what tables/queries are involved, and what the final Excel output looks like. Your description cut off at "gathers the required tab"—I need those complete requirements and ideally a sample of your source data to give you an accurate timeline and scope. Best regards, Val --- **Why this works:** - Mirrors the specific pain: "repeatable," "databases," "manual work" - Concrete tech stack: pandas, openpyxl, matplotlib/plotly, scheduling - Honest about scope gap (incomplete brief) and requests what's needed - First-24-hour action + clarifying question to drive engagement - No buzzwords, no fluff, no self-intro—straight to the problem

@alexchendev

Hi, I can build this Python workflow. My plan: 1) Connect to your databases (SQL/API). 2) Pull required tables into pandas DataFrames. 3) Clean, transform, and generate charts (matplotlib/seaborn/openpyxl). 4) Export polished Excel reports with embedded visualizations. 5) Make it repeatable — one script, one click. Experienced with pandas, database connectors, and Excel automation. Ready to start.