Hong Kong Program Trading Research Centre

L1.0.0-Introduction

L1.0.1-Tutor-Background

L1.0.2-Learning-Advice

L1.0.3-Course-Objective

L1.0.4-Course-Overview

L1.0.5-Prerequisite-and-Setup

L1.1.0-VCS-Introduction

L1.1.1-Git-SetUp

L1.1.2-Gitlab-SetUp-Part1

L1.1.3-Gitlab-SetUp-Part2

L1.1.4-SSHkey-Concept-Gitlab-Set-Up

L1.2.1-Set-Up-Helloworld

L1.2.2-Virtual-Environment-Explained

L1.2.3-Virtual-Environment-Pycharm

L1.2.4-Useful-Files-Python-Git-Pycharm-Demo

L1.2.5-Git-Full-Demo-Helloworld

L1.3.1-Project1-Intro

L1.3.2-Project1-Repo-SetUp

L1.3.3-Project1-Structure-Design

L1.3.4-REST-API-Concept

L1.3.5-Scraping-Techniques

L1.3.6-Project1-Backend-URL-Scraping-In-Depth

L1.3.7-Project1-Postman-Demo

L1.3.8-Project1-Jinse-News-Backend-URL-Pattern

L1.3.9-Project1-Python-Requests-Method1

L1.3.10-Project1-Python-Requests-Method2

L1.3.11-Project1-Jinse-News-Class-Part1

L1.3.12-Project1-Jinse-News-Class-Part2

L1.3.13-JinseNewsMR_Part3

L2.0.0-Project1-Telegram-Branch-Intro

L2.0.1-Project1-Telegram-Bot-SetUp

L2.0.2-Project1-Python-Telegram-Wrapper

L2.0.3-Project1-Mid-Summary

L2.1.0-Python-Automation-Package-Options-Intro

L2.2.0-Project1-Add-Workflow-Logic

L2.2.1-Project1-Get-Unixtimestamp-And-Trap

L2.2.2-Project1-Unixtimstamp-Explanation-And-Workflow-Logic

L2.2.3-Project1-Read-Update-News-Integration

L2.2.4-Project1-News-Order-Concern

L2.2.5-Project1-Fix-News-Order

L2.2.6-Project1-Clean-Version-Before

L2.3.1-Logging-Intro-Concept

L2.3.2-Logging-Python-Example

L2.3.3-Logging-File

L2.3.4-Logging-Advance-Walkthrough

L2.3.5-Logging-Project1

L2.4.0-Try-Except-Intro

L2.4.1-Production-Level-Project1

L2.5.0-Operating-System-Intro

L2.5.1-Servers-Intro

L2.5.2-DigitalOcean-Overall-Steps

L2.5.3-DigitalOcean-SetUp-Part1

L2.5.4-DigitalOcean-SetUp-Part2

L2.6.0-Connect-Server

L2.6.1-Server-Git-Installation

L2.6.2-Server-Python

L2.6.3-Linux-Usual-Command

L2.6.4-Server-SSHkey-SetUp-Git-Clone-Project1

L2.6.5-Systemd-Service-Intro

L2.6.6-Service-File-Project1

L2.6.7-Project1-Predeploy-Steps

L3.0.0-Project1-Deployed

L3.1.0-Database-Layman-Intro

L3.1.1-Database-Types

L3.1.2-Relational-Database-Intro

L3.2.0-MySQL-Tutorial-Agenda

L3.2.1-MySQL-Server-Installation-Part1

L3.2.2-MySQL-Server-Installation-Part2

L3.2.3-MySQL-Create-User

L3.2.4-MySQL-Create-Database

L3.2.5-MySQL-DataTypes

L3.2.6-MySQL-Create-Tables

L3.2.7-MySQL-Insert-Data

L3.2.8-MySQL-Select-Data

L3.2.9-MySQL-Keywords-Quick-Walkthrough

L3.2.10-MySQL-Alter_Drop

L3.2.11-MySQL-Index_Keys

L3.2.12-MySQLWorkbench

L3.3.0-ORM

L3.3.1-Python-SQLAlchemy-SetUp

L3.3.2-SQLAlchemy-Engine

L3.3.3-MySQL-Fix-Allow-Remote-Access

L3.3.4-MySQL-Python-Fix-Authentication-Plugin

L3.3.5-SQLAlchemy-View-Table-Details

L3.3.6-SQLAlchemy-Query-All-Data

L3.3.7-SQLAlchemy-Query-By-Filtering

L3.3.8-SQLAlchemy_Pandas-DataFrame

L3.3.9-SQLAlchemy-Data-Update-Insert-Delete

L3.3.10-SQLAlchemy-Connection-Commit

L3.3.11-SQLAlchemy-Table-Schema-Creation

L3.4.0-Project2-Intro

L3.4.1-Crypto-Lending_Borrowing-Background

L3.4.2-Crypto-Margin-Mechanism

L3.4.3-Crypto-Lending_Borrowing-Implication

L3.4.4-OKX-API-endpoint-walkthrough

L3.4.5-Project2-Postman-Request-URL

L4.0.0-Project2-Schema-Design

L4.0.1-Project2-Start

L4.0.2-Project2-Add-Dev-Branch

L4.0.3-Add-DB-Schema-Branch

L4.0.4-SQLAlchemy-Execute-Raw-SQL

L4.0.5-Project2-Server-Create-DB

L4.0.6-Project2-Table-Schema-Creation

L4.0.7-Project2-Add-DB-Schema-Branch-MR

L4.0.8-Project2-Request-OKX-Response

L4.0.9-Project2-Flow-Logic

L4.0.10-Project2-Test-Push-Data-Approach1

L4.0.11-Project2-Push-Data-Approach-Recap

L4.0.12-Project2-Test-Push-Data-Approach2

L4.0.13-Schedule-Package-Quick-Walkthrough

L4.0.14-Project2-Integrate-to-a-function

L4.0.15-Project2-Integrate-with-Exception-Handling

L4.0.16-Project2-Integrate-with-Logging

L4.0.17-Project2-Predeployment-Steps

L4.0.18-Project2-Deployment

L4.1.0-Interest-Rate-Strategy1

L4.1.1-Interest-Rate-Strategy2

L4.1.2-Interest-Rate-Strategy3

L4.1.3-Interesting-Examples-Intro

L4.1.4-ETH-Merge

L4.1.5-Launchpad-Snapshot

L4.1.6-Venue-Arbitrage

L4.2.0-Visualization-Tools-and-Plotly-Intro

L4.2.1-Grafana-Intro

L4.2.2-Steamlit-Intro

L4.2.3-Project2-Visualization-Intro

L4.2.4-Project2-Dash-Visualization-Intro

L4.2.5-Project2-Dash-Visualization-Code

L4.2.6-Project2-Dash-Dashboard-MR

L4.2.7-Project2-Dash-Dashboard-Deployment

L4.2.7-Project2-Dash-Dashboard-Deployment

L4.0.6-Project2-Table-Schema-Creation

L5.0.0-Grafana-Installation

L5.0.1-Grafana-SetUp

L5.0.2-Grafana-Config-MySQL-Data-Sources

L5.0.3-Grafana-Create-Dashboard

L5.0.4-Fix-Dash-Dashboard

L5.1.0-Crypto-Market-Participants-VCs

L5.1.1-Crypto-Market-Participants-CTA-Trading-Firms

L5.1.2-Crypto-Market-Participants-Market-Makers

L5.1.3-Crypto-Market-Participants-Family-Office

L5.1.4-Crypto-Market-Participants-Retails

L5.2.0-Market-Micrstructure-Concept-Part1

L5.2.1-Market-Micrstructure-Concept-Part2

L5.2.2-Market-Micrstructure-Concept-Orderbook-Spoofing

L5.2.3-Market-Micrstructure-Concept-Frontrunning

L5.2.4-Maker-Taker-Orders-Summary

L5.3.0-Project3-Intro

L5.3.1-Project3-Part1-Intro

L5.3.2-Project3-SetUp-Gitlab

L5.3.3-Project3-Part1-Install-Pybit

L5.3.4-Project3-Part1-Pybit-Initization

L5.3.5-Project3-Part1-Pybit-Get-Orderbook

L5.3.6-Project3-Part1-Pybit-Get-Wallet-Balance

L5.3.7-Project3-Part1-Bybit-Unified-Trading-Account

L5.3.8-Project3-Part1-Pybit-Place-Limit-Order

L5.3.9-Project3-Part1-Pybit-Wallet-Balance-Reflects-Position

L5.3.10-Project3-Part1-Pybit-Walkthrough-Called-Functions

L5.3.11-Project3-Part1-Pybit-Order-Status-Filled-Scenario

L5.3.12-Project3-Part1-Pybit-Order-Status-Not-Filled-Scenario

L5.3.13-Project3-Part1-Pybit-Execution-Algo-v1-Walkthrough

L5.3.14-Project3-Part1-Pybit-Execution-Algo-v1-Demo

L5.3.15-Project3-Part1-Pybit-Execution-Algo-v1-Add-Return-OrderId

L5.3.16-Project3-Part1-Pybit-Execution-Algo-v2-Walkthrough

L5.3.17-Project3-Part1-Pybit-Execution-Algo-v2-Demo

L6.0.0-Project3-Part1-Pybit-Execution-Algo-v3-and-Summary

L6.0.1-Project3-Part1-Appendix

L6.1.0-Time-Series-Database-Intro

L6.1.1-IM-and-MM-Intro

L6.2.0-Project3-Part2-Intro

L6.2.1-Project3-Part2-Design

L6.2.2-Project3-Part2-Leaderboard-Rank-Network

L6.2.3-Project3-Part2-Requests-Leaderboard-Rank-URL

L6.2.4-Project3-Part2-Individual-Positions-Network

L6.2.5-Project3-Part2-Walkthrough-Other-Exchanges

L6.2.6-Project3-Part2-Binance-Leaderboard-Class-Start

L6.2.7-Project3-Part2-Enums

L6.2.8-Project3-Part2-Get-Leaderboard-Rank-Code

L6.2.9-Project3-Part2-Get-Position-Code

L6.2.10-Project3-Part2-Test-Code-Base

L6.2.11-Project3-Part2-Debug

L6.2.12-Project3-Part2-TG-and-DB-code

L6.2.13-Project3-Part2-Table-Models

L6.2.14-Project3-Part2-Predeployment

L6.2.15-Project3-Part2-Deployment-Tips

L6.3.0-End

L6.2.4-Project3-Part2-Individual-Positions-Network