Load Large Bloomberg Excel Data File

版本 1.0.0 (57.5 KB) 作者: Michael Robbins
Load Excel data created with BDH in Excel. It can efficiently load hundreds of megabytes of Excel data.
0.0
(0)
9.0 次下载
更新时间 2023/6/7

查看许可证

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

引用格式

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. 检索时间: .

MATLAB 版本兼容性
创建方式 R2023a
兼容任何版本
平台兼容性
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!

版本 已发布 发行说明
1.0.0