Load Large Bloomberg Excel Data File

Load Excel data created with BDH in Excel. It can efficiently load hundreds of megabytes of Excel data.

Version 1.0.0 (57.5 KB)
10 Downloads
(0)
7 Jun 2023

You are now following this Submission

Load Excel data created with BDH in Excel. It can efficiently load hundreds of megabytes of Excel data.
www.QuantitativeAssetManagement.com
https://www.amazon.com/Quantitative-Asset-Management-Michael-Robbins/dp/1264258445/
>> tBBG = LoadLargeBloombergExcelDataFile('BBGHistory.xlsx',4,4,10)
tBBG =
22×2 timetable
Date AAPL US Equity IBM US Equity
___________ ______________ _____________
08-May-2023 173.5 123.4
09-May-2023 171.77 122.83
10-May-2023 173.56 123.69
11-May-2023 173.75 122.56
12-May-2023 172.81 124.52
15-May-2023 172.31 125.05
16-May-2023 172.31 125.15
17-May-2023 172.93 127.43
18-May-2023 175.29 127.88
19-May-2023 175.4 129
22-May-2023 174.44 129.25
23-May-2023 171.8 129.94
24-May-2023 172.08 127.4
25-May-2023 173.23 128.5
26-May-2023 175.67 130.66
30-May-2023 177.55 131.25
31-May-2023 177.5 130.35
01-Jun-2023 180.34 131.6
02-Jun-2023 181.2 134.23
05-Jun-2023 179.83 134.46
06-Jun-2023 179.46 134.51
07-Jun-2023 180.42 134.32

Cite As

Michael Robbins (2026). Load Large Bloomberg Excel Data File (https://www.mathworks.com/matlabcentral/fileexchange/130729-load-large-bloomberg-excel-data-file), MATLAB Central File Exchange. Retrieved .

General Information

MATLAB Release Compatibility

  • Compatible with any release

Platform Compatibility

  • Windows
  • macOS
  • Linux
Open in new tab
Version Published Release Notes
1.0.0