Load Large Bloomberg Excel Data File

Version 1.0.0 (57.5 KB) by Michael Robbins
Load Excel data created with BDH in Excel. It can efficiently load hundreds of megabytes of Excel data.
0.0
(0)
9 Downloads
Updated 7 Jun 2023

View License

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 (2024). Load Large Bloomberg Excel Data File (https://www.mathworks.com/matlabcentral/fileexchange/130729-load-large-bloomberg-excel-data-file), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2023a
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Version Published Release Notes
1.0.0