starweaver-logo
LOG INGET STARTED
LOG INGET STARTED
  • Browse
  • Doing

  • On Air
  • Channels
  • Career Paths
  • LEARNING

  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • CONNECTING

  • How It Works
  • Community
  • Techbytes
  • Podcasts
  • Leaderboards
  • SUPPORT

  • Support & FAQs
  • Starweaver for Business
  • Starweaver for Campus
  • Teach with Starweaver
footer-brand-logo
  • COMPANY
  • About Us
  • Support and Knowledge Base
  • Policies & Terms
  • Contact
  • CONTENT
  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • Meet the Gurus
  • Techbytes
  • FOR ORGANIZATIONS
  • Starweaver for Business
  • Starweaver for Campus
  • Catalogue
  • Pricing
  • Private Classes
  • PARTNER WITH US
  • Instructors & Teachers
  • Books, Writing & Publishing
  • FOLLOW US
    • facebook
    • twitter
    • linkedin
    • pinterest
    • instagram
    • youtube
Our trademarks include Starweaver®, Make genius happen™, Education you can bank on®, People are your most important assets!®, Body of Knowledge™, StarLabs™, LiveLabs™, Journeys™
© Starweaver Group, Inc. All Rights Reserved.
  1. Courses
  2. >
  3. Using Python and Excel for Investing in Stock

Using Python and Excel for Investing in Stock

This course will show you how to use Excel and Python in tandem to pull stock data and related information, calculate returns and establish a portfolio management strategy, predict stock market trends and much more.

John Bura
John Bura
Data Science | advanced | 5 hours |   Published: Jan 2021
In partnership with:  Coursera

    Discussions

Overview

1.5KSTUDENTS*
91.5%RECOMMEND*

This course includes:

  • 5+ hours of on-demand video
  • 6 modules
  • Core level
  • Direct access/chat with the instructor
  • 100% self-paced online
  • Many downloadable resources
  • Shareable certificate of completion
Stock markets trading activity generates massive amounts of information daily. This course will show you how to use Excel and Python in tandem to pull stock data and related information, calculate returns and establish a portfolio management strategy, predict stock market trends and much more. You will learn the fundamentals of linear regression and how this applies to machine learning, and specifically how to use this with stock market information. With these tools in hand, the instructor will help you to use machine learning to build a linear regression model to predict stock markets, as well as apply deep learning techniques (including applying Recurrent Neural Networks and Keras) to shape and scale your data and your model.

Skills You Will Gain

Excel
Investing
Python
Stock market

Learning Outcomes (At the end of this program you will be able to)

  • Understand how to use Excel and Python to gather, transform and report on stock market data
  • Create

Prerequisites

Who Should Attend

Curriculum

Instructors

Frequently Asked Questions

How much do the courses at Starweaver cost?

We offer flexible payment options to make learning accessible for everyone. With our Pay-As-You-Go plan, you can pay for each course individually. Alternatively, our Subscription-Based plan provides you with unlimited access to all courses for a monthly or yearly fee.

Do you offer any certifications upon completion of a course at Starweaver?

Yes, we do offer a certification upon completion of our course to showcase your newly acquired skills and expertise.

Does Starweaver offer any free courses or trials?

No, we don't offer any free courses, but we do offer 5-day trial only on our subscriptions-based plans.

Are Starweaver's courses designed for beginners or advanced students?

Our course is designed with three levels to cater to your learning needs - Core, Intermediate, and Advanced. You can choose the level that best suits your knowledge and skillset to enhance your learning experience.

What payment options are available for Starweaver courses?

We accept various payment methods such as major credit cards, PayPal, wire transfer, and company purchase orders. For more information related to payments contact customer support.

Do you offer refunds?

Yes, we do offer a 100% refund guarantee for our courses within a specified time frame. If you are not satisfied with the course, contact our customer support team to request a refund with your order details. Some restrictions may apply.

*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.
1Module 01: Introduction to the Course
2Module 02: Project | Track Stocks in Excel
3Module 03: Other Techniques of Stock Prediction in Excel
4Module 04: Linear Regression on Stock Data in Excel
5Module 05: Machine Learning Project Introduction
6Module 06: Your First Machine Learning Stock Prediction Project
7Module 07: Deep Learning Project for Stock Market Prediction
John Bura

John Bura

John Bura is a seasoned game developer, eLearning innovator, and AI coach with over 15 years of experience in the tech industry. Based in Vancouver, Canada, he serves as the CEO of Mammoth Interactive, where he leads the development of top-ranking games and applications across multiple platforms. His leadership also extends to Devonian Apps, a SaaS company known for delivering high-quality, fast-to-market digital products.

John is deeply passionate about education through technology. As a celebrated Udemy instructor, he has empowered over 300,000 students worldwide through practical courses on HTML5, Xcode, and game design, with his teaching style widely recognized for its clarity and real-world applicability. His dedication to curriculum excellence was further reflected in his role as a Program Advisor at Centennial College, where he shaped game design education to match industry demands.

With a rich background in both creative and technical disciplines, John has had his work featured by major industry players like Nickelodeon. As a forward-thinking AI expert, he now coaches businesses on building intelligent, automated infrastructures to increase efficiency and scalability. He's currently developing a cutting-edge tool that automates podcast and video production for content creators, furthering his mission to make innovation accessible.

Whether building games, coaching teams, or designing AI-powered tools, John blends creativity with technical mastery to drive productivity, foster innovation, and inspire learners around the world.

VIEW MY CHANNEL

Segment - 28 - Recurrent Neural Networks

Segment - 29 - Import Stock Data

Segment - 30 - What is Shaping Data

Segment - 31 - Shape Training and Testing Data

Segment - 32 - What is Scaling Data

Segment - 33 - Scale Data for Training

Segment - 34 - What is Keras

Segment - 35 - Build a Keras Model

Segment - 36 - Scale and Shape Data for Testing

Segment - 37 - Test the Model

Resource - One

Resource - Two

Resource - Three

Resource - Four

Source File

Segment - 18 - What you will learn

Segment - 19 - Build Models on the Web

Segment - 20 - What Libraries will we use

Resource - One

Resource - Two

Source File

Segment - 01 - Course Overview

Resource

Instructor bio - John Bura

Segment - 02 - What you will learn

Segment - 03 - Pull in Stock Data

Segment - 04 - Pull in more Stock Information

Segment - 05 - Calculate Equity and Returns

Segment - 06 - Calculate Selling Strategy

Segment - 07 - Calculate Total Returns

Resource

Source Files

Segment - 08 - Pull Historical Stock Data

Segment - 09 - Predict Stocks with Moving Average

Segment - 10 - Visualize Accuracy

Segment - 11 - What is Exponential Smoothing

Segment - 12 - Predict Stocks with Exponential Smoothing

Resource

Source File

Segment - 21 - Scrape Data via API

Segment - 22 - Define Variables

Segment - 23 - Split Dataset for Training and Testing

Segment - 24 - Build a Linear Regression Model

Segment - 25 - Predict Stock Prices

Segment - 26 - Calculate Model Accuracy

Segment - 27 - Predict to Buy or to Sell

Source File

Segment - 13 - What you will learn

Segment - 14 - Pull Historical Stock Data

Segment - 15 - What is Linear Regression

Segment - 16 - Linear Regression on Stock Data in Excel

Segment - 17 - Check Accuracy of Linear Regression

Resource - One

Resource - Two

Source File