Stock Data Analysis: Excel Vs Python | Full Tutorial

A quant fund manager + A HFT prop desk founder + A quant teacher = a session worth watching On 9 April, we hosted Kelvin Foo, Dr Gaurav Raizada, and Vivek Krishnamoorthy for a workshop on Algorithmic Trading & Options Risk Management. Watch the recording: www.quantinsti.com/articles/algorithmic-trading-python-ai-options-risk-management-webinar/ . . - Learn to analyse and backtest financial market data using Excel and Python. Understand the difference between both tools and their respective pros and cons. Know which one is best suited for you. **** Supercharge your trading strategy with EPAT! Buy our cutting-edge course today and revolutionize your approach to the market. Join EPAT (Executive Programme in Algorithmic Trading) today! 👉 https://bit.ly/3OyErFI **** Don't forget to 'Like' and 'Share' this video and be sure to 'Subscribe' to our YouTube channel! ----------------------------------------- Additional Reading: ✅Stock Market Data And Analysis In Python https://blog.quantinsti.com/stock-market-data-analysis-python/ ✅Basic Operations On Stock Data Using Python https://blog.quantinsti.com/basic-operations-stock-data-using-python/ ✅What Every Trader Should Know About Market Data https://blog.quantinsti.com/market-data-faq/ ✅Fundamental and Sentiment Analysis with Different Data Sources https://blog.quantinsti.com/fundamental-sentiment-analysis-data/ ----------------------------------------- Chapters: 00:00 - Introduction 02:30 - What to Expect 03:37 - Types of Stock Analysis 05:58 - Test analysis of a stock in Excel 18:45 - Backtestig a Strategy in Excel 32:05 - Benefits of Excel 33:53 - Disadvantages of Excel 36:19 - Backtesting a Strategy on Python 47:48 - Summary 48:22 - Q&A ----------------------------------------- Slides and Downloadable Code Files: https://blog.quantinsti.com/stock-data-analysis-excel-python-23-february-2021/ ----------------------------------------- Key Takeaways - Steps involved in backtesting a strategy - Demo of backtesting using Excel - Why Excel and what does it enable us to do? - Where does Excel fall short? - How to overcome it? - Demo of backtesting on multiple stocks ----------------------------------------- About the Speaker Jay Parmar (Associate, Content & Research at QuantInsti) Jay Parmar works as an Associate, Content & Research at QI and comes with several years of experience in the BFSI industry. He is actively engaged in content development for quant finance courses and mentors EPAT participants across the globe. He is passionate about algo trading and programming and enjoys developing automated trading systems. He holds a Bachelors’ in Computer Science and the EPAT Certificate. His research interests are in applying machine learning models to various facets of trading. ----------------------------------------- About EPAT https://bit.ly/3SPQukR ----------------------------------------- This event was held on: Tuesday, February 23, 2021 8:30 AM ET | 7:00 PM IST | 9:30 PM SGT ----------------------------------------- Most useful links: Join EPAT – Executive Programme in Algorithmic Trading: https://goo.gl/3Oyf2B Visit us at: https://www.quantinsti.com/ #StockAnalysis #PythonStockAnalysis #AlgorithmicTrading