Learn Python to automate: Excel reports, stock & crypto analysis, and stock price alerts to your phone!
What you'll learn
- Accounting Data Analytics (Data Cleansing & Spreadsheet Automation)
- Stock Data Extraction
- Use APIs to Extract Cryptocurrency Data
- Use APIs to Send Price Alerts (Stock & Crypto) To Your Phone
- Python Basics & Fundamentals
Requirements
- Basic computer skills
- No programming experience required
- Basic Microsoft Excel skills ideal, but not required
Description
This is a beginners Python Accounting Course that explains how to automate 4 Financial projects:- Streamline stock market analysis by automating stock data extraction,
- Automate an Excel sales report & data cleansing report using common Data Analytics techniques,
- Automate cryptocurrency data extraction from Binance, and
- Automate stock or crypto price alerts to your phone via APIs & Push notifications.
Students will also be able to understand the relevance of Python by practicing their skills on 4 real-world Financial projects.
I've condensed over 10 years of my experience as a Consultant at a Big 4 into this 3 hour course which I know you'll love because I use everything in this course to automate my job
Please watch the Course Preview to find out more and get started!
--------------------
Below is an overview of each chapter:
Chapter 1
A quick introduction about me, and what this course covers.
Chapter 2
Explains basic Python syntax and fundamentals - for example, you might love reading novels and want to write a book, but before you write it, you have to learn grammar, syntax, and style guides - same thing goes with coding, and that’s what this chapter is about - learning the grammar, syntax, and style guides of Python. This chapter will go through the following:
- Installing Python & downloading course files,
- Using the code editor (IDLE) & print function
- Arithmetic operators,
- Comparison operators,
- Variables & datatypes,
- Code documentation,
- If statements,
- F-String,
- Lists,
- For loops,
- Opening & saving text files,
- Custom functions,
- Standard libraries,
- While loops,
- Third party libraries, and
- Installing Pandas.
We'll then apply what you've learnt in the basics to solve your first real world case study - Python stock analysis - specifically, extracting stock market data to a spreadsheet using the Yahoo Finance / YFinance library.
Chapter 3
An introduction to Jupyter Notebooks. We upgrade our code editor to Jupyter Notebook which is more powerful than IDLE (the default code editor that comes with Python).
Chapter 4
Teaches fundamental Data Analytics techniques using the Pandas library which is important for every Accountant to know. This is THE chapter for Excel automation. You'll learn techniques like:
- Adding & removing columns,
- Sorting data,
- Filtering,
- Removing duplicates,
- Formatting,
- Pivot tables,
- Exporting to CSV & Excel, and
- Location / If Function.
We’ll then apply those learnings by automating 2 case studies:
- Supermarket sales report - we’ll aggregate loads of sales data into a pivot table with just a few lines of code.
- Data Cleaning / Data Wrangling case study which is about fixing bad data.
Chapter 5
A general overview of APIs. I'll explain what is an API, how to connect to APIs, and the difference between a Get and Post Request.
We'll be using the Binance API as an example as I go through the API explanation which means you'll learn how to automatically extract cryptocurrency prices to your Python script or to an Excel spreadsheet.
We'll then finish this chapter with a case study which combines EVERYTHING we've learnt in this course - we'll use the Telegram App (Android / iOS) and Telegram API to send stock market alerts, messages, and push notifications to our phone.
Who this course is for:
- Accountants who are new to coding / programming
- Accountants who want to learn Python quickly
- Accountants who want to understand how to apply Python in their work
