Note : This "Tips" area contains some original tips written by Edwin Tam, which contain the valuable experience gained in real-world application of Excel throughout his career. Such experience are hardly disclosed or shared by professionals/practitioners as those are their values. Even if you work with those people and sit next to them, they won't teach you although they are not rocket science. I hope these "tips" can become very helpful reference material for those who want to enter the industries or to know how people are doing to tackle those real-world problems.
- Bloomberg and Excel
- Bloomberg Functions won't Recalculate Automatically when Calculation set to Automatic?
- The 2 essential "correct" approaches to refresh Bloomberg formula in VBA
Option Greeks Analysis in Excel
- The "Bumping" technique
- Gamma - Part 1
- Gamma - Part 2 (the d delta / d price analysis)
Applying Benford's Law in Data Forensic and IT Audit (with case study)