Home
WSQ - Python Programming for Finance

WSQ - Python Programming for Finance

Elevate your financial analysis capabilities with our specialized WSQ-endorsed course on Python Programming for Finance. This comprehensive course delves into the application of Python for various financial tasks including trading algorithms, portfolio management, and risk assessment. Through hands-on exercises and real-world financial case studies, you will learn how to utilize Python's powerful libraries to analyze financial data, forecast trends, and make data-driven decisions.

Upon completing the course, you’ll have a robust skill set in applying Python for financial analysis and strategy development. Whether you're a financial analyst, a portfolio manager, or someone keen on fintech, this course equips you with the computational tools and knowledge to optimize your financial operations and strategies effectively.

Course Objectives

Learners will be able to code and execute Python programs on financial data to meet business requirements.

Learning Outcomes

By the end of the course, learners will be able to

LO1: Apply Python programming to meet business requirements.
LO2: Code data types and operators.
LO3: Organize codes using conditional and loop for problem-solving.
LO4: Code Python functions and scripts for business use cases.
LO5: Code import and prepare finance data using Python Pandas package.
LO6: Test Python codes with aggregation and visualization.
LO7: Improve and document Python codes to analyse finance data.

Skills Framework

This course follows the guideline of Programming and Coding ACC-DIT-3018-1.1 TSC under Accountancy Skills Framework

Course Brochure

Download WSQ - Python Programming for Finance Brochure

Certification

Certificate of Completion from Tertiary Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.
OpenCerts from SkillsFuture Singapore - After passing the assessment(s) and achieving at least 75% attendance, participants will receive a OpenCert (aka Statement of Achievement) from SkillsFuture Singapore, certifying that they have achieved the Competency Standard(s) in the above Skills Framework.

WSQ Funding

WSQ funding is only applicable to Singaporeans and PR. Subject to eligibility, the funding support is subjected to funding caps.

Effective for courses starting from 1 Jan 2024
Full Fee	GST	Nett Fee after Funding (Incl. GST)
		Baseline	MCES / SME
$1000	$90.00	$590.00	$390.00

Baseline: Singaporean/PR age 21 and above
MCES(Mid-Career Enhanced Subsidy): S'porean age 40 & above

Upon registration, we will advise further on how to tap on the WSQ Training Subsidy.

You can pay the nett fee (after the WSQ training subsidy) by the following :

SkillsFuture Enterprise Credit (SFEC)

Eligible Singapore-registered companies can tap on $10000 SFEC to cover up out-of-pocket expenses.Click here to submit SkillsFuture Enterprise Credit

SkillsFuture Credit (SFC)

Eligible Singapore Citizens can use their SFC to offset course fee payable after funding but the $4,000 Additional SFC (Mid-Career Support) cannot be used. Click here for SkillsFuture Credit submission

UTAP

Eligible NTUC members can apply for 50% of the unfunded fee from UTAP, capped up to $250/year and for members aged 40 and above, capped up to $500/year. Click here to submit UTAP

PSEA

Eligible Singapore Citizens can use their PSEA funds to offset course fee payable after funding.

To check for Post-Secondary Education Account (PSEA) eligibility for this course, Visit SkillsFuture (course code: TGS-2022014980)

Scroll down to “Keyword Tags” to verify for PSEA eligibility.
If there is “PSEA” under keyword tags, the course is eligible for PSEA.

Once you are eligible for PSEA, please download and fill up the PSEA Withdrawal Form and email to us.

Course Code: TGS-2022014980

Post-Course Support

We provide free consultation related to the subject matter after the course.
Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Course Cancellation/Reschedule Policy

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commerce.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom

Course Details

Topic 1: Introduction to Python Programming

Business requirements and objectives
Applications of Python programming to meet business requirements
Install Python and Setup Python IDE

Topic 2: Data Types and Operators

Data Types
Operators

Topic 3: Problem Solving with Control Structures

Problem solving with conditional and loop techniques
Coding using comprehensions

Topic 4: Scripting with Function and Lambda

Create Python functions to meet business use cases
Lambda function and its applications

Topic 5: Import and Process Finance Data

Data analysis using Pandas package
DataFrame and Series data structures
Import finance data
Filter and slice finance data
Clean missing data

Topic 6: Aggregate and Visualize Finance Data

Join finance data with concat, append and merge
Aggregate data with groupby and pivot table
Assess codes to identify gaps
Test and visualize finance data

Topic 7: Analyze Finance Data

Improve codes with pipe and apply
Applications of statistics
Analyse finance data to track any changes

Final Assessment

Written Assessment - Short Answer Questions (WA-SAQ)
Practical Performance (PP)

Course Info

Promotion Code

Promo or discount cannot be applied to WSQ courses

Minimum Entry Requirement

Knowledge and Skills

Able to operate using computer functions
Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

Positive Learning Attitude
Enthusiastic Learner

Experience

Minimum of 1 year of working experience.

Minimum Software/Hardware Requirement

Software:

Download and Install the following software

Hardware: Window or Mac Laptops

About Progressive Wage Model (PWM)

The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity.

Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.

For more information on PWM, please visit MOM site.

Funding Eligility Criteria

Individual Sponsored Trainee

Employer Sponsored Trainee

Singapore Citizens or Singapore Permanent Residents of age 21 and above
From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
Trainee must pass all prescribed tests / assessments and attain 100% competency.
We reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria.

Singapore Citizens or Singapore Permanent Residents who are DIRECT EMPLOYEE of the sponsoring company.
From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
Trainee must pass all prescribed tests / assessments and attain 100% competency.
We reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria.

SkillsFuture Credit:

Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

PSEA:

To check for Post-Secondary Education Account (PSEA) eligibility, goto mySkillsFuture portal and search for this course code.
Scroll down to "Keyword Tags" to verify for PSEA eligibility.
If there is “PSEA” under keyword tags, the course is eligible for PSEA.
And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA.
Not all courses are eligible for PSEA funding.

Absentee Payroll (AP) Funding:

$4.50 per hour, capped at $100,000 per enterprise per calendar year.
AP funding will be computed based on the actual number of training hours attended by the trainee.

SFEC:

If the Training Provider has submitted an enrolment for course fee grant claim in Training Partners Gateway (TPGateway), SSG would be able to derive SFEC funding based on this record. There is no need for enterprise to submit any claim request and the SFEC claim will be automatically generated and disbursed.
Where there is no such record, eligible employers are required to submit an SFEC claim after course completion via the SFEC microsite.
SkillsFuture Enterprise Credit (SFEC) Microsite

Steps to Apply Skills Future Claim

The staff will send you an invoice with the fee breakdown.
Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
Upload your invoice and click ‘Submit’

SkillsFuture Level-Up Program

The SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme

Get Additional Course Fee Support Up to $500 under UTAP

The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)

Steps to Apply UTAP

Note

SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
UTAP support amount will be paid to training provider first and claimed after end of class by learner.

Appeal Process

The candidate has the right to disagree with the assessment decision made by the assessor.
When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
If the candidate is still not satisfied with the decision, the candidate must notify the assessor of the decision to appeal. The assessor will reflect the candidate’s intention in the Feedback Section of the Assessment Summary Record.
The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
The candidate must lodge the appeal within 7 days, giving reasons for appeal
The assessor can help the candidate with writing and lodging the appeal.
he assessment manager will collect information from the candidate & assessor and give a final decision.
A record of the appeal and any subsequent actions and findings will be made.
An Assessment Appeal Panel will be formed to review and give a decision.
The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
Please click the link below to fill up the Candidates Appeal Form.

Job Roles

Aspiring Software Developer
Data Analyst
Web Developer
Automation Engineer
Data Scientist
System Administrator
Bioinformatics Specialist
Research Scientist
Finance Professional
Machine Learning Enthusiast
GIS (Geographic Information System) Specialist
IT Consultant
Network Engineer
Database Administrator
Tech Entrepreneur.

Customer Reviews (42)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 6/2/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

I had the privilege to have Dr Alvin Ang as my trainer for a Python for Finance session.

he has impressed me with his passion for teaching and commitment to learning. Dr Alvin possesses a deep understanding of python programming, and his innovative teaching methods are effective and engaging.

During our session, Dr Alvin provided the essentials of python coding and advocates for a strong foundation. he also provides resource materials that are not part of the curriculum that had helped me with my learning.

I had a fruitful and enjoyable experience attending his training session. (Posted on 5/17/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 4/28/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 4/28/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Good introduction into python language for those working in finance industry. Enable you to have a basic understanding of what your IT team is writing for your software (Posted on 4/27/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 4/27/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 3/5/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 3/5/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Dr Alvin Ang is a good teacher. He is patient, helpful and willing to take the time to explain the course materials. Recommended to attend his classes (Posted on 3/5/2024)

Dr Alvin was able to explain the logics behind the python codes in layman's term Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Dr Alvin was able to explain the logics behind the python codes in layman's term (+ humour) for programing nerds like me. At the end of the 3 days course, i was able to grasp simple concepts to read and understand basic python codes. Most importantly, he shared useful resources we could refer to should we be doing this ourselves. I would hope more use cases can be used for practice (from import to data visualisation) so we can be more confident to apply it in future.

classroom environment wise, aircon was really cold, got down with flu on 2nd day (Posted on 1/11/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Alvin has made the learning Python for Finance enjoyable, easy to understand and interesting. ***** Would appreciate to allow students to submit online/soft copy answers, rather than manually writing codes on paper. Thanks! (Posted on 1/11/2024)

Alvin has good knowledge on subject matter and is a good trainer. Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Alvin has good knowledge on subject matter and is a good trainer. (Posted on 1/11/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Dr Alvin guide me well on python programming for finance. He is very patience and made learning python for finance enjoyable (Posted on 1/11/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Increase the duration of the course as the learning materials can be quite heavy for students without prior knowledge of Python. (Posted on 1/11/2024)

Easy to understand Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Dr Alvin is a good teacher, He makes the topic easy to understand and learn. (Posted on 11/15/2023)

Dr Alvin was very knowledgeable and enthusiastic Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Dr Alvin was very knowledgeable and enthusiastic. His energetic teaching style made learning enjoyable and engaging and he also put in the effort to infuse many real life examples and applications into the lessons. Highly recommended! (Posted on 9/14/2023)

Dr Alvin Ang was my trainer at Tertiary Infotech. His passion for the subject can be shown from how he teaches me. Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Dr Alvin Ang was my trainer at Tertiary Infotech. His passion for the subject can be shown from how he teaches me. Mr Alvin Ang goes above and beyond by teaching me beyond my curriculum to real life applications to certain topics. He has vast experience in this field and recommend me more sites or places to help further my studies in this topic which allows me to learn above and beyond this class.
Overall, it was an enriching and engaging experience throughout. He made the class very engaging for me and if I had any queries about anything he will be sure to resolve my queries. I look forward to learning more from himor to have the chanceto work with him in the future (Posted on 7/18/2023)

I had a fruitful course. Alvin is a very good lecturer. Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

I had a fruitful course. Alvin is a very good lecturer. He explained very clearly on the python course. (Posted on 7/14/2023)

I am delighted to recommend Dr. Alvin Ang as a trainer for Python training for finance Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

I am delighted to recommend Dr. Alvin Ang as a trainer for Python training for finance. I had the pleasure of attending his course, and it was a truly enriching experience. Dr. Ang's expertise and experience in the domain of data, AI, and engineering were evident as he shared his extensive knowledge with us. He went above and beyond to ensure that we not only understood the material but also had the ability to apply it in practical scenarios.

One of the remarkable aspects of Dr. Ang's teaching style is his passion for data. His enthusiasm was contagious, igniting our curiosity and driving us to explore the subject further. Beyond learning Python, I gained valuable insights into other necessary skills and development relevant to the field.

I highly recommend Dr. Alvin Ang as a trainer. His expertise, patience, and passion make him an outstanding educator, and I am grateful for the knowledge and skills I acquired under his guidance. (Posted on 6/14/2023)

will recommend Review by Course Participant/Trainee