|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-driven-investing-with-excel-financial-data-science/
课程评论:没有评论
课程名称:通过Excel金融数据科学进行数据驱动投资 课程概述:成为一名数据驱动投资者,彻底消除投资中的不确定性。利用金融数据科学、金融分析和量化金融的强大力量,做出稳健的投资决策并创造超额收益。本课程将教你如何使用严格的统计技术来指导投资决策,即使你对统计学不熟悉或数学能力较弱。课程内容包括: - **两部分,八个掌握单元**(未来的所有更新均包含其中): - **13小时的实用高清在线视频课程** - 课程中的实际应用 - 200多个测验问题及详细解决方案 - 超出舒适区的作业,帮助你应用所学知识 - 实践测试以增强核心概念的信心 - 从头开始构建的Excel模板,帮助建立可复制的投资系统 - 数学证明供数学爱好者研究 - 热爱金融、投资和金融数据科学的讲师 ### 第一部分:投资分析基础 - 学习投资分析和金融分析的核心基础知识。 - 探索投资证券关系与估算回报。 - 理解价格、风险和回报之间的强大关系。 - 学习股票回报和投资组合回报的计算方法。 - 下载并处理全球任何股票的真实数据。 - 估算金融证券的预期回报、风险并进行投资组合风险分析。 ### 第二部分:数据驱动投资金融数据科学/量化金融 - 提高你的金融分析和投资分析技能,利用金融数据科学和量化金融进行投资。 - 了解数据驱动投资的过程,开发可测试的投资假设。 - 收集、清洗和探索真实世界数据。 - 进行探索性数据分析,使用Excel进行统计测试和验证假设。 - 设计和构建基于个别投资想法的投资组合,进行风险和收益评估。 本课程采用“为卓越设计”的方法,结合多种教学技术,旨在帮助你掌握强大的金融数据科学和金融分析技巧,成为一名优秀的数据驱动投资者。无论是考试、求职还是个人财务管理,这门课程都将为你提供坚实的基础。
Become a Data Driven Investor. Take the guesswork out of your investing forever. Leverage the power of Financial Data Science, Financial Analysis, and Quantitative Finance to make robust investment decisions (and generate Alpha).Discover how to use rigorous statistical techniques to guide your investment decisions (even if you don't know statistics or your math is weak).Say hello to the most comprehensive Data Driven Investing course on the internet. Featuring:# =============================# 2 PARTS, 8 SECTIONS TO MASTERY # =============================(plus, all future updates included!)Structured learning path, Designed for Distinction™ including:13 hours of engaging, practical, on-demand HD video lessonsReal-world applications throughout the course200+ quiz questions with impeccably detailed solutions to help you stay on track and retain your knowledgeAssignments that take you outside your comfort zone and empower you to apply everything you learnA Practice Test to hone in and gain confidence in the core evergreen fundamentalsExcel® spreadsheets/templates (built from scratch) to help you build a replicable system for investingMathematical proofs for the mathematically curiousAn instructor who's insanely passionate about Finance, Investing, and Financial Data SciencePART I: INVESTMENT ANALYSIS FUNDAMENTALSStart by gaining a solid command of the core fundamentals that drive the entire investment analysis / financial analysis process.Explore Investment Security Relationships & Estimate ReturnsDiscover powerful relationships between Price, Risk, and ReturnsIntuitively explore the baseline fundamental law of Financial Analysis - The Law of One Price.Learn what "Shorting" a stock actually means and how it worksLearn how to calculate stock returns and portfolio returns from scratchDownload and work with real-world data on Excel® for any stock(s) you want, anywhere in the worldEstimate Expected Returns of Financial SecuritiesExplore what "expected returns" are and how to estimate them starting with the simple meanDive deeper with "state contingent" expected returns that synthesise your opinions with the dataLearn how to calculate expected returns using Asset Pricing Models like the CAPM (Capital Asset Pricing Model)Discover Multi Factor Asset Pricing Models including the "Fama French 3 Factor Model", Carhart 4 ("Momentum"), and more)Master the theoretical foundation and apply what you learn using real-world data on your own!Quantify Stock Risk and Estimate Portfolio RiskExamine the risk of a stock and learn how to quantify total risk from scratchApply your knowledge to any stock you want to explore and work withDiscover the 3 factors that influence portfolio risk (1 of which is more important than the other two combined)Explore how to estimate portfolio risk for 'simple' 2-asset portfoliosLearn how to measure portfolio risk of multiple stocks (including working with real-world data!)Check your MasterySo. Much. Knowledge, Skills, and Experience. Are you up for the challenge? - Take the "Test Towards Mastery"Identify areas you need to improve on and get better at in the context of Financial Analysis / Investment AnalysisSet yourself up for success in Financial Data Science / Quantitative Finance by ensuring you have a rigorous foundation in placePART II: DATA DRIVEN INVESTING FINANCIAL DATA SCIENCE / QUANTITATIVE FINANCESkyrocket your financial analysis / investment analysis skills to a whole new level by learning how to leverage Financial Data Science and Quantitative Finance for your investing.Discover Data Driven Investing and Hypothesis DesignDiscover what "data driven investing" actually is, and what it entailsExplore the 5 Step Data Driven Investing process that's designed to help you take the guesswork out of your investment decision makingLearn how to develop investment ideas (including how/where to source them from)Explore the intricacies of "research questions" in the context of Financial Data Science / Data Driven InvestingTransform your investment ideas into testable hypotheses (even if you don't know what a "testable hypothesis" is)Collect, Clean, and Explore Real-World DataExplore how and where you can source data to test and validate your own hypothesesMaster the backbone of financial data science - data cleaning - and avoid the "GIGO" trap (even if you don't know what "GIGO" is)Work with large datasets (arguably "Big Data") with over 1 million observations using Excel®!Discover quick "hacks" to easily extract large amounts of data semi-automatically on Google SheetsLearn while exploring meaningful questions on the impact of ESG in financial marketsConduct Exploratory Data AnalysisDiscover how to conduct one of the most common financial data science techniques - "exploratory data analysis" using Excel®!Evaluate intriguing relationships between returns and ESG (or another factor of your choice)Learn how to statistically test and validate hypotheses using 'simple' t-testsNever compromise on the mathematical integrity of the concepts - understand why equations work the way they doExplore how to "update" beliefs and avoid losing money by leveraging the power of financial data science and quantitative financeDesign and Construct Investment PortfoliosExplore exactly what it takes to design and construct investment portfolios that are based on individual investment ideasLearn how to sort firms into "buckets" to help identify monotonic relationships (a vital analysis technique of financial data science)Discover intricate "hacks" to speed up your workflow when working with large datasets on ExcelStrengthen your financial data science skills by becoming aware of Excel®'s "bugs" (and what you can do to overcome them)Plot charts that drive meaningful insights for Quantitative Finance, including exploring portfolio performance over timeStatistically Test and Validate HypothesesSay goodbye to guesswork, hope, and luck when it comes to making investment decisionsRigorously test and statistically validate your investment ideas by applying robust financial data science techniquesAdd the use of sophisticated tools including simple t-stats and more 'complex' regressions to your suite of financial data science analyticsExplore what it really takes to search for and generate Alpha (to "beat the market")Learn and apply tried and tested financial data science and quantitative finance techniques used by hedge funds, financial data scientists, and researchersDESIGNED FOR DISTINCTION™We've used the same tried and tested, proven to work teaching techniques that have helped our clients ace their professional exams (e.g., ACA, ACCA, CFA®, CIMA), get hired by the most renowned investment banks in the world, manage their own portfolios, take control of their finances, get past their fear of math and equations, and so much more.You're in good hands.Here's how we'll help you master incredibly powerful Financial Data Science & Financial Analysis techniques to become a robust data driven investor...A Solid FoundationYou'll gain a solid foundation of the core fundamentals that drive the entire financial analysis / investment analysis process. These fundamentals are the essence of financial analysis done right.And they'll hold you in mighty good stead both when you start applying financial data science techniques in Part II of this course, but also long after you've completed this course. Top skills in quantitative finance - for the rest of your life.Practical WalkthroughsForget about watching videos where all the Excel® templates are pre-built. We'll start from blank Excel® spreadsheets (like the real world).And we'll build everything from scratch, one cell at a time. That way you'll literally see how we conduct rigorous financial analysis / financial data science using data-driven investing as the core basis, one step at a time.Hundreds of Quiz Questions, Dozen Assignments, and Much MoreApply what you learn immediately with 200+ quiz questions, all with impeccably detailed solutions. Plus, over a dozen assignments that take you outside your comfort zone. There's also a Practice Test to help you truly hone your knowledge and skills. And boatloads of practical, hands-on walkthroughs where we apply financial data science / quantitative finance techniques in data driven investing environments.Proofs & ResourcesMathematical proofs for the mathematically curious. And also because, what's a quantitative finance course without proofs?!Step-by-step mathematical proofs, workable and reusable Excel® spreadsheets, variable cheat sheets - all included. Seriously.This is the only course you need to genuinely master Data Driven Investing, and apply Financial Data Science & Quantitative Finance techniques without compromising on the theoretical integrity of concepts.