Stock Data Analysis: Excel Vs Python | Full Tutorial

Veröffentlicht am: 24 Februar 2021
auf dem Kanal: QuantInsti Quantitative Learning

5,521

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-mar...

✅Basic Operations On Stock Data Using Python
https://blog.quantinsti.com/basic-ope...

✅What Every Trader Should Know About Market Data
https://blog.quantinsti.com/market-da...

✅Fundamental and Sentiment Analysis with Different Data Sources
https://blog.quantinsti.com/fundament...
-----------------------------------------

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-dat...
-----------------------------------------
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

Auf dieser Seite können Sie das Online-Video Stock Data Analysis: Excel Vs Python | Full Tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer QuantInsti Quantitative Learning 24 Februar 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 5,521 Mal angesehen und es wurde von 78 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

1,035