Hướng dẫn python in finance course

About The Course

Learn the basic in programming and write codes in Python. No prior programming experience required.

Nội dung chính

  • About The Course
  • Learning Outcomes
  • Course Outline
  • Who Should Attend
  • ACCA Member & Affiliate CPD Subsidy
  • Prerequisites
  • Can Python be used for accounting?
  • Is Python good for finance majors?
  • Is it worth learning Python for finance?
  • Which Python is best for finance?

Python is relatively easy to learn, popular and is an open-sourced computer language, with applications on Machine Learning, Data Analytics and Cloud Computing and Robotics.

Accountants performing Financial Modelling using Excel/VBA, then Python certainly can do more and open new doors. It is a complete language and can perform multiple scenarios efficiently using few simple codes, except you're not limited by how much data you can see on your screen.

This class is scheduled as a workshop but the format may be converted to an online class depending on the COVID-19 situation.

Learning Outcomes

Accountants, will learn the key programming concepts such as:

  • Data list
  • Loops
  • Decision making
  • Functions
  • Object oriented principles and
  • Practise writing clean and clear codes

You will be using Python 3.X.

Course Outline

  1. Big Picture  
    • Python Introduction
    • Installation
    • Development Environment
  2. Key Programming Concepts
    • Key Variables
    • Decision making
    • Version control (Iterations)
    • User-defined functions
    • Import modules
  3. Ready made functions for basic input & output
    • List, Tuple and Dictionary
  4. Data Structure
    • Data persistence
    • Different file formats
  5. Object-Oriented Programming Basics
    • Object model - fields & methods
    • Inheritance

OPEN TO GLOBAL MEMBERS: Please enquire by email at  to confirm membership and class status before booking. 

Who Should Attend

Accountants or CFOs who are curious about how to use programming to solve Finance, Risk and Operations problem statement.

ACCA Member & Affiliate CPD Subsidy

ACCA Singapore is currently offering a special subsidy to active Singapore members and affiliates so as to help them through the Covid-19 pandemic to meet their CPD requirements. This offer is available on selected courses here and on a limited basis. Terms and conditions apply. 

Prerequisites

You are not required to have any prior programming knowledge. 

All hands-on exercises will be done on your own computer.

Please ensure your computer is able to have a multi-window layout so you can easily access the classroom platform and the Python programme side by side.

CPD units

Your attendance to this course will accord you with 7.0 CPD units (ACRA Category 5). A CPD certificate will be emailed to you within 3 business days after the completion of the course.

Trainer

Bala Iyer FCCA

Bala is a member with ACCA, specialises in bringing innovation to Banking and Financial Institutions using AI Machine Learning.

He has over 20 years in Banking, which includes Treasury (Liquidity and Capital Management), Product Control and Valuation control across London, Tokyo, Singapore and Johannesburg.

He currently leads an AI envisioned company driving AI initiatives on Finance and Risk area. 

He also holds a Master’s Degree in Finance from Singapore Management University.

7 Units

  • Date

    • 25 February 2022
    • 09:00 - 17:00 Singapore Time
  • Prices

    • Members
    • SGD$250
    • Affiliates
    • SGD$260
    • Approved Employers / Students
    • SGD$310
    • Public
    • SGD$360
    • UTAP Funding
    • Claim up to 50% of this course fee if you are a member of NTUC Union.
    • Partner Offer
    • CA ANZ, IIA and ISCA members enjoy 10% off public rate
    • OPEN TO GLOBAL PARTICIPANTS
    • Email to enquire on booking Member / Affiliate / Students rates.

Book online

You will be redirected to an external website for booking.

I've joined a company where integration with bank wasn't set up properly yet and cash allocation had to be done manually, which in practice meant copying and pasting data from bank statement in PDF to excel file. Each transaction one by one, and it could take really a lot of time.

As i was just an assistant and it was the worst job to do, biggest chunk was thrown out at me. As i was already planning to start learning python (spent only few hours before this), i've created a script that was processing bank statement and outputting Journal Entry with all the data ready. I've saved a shit-ton of hours for myself and other people from department, as if i wouldn't have created it in proper time, some people would be really screwed for Year-End Closing.

And basically i learned python while creating those scripts.

Later was also able to create some scripts for Intercompany Reconciliation, which were just based on performing joins on tables, so i learned pandas doing this.

Got some recognition afterwards and was promoted to other department, supposed to work with the systems, optimization and automation. And now i'm stuck with toying around ERP System and SharePoint, with barely any possibility to write any code in python, so my skills has probably decreased already over time. Now looking at the code i've written, i could wonder how the heck i was able to pull this off.

So started very nicely for me, and even though it didn't end as i would except, there are definitely use cases for Python in Finance/Accounting :).

Can Python be used for accounting?

From an accountancy perspective, Python is most useful when working with data. It can essentially read any type, both structured and unstructured. It has powerful capabilities in data importation and manipulation – tasks like merging and recoding – as well as handling large amounts.

Is Python good for finance majors?

The Bottom Line. Python is an incredibly versatile language with a very simple syntax and great readability. It is used for building highly scalable platforms and web-based applications, and is extremely useful in a burdened industry such as finance.

Is it worth learning Python for finance?

Learning financial programming with Python is becoming a requirement. Finance and banking have a reputation for very high salaries, so the job field attracts a large number of applicants. If you're one of them, you should know Python is hugely popular for finance — and still growing in popularity.

Which Python is best for finance?

Best Python Courses for Banking, Finance & FinTech (2022).

Investment Management with Python and Machine Learning from EDHEC. ... .

AI Programming with Python from Udacity. ... .

Python Programming for Finance from NYIF. ... .

Professional Certificate in Python Data Science from IBM. ... .

Python and Statistics for Financial Analysis from HKU..