Introduction to FinTech using Excel: in an R-assisted Learning Environment

Introduction to FinTech using Excel

• Full name: Introduction to FinTech using Excel (in an R-assisted learning environment)
• Publisher: Springer July 2025
• Amazon link
• Preface | chapter #1 | chapter #2 | chapter #5

Links for the book

• Sample syllabi: PDF file | WORD file
• Slides: zip file (chapters 0 to 8) | zip file (chapters 9 to 18) |
• Excel files: (chapters 1 to 13)
• For advanced instructors who know R well: code |
• GitHub repository
• Many Excel related functions: my webpage

How to install R (open-source software)

• Video (t6m39s) for Windows users
• Video (t:5m59s) for Mac users

R commands for a 15-week course

• source("http://datayyy.com/i2ft/week1.txt")
• source("http://datayyy.com/i2ft/week2.txt")
• ...
• source("http://datayyy.com/i2ft/week14.txt")
• source("http://datayyy.com/i2ft/week15.txt")

Links for FinTech

• Ledger: Accounting | Distributed
• Hash: Generator |
• Public/private keys: Explanation | work? | Generator

Videos for FinTech

• General ledger (t3:47)
• Cryptocurrencies (t42:26)
• Stable coins: (t:4:30) | GENIUS bill (t4:38)
• Enigma Machine (t11.21)
• Flaw in the Enigma Code (t10:58)
• Encryption and HUGE numbers (t9:21) |

Links for crypto-related bills

• GENIUS Act: Fact Sheet | Text | PDF | Videos: (t4:56) |
• Clarity Act: H.R. 1919 | Text | PDF |
• Anti-CBDC Surveillance State Act: text | PDF |
• Videos: 3 bills (t16:41) |

Blockchain/crypto explorers

• Ether | Tron | Binance