BACK TO COURSES
QUICK WIN

Bloomberg Data Cleaning Macros

JO
James OkaforEx-Citadel Data Quant
15 MIN VIDEO
DOWNLOADABLE VBA CODE
30-DAY GUARANTEE
Your Instructor
JO
James Okafor
Ex-Citadel Data Quant

James spent 6 years at Citadel as a data infrastructure quant, wrangling Bloomberg terminal exports into clean, model-ready datasets for the systematic trading team. He personally processed over 3 million rows of Bloomberg data using the VBA macros he now teaches. His macros have been adopted by analysts at 12+ funds since he began teaching.

What You'll Learn

Concrete skills you can apply tomorrow morning

  • Automate delimiter normalization across Bloomberg's inconsistent CSV and TXT export formats
  • Fix date-field mismatches where Bloomberg mixes DD/MM and MM/DD formats in the same export
  • Reshape wide Bloomberg field dumps into long format for easy pivot analysis or model ingestion
  • Build a batch-processing macro that cleans an entire folder of Bloomberg exports in under 30 seconds
Course Format
15-minute focused video
Dense, no-filler instruction. Every minute teaches a skill you'll use.
Downloadable VBA source code
The exact .xlsm file used in the video. Open it, run it, adapt it.
Lifetime access
One purchase, permanent access. Re-watch whenever you need a refresher.
QUICK WIN
⏱ 15 MIN
$49one-time
ENROLL NOWDOWNLOAD VBA CODE
30-day money-back guarantee
This course includes
  • 15-minute focused video
  • Downloadable VBA source code
  • Lifetime access