Debanik Chakraborty's Projects
Google Analytics, EDA with PowerBi, Wall Street Prep
A Value at Risk function, which takes list of two tickers, alpha, their weights, start and end dates and calculates the summary stats, skewness and kurtosis for the stocks. Provides Historical and Parametric VaR and TVaR for portfolio. The input from the tickers is also given in excel file.
Developed a stock valuation python function for UnitedHealth Group Inc, and taking stock ticker and peer health tickers list as inputs, obtained intrinsic prices as per FCEF and industry PE Ratio, uncovering an average 20% undervaluation in 2022
Applied MLR with 5-year bike rental data, incorporating model diagnostics, hypothesis testing, ANOVA and step-wise AIC, identified a significant impact of winter rainfall variation.
Performed Netflix Inc. stock valuation using DCF (Perpetuity and EBIDTA) and comparable companies EV/EBIDTA multiples, and 5-year financial analysis of Netflix Inc's original content (2012-2017)
A comprehensive project on sentiment scoring of 90,000 Amazon appliance products usersβ reviews with VADER, RoBERTa, and Google API techniques. The individual model's scoring was verified with the True sentiment score, and The Google API outperformed with a 98% F1-Score. However, due to the stronger correlation of RoBERTa scores with true sentiment