Bhushan Varadkar

Developing trade setups, trading strategies and automation programs for equity research

• MS Excel Automation projects using VBA & Power Query: 1. Programmed a code to compile and email news headlines & source links from 10 news sources 2. Constructed a power query to record the live option data for Volume-Open Interest analysis to backtest trading strategies of +- 6 strike prices near the spot price

• Google Sheet Automation projects using App Script: 1. Set up tracker which compares price to the moving averages & RSI indicator for a portfolio of 50 companies every 15 minutes to generate an email alert for buy and sell signals 2. Prepared a Google sheet to automatically record option chain data to identify the supply/demand zones for watchlist stocks

Sectors Analysed: FMCG, Consumer Electronics, Infrastructure, Power and Logistics

• Collaborated with the MD & India co-head of research of an American multinational investment bank for 5 theme-based macroeconomic reports

• Aggregated & analysed complex datasets like 15-year data of import/export data, government budgetary spending on Infrastructure & manufacturing sectors, power generation capacities, etc. for forecasting

• Forecasted 20 bottom-up financial models apart from tracking 15 portfolio companies,

• Counselled on 35 earnings reports and 10 investment thesis for institutional investors

• Programmed automation of routine team tasks using excel macros, yielded about 1 hour daily

• Trained 20 associates on financial modelling and dashboards

Improved the turnout for investor awareness seminars by about 20% Developed a VBA based automated financial planner for up to 5 goals to exemplify the ease and importance of financial planning The planner took the 8 inputs like the age, income, and details of the goal (Cost, time to achieve, and risk appetite for the goal) to devise a plan for an investor as to how much percent of salary should be invested at what rate of return to achieve the goal.